[MDEV-21761] [ERROR] WSREP: Failed to create a new provider '/usr/lib/libgalera_smm.so' with options '':Failed to load wsrep library Created: 2020-02-18  Updated: 2020-12-08  Resolved: 2020-03-09

Status: Closed
Project: MariaDB Server
Component/s: Galera, wsrep
Fix Version/s: 10.5.2

Type: Task Priority: Blocker
Reporter: Enjel Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: galera, replication

Attachments: HTML File config_mariadb    

 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.



 Comments   
Comment by Jan Lindström (Inactive) [ 2020-02-19 ]

From some reason release has wrong Galera library.

Comment by Daniel Bartholomew [ 2020-02-19 ]

We've identified an issue in the build of the galera-26.4.4 packages that were pushed out with the 10.5.1 release. We're working on a fix now.

Comment by Daniel Bartholomew [ 2020-02-20 ]

I've reverted the galera version in the 10.5.1 repositories to galera-26.4.3 while I prep the rebuilt 26.4.4 packages.

Comment by Daniel Bartholomew [ 2020-02-22 ]

Newly built galera-26.4.4 packages added to the repositories.

You may need to do a `sudo yum clean all; sudo rm -rf /var/cache/yum` so that Yum doesn't complain about the new package.

On Debian/Ubuntu, removing the repo, doing a `sudo apt update`, adding the repo back, and then another `sudo apt update` should clear up any issues apt might have with the new package.

Generated at Thu Feb 08 09:09:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.