Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.7-galera
-
None
Description
mysqldump SST fails with the following errors in respective
donor and receiver logs.
[Donor]
140411 12:33:55 [Note] WSREP: Node 0.0 (nirbhay-VirtualBox) requested state transfer from 'any'. Selected 1.0 (nirbhay-VirtualBox)(SYNCED) as donor.
140411 12:33:55 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 0)
140411 12:33:55 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
140411 12:33:55 [Note] WSREP: Running: 'wsrep_sst_mysqldump --user 'root' --password '' --host '10.0.2.15' --port '16001' --local-port '16000' --socket '/tmp/my_node1.sock' --gtid 'd07480a7-c196-11e3-b1bc-ef79037e7fec:0''
~/project//maria-10.0-galera/install//bin/wsrep_sst_mysqldump: 91: ~/project//maria-10.0-galera/install//bin/wsrep_sst_common: WSREP_SST_OPT_CONF: parameter not set
mysql Ver 15.1 Distrib 10.0.10-MariaDB, for Linux (i686) using readline 5.2
WSREP_SST: [ERROR] this operation requires MySQL client version 5.5.x (20140411 12:33:55.434)
140411 12:33:55 [ERROR] WSREP: Process completed with error: wsrep_sst_mysqldump --user 'root' --password '' --host '10.0.2.15' --port '16001' --local-port '16000' --socket '/tmp/my_node1.sock' --gtid 'd07480a7-c196-11e3-b1bc-ef79037e7fec:0': 22 (Invalid argument)
140411 12:33:55 [ERROR] WSREP: Try 1/3: 'wsrep_sst_mysqldump --user 'root' --password '' --host '10.0.2.15' --port '16001' --local-port '16000' --socket '/tmp/my_node1.sock' --gtid 'd07480a7-c196-11e3-b1bc-ef79037e7fec:0'' failed: 22 (Invalid argument)
~/project//maria-10.0-galera/install//bin/wsrep_sst_mysqldump: 91: ~/project//maria-10.0-galera/install//bin/wsrep_sst_common: WSREP_SST_OPT_CONF: parameter not set
mysql Ver 15.1 Distrib 10.0.10-MariaDB, for Linux (i686) using readline 5.2
WSREP_SST: [ERROR] this operation requires MySQL client version 5.5.x (20140411 12:33:56.478)
140411 12:33:56 [ERROR] WSREP: Process completed with error: wsrep_sst_mysqldump --user 'root' --password '' --host '10.0.2.15' --port '16001' --local-port '16000' --socket '/tmp/my_node1.sock' --gtid 'd07480a7-c196-11e3-b1bc-ef79037e7fec:0': 22 (Invalid argument)
140411 12:33:56 [ERROR] WSREP: Try 2/3: 'wsrep_sst_mysqldump --user 'root' --password '' --host '10.0.2.15' --port '16001' --local-port '16000' --socket '/tmp/my_node1.sock' --gtid 'd07480a7-c196-11e3-b1bc-ef79037e7fec:0'' failed: 22 (Invalid argument)
~/project//maria-10.0-galera/install//bin/wsrep_sst_mysqldump: 91: ~/project//maria-10.0-galera/install//bin/wsrep_sst_common: WSREP_SST_OPT_CONF: parameter not set
mysql Ver 15.1 Distrib 10.0.10-MariaDB, for Linux (i686) using readline 5.2
WSREP_SST: [ERROR] this operation requires MySQL client version 5.5.x (20140411 12:33:57.529)
140411 12:33:57 [ERROR] WSREP: Process completed with error: wsrep_sst_mysqldump --user 'root' --password '' --host '10.0.2.15' --port '16001' --local-port '16000' --socket '/tmp/my_node1.sock' --gtid 'd07480a7-c196-11e3-b1bc-ef79037e7fec:0': 22 (Invalid argument)
140411 12:33:57 [ERROR] WSREP: Try 3/3: 'wsrep_sst_mysqldump --user 'root' --password '' --host '10.0.2.15' --port '16001' --local-port '16000' --socket '/tmp/my_node1.sock' --gtid 'd07480a7-c196-11e3-b1bc-ef79037e7fec:0'' failed: 22 (Invalid argument)
140411 12:33:58 [Warning] WSREP: 1.0 (nirbhay-VirtualBox): State transfer to 0.0 (nirbhay-VirtualBox) failed: -22 (Invalid argument)
140411 12:33:58 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 0)
[Receiver]
140411 12:33:55 [Note] WSREP: Node 0.0 (nirbhay-VirtualBox) requested state transfer from 'any'. Selected 1.0 (nirbhay-VirtualBox)(SYNCED) as donor.
140411 12:33:55 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0)
140411 12:33:55 [Note] WSREP: Requesting state transfer: success, donor: 1
140411 12:33:58 [Warning] WSREP: 1.0 (nirbhay-VirtualBox): State transfer to 0.0 (nirbhay-VirtualBox) failed: -22 (Invalid argument)
140411 12:33:58 [ERROR] WSREP: gcs/src/gcs_group.c:gcs_group_handle_join_msg():723: Will never receive state. Need to abort.