Announcement

Announcement Module
Collapse
No announcement yet.

How to manual debuging - mysqldump sst?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to manual debuging - mysqldump sst?


    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" ?


    Code:
    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)

    Last edited by Sych; 05-23-2013, 08:27 AM.

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

    Comment


    • #3
      @Sych,

      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
      sst_user@*.*.*.249 and not sst_user@locahost or sst_user@127.0.0.1
      Thats why its reject the connection(auth failure).



      @jaigupta,
      If u r facing the same problem,check to see what IP the mysql user is privileged to!.


      Last edited by madhusudan; 03-03-2014, 06:49 AM.

      Comment


      • #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.

        Code:
        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?

        Comment

        Working...
        X