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

Can only Single Node in CentOS 7

randymelderrandymelder EntrantCurrent User Role Beginner
Can't seem to get hosts talking to each other. Cluster size is always 1 and, even though I can ping boxes from each other, they won't join.

Followed the guide here: http://www.percona.com/doc/percona-xtradb-cluster/5.5/howtos/cenots_howto.html
with these packages:
Percona-XtraDB-Cluster-56-debuginfo.x86_64
                                          1:5.6.21-25.8.940.el7          @percona 
  Percona-XtraDB-Cluster-client-56.x86_64 1:5.6.21-25.8.940.el7          @percona 
  Percona-XtraDB-Cluster-full-56.x86_64   1:5.6.21-25.8.940.el7          @percona 
  Percona-XtraDB-Cluster-galera-3.x86_64  3.8-1.3390.rhel7               @percona 
  Percona-XtraDB-Cluster-galera-3-debuginfo.x86_64
                                          3.8-1.3390.rhel7               @percona 
  Percona-XtraDB-Cluster-garbd-3.x86_64   3.8-1.3390.rhel7               @percona 
  Percona-XtraDB-Cluster-server-56.x86_64 1:5.6.21-25.8.940.el7          @percona 
  Percona-XtraDB-Cluster-shared-56.x86_64 1:5.6.21-25.8.940.el7          @percona 
  Percona-XtraDB-Cluster-test-56.x86_64   1:5.6.21-25.8.940.el7          @percona 
  percona-release.x86_64                  0.0-1                          installed
  percona-xtrabackup.x86_64               2.2.7-5050.el7                 @percona 



Host 1:
| wsrep_local_state | 4 |
| wsrep_local_state_comment | Synced |
| wsrep_incoming_addresses | 192.168.197.115:3306 |
| wsrep_evs_state | OPERATIONAL |
| wsrep_gcomm_uuid | eace2c17-8b9a-11e4-a4e2-375c869d986a |
| wsrep_cluster_conf_id | 3 |
| wsrep_cluster_size | 1 |
| wsrep_cluster_state_uuid | 98047d41-8b9a-11e4-9b38-37945e1e5709 |
| wsrep_cluster_status | Primary |
| wsrep_connected | ON |

[root@localhost ~]# cat /etc/my.cnf
   
  [mysqld]
  # Path to Galera library
  wsrep_provider=/usr/lib64/libgalera_smm.so
   
  # Cluster connection URL contains the IPs of node#1, node#2 and node#3
  #wsrep_cluster_address=gcomm://192.168.197.115,192.168.136.56,192.168.134.12
  wsrep_cluster_address=gcomm://
   
  # In order for Galera to work correctly binlog format should be ROW
  binlog_format=ROW
   
  # MyISAM storage engine has only experimental support
  default_storage_engine=InnoDB
   
  # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
  innodb_autoinc_lock_mode=2
   
  # Node address
  wsrep_node_address=192.168.197.115
   
  #
  wsrep_cluster_name=vfcluster1
  wsrep_sst_method=xtrabackup
  wsrep_sst_auth="sstuser:sstpass"
   
  # LOGGING #
  log-bin                        = /var/lib/mysql/bin.log
  log_error                      = /var/log/mysql/mysql-error.log
  slow_query_log                 = 1
  slow_query_log_file            = /var/log/mysql/mysql-slow.log
  long_query_time                = 1
[root@localhost ~]# garbd -a gcomm://192.168.197.115,192.168.136.56,192.168.134.12?pc.wait_prim=no -g vfcluster1
  2014-12-24 14:10:10.615  INFO: CRC-32C: using hardware acceleration.
  2014-12-24 14:10:10.615  INFO: Read config: 
          daemon:  0
          name:    garb
          address: gcomm://192.168.197.115,192.168.136.56,192.168.134.12?pc.wait_prim=no
          group:   vfcluster1
          sst:     trivial
          donor:   
          options: gcs.fc_limit=9999999; gcs.fc_factor=1.0; gcs.fc_master_slave=yes
          cfg:     
          log:     
   
  2014-12-24 14:10:10.617  INFO: protonet asio version 0
  2014-12-24 14:10:10.617  INFO: Using CRC-32C for message checksums.
  2014-12-24 14:10:10.618  INFO: backend: asio
  2014-12-24 14:10:10.619  WARN: access file(gvwstate.dat) failed(No such file or directory)
  2014-12-24 14:10:10.619  INFO: restore pc from disk failed
  2014-12-24 14:10:10.620  INFO: GMCast version 0
  terminate called after throwing an instance of 'gu::NotSet'
  Aborted


