[MDEV-19815] mariabackup SST method doesn't work after 10.4 upgrade Created: 2019-06-20  Updated: 2021-12-23  Resolved: 2021-12-23

Status: Closed
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.4
Fix Version/s: 10.4.23

Type: Bug Priority: Major
Reporter: Ranjan Ghosh Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 1
Labels: None


 Description   

The 10.3 => 10.4 upgrade has simply been a terrible experience so far After many, many other problems I decided to start with 10.4 from scratch with a new database and just restore a backup of all tables (but no users). Now, I tried to recreate a user for the mariabackup and found this:

https://mariadb.com/kb/en/library/mariabackup-sst-method/

It says that you are supposed to be able to use a socket authentication without any password. Great. I did this:
CREATE USER 'mysql'@'localhost' IDENTIFIED VIA unix_socket;
and this:
GRANT RELOAD, PROCESS, LOCK TABLES, REPLICATION CLIENT ON . TO 'mysql'@'localhost';
on the first node.
I can now do:
sudo -u mysql mysql -u mysql
on the first/donor node and I'm logged in. Seems to work.
Now I add this to the .cnf file on donor and joiner node:
wsrep-sst-method = mariabackup
wsrep-sst-auth = mysql:

Now, when I try to start the joiner, it fails:
Jun 20 19:41:40 tukan2 mysqld[19614]: 2019-06-20 19:41:40 0 [Warning] WSREP: 0.0 (tukan1): State transfer to 1.0 (tukan2) failed: -1 (Operation not permitted)
Jun 20 19:41:40 tukan2 mysqld[19614]: 2019-06-20 19:41:40 0 [ERROR] WSREP: gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():1085: Will never receive state. Need to abort.

Not very helpful
It just to work with MariaDB 10.3, albeit with root user and a password.
Now, I cannot get it to work either way.
I always get the above error message.



 Comments   
Comment by Ranjan Ghosh [ 2019-06-21 ]

Okay, I finally figured this out: On the donor node the APT package "mariadb-backup" wasn't installed so mariabackup wasn't available. Actually a simple and very stupid bug. Sigh. Still, I think that the error message "Operation not permitted" is extremely misleading for such a probably common and easy-to-make mistake. Why doesn't the SST script check whether the mariabackup command is available and say so? This would have saved my lots of hours of searching.

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