How to manual debuging - mysqldump sst?

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

i have 2 boxes with same users in db and sst_user (sst_user@%, sst_user@locahost, sst_user@127.0.0.1)have all privilegies

How to debug why node exited with “Operation not permitted” ?


130523 14:08:31 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130523 14:08:31 [Note] WSREP: Assign initial position for certification: 291028, protocol version: 2
130523 14:08:33 [Note] WSREP: Node 1 (box2) requested state transfer from '*any*'. Selected 0 (box1)(SYNCED) as donor.
130523 14:08:33 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 291028)
130523 14:08:33 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
ERROR 2003 (HY000): Can't connect to MySQL server on '*.*.*.249' (111)
130523 14:08:33 [ERROR] WSREP: Process completed with error: wsrep_sst_mysqldump --user 'sst_user' --password '****' --host '*.*.*.249' --port '3500' --local-port '3306' --socket '/var/run/mysqld/mysqld.sock' --gtid 'c3c90bbb-c37d-11e2-0800-5896eee4fb82:291028': 1 (Operation not permitted)
130523 14:08:33 [ERROR] WSREP: Try 1/3: 'wsrep_sst_mysqldump --user 'sst_user' --password '****' --host '5.9.6.249' --port '3500' --local-port '3306' --socket '/var/run/mysqld/mysqld.sock' --gtid 'c3c90bbb-c37d-11e2-0800-5896eee4fb82:291028'' failed: 1 (Operation not permitted)
ERROR 2003 (HY000): Can't connect to MySQL server on '*.*.*.249' (111)
2

Can no one answer this question? I am myself struggling with it.

3

@Sych,

[COLOR=#252C2F]mysql error 111 means connection refused!.

The user privilege that u specified is for 127.0.0.1(localhost) and not to the LAN/WAN Host IP address! .
the user privilege should be given to [COLOR=#252C2F]sst_user@..*.249 and not sst_user@locahost or sst_user@127.0.0.1
Thats why its reject the connection(auth failure).

@jaigupta,
[COLOR=#252C2F]If u r facing the same problem,check to see what IP the mysql user is privileged to!.

4

@madhusudan
No, I don’t have same problem. I tried creating a user with host as %, I have also tried using root user but same error.

Both users are able to connect to donor from receiver node using mysql -h x.x.x.x command

I also tried adding user and password directly to /usr/bin/wsrep_sst_mysqldump

I recieved multiple errors.

16462 [ERROR] WSREP: Process completed with error: wsrep_sst_mysqldump --user 'root' --password 'xxxx' --host 'x.x.x.x' --port '3306' --local-port '3306' --socket '/var/lib/mysql/mysql.sock' --gtid '6da46c5b-9acc-11e3-9d28-9f9960e4e0f4:79126321' --bypass: 1 (Operation not permitted)
16462 [ERROR] WSREP: Try 3/3: 'wsrep_sst_mysqldump --root 'sstuser' --password 'xxxx' --host 'x.x.x.x' --port '3306' --local-port '3306' --socket '/var/lib/mysql/mysql.sock' --gtid '6da46c5b-9acc-11e3-9d28-9f9960e4e0f4:79126321' --bypass' failed: 1 (Operation not permitted)

I don’t have another error but it was related to RESET MASTER command.

I was not able to create a new node using mysqldump SST.

Can someone please point to correct method of creating a new node using mysqldump SST?