Pxc wsrep_sst_method are configured as xtrabackup-v2 error, pxcxtrabackup-v2
When the second node is started, the following error occurs:WSREP_SST: [ERROR] Error while getting data from donor node: exit codes: 137 0Wsrep_sst_method for all nodes was originally configured as a xtrabackup-v2, but an ERROR was reported when adding a second node: WSREP_SST: [Error] ERROR while getting data from donor node: exit codes: 137 0, after changing to rsync, there is no problem, to verify whether it is xtrabackup version problems, I used 2.4.7 wsrep_sst_method = xtrabackup-v2wsrep_sst_method = rsync using xtrabackup2.1.8 error: [ERROR] The xtrabackup vexrsion is 2.1.8. needs xtrabackup-2.4.4 or higher to perform SST is replaced with a xtrabackup-2.4.4, or the same error:WSREP_SST: [ERROR] Error while getting data from donor node: exit codes: 137 0 Verify that this is not an issue with xtrabackup!In the following check process, we first found that socat on node1 node is not installed. After the installation, the log reports an error again, which is caused by the sst user permission problem. After the installation, we can solve the problem!Test procedure: 1. Start the cluster in node1, create a database in node1, create a table, and insert data. 2. Start Node 2 with wsrep_sst_method = rsync. After Node 2 is started normally, data synchronization is complete. shutdown Node 2; 3, modify node2 wsrep_sst_method = xtrabackup-v2, or normal start; 4, node1 write data, node2 synchronization data normal. View error logs for node 1: 2017-07-31T03: 04: 03.419546Z 0 [Note] WSREP: Initiating SST/IST transfer on DONOR side (wsrep_sst_xtrabackup-v2 -- role 'donor' -- address' 10. 157.26.small: 4444/xtrabackup_sst // 1' -- socket '/tmp/mysql. sock '-- datadir'/data/mysql/mysql_6666/data/'-- ults-file'/etc/my. cnf '-- defaults-group-suffix ''-- binlog'/data/mysql/mysql_6666/logs/binlog/mysql-bin' -- gtid 'ed816d86-defaults: 0') 2017-07-31T03: 04: 03.20.705z 2 [Note] WSREP: DONOR thread signaled with 0 which: no socat in (/usr/sbin:/opt/mysql/Percona-XtraDB-Cluster-5.7.18-rel15-29.20.1.Linux.x86_64.ssl101/bin: /usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin: /root/bin:/opt/httpd/php5/bin:/usr/local/mysql_pxc/bin) 2017-07-31T03: 04: 03.713864Z WSREP_SST: [ERROR] ******************* fatal error **************** * ***** 2017-07-31T03: 04: 03.715590Z WSREP_SST: [ERROR]Socat not found in path:/usr/sbin:/opt/mysql/Percona-XtraDB-Cluster-5.7.18-rel15-29.20.1.Linux.x86_64.ssl101/bin:/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin: /opt/httpd/php5/bin:/usr/local/mysql_pxc/bin2017-07-31T03: 04: 03.717220Z WSREP_SST: [ERROR] ********************************** * **************** 2017-07-31T03: 04: 03.717775Z 0 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 -- role 'donor' -- address '10. 157.26.small: 4444/xtrabackup_sst // 1' -- socket '/tmp/mysql. sock '-- datadir'/data/mysql/mysql_6666/data/'-- ults-file'/etc/my. cnf '-- defaults-group-suffix ''-- binlog'/data/mysql/mysql_6666/logs/binlog/mysql-bin' -- gtid 'ed816d86-defaults: 0 ': 2 (No such file or directory) 2017-07-31T03: 04: 03.717918Z 0 [ERROR] WSREP: Command did not run: wsrep_sst_xtrabackup-v2 -- role 'donor' -- address '10. 157.26.small: 4444/xtrabackup_sst // 1' -- socket '/tmp/mysql. sock '-- datadir'/data/mysql/mysql_6666/data/'-- ults-file'/etc/my. cnf '-- defaults-group-suffix ''-- binlog'/data/mysql/mysql_6666/logs/binlog/mysql-bin' -- gtid 'ed816d86-759a-11e7-a5c4-469a5c88e506: 0 '2014-07-31T03: 04: 03.719442Z 0 [Warning] WSREP: 2017 (node132): State transfer to 1.0 (nodeizer) failed:-2 (No such file or directory) install socat: wget http://www.dest-unreach.org/socat/download/socat-1.7.3.2.tar.gztar zxvf socat-1.7.3.2.tar.gzcd socat-1.7.3.2. /configuremake & make install after socat is installed on the three nodes, add the second node again. Error: 2017-07-31T03: 18: 57.289292Z WSREP_SST: [ERROR] ******************* fatal error **************** * ***** 2017-07-31T03: 18: 57.291514Z WSREP_SST: [ERROR]Xtrabackup_checkpoints missing. xtrabackup/SST failed on DONOR. Check DONOR log2017-07-31T03: 18: 57.293551Z WSREP_SST: [ERROR] ********************************** * **************** 2017-07-31T03: 18: 57.296400Z WSREP_SST: [ERROR] Cleanup after exit with status: 22017-07-31T03: 18: 57.300659Z 0 [Warning] WSREP: 0.0 (node132): State transfer to 1.0 (nodefailed) failed: -22 (Invalid argument) 2017-07-31T03: 18: 57.300706Z 0 [ERROR] WSREP: gcs/src/gcs_group.cpp: gcs_group_handle_join_msg (): 765: Will never receive state. need to abort. check the error log at the first node: 2017-07-31T03: 18: 57.274531Z 12 [Note] Access denied for user 'sst '@ 'localhost' (using password: YES) 2017-07-31T03: 18: 57.278394Z WSREP_SST: [ERROR] ******************* fatal error **************** * ***** 2017-07-31T03: 18: 57.281082Z WSREP_SST: [ERROR]Xtrabackup finished with error: 1. Check/data/mysql/mysql_6666/data // innobackup. backup. log--------------- Innobackup. backup. log (START) ------------------ 170731 11:18:57 version_check Connecting to MySQL server with DSN 'dbi: mysql:; mysql_read_default_group = xtrabackup; port = 6666; mysql_socket =/tmp/mysql. sock 'as 'sst '(using password: YES ). character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index. xml 'filefailed to connect to MySQL server: DBI connect ('; mysql_read_default_group = xtrabackup; port = 6666; mysql_socket =/tmp/mysql. sock ', 'sst ',...) failed: Can't initialize character set utf8mb4 (path:/usr/share/mysql/charsets/) at-line 1314170731 11:18:57 Connecting to MySQL server host: localhost, user: sst, password: set, port: 6666, socket:/tmp/mysql. sockCheck/data/mysql/mysql_6666/data/innobackup. backup. log. You can see that this is a user permission issue.: [Root @ dpstcmsweb00 src] # cat/data/mysql/mysql_6666/data/innobackup. backup. log170731 11:18:57 version_check Connecting to MySQL server with DSN 'dbi: mysql:; mysql_read_default_group = xtrabackup; port = 6666; mysql_socket =/tmp/mysql. sock 'as 'sst '(using password: YES ). character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index. xml 'filefailed to connect to MySQL server: DBI connect ('; mysql_read_default_group = xtrabackup; port = 6666; mysql_socket =/tmp/mysql. sock ', 'sst ',...) failed: Can't initialize character set utf8mb4 (path:/usr/share/mysql/charsets/) at-line 1314170731 11:18:57 Connecting to MySQL server host: localhost, user: sst, password: set, port: 6666, socket:/tmp/mysql. sockFailed to connect to MySQL server: Access denied for user 'sst '@ 'localhost' (using password: YES ). authorize on the first node:Grant all privileges on *. * to 'sst '@ 'localhost' identified by 'sst123 ';Start the second node again and add it successfully!