Host 2:
| wsrep_local_state | 4 |
| wsrep_local_state_comment | Synced |
| wsrep_incoming_addresses | 192.168.197.115:3306 |
| wsrep_evs_state | OPERATIONAL |
| wsrep_gcomm_uuid | 6acc4184-8b9d-11e4-be4b-f666cd9bd1e5 |
| wsrep_cluster_conf_id | 1 |
| wsrep_cluster_size | 1 |
| wsrep_cluster_state_uuid | 389ea7e8-8b9d-11e4-9dda-e6c798b477e1 |
| wsrep_cluster_status | Primary |

[root@localhost ~]# cat /etc/my.cnf
   
  [mysqld]
  # Path to Galera library
  wsrep_provider=/usr/lib64/libgalera_smm.so
   
  # Cluster connection URL contains the IPs of node#1, node#2 and node#3
  wsrep_cluster_address=gcomm://192.168.197.115,192.168.136.56,192.168.134.12
  #wsrep_cluster_address=gcomm://
   
  # In order for Galera to work correctly binlog format should be ROW
  binlog_format=ROW
   
  # MyISAM storage engine has only experimental support
  default_storage_engine=InnoDB
   
  # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
  innodb_autoinc_lock_mode=2
   
  # Node address
  wsrep_node_address=192.168.197.115
   
  #
  wsrep_cluster_name=vfcluster1
  wsrep_sst_method=xtrabackup
  wsrep_sst_auth="sstuser:sstpass"
   
  # LOGGING #
  log-bin                        = /var/lib/mysql/bin.log
  log_error                      = /var/log/mysql/mysql-error.log
  slow_query_log                 = 1
  slow_query_log_file            = /var/log/mysql/mysql-slow.log
  long_query_time                = 1
[root@localhost ~]# garbd -a gcomm://192.168.197.115,192.168.136.56,192.168.134.12?pc.wait_prim=no -g vfcluster1
  2014-12-24 13:55:55.622  INFO: CRC-32C: using hardware acceleration.
  2014-12-24 13:55:55.622  INFO: Read config:
          daemon:  0
          name:    garb
          address: gcomm://192.168.197.115,192.168.136.56,192.168.134.12?pc.wait_prim=no
          group:   vfcluster1
          sst:     trivial
          donor:
          options: gcs.fc_limit=9999999; gcs.fc_factor=1.0; gcs.fc_master_slave=yes
          cfg:
          log:
   
  2014-12-24 13:55:55.624  INFO: protonet asio version 0
  2014-12-24 13:55:55.624  INFO: Using CRC-32C for message checksums.
  2014-12-24 13:55:55.625  INFO: backend: asio
  2014-12-24 13:55:55.625  WARN: access file(gvwstate.dat) failed(No such file or directory)
  2014-12-24 13:55:55.626  INFO: restore pc from disk failed
  2014-12-24 13:55:55.627  INFO: GMCast version 0
  terminate called after throwing an instance of 'gu::NotSet'
  Aborted

