150224 21:16:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150224 21:16:56 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.df5lDk' --pid-file='/var/lib/mysql/db1.dev-recover.pid' 150224 21:16:58 mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1 150224 21:16:58 [Note] WSREP: wsrep_start_position var submitted: '00000000-0000-0000-0000-000000000000:-1' 150224 21:16:58 [Note] WSREP: Read nil XID from storage engines, skipping position init 150224 21:16:58 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' 150224 21:16:58 [Note] WSREP: wsrep_load(): Galera 25.3.9(r0) by Codership Oy loaded successfully. 150224 21:16:58 [Note] WSREP: CRC-32C: using hardware acceleration. 150224 21:16:58 [Warning] WSREP: Could not open saved state file for reading: /var/lib/mysql//grastate.dat 150224 21:16:58 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1 150224 21:16:58 [Note] WSREP: Passing config to GCS: base_host = 10.2.0.68; 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_timeouts = 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.recovery = 150224 21:16:58 [Note] WSREP: Service thread queue flushed. 150224 21:16:58 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 150224 21:16:58 [Note] WSREP: wsrep_sst_grab() 150224 21:16:58 [Note] WSREP: Start replication 150224 21:16:58 [Note] WSREP: 'wsrep-new-cluster' option used, bootstrapping the cluster 150224 21:16:58 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 150224 21:16:58 [Note] WSREP: protonet asio version 0 150224 21:16:58 [Note] WSREP: Using CRC-32C for message checksums. 150224 21:16:58 [Note] WSREP: backend: asio 150224 21:16:58 [Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory) 150224 21:16:58 [Note] WSREP: restore pc from disk failed 150224 21:16:58 [Note] WSREP: GMCast version 0 150224 21:16:58 [Note] WSREP: (77b831d5, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 150224 21:16:58 [Note] WSREP: (77b831d5, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 150224 21:16:58 [Note] WSREP: EVS version 0 150224 21:16:58 [Note] WSREP: gcomm: bootstrapping new group 'convoy_cluster' 150224 21:16:58 [Note] WSREP: start_prim is enabled, turn off pc_recovery 150224 21:16:58 [Note] WSREP: Node 77b831d5 state prim 150224 21:16:58 [Note] WSREP: view(view_id(PRIM,77b831d5,1) memb { 77b831d5,0 } joined { } left { } partitioned { }) 150224 21:16:58 [Note] WSREP: save pc into disk 150224 21:16:58 [Note] WSREP: discarding pending addr without UUID: tcp://10.2.0.69:4567 150224 21:16:58 [Note] WSREP: discarding pending addr proto entry 0x7f38fb8d2440 150224 21:16:58 [Note] WSREP: gcomm: connected 150224 21:16:58 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 150224 21:16:58 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 150224 21:16:58 [Note] WSREP: Opened channel 'convoy_cluster' 150224 21:16:58 [Note] WSREP: Waiting for SST to complete. 150224 21:16:58 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 150224 21:16:58 [Note] WSREP: Starting new group from scratch: 77b9aaef-bc6a-11e4-9686-166bd65cd1d1 150224 21:16:58 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 77b9d6b6-bc6a-11e4-ba28-caa993ee0e2a 150224 21:16:58 [Note] WSREP: STATE EXCHANGE: sent state msg: 77b9d6b6-bc6a-11e4-ba28-caa993ee0e2a 150224 21:16:58 [Note] WSREP: STATE EXCHANGE: got state msg: 77b9d6b6-bc6a-11e4-ba28-caa993ee0e2a from 0 (db1.dev) 150224 21:16:58 [Note] WSREP: Quorum results: version = 3, component = PRIMARY, conf_id = 0, members = 1/1 (joined/total), act_id = 0, last_appl. = -1, protocols = 0/7/3 (gcs/repl/appl), group UUID = 77b9aaef-bc6a-11e4-9686-166bd65cd1d1 150224 21:16:58 [Note] WSREP: Flow-control interval: [16, 16] 150224 21:16:58 [Note] WSREP: Restored state OPEN -> JOINED (0) 150224 21:16:58 [Note] WSREP: Member 0.0 (db1.dev) synced with group. 150224 21:16:58 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) 150224 21:16:58 [Note] WSREP: New cluster view: global state: 77b9aaef-bc6a-11e4-9686-166bd65cd1d1:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3 150224 21:16:58 [Note] WSREP: SST complete, seqno: 0 150224 21:16:58 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150224 21:16:58 [Note] InnoDB: The InnoDB memory heap is disabled 150224 21:16:58 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150224 21:16:58 [Note] InnoDB: Memory barrier is not used 150224 21:16:58 [Note] InnoDB: Compressed tables use zlib 1.2.3 150224 21:16:58 [Note] InnoDB: Using Linux native AIO 150224 21:16:58 [Note] InnoDB: Using CPU crc32 instructions 150224 21:16:58 [Note] InnoDB: Initializing buffer pool, size = 798.0M 150224 21:16:58 [Note] InnoDB: Completed initialization of buffer pool 150224 21:16:58 [Note] InnoDB: Highest supported file format is Barracuda. 150224 21:16:59 [Note] InnoDB: 128 rollback segment(s) are active. 150224 21:16:59 [Note] InnoDB: Waiting for purge to start 150224 21:16:59 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-71.0 started; log sequence number 1616885 150224 21:16:59 [Note] Plugin 'FEEDBACK' is disabled. 150224 21:16:59 [Note] Server socket created on IP: '::'. 150224 21:16:59 [Note] Event Scheduler: Loaded 0 events 150224 21:16:59 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150224 21:16:59 [Note] WSREP: REPL Protocols: 7 (3, 2) 150224 21:16:59 [Note] WSREP: Service thread queue flushed. 150224 21:16:59 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3 150224 21:16:59 [Note] WSREP: Service thread queue flushed. 150224 21:16:59 [Note] WSREP: Synchronized with group, ready for connections 150224 21:16:59 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150224 21:16:59 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.0.16-MariaDB-wsrep-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server, wsrep_25.10.r4144 Status information: Current dir: /var/lib/mysql/ Running threads: 2 Stack size: 294912 Current locks: lock: 0x7f38fb88f788: lock: 0x7f38fb883788: lock: 0x7f38fb869588: lock: 0x7f38fb868188: lock: 0x7f38fb866388: lock: 0x7f38fb864f88: lock: 0x7f38fb956b88: lock: 0x7f38fb997388: lock: 0x7f38fb880788: lock: 0x7f38fb861d88: lock: 0x7f389801a508: lock: 0x14395e0: lock: 0x1439500: lock: 0x1438540: lock: 0x1438460: lock: 0x1438380: lock: 0x1438700: lock: 0x1436940: lock: 0x1439420: lock: 0x1437040: lock: 0x14372e0: lock: 0x1436f60: lock: 0x1437200: lock: 0x1436e80: lock: 0x1437120: lock: 0x1437660: lock: 0x1437740: lock: 0x1437820: lock: 0x1436da0: lock: 0x1436b00: lock: 0x1436cc0: lock: 0x1436a20: lock: 0x1436be0: lock: 0x14373c0: lock: 0x14374a0: lock: 0x1437580: lock: 0x14390a0: lock: 0x1439340: lock: 0x1439260: lock: 0x1439180: lock: 0x1438d20: lock: 0x1438c40: lock: 0x1438b60: lock: 0x1438a80: lock: 0x14389a0: lock: 0x1438ee0: lock: 0x14388c0: lock: 0x14387e0: lock: 0x1438fc0: lock: 0x1438620: lock: 0x14381c0: lock: 0x14382a0: lock: 0x14380e0: lock: 0x1438000: lock: 0x1437c80: lock: 0x1437f20: lock: 0x1437e40: lock: 0x1437ba0: lock: 0x1437d60: lock: 0x1437900: lock: 0x14379e0: lock: 0x1437ac0: lock: 0x1438e00: Key caches: default Buffer_size: 134217728 Block_size: 1024 Division_limit: 100 Age_threshold: 300 Partitions: 0 blocks used: 2 not flushed: 0 w_requests: 8 writes: 2 r_requests: 4 reads: 2 handler status: read_key: 0 read_next: 0 read_rnd 0 read_first: 0 write: 0 delete 0 update: 0 Table status: Opened tables: 0 Open tables: 63 Open files: 26 Open streams: 0 Alarm status: Active alarms: 0 Max used alarms: 0 Next alarm time: 0 Memory status: Non-mmapped space allocated from system: 0 Number of free chunks: 1 Number of fastbin blocks: 0 Number of mmapped regions: 0 Space in mmapped regions: 0 Maximum total allocated space: 0 Space available in freed fastbin blocks: 0 Total allocated space: 0 Total free space: 0 Top-most, releasable space: 0 Estimated memory (with thread stack): 589824 Events status: LLA = Last Locked At LUA = Last Unlocked At WOC = Waiting On Condition DL = Data Locked Event scheduler status: State : INITIALIZED Thread id : 0 LLA : n/a:0 LUA : n/a:0 WOC : NO Workers : 0 Executed : 0 Data locked: NO Event queue status: Element count : 0 Data locked : NO Attempting lock : NO LLA : init_queue:140 LUA : init_queue:150 WOC : NO Next activation : never 150224 21:17:05 [Note] WSREP: (77b831d5, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 150224 21:17:06 [Note] WSREP: declaring 7bdd4961 at tcp://10.2.0.69:4567 stable 150224 21:17:06 [Note] WSREP: Node 77b831d5 state prim 150224 21:17:06 [Note] WSREP: view(view_id(PRIM,77b831d5,2) memb { 77b831d5,0 7bdd4961,0 } joined { } left { } partitioned { }) 150224 21:17:06 [Note] WSREP: save pc into disk 150224 21:17:06 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 150224 21:17:06 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 7c2b16aa-bc6a-11e4-867f-6f83e9794893 150224 21:17:06 [Note] WSREP: STATE EXCHANGE: sent state msg: 7c2b16aa-bc6a-11e4-867f-6f83e9794893 150224 21:17:06 [Note] WSREP: STATE EXCHANGE: got state msg: 7c2b16aa-bc6a-11e4-867f-6f83e9794893 from 0 (db1.dev) 150224 21:17:06 [Note] WSREP: STATE EXCHANGE: got state msg: 7c2b16aa-bc6a-11e4-867f-6f83e9794893 from 1 (db2.dev) 150224 21:17:06 [Note] WSREP: Quorum results: version = 3, component = PRIMARY, conf_id = 1, members = 1/2 (joined/total), act_id = 11, last_appl. = 0, protocols = 0/7/3 (gcs/repl/appl), group UUID = 77b9aaef-bc6a-11e4-9686-166bd65cd1d1 150224 21:17:06 [Note] WSREP: Flow-control interval: [23, 23] 150224 21:17:06 [Note] WSREP: New cluster view: global state: 77b9aaef-bc6a-11e4-9686-166bd65cd1d1:11, view# 2: Primary, number of nodes: 2, my index: 0, protocol version 3 150224 21:17:06 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150224 21:17:06 [Note] WSREP: REPL Protocols: 7 (3, 2) 150224 21:17:06 [Note] WSREP: Service thread queue flushed. 150224 21:17:06 [Note] WSREP: Assign initial position for certification: 11, protocol version: 3 150224 21:17:06 [Note] WSREP: Service thread queue flushed. 150224 21:17:06 [Note] WSREP: Member 1.0 (db2.dev) requested state transfer from '*any*'. Selected 0.0 (db1.dev)(SYNCED) as donor. 150224 21:17:06 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 11) 150224 21:17:06 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150224 21:17:06 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '10.2.0.69:4444/rsync_sst' --auth '(null)' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --binlog 'mysqld-bin' --gtid '77b9aaef-bc6a-11e4-9686-166bd65cd1d1:11'' 150224 21:17:06 [Note] WSREP: sst_donor_thread signaled with 0 150224 21:17:06 [Note] WSREP: Flushing tables for SST... 150224 21:17:06 [Note] WSREP: Provider paused at 77b9aaef-bc6a-11e4-9686-166bd65cd1d1:11 (16) 150224 21:17:06 [Note] WSREP: Tables flushed. 150224 21:17:08 [Note] WSREP: resuming provider at 16 150224 21:17:08 [Note] WSREP: Provider resumed. 150224 21:17:08 [Note] WSREP: 0.0 (db1.dev): State transfer to 1.0 (db2.dev) complete. 150224 21:17:08 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 11) 150224 21:17:08 [Note] WSREP: Member 0.0 (db1.dev) synced with group. 150224 21:17:08 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 11) 150224 21:17:08 [Note] WSREP: Synchronized with group, ready for connections 150224 21:17:08 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150224 21:17:08 [Note] WSREP: (77b831d5, 'tcp://0.0.0.0:4567') turning message relay requesting off 150224 21:17:09 [Note] WSREP: 1.0 (db2.dev): State transfer from 0.0 (db1.dev) complete. 150224 21:17:09 [Note] WSREP: Member 1.0 (db2.dev) synced with group. 150224 21:19:40 [Note] /usr/sbin/mysqld: Normal shutdown 150224 21:19:40 [Note] WSREP: Stop replication 150224 21:19:40 [Note] WSREP: Closing send monitor... 150224 21:19:40 [Note] WSREP: Closed send monitor. 150224 21:19:40 [Note] WSREP: gcomm: terminating thread 150224 21:19:40 [Note] WSREP: gcomm: joining thread 150224 21:19:40 [Note] WSREP: gcomm: closing backend 150224 21:19:41 [Note] WSREP: view(view_id(NON_PRIM,77b831d5,2) memb { 77b831d5,0 } joined { } left { } partitioned { 7bdd4961,0 }) 150224 21:19:41 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 150224 21:19:41 [Note] WSREP: view((empty)) 150224 21:19:41 [Note] WSREP: gcomm: closed 150224 21:19:41 [Note] WSREP: Flow-control interval: [16, 16] 150224 21:19:41 [Note] WSREP: Received NON-PRIMARY. 150224 21:19:41 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 11) 150224 21:19:41 [Note] WSREP: Received self-leave message. 150224 21:19:41 [Note] WSREP: Flow-control interval: [0, 0] 150224 21:19:41 [Note] WSREP: Received SELF-LEAVE. Closing connection. 150224 21:19:41 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 11) 150224 21:19:41 [Note] WSREP: RECV thread exiting 0: Success 150224 21:19:41 [Note] WSREP: New cluster view: global state: 77b9aaef-bc6a-11e4-9686-166bd65cd1d1:11, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 150224 21:19:41 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150224 21:19:41 [Note] WSREP: New cluster view: global state: 77b9aaef-bc6a-11e4-9686-166bd65cd1d1:11, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 3 150224 21:19:41 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150224 21:19:41 [Note] WSREP: applier thread exiting (code:0) 150224 21:19:41 [Note] WSREP: recv_thread() joined. 150224 21:19:41 [Note] WSREP: Closing replication queue. 150224 21:19:41 [Note] WSREP: Closing slave action queue. 150224 21:19:43 [Note] WSREP: rollbacker thread exiting 150224 21:19:43 [Note] Event Scheduler: Purging the queue. 0 events 150224 21:19:43 [Note] WSREP: dtor state: CLOSED 150224 21:19:43 [Note] WSREP: mon: entered 11 oooe fraction 0 oool fraction 0 150224 21:19:43 [Note] WSREP: mon: entered 11 oooe fraction 0 oool fraction 0 150224 21:19:43 [Note] WSREP: mon: entered 20 oooe fraction 0 oool fraction 0 150224 21:19:43 [Note] WSREP: cert index usage at exit 0 150224 21:19:43 [Note] WSREP: cert trx map usage at exit 0 150224 21:19:43 [Note] WSREP: deps set usage at exit 0 150224 21:19:43 [Note] WSREP: avg deps dist 1 150224 21:19:43 [Note] WSREP: avg cert interval 0 150224 21:19:43 [Note] WSREP: cert index size 7 150224 21:19:43 [Note] WSREP: Service thread queue flushed. 150224 21:19:43 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 150224 21:19:43 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 11, in use: 0, in pool: 11 150224 21:19:43 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 150224 21:19:43 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 11) 150224 21:19:43 [Note] WSREP: Flushing memory map to disk... 150224 21:19:43 [Note] InnoDB: FTS optimize thread exiting. 150224 21:19:43 [Note] InnoDB: Starting shutdown... 150224 21:19:45 [Note] InnoDB: Shutdown completed; log sequence number 1618807 150224 21:19:45 [Note] /usr/sbin/mysqld: Shutdown complete 150224 21:19:45 mysqld_safe mysqld from pid file /var/lib/mysql/db1.dev.pid ended 150224 21:19:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150224 21:19:46 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.JNnFQW' --pid-file='/var/lib/mysql/db1.dev-recover.pid' 150224 21:19:48 mysqld_safe WSREP: Recovered position 77b9aaef-bc6a-11e4-9686-166bd65cd1d1:11 150224 21:19:48 [Note] WSREP: wsrep_start_position var submitted: '77b9aaef-bc6a-11e4-9686-166bd65cd1d1:11' 150224 21:19:48 [Note] WSREP: Read nil XID from storage engines, skipping position init 150224 21:19:48 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' 150224 21:19:48 [Note] WSREP: wsrep_load(): Galera 25.3.9(r0) by Codership Oy loaded successfully. 150224 21:19:48 [Note] WSREP: CRC-32C: using hardware acceleration. 150224 21:19:48 [Note] WSREP: Found saved state: 77b9aaef-bc6a-11e4-9686-166bd65cd1d1:11 150224 21:19:48 [Note] WSREP: Passing config to GCS: base_host = 10.2.0.68; 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_timeouts = 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.recovery = 150224 21:19:48 [Note] WSREP: Service thread queue flushed. 150224 21:19:48 [Note] WSREP: Assign initial position for certification: 11, protocol version: -1 150224 21:19:48 [Note] WSREP: wsrep_sst_grab() 150224 21:19:48 [Note] WSREP: Start replication 150224 21:19:48 [Note] WSREP: 'wsrep-new-cluster' option used, bootstrapping the cluster 150224 21:19:48 [Note] WSREP: Setting initial position to 77b9aaef-bc6a-11e4-9686-166bd65cd1d1:11 150224 21:19:48 [Note] WSREP: protonet asio version 0 150224 21:19:48 [Note] WSREP: Using CRC-32C for message checksums. 150224 21:19:48 [Note] WSREP: backend: asio 150224 21:19:48 [Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory) 150224 21:19:48 [Note] WSREP: restore pc from disk failed 150224 21:19:48 [Note] WSREP: GMCast version 0 150224 21:19:48 [Note] WSREP: (dcd8be91, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 150224 21:19:48 [Note] WSREP: (dcd8be91, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 150224 21:19:48 [Note] WSREP: EVS version 0 150224 21:19:48 [Note] WSREP: gcomm: bootstrapping new group 'convoy_cluster' 150224 21:19:48 [Note] WSREP: start_prim is enabled, turn off pc_recovery 150224 21:19:48 [Note] WSREP: Node dcd8be91 state prim 150224 21:19:48 [Note] WSREP: view(view_id(PRIM,dcd8be91,1) memb { dcd8be91,0 } joined { } left { } partitioned { }) 150224 21:19:48 [Note] WSREP: save pc into disk 150224 21:19:48 [Note] WSREP: discarding pending addr without UUID: tcp://10.2.0.69:4567 150224 21:19:48 [Note] WSREP: discarding pending addr proto entry 0x7f7880cd2440 150224 21:19:48 [Note] WSREP: gcomm: connected 150224 21:19:48 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 150224 21:19:48 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 150224 21:19:48 [Note] WSREP: Opened channel 'convoy_cluster' 150224 21:19:48 [Note] WSREP: Waiting for SST to complete. 150224 21:19:48 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 150224 21:19:48 [Note] WSREP: STATE_EXCHANGE: sent state UUID: dcdba9c9-bc6a-11e4-87db-ee6c80d39810 150224 21:19:48 [Note] WSREP: STATE EXCHANGE: sent state msg: dcdba9c9-bc6a-11e4-87db-ee6c80d39810 150224 21:19:48 [Note] WSREP: STATE EXCHANGE: got state msg: dcdba9c9-bc6a-11e4-87db-ee6c80d39810 from 0 (db1.dev) 150224 21:19:48 [Note] WSREP: Quorum results: version = 3, component = PRIMARY, conf_id = 0, members = 1/1 (joined/total), act_id = 11, last_appl. = -1, protocols = 0/7/3 (gcs/repl/appl), group UUID = 77b9aaef-bc6a-11e4-9686-166bd65cd1d1 150224 21:19:48 [Note] WSREP: Flow-control interval: [16, 16] 150224 21:19:48 [Note] WSREP: Restored state OPEN -> JOINED (11) 150224 21:19:48 [Note] WSREP: Member 0.0 (db1.dev) synced with group. 150224 21:19:48 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 11) 150224 21:19:48 [Note] WSREP: New cluster view: global state: 77b9aaef-bc6a-11e4-9686-166bd65cd1d1:11, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3 150224 21:19:48 [Note] WSREP: SST complete, seqno: 11 150224 21:19:48 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150224 21:19:48 [Note] InnoDB: The InnoDB memory heap is disabled 150224 21:19:48 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150224 21:19:48 [Note] InnoDB: Memory barrier is not used 150224 21:19:48 [Note] InnoDB: Compressed tables use zlib 1.2.3 150224 21:19:48 [Note] InnoDB: Using Linux native AIO 150224 21:19:48 [Note] InnoDB: Using CPU crc32 instructions 150224 21:19:48 [Note] InnoDB: Initializing buffer pool, size = 798.0M 150224 21:19:48 [Note] InnoDB: Completed initialization of buffer pool 150224 21:19:48 [Note] InnoDB: Highest supported file format is Barracuda. 150224 21:19:48 [Note] InnoDB: 128 rollback segment(s) are active. 150224 21:19:48 [Note] InnoDB: Waiting for purge to start 150224 21:19:48 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-71.0 started; log sequence number 1618817 150224 21:19:48 [Note] Plugin 'FEEDBACK' is disabled. 150224 21:19:48 [Note] Server socket created on IP: '::'. 150224 21:19:48 [Note] Event Scheduler: Loaded 0 events 150224 21:19:48 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150224 21:19:48 [Note] WSREP: REPL Protocols: 7 (3, 2) 150224 21:19:48 [Note] WSREP: Service thread queue flushed. 150224 21:19:48 [Note] WSREP: Assign initial position for certification: 11, protocol version: 3 150224 21:19:48 [Note] WSREP: Service thread queue flushed. 150224 21:19:48 [Note] WSREP: Synchronized with group, ready for connections 150224 21:19:48 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150224 21:19:48 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.0.16-MariaDB-wsrep-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server, wsrep_25.10.r4144 Status information: Current dir: /var/lib/mysql/ Running threads: 2 Stack size: 294912 Current locks: lock: 0x7f7880c8f788: lock: 0x7f7880c83788: lock: 0x7f7880c69588: lock: 0x7f7880c68188: lock: 0x7f7880c66388: lock: 0x7f7880c64f88: lock: 0x7f7880d56b88: lock: 0x7f7880d98388: lock: 0x7f7880c80788: lock: 0x7f7880c61d88: lock: 0x7f781d41a508: lock: 0x14395e0: lock: 0x1439500: lock: 0x1438540: lock: 0x1438460: lock: 0x1438380: lock: 0x1438700: lock: 0x1436940: lock: 0x1439420: lock: 0x1437040: lock: 0x14372e0: lock: 0x1436f60: lock: 0x1437200: lock: 0x1436e80: lock: 0x1437120: lock: 0x1437660: lock: 0x1437740: lock: 0x1437820: lock: 0x1436da0: lock: 0x1436b00: lock: 0x1436cc0: lock: 0x1436a20: lock: 0x1436be0: lock: 0x14373c0: lock: 0x14374a0: lock: 0x1437580: lock: 0x14390a0: lock: 0x1439340: lock: 0x1439260: lock: 0x1439180: lock: 0x1438d20: lock: 0x1438c40: lock: 0x1438b60: lock: 0x1438a80: lock: 0x14389a0: lock: 0x1438ee0: lock: 0x14388c0: lock: 0x14387e0: lock: 0x1438fc0: lock: 0x1438620: lock: 0x14381c0: lock: 0x14382a0: lock: 0x14380e0: lock: 0x1438000: lock: 0x1437c80: lock: 0x1437f20: lock: 0x1437e40: lock: 0x1437ba0: lock: 0x1437d60: lock: 0x1437900: lock: 0x14379e0: lock: 0x1437ac0: lock: 0x1438e00: Key caches: default Buffer_size: 134217728 Block_size: 1024 Division_limit: 100 Age_threshold: 300 Partitions: 0 blocks used: 0 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 handler status: read_key: 0 read_next: 0 read_rnd 0 read_first: 0 write: 0 delete 0 update: 0 Table status: Opened tables: 0 Open tables: 63 Open files: 26 Open streams: 0 Alarm status: Active alarms: 0 Max used alarms: 0 Next alarm time: 0 Memory status: Non-mmapped space allocated from system: 0 Number of free chunks: 1 Number of fastbin blocks: 0 Number of mmapped regions: 0 Space in mmapped regions: 0 Maximum total allocated space: 0 Space available in freed fastbin blocks: 0 Total allocated space: 0 Total free space: 0 Top-most, releasable space: 0 Estimated memory (with thread stack): 589824 Events status: LLA = Last Locked At LUA = Last Unlocked At WOC = Waiting On Condition DL = Data Locked Event scheduler status: State : INITIALIZED Thread id : 0 LLA : n/a:0 LUA : n/a:0 WOC : NO Workers : 0 Executed : 0 Data locked: NO Event queue status: Element count : 0 Data locked : NO Attempting lock : NO LLA : init_queue:140 LUA : init_queue:150 WOC : NO Next activation : never 150224 21:19:59 [Note] WSREP: (dcd8be91, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 150224 21:20:00 [Note] WSREP: declaring e363b512 at tcp://10.2.0.69:4567 stable 150224 21:20:00 [Note] WSREP: Node dcd8be91 state prim 150224 21:20:00 [Note] WSREP: view(view_id(PRIM,dcd8be91,2) memb { dcd8be91,0 e363b512,0 } joined { } left { } partitioned { }) 150224 21:20:00 [Note] WSREP: save pc into disk 150224 21:20:00 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 150224 21:20:00 [Note] WSREP: STATE_EXCHANGE: sent state UUID: e3b171fd-bc6a-11e4-9209-fb77dab1ea3d 150224 21:20:00 [Note] WSREP: STATE EXCHANGE: sent state msg: e3b171fd-bc6a-11e4-9209-fb77dab1ea3d 150224 21:20:00 [Note] WSREP: STATE EXCHANGE: got state msg: e3b171fd-bc6a-11e4-9209-fb77dab1ea3d from 0 (db1.dev) 150224 21:20:00 [Note] WSREP: STATE EXCHANGE: got state msg: e3b171fd-bc6a-11e4-9209-fb77dab1ea3d from 1 (db2.dev) 150224 21:20:00 [Note] WSREP: Quorum results: version = 3, component = PRIMARY, conf_id = 1, members = 1/2 (joined/total), act_id = 22, last_appl. = 0, protocols = 0/7/3 (gcs/repl/appl), group UUID = 77b9aaef-bc6a-11e4-9686-166bd65cd1d1 150224 21:20:00 [Note] WSREP: Flow-control interval: [23, 23] 150224 21:20:00 [Note] WSREP: New cluster view: global state: 77b9aaef-bc6a-11e4-9686-166bd65cd1d1:22, view# 2: Primary, number of nodes: 2, my index: 0, protocol version 3 150224 21:20:00 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150224 21:20:00 [Note] WSREP: REPL Protocols: 7 (3, 2) 150224 21:20:00 [Note] WSREP: Service thread queue flushed. 150224 21:20:00 [Note] WSREP: Assign initial position for certification: 22, protocol version: 3 150224 21:20:00 [Note] WSREP: Service thread queue flushed. 150224 21:20:00 [Note] WSREP: Member 1.0 (db2.dev) requested state transfer from '*any*'. Selected 0.0 (db1.dev)(SYNCED) as donor. 150224 21:20:00 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 22) 150224 21:20:00 [Note] WSREP: IST request: 77b9aaef-bc6a-11e4-9686-166bd65cd1d1:11-22|tcp://10.2.0.69:4568 150224 21:20:00 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150224 21:20:00 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '10.2.0.69:4444/rsync_sst' --auth '(null)' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --binlog 'mysqld-bin' --gtid '77b9aaef-bc6a-11e4-9686-166bd65cd1d1:11' --bypass' 150224 21:20:00 [Note] WSREP: sst_donor_thread signaled with 0 150224 21:20:00 [Note] WSREP: async IST sender starting to serve tcp://10.2.0.69:4568 sending 12-22 150224 21:20:00 [Note] WSREP: 0.0 (db1.dev): State transfer to 1.0 (db2.dev) complete. 150224 21:20:00 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 22) 150224 21:20:00 [Note] WSREP: Member 0.0 (db1.dev) synced with group. 150224 21:20:00 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 22) 150224 21:20:00 [Note] WSREP: Synchronized with group, ready for connections 150224 21:20:00 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150224 21:20:02 [Note] WSREP: async IST sender served 150224 21:20:02 [Note] WSREP: 1.0 (db2.dev): State transfer from 0.0 (db1.dev) complete. 150224 21:20:02 [Note] WSREP: Member 1.0 (db2.dev) synced with group. 150224 21:20:02 [Note] WSREP: (dcd8be91, 'tcp://0.0.0.0:4567') turning message relay requesting off 150224 21:20:18 [Note] /usr/sbin/mysqld: Normal shutdown 150224 21:20:18 [Note] WSREP: Stop replication 150224 21:20:18 [Note] WSREP: Closing send monitor... 150224 21:20:18 [Note] WSREP: Closed send monitor. 150224 21:20:18 [Note] WSREP: gcomm: terminating thread 150224 21:20:18 [Note] WSREP: gcomm: joining thread 150224 21:20:18 [Note] WSREP: gcomm: closing backend 150224 21:20:19 [Note] WSREP: view(view_id(NON_PRIM,dcd8be91,2) memb { dcd8be91,0 } joined { } left { } partitioned { e363b512,0 }) 150224 21:20:19 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 150224 21:20:19 [Note] WSREP: view((empty)) 150224 21:20:19 [Note] WSREP: gcomm: closed 150224 21:20:19 [Note] WSREP: Flow-control interval: [16, 16] 150224 21:20:19 [Note] WSREP: Received NON-PRIMARY. 150224 21:20:19 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 22) 150224 21:20:19 [Note] WSREP: Received self-leave message. 150224 21:20:19 [Note] WSREP: Flow-control interval: [0, 0] 150224 21:20:19 [Note] WSREP: Received SELF-LEAVE. Closing connection. 150224 21:20:19 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 22) 150224 21:20:19 [Note] WSREP: RECV thread exiting 0: Success 150224 21:20:19 [Note] WSREP: New cluster view: global state: 77b9aaef-bc6a-11e4-9686-166bd65cd1d1:22, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 150224 21:20:19 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150224 21:20:19 [Note] WSREP: New cluster view: global state: 77b9aaef-bc6a-11e4-9686-166bd65cd1d1:22, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 3 150224 21:20:19 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150224 21:20:19 [Note] WSREP: applier thread exiting (code:0) 150224 21:20:19 [Note] WSREP: recv_thread() joined. 150224 21:20:19 [Note] WSREP: Closing replication queue. 150224 21:20:19 [Note] WSREP: Closing slave action queue. 150224 21:20:21 [Note] WSREP: rollbacker thread exiting 150224 21:20:21 [Note] Event Scheduler: Purging the queue. 0 events 150224 21:20:21 [Note] WSREP: dtor state: CLOSED 150224 21:20:21 [Note] WSREP: mon: entered 11 oooe fraction 0 oool fraction 0 150224 21:20:21 [Note] WSREP: mon: entered 11 oooe fraction 0 oool fraction 0 150224 21:20:21 [Note] WSREP: mon: entered 19 oooe fraction 0 oool fraction 0 150224 21:20:21 [Note] WSREP: cert index usage at exit 0 150224 21:20:21 [Note] WSREP: cert trx map usage at exit 0 150224 21:20:21 [Note] WSREP: deps set usage at exit 0 150224 21:20:21 [Note] WSREP: avg deps dist 1 150224 21:20:21 [Note] WSREP: avg cert interval 0 150224 21:20:21 [Note] WSREP: cert index size 7 150224 21:20:21 [Note] WSREP: Service thread queue flushed. 150224 21:20:21 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 150224 21:20:21 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 11, in use: 0, in pool: 11 150224 21:20:21 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 150224 21:20:21 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 22) 150224 21:20:21 [Note] WSREP: Flushing memory map to disk... 150224 21:20:21 [Note] InnoDB: FTS optimize thread exiting. 150224 21:20:21 [Note] InnoDB: Starting shutdown... 150224 21:20:23 [Note] InnoDB: Shutdown completed; log sequence number 1620739 150224 21:20:23 [Note] /usr/sbin/mysqld: Shutdown complete 150224 21:20:23 mysqld_safe mysqld from pid file /var/lib/mysql/db1.dev.pid ended 150224 21:20:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150224 21:20:23 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.82ziI3' --pid-file='/var/lib/mysql/db1.dev-recover.pid' 150224 21:20:25 mysqld_safe WSREP: Failed to recover position: '150224 21:20:23 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150224 21:20:23 [Note] InnoDB: The InnoDB memory heap is disabled 150224 21:20:23 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150224 21:20:23 [Note] InnoDB: Memory barrier is not used 150224 21:20:23 [Note] InnoDB: Compressed tables use zlib 1.2.3 150224 21:20:23 [Note] InnoDB: Using Linux native AIO 150224 21:20:23 [Note] InnoDB: Using CPU crc32 instructions 150224 21:20:23 [Note] InnoDB: Initializing buffer pool, size = 798.0M 150224 21:20:23 [Note] InnoDB: Completed initialization of buffer pool 150224 21:20:23 [Note] InnoDB: Highest supported file format is Barracuda. 150224 21:20:23 [Note] InnoDB: 128 rollback segment(s) are active. 150224 21:20:23 [Note] InnoDB: Waiting for purge to start 150224 21:20:23 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-71.0 started; log sequence number 1620739 150224 21:20:23 [Note] Plugin 'FEEDBACK' is disabled. 150224 21:20:23 [ERROR] mysqld: File 'WSREP_SST: [INFO] Bypassing state dump. (20150224 21:20:00.648)' not found (Errcode: 2 "No such file or directory") 150224 21:20:23 [ERROR] Failed to open log (file 'WSREP_SST: [INFO] Bypassing state dump. (20150224 21:20:00.648)', errno 2) 150224 21:20:23 [ERROR] Could not open log file 150224 21:20:23 [ERROR] Can't init tc log 150224 21:20:23 [ERROR] Aborting 150224 21:20:23 [Note] InnoDB: FTS optimize thread exiting. 150224 21:20:23 [Note] InnoDB: Starting shutdown... 150224 21:20:25 [Note] InnoDB: Shutdown completed; log sequence number 1620749 150224 21:20:25 [Note] /usr/sbin/mysqld: Shutdown complete'