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

Problem with join second node

finderomfinderom EntrantInactive User Role Beginner
on the second node
...
2014-11-06 18:07:08 31639 [Note] WSREP: Quorum results:
        version    = 3,
        component  = PRIMARY,
        conf_id    = 1,
        members    = 1/2 (joined/total),
        act_id     = 2,
        last_appl. = -1,
        protocols  = 0/6/3 (gcs/repl/appl),
        group UUID = 2229ae6f-6595-11e4-8b6c-e71853b84023
2014-11-06 18:07:08 31639 [Note] WSREP: Flow-control interval: [23, 23]
2014-11-06 18:07:08 31639 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 2)
2014-11-06 18:07:08 31639 [Note] WSREP: State transfer required:
        Group state: 2229ae6f-6595-11e4-8b6c-e71853b84023:2
        Local state: ebf70b75-6598-11e4-a137-bfaf04127fe1:2
2014-11-06 18:07:08 31639 [Note] WSREP: New cluster view: global state: 2229ae6f-6595-11e4-8b6c-e71853b84023:2, view# 2: Primary, number of nodes: 2, my index: 1, protocol version 3
2014-11-06 18:07:08 31639 [Warning] WSREP: Gap in state sequence. Need state transfer.
2014-11-06 18:07:08 31639 [Note] WSREP: Running: 'wsrep_sst_xtrabackup-v2 --role 'joiner' --address '192.168.1.104' --auth 'sstuser:s3cretPass' --datadir '/var/lib/mysql/' --defaults-file '
/etc/mysql/my.cnf' --parent '31639'  '' '
[B]2014-11-06 18:07:08 31639 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '192.168.1.104' --auth 'sstuser:s3cretPass' --datadir '/var/li
b/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent '31639'  ''
        Read: '(null)'
2014-11-06 18:07:08 31639 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '192.168.1.104' --auth 'sstuser:s3cretPass' --datadir '/var/lib/mysq
l/' --defaults-file '/etc/mysql/my.cnf' --parent '31639'  '' : 2 (No such file or directory)[/B]
2014-11-06 18:07:08 31639 [ERROR] WSREP: Failed to prepare for 'xtrabackup-v2' SST. Unrecoverable.
2014-11-06 18:07:08 31639 [ERROR] Aborting

2014-11-06 18:07:10 31639 [Note] WSREP: Closing send monitor...
...

on the first donor
2014-11-06 18:07:04 14322 [Note] WSREP: (2386c901, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
2014-11-06 18:07:05 14322 [Note] WSREP: declaring 31bf04dc at tcp://192.168.1.104:4567 stable
2014-11-06 18:07:05 14322 [Note] WSREP: Node 2386c901 state prim
2014-11-06 18:07:05 14322 [Note] WSREP: save pc into disk
2014-11-06 18:07:05 14322 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
2014-11-06 18:07:05 14322 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 301ac1d6-65be-11e4-90a5-e21a08d488d0
2014-11-06 18:07:05 14322 [Note] WSREP: STATE EXCHANGE: sent state msg: 301ac1d6-65be-11e4-90a5-e21a08d488d0
2014-11-06 18:07:05 14322 [Note] WSREP: STATE EXCHANGE: got state msg: 301ac1d6-65be-11e4-90a5-e21a08d488d0 from 0 (UbuntuServer003)
2014-11-06 18:07:05 14322 [Note] WSREP: STATE EXCHANGE: got state msg: 301ac1d6-65be-11e4-90a5-e21a08d488d0 from 1 (UbuntuServer002)
2014-11-06 18:07:05 14322 [Note] WSREP: Quorum results:
        version    = 3,
        component  = PRIMARY,
        conf_id    = 1,
        members    = 1/2 (joined/total),
        act_id     = 2,
        last_appl. = 0,
        protocols  = 0/6/3 (gcs/repl/appl),
        group UUID = 2229ae6f-6595-11e4-8b6c-e71853b84023
2014-11-06 18:07:05 14322 [Note] WSREP: Flow-control interval: [23, 23]
2014-11-06 18:07:05 14322 [Note] WSREP: New cluster view: global state: 2229ae6f-6595-11e4-8b6c-e71853b84023:2, view# 2: Primary, number of nodes:
 2, my index: 0, protocol version 3
2014-11-06 18:07:05 14322 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2014-11-06 18:07:05 14322 [Note] WSREP: REPL Protocols: 6 (3, 2)
2014-11-06 18:07:05 14322 [Note] WSREP: Service thread queue flushed.
2014-11-06 18:07:05 14322 [Note] WSREP: Assign initial position for certification: 2, protocol version: 3
2014-11-06 18:07:05 14322 [Note] WSREP: Service thread queue flushed.
2014-11-06 18:07:08 14322 [Note] WSREP: (2386c901, 'tcp://0.0.0.0:4567') turning message relay requesting off
2014-11-06 18:07:08 14322 [Note] WSREP: forgetting 31bf04dc (tcp://192.168.1.104:4567)
2014-11-06 18:07:08 14322 [Note] WSREP: Node 2386c901 state prim
2014-11-06 18:07:08 14322 [Note] WSREP: save pc into disk
2014-11-06 18:07:08 14322 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2014-11-06 18:07:08 14322 [Note] WSREP: forgetting 31bf04dc (tcp://192.168.1.104:4567)
2014-11-06 18:07:08 14322 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 31e4e5d0-65be-11e4-93e6-de91cc2fe202
2014-11-06 18:07:08 14322 [Note] WSREP: STATE EXCHANGE: sent state msg: 31e4e5d0-65be-11e4-93e6-de91cc2fe202
2014-11-06 18:07:08 14322 [Note] WSREP: STATE EXCHANGE: got state msg: 31e4e5d0-65be-11e4-93e6-de91cc2fe202 from 0 (UbuntuServer003)
2014-11-06 18:07:08 14322 [Note] WSREP: Quorum results:
        version    = 3,
        component  = PRIMARY,
        conf_id    = 2,
        members    = 1/1 (joined/total),
        act_id     = 2,
        last_appl. = 0,
        protocols  = 0/6/3 (gcs/repl/appl),
        group UUID = 2229ae6f-6595-11e4-8b6c-e71853b84023
2014-11-06 18:07:08 14322 [Note] WSREP: Flow-control interval: [16, 16]
2014-11-06 18:07:08 14322 [Note] WSREP: New cluster view: global state: 2229ae6f-6595-11e4-8b6c-e71853b84023:2, view# 3: Primary, number of nodes:
 1, my index: 0, protocol version 3
2014-11-06 18:07:08 14322 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2014-11-06 18:07:08 14322 [Note] WSREP: REPL Protocols: 6 (3, 2)
2014-11-06 18:07:08 14322 [Note] WSREP: Service thread queue flushed.
2014-11-06 18:07:08 14322 [Note] WSREP: Assign initial position for certification: 2, protocol version: 3
2014-11-06 18:07:08 14322 [Note] WSREP: Service thread queue flushed.
2014-11-06 18:07:13 14322 [Note] WSREP:  cleaning up 31bf04dc (tcp://192.168.1.104:4567)

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    Is /var/lib/mysql/ present on the joiner and having correct ownership? Can you share my.cnf?
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.