[MDEV-13283] mysqldump sst fails "this operation requires MySQL client version 10 or newer" Created: 2017-07-10  Updated: 2017-07-18  Resolved: 2017-07-18

Status: Closed
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Andrii Nikitin (Inactive) Assignee: Sachin Setiya (Inactive)
Resolution: Duplicate Votes: 1
Labels: None

Issue Links:
Duplicate
duplicates MDEV-13037 wsrep_sst_mysqldump checking wrong ve... Closed

 Description   

Trying to attempt 10.2 mysqldump sst triggers an error :

WSREP_SST: [ERROR] this operation requires MySQL client version 10 or newer (20170710 11:38:06.873)
2017-07-10 11:38:06 140605822228224 [ERROR] WSREP: Process completed with error: wsrep_sst_mysqldump --host '192.168.1.183' --port '3309' --local-port '3306' --socket '/home/a/spd/m0-10.2.6/dt/my.sock'  --defaults-file '/home/a/spd/m0-10.2.6/my.cnf'  --gtid '6f9b051c-6553-11e7-a99a-870c00169d61:0' --gtid-domain-id '0': 22 (Invalid argument)

Following lines are to blame https://github.com/MariaDB/server/blob/10.2/scripts/wsrep_sst_mysqldump.sh#L59 :

if ! $MYSQL_CLIENT --version | grep 'Distrib 10.1' >/dev/null
then
    $MYSQL_CLIENT --version >&2
    wsrep_log_error "this operation requires MySQL client version 10 or newer"
    exit $EINVAL
fi



 Comments   
Comment by Andrii Nikitin (Inactive) [ 2017-07-10 ]

just for reference, below is script to reproduce the problem with environs framework
https://github.com/AndriiNikitin/mariadb-environs-galera/blob/master/_bugscript/MDEV-13283.sh

and travis logs with demonstrated problem and workaround in centos 7 docker images:
https://travis-ci.org/AndriiNikitin/mariadb-environs-galera/builds/251976616

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