Not the answer you need?
Register and ask your own question!

Unable to Start Second Node

dbasaurusdbasaurus ContributorCurrent User Role Beginner
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.

Comments

  • dbasaurusdbasaurus Contributor Current User Role Beginner
    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.cpp:prepare_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.
  • dbasaurusdbasaurus Contributor Current User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.