Comments

  • randymelderrandymelder Entrant Current User Role Beginner
    From the joiner
    141230 00:40:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    141230 00:40:00 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.AdmgHG' --pid-file='/var/lib/mysql/localhost.localdomain-recover.pid'
    2014-12-30 00:40:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    141230 00:40:03 mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1
    Log of wsrep recovery (--wsrep-recover):
    2014-12-30 00:40:00 15065 [Note] Plugin 'FEDERATED' is disabled.
    2014-12-30 00:40:00 15065 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2014-12-30 00:40:00 15065 [Note] InnoDB: The InnoDB memory heap is disabled
    2014-12-30 00:40:00 15065 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2014-12-30 00:40:00 15065 [Note] InnoDB: Memory barrier is not used
    2014-12-30 00:40:00 15065 [Note] InnoDB: Compressed tables use zlib 1.2.7
    2014-12-30 00:40:00 15065 [Note] InnoDB: Using Linux native AIO
    2014-12-30 00:40:00 15065 [Note] InnoDB: Using CPU crc32 instructions
    2014-12-30 00:40:00 15065 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2014-12-30 00:40:00 15065 [Note] InnoDB: Completed initialization of buffer pool
    2014-12-30 00:40:00 15065 [Note] InnoDB: Highest supported file format is Barracuda.
    2014-12-30 00:40:00 15065 [Note] InnoDB: 128 rollback segment(s) are active.
    2014-12-30 00:40:00 15065 [Note] InnoDB: Waiting for purge to start
    2014-12-30 00:40:00 15065 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.21-70.1 started; log sequence number 1626302
    2014-12-30 00:40:00 15065 [Warning] InnoDB: Skipping buffer pool dump/restore during wsrep recovery.
    2014-12-30 00:40:00 15065 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
    2014-12-30 00:40:00 15065 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
    2014-12-30 00:40:00 15065 [Note] Server hostname (bind-address): '*'; port: 3306
    2014-12-30 00:40:00 15065 [Note] IPv6 is available.
    2014-12-30 00:40:00 15065 [Note]   - '::' resolves to '::';
    2014-12-30 00:40:00 15065 [Note] Server socket created on IP: '::'.
    2014-12-30 00:40:00 15065 [Note] WSREP: Recovered position: 00000000-0000-0000-0000-000000000000:-1
    2014-12-30 00:40:00 15065 [Note] Binlog end
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'partition'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_METRICS'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_CMP'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_LOCKS'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'INNODB_TRX'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'XTRADB_RSEG'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
    2014-12-30 00:40:00 15065 [Note] Shutting down plugin 'InnoDB'
    2014-12-30 00:40:00 15065 [Note] InnoDB: FTS optimize thread exiting.
    2014-12-30 00:40:00 15065 [Note] InnoDB: Starting shutdown...
    2014-12-30 00:40:02 15065 [Note] InnoDB: Shutdown completed; log sequence number 1626312
    2014-12-30 00:40:02 15065 [Note] Shutting down plugin 'BLACKHOLE'
    2014-12-30 00:40:02 15065 [Note] Shutting down plugin 'ARCHIVE'
    2014-12-30 00:40:02 15065 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2014-12-30 00:40:02 15065 [Note] Shutting down plugin 'MRG_MYISAM'
    2014-12-30 00:40:02 15065 [Note] Shutting down plugin 'MyISAM'
    2014-12-30 00:40:02 15065 [Note] Shutting down plugin 'MEMORY'
    2014-12-30 00:40:02 15065 [Note] Shutting down plugin 'CSV'
    2014-12-30 00:40:02 15065 [Note] Shutting down plugin 'sha256_password'
    2014-12-30 00:40:02 15065 [Note] Shutting down plugin 'mysql_old_password'
    2014-12-30 00:40:02 15065 [Note] Shutting down plugin 'mysql_native_password'
    2014-12-30 00:40:02 15065 [Note] Shutting down plugin 'wsrep'
    2014-12-30 00:40:02 15065 [Note] Shutting down plugin 'binlog'
    2014-12-30 00:40:02 15065 [Note] /usr/sbin/mysqld: Shutdown complete
    2014-12-30 00:40:03 0 [Note] WSREP: wsrep_start_position var submitted: '00000000-0000-0000-0000-000000000000:-1'
    2014-12-30 00:40:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2014-12-30 00:40:03 15110 [Note] WSREP: Read nil XID from storage engines, skipping position init
    2014-12-30 00:40:03 15110 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so'
    2014-12-30 00:40:03 15110 [Note] WSREP: wsrep_load(): Galera 3.8(rf6147dd) by Codership Oy <info&#64;codership.com> loaded successfully.
    2014-12-30 00:40:03 15110 [Note] WSREP: CRC-32C: using hardware acceleration.
    2014-12-30 00:40:03 15110 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
    2014-12-30 00:40:03 15110 [Note] WSREP: Passing config to GCS: base_host = 192.168.136.56; base_port = 4567; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeo
    uts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.recov
    2014-12-30 00:40:03 15110 [Note] WSREP: Service thread queue flushed.
    2014-12-30 00:40:03 15110 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
    2014-12-30 00:40:03 15110 [Note] WSREP: wsrep_sst_grab()
    2014-12-30 00:40:03 15110 [Note] WSREP: Start replication
    2014-12-30 00:40:03 15110 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
    2014-12-30 00:40:03 15110 [Note] WSREP: protonet asio version 0
    2014-12-30 00:40:03 15110 [Note] WSREP: Using CRC-32C for message checksums.
    2014-12-30 00:40:03 15110 [Note] WSREP: backend: asio
    2014-12-30 00:40:03 15110 [Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory)
    2014-12-30 00:40:03 15110 [Note] WSREP: restore pc from disk failed
    2014-12-30 00:40:03 15110 [Note] WSREP: GMCast version 0
    2014-12-30 00:40:03 15110 [Note] WSREP: (4da7ba34, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
    2014-12-30 00:40:03 15110 [Note] WSREP: (4da7ba34, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
    2014-12-30 00:40:03 15110 [Note] WSREP: EVS version 0
    2014-12-30 00:40:03 15110 [Note] WSREP: gcomm: connecting to group 'vfcluster1', peer '192.168.197.115:,192.168.136.56:,192.168.134.12:'
    2014-12-30 00:40:03 15110 [Warning] WSREP: (4da7ba34, 'tcp://0.0.0.0:4567') address 'tcp://192.168.136.56:4567' points to own listening address, blacklisting
    2014-12-30 00:40:03 15110 [Note] WSREP: (4da7ba34, 'tcp://0.0.0.0:4567') address 'tcp://192.168.136.56:4567' pointing to uuid 4da7ba34 is blacklisted, skipping
    2014-12-30 00:40:03 15110 [Note] WSREP: (4da7ba34, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 
    2014-12-30 00:40:04 15110 [Note] WSREP: gcomm: connected
    2014-12-30 00:40:04 15110 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
    2014-12-30 00:40:04 15110 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
    2014-12-30 00:40:04 15110 [Note] WSREP: Opened channel 'vfcluster1'
    2014-12-30 00:40:04 15110 [Note] WSREP: Waiting for SST to complete.
    2014-12-30 00:40:04 15110 [Note] WSREP: declaring 3456e083 at tcp://192.168.197.115:4567 stable
    2014-12-30 00:40:04 15110 [Note] WSREP: Node 3456e083 state prim
    2014-12-30 00:40:04 15110 [Note] WSREP: view(view_id(PRIM,3456e083,4) memb {
            3456e083,0
            4da7ba34,0
    } joined {
    } left {
    } partitioned {
    })
    2014-12-30 00:40:04 15110 [Note] WSREP: save pc into disk
    2014-12-30 00:40:04 15110 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
    2014-12-30 00:40:04 15110 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
    2014-12-30 00:40:04 15110 [Note] WSREP: discarding pending addr without UUID: tcp://192.168.134.12:4567
    2014-12-30 00:40:04 15110 [Note] WSREP: discarding pending addr proto entry 0x31eff40
    2014-12-30 00:40:04 15110 [Note] WSREP: STATE EXCHANGE: sent state msg: 4def8365-8fe6-11e4-a7cd-e75da6daccdf
    2014-12-30 00:40:04 15110 [Note] WSREP: STATE EXCHANGE: got state msg: 4def8365-8fe6-11e4-a7cd-e75da6daccdf from 0 (localhost.localdomain)
    2014-12-30 00:40:04 15110 [Note] WSREP: STATE EXCHANGE: got state msg: 4def8365-8fe6-11e4-a7cd-e75da6daccdf from 1 (localhost.localdomain)
    2014-12-30 00:40:04 15110 [Note] WSREP: Quorum results:
            version    = 3,
            component  = PRIMARY,
            conf_id    = 3,
            members    = 1/2 (joined/total),
            act_id     = 0,
            last_appl. = -1,
            protocols  = 0/6/3 (gcs/repl/appl),
            group UUID = 34579e25-8fe2-11e4-93f3-f7db4a4bab57
    2014-12-30 00:40:04 15110 [Note] WSREP: Flow-control interval: [23, 23]
    2014-12-30 00:40:04 15110 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 0)
    2014-12-30 00:40:04 15110 [Note] WSREP: State transfer required: 
            Group state: 34579e25-8fe2-11e4-93f3-f7db4a4bab57:0
            Local state: 00000000-0000-0000-0000-000000000000:-1
    2014-12-30 00:40:04 15110 [Note] WSREP: New cluster view: global state: 34579e25-8fe2-11e4-93f3-f7db4a4bab57:0, view# 4: Primary, number of nodes: 2, my index: 1, protocol version 3
    2014-12-30 00:40:04 15110 [Warning] WSREP: Gap in state sequence. Need state transfer.
    2014-12-30 00:40:04 15110 [Note] WSREP: Running: 'wsrep_sst_xtrabackup --role 'joiner' --address '192.168.136.56' --auth '"sstuser:sst2014a"' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '15110'  '' '
    WSREP_SST: [INFO] Streaming with tar (20141230 00:40:04.391)
    WSREP_SST: [INFO] Using socat as streamer (20141230 00:40:04.398)
    WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:4444,reuseaddr stdio | tar xfi - --recursive-unlink -h; RC=( ${PIPESTATUS[&#64;]} ) (20141230 00:40:04.432)
    2014-12-30 00:40:04 15110 [Note] WSREP: Prepared SST request: xtrabackup|192.168.136.56:4444/xtrabackup_sst
    2014-12-30 00:40:04 15110 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
    2014-12-30 00:40:04 15110 [Note] WSREP: REPL Protocols: 6 (3, 2)
    2014-12-30 00:40:04 15110 [Note] WSREP: Service thread queue flushed.
    2014-12-30 00:40:04 15110 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
    2014-12-30 00:40:04 15110 [Note] WSREP: Service thread queue flushed.
    2014-12-30 00:40:04 15110 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (34579e25-8fe2-11e4-93f3-f7db4a4bab57): 1 (Operation not permitted)
             at galera/src/replicator_str.cpp:prepare_for_IST():456. IST will be unavailable.
    2014-12-30 00:40:04 15110 [Note] WSREP: Member 1.0 (localhost.localdomain) requested state transfer from '*any*'. Selected 0.0 (localhost.localdomain)(SYNCED) as donor.
    2014-12-30 00:40:04 15110 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0)
    2014-12-30 00:40:04 15110 [Note] WSREP: Requesting state transfer: success, donor: 0
    tar: This does not look like a tar archive
    tar: Exiting with failure status due to previous errors
    WSREP_SST: [ERROR] Error while getting data from donor node:  exit codes: 0 2 (20141230 00:40:04.934)
    WSREP_SST: [ERROR] Cleanup after exit with status:32 (20141230 00:40:04.939)
    2014-12-30 00:40:04 15110 [Warning] WSREP: 0.0 (localhost.localdomain): State transfer to 1.0 (localhost.localdomain) failed: -22 (Invalid argument)
    2014-12-30 00:40:04 15110 [ERROR] WSREP: gcs/src/gcs_group.cpp:int gcs_group_handle_join_msg(gcs_group_t*, const gcs_recv_msg_t*)():722: Will never receive state. Need to abort.
    2014-12-30 00:40:04 15110 [Note] WSREP: gcomm: terminating thread
    2014-12-30 00:40:04 15110 [Note] WSREP: gcomm: joining thread
    2014-12-30 00:40:04 15110 [Note] WSREP: gcomm: closing backend
    WSREP_SST: [INFO] Removing the sst_in_progress file (20141230 00:40:04.951)
    2014-12-30 00:40:04 15110 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role 'joiner' --address '192.168.136.56' --auth '"sstuser:sst2014a"' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '15110'  '' : 32 (Broken pipe)
    2014-12-30 00:40:04 15110 [ERROR] WSREP: Failed to read uuid:seqno from joiner script.
    2014-12-30 00:40:04 15110 [ERROR] WSREP: SST failed: 32 (Broken pipe)
    2014-12-30 00:40:04 15110 [ERROR] Aborting
    
    2014-12-30 00:40:05 15110 [Note] WSREP: view(view_id(NON_PRIM,3456e083,4) memb {
            4da7ba34,0
    } joined {
    } left {
    } partitioned {
            3456e083,0
    })
    2014-12-30 00:40:05 15110 [Note] WSREP: view((empty))
    2014-12-30 00:40:05 15110 [Note] WSREP: gcomm: closed
    2014-12-30 00:40:05 15110 [Note] WSREP: /usr/sbin/mysqld: Terminated.
    141230 00:40:05 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
    
  • randymelderrandymelder Entrant Current User Role Beginner
    Solved this by commenting out in /etc/my.cnf:
    #wsrep_sst_method               =xtrabackup
    
    Same as: http://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/27626-2nd-node-unable-to-join-cluster
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.