111115 17:17:27 [Note] WSREP: wsrep_load(): loading provider library 'none' 111115 17:17:27 [Note] WSREP: Service disconnected. 111115 17:17:28 [Note] WSREP: Some threads may fail to exit. 111115 17:17:28 [Note] WSREP: wsrep_load(): loading provider library 'none' 111115 17:17:28 [Note] WSREP: Service disconnected. 111115 17:17:29 [Note] WSREP: Some threads may fail to exit. 111115 17:17:31 mysqld_safe Starting mysqld daemon with databases from /mnt/data/mysql 111115 17:17:31 [Note] Plugin 'FEDERATED' is disabled. 111115 17:17:31 InnoDB: The InnoDB memory heap is disabled 111115 17:17:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins 111115 17:17:31 InnoDB: Compressed tables use zlib 1.2.3 111115 17:17:31 InnoDB: Using Linux native AIO 111115 17:17:31 InnoDB: Initializing buffer pool, size = 10.5G 111115 17:17:32 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 111115 17:17:32 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 111115 17:17:32 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 111115 17:17:32 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... 111115 17:17:32 InnoDB: Log file ./ib_logfile2 did not exist: new to be created InnoDB: Setting log file ./ib_logfile2 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: 127 rollback segment(s) active. InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 111115 17:17:33 InnoDB: Waiting for the background threads to start 111115 17:17:34 InnoDB: 1.1.8 started; log sequence number 0 111115 17:17:34 [Warning] 'user' entry 'root@ip-10-176-247-97' ignored in --skip-name-resolve mode. 111115 17:17:34 [Warning] 'user' entry '@ip-10-176-247-97' ignored in --skip-name-resolve mode. 111115 17:17:34 [Warning] 'proxies_priv' entry '@ root@ip-10-176-247-97' ignored in --skip-name-resolve mode. 111115 17:17:34 [Note] Event Scheduler: Loaded 0 events 111115 17:17:34 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' 111115 17:17:34 [Note] WSREP: wsrep_load(): Galera 21.1.0(r86) by Codership Oy loaded succesfully. 111115 17:17:34 [Note] WSREP: Preallocating 134219040/134219040 bytes in '/mnt/data/mysql//galera.cache'... Status information: Current dir: /mnt/data/mysql/ Running threads: 0 Stack size: 262144 Current locks: lock: 0x17dea400: lock: 0x17db29d0: lock: 0x17da7db0: lock: 0x17d9eb30: lock: 0x17d89010: lock: 0x17d85780: lock: 0x17d806c0: lock: 0x17d7a1b0: lock: 0x17d6a170: lock: 0x105a420: lock: 0x105ac00: lock: 0x105ab20: lock: 0x105aa40: lock: 0x105a5e0: lock: 0x105a500: lock: 0x105a340: lock: 0x105a260: lock: 0x105a180: lock: 0x105ace0: lock: 0x105a6c0: lock: 0x105a960: lock: 0x105a880: lock: 0x105a7a0: lock: 0x105a0a0: lock: 0x1059fc0: lock: 0x1059ee0: Key caches: default Buffer_size: 268435456 Block_size: 1024 Division_limit: 100 Age_limit: 300 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: 3 write: 0 delete 0 update: 0 Table status: Opened tables: 33 Open tables: 26 Open files: 18 Open streams: 0 Alarm status: Active alarms: 0 Max used alarms: 0 Next alarm time: 0 111115 17:17:34 [Warning] 'user' entry 'root@ip-10-176-247-97' ignored in --skip-name-resolve mode. 111115 17:17:34 [Warning] 'user' entry '@ip-10-176-247-97' ignored in --skip-name-resolve mode. 111115 17:17:34 [Warning] 'proxies_priv' entry '@ root@ip-10-176-247-97' ignored in --skip-name-resolve mode. Memory status: Non-mmapped space allocated from system: 320909312 Number of free chunks: 9 Number of fastbin blocks: 0 Number of mmapped regions: 16 Space in mmapped regions: 562278400 Maximum total allocated space: 0 Space available in freed fastbin blocks: 0 Total allocated space: 320432464 Total free space: 476848 Top-most, releasable space: 469248 Estimated memory (with thread stack): 883187712 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:139 LUA : init_queue:149 WOC : NO Next activation : never 111115 17:17:34 [Note] WSREP: Passing config to GCS: gcache.dir = /mnt/data/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /mnt/data/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 0.5; 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; replicator.commit_order = 3 111115 17:17:34 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.15-wsrep_21.2' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) wsrep patch: 21.21.2.r3595 111115 17:18:15 [Note] WSREP: Stop replication 111115 17:18:17 [Note] WSREP: dtor state: CLOSED 111115 17:18:17 [Note] WSREP: apply mon: entered 0 111115 17:18:17 [Note] WSREP: apply mon: entered 0 111115 17:18:17 [Note] WSREP: apply mon: entered 0 111115 17:18:17 [Note] WSREP: cert index usage at exit 0 111115 17:18:17 [Note] WSREP: cert trx map usage at exit 0 111115 17:18:17 [Note] WSREP: deps set usage at exit 0 111115 17:18:17 [Note] WSREP: avg deps dist 0 111115 17:18:17 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 111115 17:18:17 [Note] WSREP: Flushing memory map to disk... 111115 17:18:17 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' 111115 17:18:17 [Note] WSREP: wsrep_load(): Galera 21.1.0(r86) by Codership Oy loaded succesfully. 111115 17:18:17 [Note] WSREP: Reusing existing '/mnt/data/mysql//galera.cache'. 111115 17:18:17 [Note] WSREP: Passing config to GCS: gcache.dir = /mnt/data/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /mnt/data/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 0.5; 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; replicator.commit_order = 3 111115 17:18:17 [Note] WSREP: Stop replication 111115 17:18:19 [Note] WSREP: Start replication 111115 17:18:19 [Warning] WSREP: state file not found: /mnt/data/mysql//grastate.dat 111115 17:18:19 [Note] WSREP: Assign initial position for certification: -1, protocol version: 1 111115 17:18:19 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 111115 17:18:19 [Note] WSREP: protonet asio version 0 111115 17:18:19 [Note] WSREP: backend: asio 111115 17:18:19 [Note] WSREP: GMCast version 0 111115 17:18:19 [Note] WSREP: (b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 111115 17:18:19 [Note] WSREP: (b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 111115 17:18:19 [Note] WSREP: EVS version 0 111115 17:18:19 [Note] WSREP: PC version 0 111115 17:18:19 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '10.176.215.163:4567' 111115 17:18:20 [Note] WSREP: GMCast::handle_stable_view: view(view_id(PRIM,b663b4a8-0fd7-11e1-0800-ba0f4e15105a,2) memb { b663b4a8-0fd7-11e1-0800-ba0f4e15105a, b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, } joined { } left { } partitioned { }) 111115 17:18:20 [Note] WSREP: declaring b663b4a8-0fd7-11e1-0800-ba0f4e15105a stable 111115 17:18:20 [Note] WSREP: gcomm: connected 111115 17:18:20 [Note] WSREP: Changing maximum message size 0 -> 64500, result: 32636 111115 17:18:20 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 111115 17:18:20 [Note] WSREP: Opened channel 'my_wsrep_cluster' 111115 17:18:20 [Note] WSREP: New COMPONENT: primary = yes, my_idx = 1, memb_num = 2 111115 17:18:20 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 111115 17:18:20 [Note] WSREP: STATE EXCHANGE: sent state msg: b988b4bc-0fd7-11e1-0800-ae07865ae29b 111115 17:18:20 [Note] WSREP: STATE EXCHANGE: got state msg: b988b4bc-0fd7-11e1-0800-ae07865ae29b from 0 (ip-10-176-215-163) 111115 17:18:20 [Note] WSREP: STATE EXCHANGE: got state msg: b988b4bc-0fd7-11e1-0800-ae07865ae29b from 1 (ip-10-176-247-97) 111115 17:18:20 [Note] WSREP: Quorum results: version = 1, component = PRIMARY, conf_id = 1, members = 1/2 (joined/total), act_id = 0, last_appl. = -1, protocols = 0/1/1 (gcs/repl/appl), group UUID = b6b0ac9a-0fd7-11e1-0800-02efcec769b8 111115 17:18:20 [Note] WSREP: Flow-control interval: [12, 23] 111115 17:18:20 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 0) 111115 17:18:20 [Note] WSREP: New cluster view: group UUID: b6b0ac9a-0fd7-11e1-0800-02efcec769b8, conf# 2: Primary, number of nodes: 2, my index: 1, first seqno: 1, protocol version 1 111115 17:18:20 [Warning] WSREP: Gap in state sequence. Need state transfer. 111115 17:18:22 [Note] WSREP: Prepared SST request: (null)|10.176.247.97:3306 111115 17:18:22 [Warning] WSREP: wsrep_notify_cmd is not defined, skipping notification. 111115 17:18:22 [Note] WSREP: Assign initial position for certification: 0, protocol version: 1 111115 17:18:22 [Note] WSREP: State transfer required: Group state: b6b0ac9a-0fd7-11e1-0800-02efcec769b8:0 Local state: 00000000-0000-0000-0000-000000000000:-1 111115 17:18:22 [Note] WSREP: Node 1 (ip-10-176-247-97) requested state transfer from '*any*'. Selected 0 (ip-10-176-215-163)(SYNCED) as donor. 111115 17:18:22 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0) 111115 17:18:22 [Note] WSREP: Requesting state transfer: success, donor: 0 111115 17:18:23 [Warning] 'user' entry 'root@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111115 17:18:23 [Warning] 'user' entry '@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111115 17:18:23 [Warning] 'proxies_priv' entry '@ root@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111115 17:18:23 [Note] WSREP: wsrep_start_position var submitted: 'b6b0ac9a-0fd7-11e1-0800-02efcec769b8:0' 111115 17:18:23 [Note] WSREP: Received SST: b6b0ac9a-0fd7-11e1-0800-02efcec769b8:0 111115 17:18:23 [Note] WSREP: 1 (ip-10-176-247-97): State transfer from 0 (ip-10-176-215-163) complete. 111115 17:18:23 [Note] WSREP: Shifting JOINER -> JOINED (TO: 0) 111115 17:18:23 [Note] WSREP: Member 1 (ip-10-176-247-97) synced with group. 111115 17:18:23 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) 111115 17:18:23 [Note] WSREP: Synchronized with group, ready for connections 111115 17:18:23 [Warning] WSREP: wsrep_notify_cmd is not defined, skipping notification. 111115 17:18:23 [Note] WSREP: 0 (ip-10-176-215-163): State transfer to 1 (ip-10-176-247-97) complete. 111115 17:18:23 [Note] WSREP: Member 0 (ip-10-176-215-163) synced with group. 111115 17:18:25 [Note] WSREP: GMCast::handle_stable_view: view(view_id(PRIM,b663b4a8-0fd7-11e1-0800-ba0f4e15105a,3) memb { b663b4a8-0fd7-11e1-0800-ba0f4e15105a, b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, bc5f9002-0fd7-11e1-0800-aaa2daee2824, } joined { } left { } partitioned { }) 111115 17:18:25 [Note] WSREP: declaring b663b4a8-0fd7-11e1-0800-ba0f4e15105a stable 111115 17:18:25 [Note] WSREP: declaring bc5f9002-0fd7-11e1-0800-aaa2daee2824 stable 111115 17:18:25 [Note] WSREP: New COMPONENT: primary = yes, my_idx = 1, memb_num = 3 111115 17:18:25 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 111115 17:18:25 [Note] WSREP: STATE EXCHANGE: sent state msg: bcb385fe-0fd7-11e1-0800-adac5d93cdc6 111115 17:18:25 [Note] WSREP: STATE EXCHANGE: got state msg: bcb385fe-0fd7-11e1-0800-adac5d93cdc6 from 0 (ip-10-176-215-163) 111115 17:18:25 [Note] WSREP: STATE EXCHANGE: got state msg: bcb385fe-0fd7-11e1-0800-adac5d93cdc6 from 1 (ip-10-176-247-97) 111115 17:18:26 [Note] WSREP: STATE EXCHANGE: got state msg: bcb385fe-0fd7-11e1-0800-adac5d93cdc6 from 2 (ip-10-174-57-115) 111115 17:18:26 [Note] WSREP: Quorum results: version = 1, component = PRIMARY, conf_id = 2, members = 2/3 (joined/total), act_id = 0, last_appl. = 0, protocols = 0/1/1 (gcs/repl/appl), group UUID = b6b0ac9a-0fd7-11e1-0800-02efcec769b8 111115 17:18:26 [Note] WSREP: Flow-control interval: [14, 28] 111115 17:18:26 [Note] WSREP: New cluster view: group UUID: b6b0ac9a-0fd7-11e1-0800-02efcec769b8, conf# 3: Primary, number of nodes: 3, my index: 1, first seqno: 1, protocol version 1 111115 17:18:26 [Warning] WSREP: wsrep_notify_cmd is not defined, skipping notification. 111115 17:18:26 [Note] WSREP: Assign initial position for certification: 0, protocol version: 1 111115 17:18:28 [Note] WSREP: Node 2 (ip-10-174-57-115) requested state transfer from '*any*'. Selected 0 (ip-10-176-215-163)(SYNCED) as donor. 111115 17:18:28 [Note] WSREP: 2 (ip-10-174-57-115): State transfer from 0 (ip-10-176-215-163) complete. 111115 17:18:28 [Note] WSREP: 0 (ip-10-176-215-163): State transfer to 2 (ip-10-174-57-115) complete. 111115 17:18:28 [Note] WSREP: Member 2 (ip-10-174-57-115) synced with group. 111115 17:18:28 [Note] WSREP: Member 0 (ip-10-176-215-163) synced with group. 111115 17:18:30 [Note] WSREP: (b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, 'tcp://0.0.0.0:4567') cleaning up duplicate 0x17dd2230 after established 0x17dac6a0 111115 17:18:30 [Note] WSREP: GMCast::handle_stable_view: view(view_id(PRIM,b663b4a8-0fd7-11e1-0800-ba0f4e15105a,4) memb { b663b4a8-0fd7-11e1-0800-ba0f4e15105a, b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, bc5f9002-0fd7-11e1-0800-aaa2daee2824, bf8e72ca-0fd7-11e1-0800-b43adffdca5a, } joined { } left { } partitioned { }) 111115 17:18:30 [Note] WSREP: declaring b663b4a8-0fd7-11e1-0800-ba0f4e15105a stable 111115 17:18:30 [Note] WSREP: declaring bc5f9002-0fd7-11e1-0800-aaa2daee2824 stable 111115 17:18:30 [Note] WSREP: declaring bf8e72ca-0fd7-11e1-0800-b43adffdca5a stable 111115 17:18:30 [Note] WSREP: New COMPONENT: primary = yes, my_idx = 1, memb_num = 4 111115 17:18:30 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 111115 17:18:30 [Note] WSREP: STATE EXCHANGE: sent state msg: bfb02280-0fd7-11e1-0800-cc3cf37d2c82 111115 17:18:30 [Note] WSREP: STATE EXCHANGE: got state msg: bfb02280-0fd7-11e1-0800-cc3cf37d2c82 from 0 (ip-10-176-215-163) 111115 17:18:30 [Note] WSREP: STATE EXCHANGE: got state msg: bfb02280-0fd7-11e1-0800-cc3cf37d2c82 from 1 (ip-10-176-247-97) 111115 17:18:30 [Note] WSREP: STATE EXCHANGE: got state msg: bfb02280-0fd7-11e1-0800-cc3cf37d2c82 from 2 (ip-10-174-57-115) 111115 17:18:31 [Note] WSREP: STATE EXCHANGE: got state msg: bfb02280-0fd7-11e1-0800-cc3cf37d2c82 from 3 (ip-10-174-65-69) 111115 17:18:31 [Note] WSREP: Quorum results: version = 1, component = PRIMARY, conf_id = 3, members = 3/4 (joined/total), act_id = 0, last_appl. = 0, protocols = 0/1/1 (gcs/repl/appl), group UUID = b6b0ac9a-0fd7-11e1-0800-02efcec769b8 111115 17:18:31 [Note] WSREP: Flow-control interval: [16, 32] 111115 17:18:31 [Note] WSREP: New cluster view: group UUID: b6b0ac9a-0fd7-11e1-0800-02efcec769b8, conf# 4: Primary, number of nodes: 4, my index: 1, first seqno: 1, protocol version 1 111115 17:18:31 [Warning] WSREP: wsrep_notify_cmd is not defined, skipping notification. 111115 17:18:31 [Note] WSREP: Assign initial position for certification: 0, protocol version: 1 111115 17:18:33 [Note] WSREP: Node 3 (ip-10-174-65-69) requested state transfer from '*any*'. Selected 0 (ip-10-176-215-163)(SYNCED) as donor. 111115 17:18:34 [Note] WSREP: 3 (ip-10-174-65-69): State transfer from 0 (ip-10-176-215-163) complete. 111115 17:18:34 [Note] WSREP: 0 (ip-10-176-215-163): State transfer to 3 (ip-10-174-65-69) complete. 111115 17:18:34 [Note] WSREP: Member 3 (ip-10-174-65-69) synced with group. 111115 17:18:34 [Note] WSREP: Member 0 (ip-10-176-215-163) synced with group. 111115 17:19:48 [Warning] 'user' entry 'root@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111115 17:19:48 [Warning] 'user' entry '@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111115 17:19:48 [Warning] 'proxies_priv' entry '@ root@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111115 19:07:54 [Warning] 'user' entry 'root@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111115 19:07:54 [Warning] 'user' entry '@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111115 19:07:54 [Warning] 'proxies_priv' entry '@ root@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111115 19:10:13 [Note] WSREP: (b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.174.57.115:4567 111115 19:10:14 [Note] WSREP: (b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, 'tcp://0.0.0.0:4567') turning message relay requesting off 111115 19:18:15 [Note] WSREP: (b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.174.57.115:4567 111115 19:18:17 [Note] WSREP: (b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, 'tcp://0.0.0.0:4567') reconnecting to bf8e72ca-0fd7-11e1-0800-b43adffdca5a (tcp://10.174.65.69:4567), attempt 0 111115 19:18:17 [Note] WSREP: (b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, 'tcp://0.0.0.0:4567') turning message relay requesting off 111115 19:22:07 [Note] WSREP: (b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.174.57.115:4567 111115 19:22:09 [Note] WSREP: (b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, 'tcp://0.0.0.0:4567') turning message relay requesting off 111115 19:33:46 [Note] WSREP: (b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.174.57.115:4567 111115 19:33:47 [Note] WSREP: (b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, 'tcp://0.0.0.0:4567') turning message relay requesting off 111115 19:39:19 [Warning] 'user' entry 'root@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111115 19:39:19 [Warning] 'user' entry '@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111115 19:39:19 [Warning] 'proxies_priv' entry '@ root@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111115 22:29:40 [Note] WSREP: (b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.174.57.115:4567 111115 22:29:42 [Note] WSREP: evs::proto(b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, GATHER, view_id(REG,b663b4a8-0fd7-11e1-0800-ba0f4e15105a,4)) suspecting node: bc5f9002-0fd7-11e1-0800-aaa2daee2824 111115 22:29:46 [Note] WSREP: GMCast::handle_stable_view: view(view_id(PRIM,b663b4a8-0fd7-11e1-0800-ba0f4e15105a,6) memb { b663b4a8-0fd7-11e1-0800-ba0f4e15105a, b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, bf8e72ca-0fd7-11e1-0800-b43adffdca5a, } joined { } left { } partitioned { bc5f9002-0fd7-11e1-0800-aaa2daee2824, }) 111115 22:29:46 [Note] WSREP: forgetting bc5f9002-0fd7-11e1-0800-aaa2daee2824 (tcp://10.174.57.115:4567) 111115 22:29:46 [Note] WSREP: deleting entry tcp://10.174.57.115:4567 111115 22:29:46 [Note] WSREP: declaring b663b4a8-0fd7-11e1-0800-ba0f4e15105a stable 111115 22:29:46 [Note] WSREP: declaring bf8e72ca-0fd7-11e1-0800-b43adffdca5a stable 111115 22:29:46 [Note] WSREP: (b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, 'tcp://0.0.0.0:4567') turning message relay requesting off 111115 22:29:51 [Note] WSREP: New COMPONENT: primary = yes, my_idx = 1, memb_num = 3 111115 22:29:51 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 111115 22:29:51 [Note] WSREP: STATE EXCHANGE: sent state msg: 3b566874-1003-11e1-0800-a3d94d874622 111115 22:29:51 [Note] WSREP: STATE EXCHANGE: got state msg: 3b566874-1003-11e1-0800-a3d94d874622 from 0 (ip-10-176-215-163) 111115 22:29:51 [Note] WSREP: STATE EXCHANGE: got state msg: 3b566874-1003-11e1-0800-a3d94d874622 from 2 (ip-10-174-65-69) 111115 22:29:51 [Note] WSREP: STATE EXCHANGE: got state msg: 3b566874-1003-11e1-0800-a3d94d874622 from 1 (ip-10-176-247-97) 111115 22:29:51 [Note] WSREP: Quorum results: version = 1, component = PRIMARY, conf_id = 4, members = 3/3 (joined/total), act_id = 6012, last_appl. = 5889, protocols = 0/1/1 (gcs/repl/appl), group UUID = b6b0ac9a-0fd7-11e1-0800-02efcec769b8 111115 22:29:51 [Note] WSREP: Flow-control interval: [14, 28] 111115 22:29:51 [Note] WSREP: cleaning up bc5f9002-0fd7-11e1-0800-aaa2daee2824 (tcp://10.174.57.115:4567) 111115 22:29:51 [Note] WSREP: New cluster view: group UUID: b6b0ac9a-0fd7-11e1-0800-02efcec769b8, conf# 5: Primary, number of nodes: 3, my index: 1, first seqno: 6013, protocol version 1 111115 22:29:51 [Warning] WSREP: wsrep_notify_cmd is not defined, skipping notification. 111115 22:30:10 [Note] WSREP: Assign initial position for certification: 6012, protocol version: 1 111115 22:35:05 [Note] WSREP: GMCast::handle_stable_view: view(view_id(PRIM,b663b4a8-0fd7-11e1-0800-ba0f4e15105a,7) memb { b663b4a8-0fd7-11e1-0800-ba0f4e15105a, b94f4d76-0fd7-11e1-0800-5eb8f7a832c5, bf8e72ca-0fd7-11e1-0800-b43adffdca5a, f93b8f9a-1003-11e1-0800-5ff4308a3407, } joined { } left { } partitioned { }) 111115 22:35:05 [Note] WSREP: New COMPONENT: primary = yes, my_idx = 1, memb_num = 4 111115 22:35:05 [Note] WSREP: declaring b663b4a8-0fd7-11e1-0800-ba0f4e15105a stable 111115 22:35:05 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 111115 22:35:05 [Note] WSREP: declaring bf8e72ca-0fd7-11e1-0800-b43adffdca5a stable 111115 22:35:05 [Note] WSREP: declaring f93b8f9a-1003-11e1-0800-5ff4308a3407 stable 111115 22:35:05 [Note] WSREP: STATE EXCHANGE: sent state msg: f9832738-1003-11e1-0800-a8236e35a2b7 111115 22:35:05 [Note] WSREP: STATE EXCHANGE: got state msg: f9832738-1003-11e1-0800-a8236e35a2b7 from 0 (ip-10-176-215-163) 111115 22:35:05 [Note] WSREP: STATE EXCHANGE: got state msg: f9832738-1003-11e1-0800-a8236e35a2b7 from 1 (ip-10-176-247-97) 111115 22:35:05 [Note] WSREP: STATE EXCHANGE: got state msg: f9832738-1003-11e1-0800-a8236e35a2b7 from 2 (ip-10-174-65-69) 111115 22:35:06 [Note] WSREP: STATE EXCHANGE: got state msg: f9832738-1003-11e1-0800-a8236e35a2b7 from 3 (ip-10-174-57-115) 111115 22:35:06 [Note] WSREP: Quorum results: version = 1, component = PRIMARY, conf_id = 5, members = 3/4 (joined/total), act_id = 6029, last_appl. = 6017, protocols = 0/1/1 (gcs/repl/appl), group UUID = b6b0ac9a-0fd7-11e1-0800-02efcec769b8 111115 22:35:06 [Note] WSREP: Flow-control interval: [16, 32] 111115 22:35:06 [Note] WSREP: New cluster view: group UUID: b6b0ac9a-0fd7-11e1-0800-02efcec769b8, conf# 6: Primary, number of nodes: 4, my index: 1, first seqno: 6030, protocol version 1 111115 22:35:06 [Warning] WSREP: wsrep_notify_cmd is not defined, skipping notification. 111115 22:35:08 [Note] WSREP: Node 3 (ip-10-174-57-115) requested state transfer from '*any*'. Selected 0 (ip-10-176-215-163)(SYNCED) as donor. 111115 22:35:08 [Note] WSREP: Assign initial position for certification: 6029, protocol version: 1 111115 23:15:36 [Warning] WSREP: last inactive check more than PT1.5S ago, skipping check 111115 23:15:36 [Warning] WSREP: last inactive check more than PT1.5S ago, skipping check 111115 23:24:24 mysqld_safe Number of processes running now: 0 111115 23:24:24 mysqld_safe mysqld restarted 111115 23:24:24 [Note] Plugin 'FEDERATED' is disabled. 111115 23:24:24 InnoDB: The InnoDB memory heap is disabled 111115 23:24:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins 111115 23:24:24 InnoDB: Compressed tables use zlib 1.2.3 111115 23:24:24 InnoDB: Using Linux native AIO 111115 23:24:24 InnoDB: Initializing buffer pool, size = 10.5G 111115 23:24:25 InnoDB: Completed initialization of buffer pool 111115 23:24:25 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 16377034770 111115 23:24:26 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 16382277632 InnoDB: Doing recovery: scanned up to log sequence number 16387096595 InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 29616 row operations to undo InnoDB: Trx id counter is 3400 111115 23:24:27 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Starting in background the rollback of uncommitted transactions 111115 23:25:23 InnoDB: Rolling back trx with id 324A, 29616 rows to undo InnoDB: Progress in percents: 1111115 23:25:23 InnoDB: Waiting for the background threads to start 2 3 4111115 23:25:24 InnoDB: 1.1.8 started; log sequence number 16387096595 111115 23:25:25 [Warning] 'user' entry 'root@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111115 23:25:25 [Warning] 'user' entry '@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111115 23:25:25 [Warning] 'proxies_priv' entry '@ root@ip-10-176-215-163' ignored in --skip-name-resolve mode. 5111115 23:25:25 [Note] Event Scheduler: Loaded 0 events 111115 23:25:25 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' 111115 23:25:25 [Note] WSREP: wsrep_load(): Galera 21.1.0(r86) by Codership Oy loaded succesfully. 111115 23:25:25 [Note] WSREP: Reusing existing '/mnt/data/mysql//galera.cache'. 111115 23:25:25 [Note] WSREP: Passing config to GCS: gcache.dir = /mnt/data/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /mnt/data/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 0.5; 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; replicator.commit_order = 3 111115 23:25:25 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.15-wsrep_21.2' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) wsrep patch: 21.21.2.r3595 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55111115 23:25:47 [Note] WSREP: Stop replication 56 57 58 59111115 23:25:49 [Note] WSREP: Start replication 111115 23:25:49 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1 111115 23:25:49 [Note] WSREP: Assign initial position for certification: -1, protocol version: 1 111115 23:25:49 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 111115 23:25:49 [Note] WSREP: protonet asio version 0 111115 23:25:49 [Note] WSREP: backend: asio 111115 23:25:49 [Note] WSREP: GMCast version 0 111115 23:25:49 [Note] WSREP: (101d4e18-100b-11e1-0800-3d677088c3db, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 111115 23:25:49 [Note] WSREP: (101d4e18-100b-11e1-0800-3d677088c3db, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 111115 23:25:49 [Note] WSREP: EVS version 0 111115 23:25:49 [Note] WSREP: PC version 0 111115 23:25:49 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '10.174.65.69:4567' 60111115 23:25:50 [Note] WSREP: GMCast::handle_stable_view: view(view_id(PRIM,101d4e18-100b-11e1-0800-3d677088c3db,9) memb { 101d4e18-100b-11e1-0800-3d677088c3db, b663b4a8-0fd7-11e1-0800-ba0f4e15105a, bf8e72ca-0fd7-11e1-0800-b43adffdca5a, f93b8f9a-1003-11e1-0800-5ff4308a3407, } joined { } left { } partitioned { }) 111115 23:25:50 [Note] WSREP: declaring b663b4a8-0fd7-11e1-0800-ba0f4e15105a stable 111115 23:25:50 [Note] WSREP: declaring bf8e72ca-0fd7-11e1-0800-b43adffdca5a stable 111115 23:25:50 [Note] WSREP: declaring f93b8f9a-1003-11e1-0800-5ff4308a3407 stable 61 62111115 23:25:51 [Note] WSREP: gcomm: connected 111115 23:25:51 [Note] WSREP: Changing maximum message size 0 -> 64500, result: 32636 111115 23:25:51 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 111115 23:25:51 [Note] WSREP: Opened channel 'my_wsrep_cluster' 111115 23:25:51 [Note] WSREP: New COMPONENT: primary = yes, my_idx = 0, memb_num = 4 111115 23:25:51 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 11035f20-100b-11e1-0800-d637d1447e46 111115 23:25:51 [Note] WSREP: STATE EXCHANGE: sent state msg: 11035f20-100b-11e1-0800-d637d1447e46 111115 23:25:51 [Note] WSREP: STATE EXCHANGE: got state msg: 11035f20-100b-11e1-0800-d637d1447e46 from 0 (ip-10-176-247-97) 111115 23:25:51 [Note] WSREP: STATE EXCHANGE: got state msg: 11035f20-100b-11e1-0800-d637d1447e46 from 1 (ip-10-176-215-163) 111115 23:25:51 [Note] WSREP: STATE EXCHANGE: got state msg: 11035f20-100b-11e1-0800-d637d1447e46 from 2 (ip-10-174-65-69) 111115 23:25:51 [Note] WSREP: STATE EXCHANGE: got state msg: 11035f20-100b-11e1-0800-d637d1447e46 from 3 (ip-10-174-57-115) 111115 23:25:51 [Note] WSREP: Quorum results: version = 1, component = PRIMARY, conf_id = 7, members = 2/4 (joined/total), act_id = 6150, last_appl. = -1, protocols = 0/1/1 (gcs/repl/appl), group UUID = b6b0ac9a-0fd7-11e1-0800-02efcec769b8 111115 23:25:51 [Note] WSREP: Flow-control interval: [16, 32] 111115 23:25:51 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 6150) 111115 23:25:51 [Note] WSREP: New cluster view: group UUID: b6b0ac9a-0fd7-11e1-0800-02efcec769b8, conf# 8: Primary, number of nodes: 4, my index: 0, first seqno: 6151, protocol version 1 111115 23:25:51 [Warning] WSREP: Gap in state sequence. Need state transfer. 63 64 65 66111115 23:25:53 [Note] WSREP: Prepared SST request: (null)|10.176.247.97:3306 111115 23:25:53 [Warning] WSREP: wsrep_notify_cmd is not defined, skipping notification. 111115 23:25:53 [Note] WSREP: Assign initial position for certification: 6150, protocol version: 1 111115 23:25:53 [Note] WSREP: State transfer required: Group state: b6b0ac9a-0fd7-11e1-0800-02efcec769b8:6150 Local state: 00000000-0000-0000-0000-000000000000:-1 111115 23:25:53 [Note] WSREP: Node 0 (ip-10-176-247-97) requested state transfer from '*any*'. Selected 2 (ip-10-174-65-69)(SYNCED) as donor. 111115 23:25:53 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 6150) 111115 23:25:53 [Note] WSREP: Requesting state transfer: success, donor: 2 67 68 69111115 23:26:01 [Note] WSREP: Stop replication 111115 23:26:01 [Note] WSREP: Closing send monitor... 111115 23:26:01 [Note] WSREP: Closed send monitor. 111115 23:26:01 [Note] WSREP: gcomm: terminating thread 111115 23:26:01 [Note] WSREP: gcomm: joining thread 111115 23:26:01 [Note] WSREP: gcomm: closing backend 111115 23:26:01 [Note] WSREP: evs::proto(101d4e18-100b-11e1-0800-3d677088c3db, LEAVING, view_id(REG,101d4e18-100b-11e1-0800-3d677088c3db,9)) uuid b663b4a8-0fd7-11e1-0800-ba0f4e15105a missing from install message, assuming partitioned 111115 23:26:01 [Note] WSREP: evs::proto(101d4e18-100b-11e1-0800-3d677088c3db, LEAVING, view_id(REG,101d4e18-100b-11e1-0800-3d677088c3db,9)) uuid bf8e72ca-0fd7-11e1-0800-b43adffdca5a missing from install message, assuming partitioned 111115 23:26:01 [Note] WSREP: evs::proto(101d4e18-100b-11e1-0800-3d677088c3db, LEAVING, view_id(REG,101d4e18-100b-11e1-0800-3d677088c3db,9)) uuid f93b8f9a-1003-11e1-0800-5ff4308a3407 missing from install message, assuming partitioned 111115 23:26:01 [Note] WSREP: GMCast::handle_stable_view: view(view_id(NON_PRIM,101d4e18-100b-11e1-0800-3d677088c3db,9) memb { 101d4e18-100b-11e1-0800-3d677088c3db, } joined { } left { } partitioned { b663b4a8-0fd7-11e1-0800-ba0f4e15105a, bf8e72ca-0fd7-11e1-0800-b43adffdca5a, f93b8f9a-1003-11e1-0800-5ff4308a3407, }) 111115 23:26:01 [Note] WSREP: GMCast::handle_stable_view: view((empty)) 111115 23:26:01 [Note] WSREP: gcomm: closed 111115 23:26:01 [Note] WSREP: New COMPONENT: primary = no, my_idx = 0, memb_num = 1 111115 23:26:01 [Note] WSREP: Flow-control interval: [8, 16] 111115 23:26:01 [Note] WSREP: Received NON-PRIMARY. 111115 23:26:01 [Note] WSREP: Shifting JOINER -> OPEN (TO: 6150) 111115 23:26:01 [Note] WSREP: Received self-leave message. 111115 23:26:01 [Note] WSREP: Flow-control interval: [0, 0] 111115 23:26:01 [Note] WSREP: Received SELF-LEAVE. Closing connection. 111115 23:26:01 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 6150) 111115 23:26:01 [Note] WSREP: RECV thread exiting 0: Success 111115 23:26:01 [Note] WSREP: recv_thread() joined. 111115 23:26:01 [Note] WSREP: Closing slave action queue. 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 InnoDB: Rolling back of trx id 324A completed 111115 23:26:23 InnoDB: Rollback of non-prepared transactions completed 111116 0:07:02 [Note] /usr/sbin/mysqld: Normal shutdown 111116 0:07:02 [Note] WSREP: Stop replication 111116 0:07:02 [Note] WSREP: Closing send monitor... 111116 0:07:02 [Note] WSREP: Closed send monitor. 111116 00:07:30 mysqld_safe Number of processes running now: 0 111116 00:07:30 mysqld_safe mysqld restarted 111116 0:07:30 [Note] Plugin 'FEDERATED' is disabled. 111116 0:07:30 InnoDB: The InnoDB memory heap is disabled 111116 0:07:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins 111116 0:07:30 InnoDB: Compressed tables use zlib 1.2.3 111116 0:07:30 InnoDB: Using Linux native AIO 111116 0:07:30 InnoDB: Initializing buffer pool, size = 10.5G 111116 0:07:31 InnoDB: Completed initialization of buffer pool 111116 0:07:31 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 111116 0:07:31 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 111116 0:07:32 InnoDB: Waiting for the background threads to start 111116 0:07:33 InnoDB: 1.1.8 started; log sequence number 16398040414 111116 0:07:33 [Warning] 'user' entry 'root@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111116 0:07:33 [Warning] 'user' entry '@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111116 0:07:33 [Warning] 'proxies_priv' entry '@ root@ip-10-176-215-163' ignored in --skip-name-resolve mode. 111116 0:07:33 [Note] Event Scheduler: Loaded 0 events 111116 0:07:33 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' 111116 0:07:33 [Note] WSREP: wsrep_load(): Galera 21.1.0(r86) by Codership Oy loaded succesfully. 111116 0:07:33 [Note] WSREP: Reusing existing '/mnt/data/mysql//galera.cache'. 111116 0:07:33 [Note] WSREP: Passing config to GCS: gcache.dir = /mnt/data/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /mnt/data/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 0.5; 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; replicator.commit_order = 3 111116 0:07:33 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.15-wsrep_21.2' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) wsrep patch: 21.21.2.r3595 111116 0:07:40 [Note] WSREP: Stop replication 111116 0:07:42 [Note] WSREP: Start replication 111116 0:07:42 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1 111116 0:07:42 [Note] WSREP: Assign initial position for certification: -1, protocol version: 1 111116 0:07:42 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 111116 0:07:42 [Note] WSREP: protonet asio version 0 111116 0:07:42 [Note] WSREP: backend: asio 111116 0:07:42 [Note] WSREP: GMCast version 0 111116 0:07:42 [Note] WSREP: (e9b3aa5a-1010-11e1-0800-b38591c9e8cb, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 111116 0:07:42 [Note] WSREP: (e9b3aa5a-1010-11e1-0800-b38591c9e8cb, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 111116 0:07:42 [Note] WSREP: EVS version 0 111116 0:07:42 [Note] WSREP: PC version 0 111116 0:07:42 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '10.174.65.69:4567' 111116 0:07:42 [Note] WSREP: (e9b3aa5a-1010-11e1-0800-b38591c9e8cb, 'tcp://0.0.0.0:4567') cleaning up established 0x16a48300 which is duplicate of 0x16a518f0 111116 0:07:43 [Note] WSREP: GMCast::handle_stable_view: view(view_id(PRIM,b663b4a8-0fd7-11e1-0800-ba0f4e15105a,11) memb { b663b4a8-0fd7-11e1-0800-ba0f4e15105a, bf8e72ca-0fd7-11e1-0800-b43adffdca5a, e9b3aa5a-1010-11e1-0800-b38591c9e8cb, f93b8f9a-1003-11e1-0800-5ff4308a3407, } joined { } left { } partitioned { }) 111116 0:07:43 [Note] WSREP: declaring b663b4a8-0fd7-11e1-0800-ba0f4e15105a stable 111116 0:07:43 [Note] WSREP: declaring bf8e72ca-0fd7-11e1-0800-b43adffdca5a stable 111116 0:07:43 [Note] WSREP: declaring f93b8f9a-1003-11e1-0800-5ff4308a3407 stable 111116 0:07:44 [Note] WSREP: gcomm: connected 111116 0:07:44 [Note] WSREP: Changing maximum message size 0 -> 64500, result: 32636 111116 0:07:44 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 111116 0:07:44 [Note] WSREP: Opened channel 'my_wsrep_cluster' 111116 0:07:44 [Note] WSREP: New COMPONENT: primary = yes, my_idx = 2, memb_num = 4 111116 0:07:44 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 111116 0:07:44 [Note] WSREP: STATE EXCHANGE: sent state msg: ea9b80b4-1010-11e1-0800-972c04371123 111116 0:07:44 [Note] WSREP: STATE EXCHANGE: got state msg: ea9b80b4-1010-11e1-0800-972c04371123 from 0 (ip-10-176-215-163) 111116 0:07:44 [Note] WSREP: STATE EXCHANGE: got state msg: ea9b80b4-1010-11e1-0800-972c04371123 from 1 (ip-10-174-65-69) 111116 0:07:44 [Note] WSREP: STATE EXCHANGE: got state msg: ea9b80b4-1010-11e1-0800-972c04371123 from 3 (ip-10-174-57-115) 111116 0:07:44 [Note] WSREP: STATE EXCHANGE: got state msg: ea9b80b4-1010-11e1-0800-972c04371123 from 2 (ip-10-176-247-97) 111116 0:07:44 [Note] WSREP: Quorum results: version = 1, component = PRIMARY, conf_id = 9, members = 2/4 (joined/total), act_id = 6150, last_appl. = -1, protocols = 0/1/1 (gcs/repl/appl), group UUID = b6b0ac9a-0fd7-11e1-0800-02efcec769b8 111116 0:07:44 [Note] WSREP: Flow-control interval: [16, 32] 111116 0:07:44 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 6150) 111116 0:07:44 [Note] WSREP: New cluster view: group UUID: b6b0ac9a-0fd7-11e1-0800-02efcec769b8, conf# 10: Primary, number of nodes: 4, my index: 2, first seqno: 6151, protocol version 1 111116 0:07:44 [Warning] WSREP: Gap in state sequence. Need state transfer. 111116 0:07:46 [Note] WSREP: Prepared SST request: (null)|10.176.247.97:3306 111116 0:07:46 [Warning] WSREP: wsrep_notify_cmd is not defined, skipping notification. 111116 0:07:46 [Note] WSREP: Assign initial position for certification: 6150, protocol version: 1 111116 0:07:46 [Note] WSREP: State transfer required: Group state: b6b0ac9a-0fd7-11e1-0800-02efcec769b8:6150 Local state: 00000000-0000-0000-0000-000000000000:-1 111116 0:07:46 [Note] WSREP: Node 2 (ip-10-176-247-97) requested state transfer from '*any*'. Selected 1 (ip-10-174-65-69)(SYNCED) as donor. 111116 0:07:46 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 6150) 111116 0:07:46 [Note] WSREP: Requesting state transfer: success, donor: 1 111116 0:07:55 [Note] WSREP: Stop replication 111116 0:07:55 [Note] WSREP: Closing send monitor... 111116 0:07:55 [Note] WSREP: Closed send monitor. 111116 0:07:55 [Note] WSREP: gcomm: terminating thread 111116 0:07:55 [Note] WSREP: gcomm: joining thread 111116 0:07:55 [Note] WSREP: gcomm: closing backend 111116 0:07:55 [Note] WSREP: evs::proto(e9b3aa5a-1010-11e1-0800-b38591c9e8cb, LEAVING, view_id(REG,b663b4a8-0fd7-11e1-0800-ba0f4e15105a,11)) uuid b663b4a8-0fd7-11e1-0800-ba0f4e15105a missing from install message, assuming partitioned 111116 0:07:55 [Note] WSREP: evs::proto(e9b3aa5a-1010-11e1-0800-b38591c9e8cb, LEAVING, view_id(REG,b663b4a8-0fd7-11e1-0800-ba0f4e15105a,11)) uuid bf8e72ca-0fd7-11e1-0800-b43adffdca5a missing from install message, assuming partitioned 111116 0:07:55 [Note] WSREP: evs::proto(e9b3aa5a-1010-11e1-0800-b38591c9e8cb, LEAVING, view_id(REG,b663b4a8-0fd7-11e1-0800-ba0f4e15105a,11)) uuid f93b8f9a-1003-11e1-0800-5ff4308a3407 missing from install message, assuming partitioned 111116 0:07:55 [Note] WSREP: GMCast::handle_stable_view: view(view_id(NON_PRIM,b663b4a8-0fd7-11e1-0800-ba0f4e15105a,11) memb { e9b3aa5a-1010-11e1-0800-b38591c9e8cb, } joined { } left { } partitioned { b663b4a8-0fd7-11e1-0800-ba0f4e15105a, bf8e72ca-0fd7-11e1-0800-b43adffdca5a, f93b8f9a-1003-11e1-0800-5ff4308a3407, }) 111116 0:07:55 [Note] WSREP: GMCast::handle_stable_view: view((empty)) 111116 0:07:55 [Note] WSREP: gcomm: closed 111116 0:07:55 [Note] WSREP: New COMPONENT: primary = no, my_idx = 0, memb_num = 1 111116 0:07:55 [Note] WSREP: Flow-control interval: [8, 16] 111116 0:07:55 [Note] WSREP: Received NON-PRIMARY. 111116 0:07:55 [Note] WSREP: Shifting JOINER -> OPEN (TO: 6150) 111116 0:07:55 [Note] WSREP: Received self-leave message. 111116 0:07:55 [Note] WSREP: Flow-control interval: [0, 0] 111116 0:07:55 [Note] WSREP: Received SELF-LEAVE. Closing connection. 111116 0:07:55 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 6150) 111116 0:07:55 [Note] WSREP: RECV thread exiting 0: Success 111116 0:07:55 [Note] WSREP: recv_thread() joined. 111116 0:07:55 [Note] WSREP: Closing slave action queue.