Details
-
Task
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
Description
I want to set up galera cluster with MariaDB 10.5, galera-4.
I follow the instructions to install MariaDB 10.5 from this site https://downloads.mariadb.org/mariadb/repositories/#distro=Ubuntu&distro_release=bionic--ubuntu_bionic&mirror=biznetgio&version=10.5
I change configuration in my.cnf, then run command ```mariadb-install-db --defaults-file=/etc/mysql/my.cnf```
Status Ok, db is running well.
I add this lines to my.cnf :
```##clustering db configuration
wsrep_on = ON
wsrep_provider = /usr/lib/libgalera_smm.so
wsrep_cluster_name = galera-test
wsrep_cluster_address = gcomm://192.168.56.107,192.168.56.108, 192.168.56.109
wsrep_sst_method = mariabackup
wsrep_sst_auth = clusteradmin:clusteradmin789
wsrep_node_address = 192.168.56.107
wsrep_node_name = node107
wsrep_OSU_method = TOI
wsrep_slave_threads = 21
```
then stop mysql service.
I run command : ```galera_new_cluster```
After run the command, appears errors below :
```Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.```
error in log file :
```2020-02-18 9:42:02 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
wsrep loader: [ERROR] provider interface version mismatch: need '26', found '27dev'
2020-02-18 9:42:02 0 [ERROR] WSREP: Failed to create a new provider '/usr/lib/galera/libgalera_smm.so' with options '':Failed to load wsrep library
2020-02-18 9:42:02 0 [ERROR] WSREP: Failed to load provider
2020-02-18 9:42:02 0 [ERROR] Aborting
2020-02-18 10:22:50 0 [Warning] Buffered warning: Performance schema disabled (reason: init failed).
2020-02-18 10:22:50 0 [Note] WSREP: Loading provider /usr/lib/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib/libgalera_smm.so'
wsrep loader: [ERROR] provider interface version mismatch: need '26', found '27dev'
2020-02-18 10:22:50 0 [ERROR] WSREP: Failed to create a new provider '/usr/lib/libgalera_smm.so' with options '':Failed to load wsrep library
2020-02-18 10:22:50 0 [ERROR] WSREP: Failed to load provider
2020-02-18 10:22:50 0 [ERROR] Aborting```
Here some details :
```# ls -lthr /usr/lib/libgalera_smm.so
lrwxrwxrwx 1 root root 23 Jan 30 15:52 /usr/lib/libgalera_smm.so -> galera/libgalera_smm.s```
```# dpkg -l | grep mariadb
ii libmariadb3:amd64 1:10.5.1+maria~bionic amd64 MariaDB database client library
ii mariadb-backup 1:10.5.1+maria~bionic amd64 Backup tool for MariaDB server
ii mariadb-client-10.5 1:10.5.1+maria~bionic amd64 MariaDB database client binaries
ii mariadb-client-core-10.5 1:10.5.1+maria~bionic amd64 MariaDB database core client binaries
ii mariadb-common 1:10.5.1+maria~bionic all MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
ii mariadb-server-10.5 1:10.5.1+maria~bionic amd64 MariaDB database server binaries
ii mariadb-server-core-10.5 1:10.5.1+maria~bionic amd64 MariaDB database core server files```
```# dpkg -l | grep galera
ii galera-4 26.4.4-bionic amd64 Replication framework for transactional applications```
I test the API provider on MariaDB 10.4. everything is good, the provider can be loaded.
I have no idea why it error on MariaDB 10.5.