codership/mysql-wsrep

Various other bus in clone sst script

Opened this issue · 3 comments

shinguz commented

We got this error:

/usr//bin/wsrep_sst_clone: Zeile 118: [: 27-26: Ganzzahliger Ausdruck erwartet.
/usr//bin/wsrep_sst_clone: Zeile 120: [: 27-26: Ganzzahliger Ausdruck erwartet.

It is comparing those 2 numbers:

WSREP_SST: [ERROR] this operation requires MySQL client version 8.0.19, this client is '8.0.27-26.9' (20220321 17:35:22.017)

This is the problematic line in the code:

CLIENT_VERSION=$($MYSQL_CLIENT --version | grep -vi MariaDB | cut -d ' ' -f 4)
check_client_version $CLIENT_VERSION

This would solve the issue:

CLIENT_VERSION=$($MYSQL_CLIENT --version | grep -vi MariaDB | cut -d ' ' -f 4 | cut -b1-6)

Got another error:

ERROR 1044 (42000) at line 3: Access denied for user 'sst'@'localhost' to database 'performance_schema'
WSREP_SST: [ERROR] Donor prepare returned code 1 (20220321 17:39:11.491)
CREATE USER 'clone_to_192.168.101.22:4444' IDENTIFIED BY '29f20815e9c9f7d2358f78caa2a55944Aa+1' REQUIRE SSL;
GRANT BACKUP_ADMIN ON . TO 'clone_to_192.168.101.22:4444';
GRANT SELECT ON performance_schema.* TO 'clone_to_192.168.101.22:4444';
GRANT EXECUTE ON . TO 'clone_to_192.168.101.22:4444';
2022-03-21T16:39:11.507078Z 2876 [Note] [MY-010733] [Server] Shutting down plugin 'clone'
2022-03-21T16:39:11.514495Z 0 [ERROR] [MY-000000] [WSREP] Failed to read from: wsrep_sst_clone --role 'donor' --address '192.168.101.22:4444' --local-port '3306' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --mysqld-version '8.0.27-26.9' --plugin-dir '/usr/lib/mysql/plugin/' '' --binlog-index 'binlog.index' --gtid 8fb95896-a91f-11ec-84b1-db08983c5c9a:579251 --local-gtid 8fb95896-a91f-11ec-84b1-db08983c5c9a:578442 --server-id 1
2

Granted this:

grant select, update, delete, insert on performance_schema.* to sst@localhost;

But did not help. Documentation was not indicating anything:

https://galeracluster.com/library/documentation/sst-physical.html

shinguz commented

giving up here

ayurchen commented

Thanks, Oli! Will be fixed in the next release.