Announcement

Announcement Module
Collapse
No announcement yet.

Unable to Start Second Node

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

  • Unable to Start Second Node

    I am trying to setup Percona cluster, but ran into a issue trying to start the other nodes. When I issue "/etc/init.d/mysql start" the script fails. The error log indicates this as the error message:

    2014-06-25 17:38:28 37491 [ERROR] WSREP: gcs/src/gcs_group.c:gcs_group_handle_join_msg():723: Will never receive state. Need to abort.

    Anyone have any idea what it means or how to resolve? I initially thought it was due to the wsrep_sst_auth option, but I have that set on all three nodes.

  • #2
    I changed wsrep_sst_method=xtrabackup to wsrep_sst_method=xtrabackup-v2 and got a slightly different error message:

    2014-06-25 17:54:34 38204 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (bb20590b-fc9e-11e3-94a8-2f6db7a0e599): 1 (Operation not permitted)
    at galera/src/replicator_str.cpprepare_for_IST():447. IST will be unavailable.
    2014-06-25 17:54:34 38204 [Note] WSREP: Member 0.0 (csg1zbecomdbm2) requested state transfer from '*any*'. Selected 1.0 (csg1zbecomdbm1)(SYNCED) as donor.

    Comment


    • #3
      I was able to figure it out. The problem was the port socat was using to perform the transfer; 4444. I added this port to my iptables rules for all my nodes and it worked. Also, on the two secondary nodes I deleted everything in the data directory.

      Comment


      • #4
        That is good news, dbasaurus! Thanks for sharing the issue and also the resolution with the community. I am sure it will help someone facing a similar issue.
        Is this an emergency? Get immediate assistance from Percona Support 24/7. Click here.

        Comment

        Working...
        X