150225 20:51:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150225 20:51:43 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.DSugTQ' --pid-file='/var/lib/mysql/db1.dev-recover.pid' 150225 20:51:45 mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1 150225 20:51:45 [Note] WSREP: wsrep_start_position var submitted: '00000000-0000-0000-0000-000000000000:-1' 150225 20:51:45 [Note] WSREP: Read nil XID from storage engines, skipping position init 150225 20:51:45 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' 150225 20:51:45 [Note] WSREP: wsrep_load(): Galera 25.3.9(r0) by Codership Oy loaded successfully. 150225 20:51:45 [Note] WSREP: CRC-32C: using hardware acceleration. 150225 20:51:45 [Warning] WSREP: Could not open saved state file for reading: /var/lib/mysql//grastate.dat 150225 20:51:45 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1 150225 20:51:45 [Note] WSREP: Passing config to GCS: base_host = 10.2.0.103; 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 150225 20:51:45 [Note] WSREP: Service thread queue flushed. 150225 20:51:45 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 150225 20:51:45 [Note] WSREP: wsrep_sst_grab() 150225 20:51:45 [Note] WSREP: Start replication 150225 20:51:45 [Note] WSREP: 'wsrep-new-cluster' option used, bootstrapping the cluster 150225 20:51:45 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 150225 20:51:45 [Note] WSREP: protonet asio version 0 150225 20:51:45 [Note] WSREP: Using CRC-32C for message checksums. 150225 20:51:45 [Note] WSREP: backend: asio 150225 20:51:45 [Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory) 150225 20:51:45 [Note] WSREP: restore pc from disk failed 150225 20:51:45 [Note] WSREP: GMCast version 0 150225 20:51:45 [Note] WSREP: (1c2c1a76, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 150225 20:51:45 [Note] WSREP: (1c2c1a76, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 150225 20:51:45 [Note] WSREP: EVS version 0 150225 20:51:45 [Note] WSREP: start_prim is enabled, turn off pc_recovery 150225 20:51:45 [Note] WSREP: Node 1c2c1a76 state prim 150225 20:51:45 [Note] WSREP: view(view_id(PRIM,1c2c1a76,1) memb { 1c2c1a76,0 } joined { } left { } partitioned { }) 150225 20:51:45 [Note] WSREP: save pc into disk 150225 20:51:45 [Note] WSREP: discarding pending addr without UUID: tcp://10.2.0.104:4567 150225 20:51:45 [Note] WSREP: discarding pending addr proto entry 0x7f9c470d2500 150225 20:51:45 [Note] WSREP: discarding pending addr without UUID: tcp://10.2.0.105:4567 150225 20:51:45 [Note] WSREP: discarding pending addr proto entry 0x7f9c470d25c0 150225 20:51:45 [Note] WSREP: gcomm: connected 150225 20:51:45 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 150225 20:51:45 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 150225 20:51:45 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 150225 20:51:45 [Note] WSREP: Waiting for SST to complete. 150225 20:51:45 [Note] WSREP: Starting new group from scratch: 1c2e68d6-bd30-11e4-bead-7a8d323d17d8 150225 20:51:45 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 1c2e7e3d-bd30-11e4-959d-57554c41d7b6 150225 20:51:45 [Note] WSREP: STATE EXCHANGE: sent state msg: 1c2e7e3d-bd30-11e4-959d-57554c41d7b6 150225 20:51:45 [Note] WSREP: STATE EXCHANGE: got state msg: 1c2e7e3d-bd30-11e4-959d-57554c41d7b6 from 0 (db1.dev) 150225 20:51:45 [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 = 1c2e68d6-bd30-11e4-bead-7a8d323d17d8 150225 20:51:45 [Note] WSREP: Flow-control interval: [16, 16] 150225 20:51:45 [Note] WSREP: Restored state OPEN -> JOINED (0) 150225 20:51:45 [Note] WSREP: Member 0.0 (db1.dev) synced with group. 150225 20:51:45 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) 150225 20:51:45 [Note] WSREP: New cluster view: global state: 1c2e68d6-bd30-11e4-bead-7a8d323d17d8:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3 150225 20:51:45 [Note] WSREP: SST complete, seqno: 0 150225 20:51:45 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150225 20:51:45 [Note] InnoDB: The InnoDB memory heap is disabled 150225 20:51:45 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150225 20:51:45 [Note] InnoDB: Memory barrier is not used 150225 20:51:45 [Note] InnoDB: Compressed tables use zlib 1.2.3 150225 20:51:45 [Note] InnoDB: Using Linux native AIO 150225 20:51:45 [Note] InnoDB: Using CPU crc32 instructions 150225 20:51:45 [Note] InnoDB: Initializing buffer pool, size = 798.0M 150225 20:51:45 [Note] InnoDB: Completed initialization of buffer pool 150225 20:51:45 [Note] InnoDB: Highest supported file format is Barracuda. 150225 20:51:45 [Note] InnoDB: 128 rollback segment(s) are active. 150225 20:51:45 [Note] InnoDB: Waiting for purge to start 150225 20:51:45 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-71.0 started; log sequence number 1616885 150225 20:51:45 [Note] Plugin 'FEEDBACK' is disabled. 150225 20:51:45 [Note] Server socket created on IP: '::'. 150225 20:51:45 [Note] Event Scheduler: Loaded 0 events 150225 20:51:45 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150225 20:51:45 [Note] WSREP: REPL Protocols: 7 (3, 2) 150225 20:51:45 [Note] WSREP: Service thread queue flushed. 150225 20:51:45 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3 150225 20:51:45 [Note] WSREP: Service thread queue flushed. 150225 20:51:45 [Note] WSREP: Synchronized with group, ready for connections 150225 20:51:45 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150225 20:51:45 [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: 0x7f9c4708f788: lock: 0x7f9c47083788: lock: 0x7f9c47069588: lock: 0x7f9c47068188: lock: 0x7f9c47066388: lock: 0x7f9c47064f88: lock: 0x7f9c47156b88: lock: 0x7f9c47197388: lock: 0x7f9c47080788: lock: 0x7f9c47061d88: lock: 0x7f9be381a508: 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 150225 20:51:51 [Note] WSREP: (1c2c1a76, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 150225 20:51:52 [Note] WSREP: declaring 1fc6c39c at tcp://10.2.0.104:4567 stable 150225 20:51:52 [Note] WSREP: Node 1c2c1a76 state prim 150225 20:51:52 [Note] WSREP: view(view_id(PRIM,1c2c1a76,2) memb { 1c2c1a76,0 1fc6c39c,0 } joined { } left { } partitioned { }) 150225 20:51:52 [Note] WSREP: save pc into disk 150225 20:51:52 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 150225 20:51:52 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 20155494-bd30-11e4-bcde-6675176d5b09 150225 20:51:52 [Note] WSREP: STATE EXCHANGE: sent state msg: 20155494-bd30-11e4-bcde-6675176d5b09 150225 20:51:52 [Note] WSREP: STATE EXCHANGE: got state msg: 20155494-bd30-11e4-bcde-6675176d5b09 from 0 (db1.dev) 150225 20:51:52 [Note] WSREP: STATE EXCHANGE: got state msg: 20155494-bd30-11e4-bcde-6675176d5b09 from 1 (db2.dev) 150225 20:51:52 [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 = 1c2e68d6-bd30-11e4-bead-7a8d323d17d8 150225 20:51:52 [Note] WSREP: Flow-control interval: [23, 23] 150225 20:51:52 [Note] WSREP: New cluster view: global state: 1c2e68d6-bd30-11e4-bead-7a8d323d17d8:11, view# 2: Primary, number of nodes: 2, my index: 0, protocol version 3 150225 20:51:52 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150225 20:51:52 [Note] WSREP: REPL Protocols: 7 (3, 2) 150225 20:51:52 [Note] WSREP: Service thread queue flushed. 150225 20:51:52 [Note] WSREP: Assign initial position for certification: 11, protocol version: 3 150225 20:51:52 [Note] WSREP: Service thread queue flushed. 150225 20:51:52 [Note] WSREP: Member 1.0 (db2.dev) requested state transfer from '*any*'. Selected 0.0 (db1.dev)(SYNCED) as donor. 150225 20:51:52 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 11) 150225 20:51:52 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150225 20:51:52 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '10.2.0.104:4444/rsync_sst' --auth '(null)' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --binlog 'mysqld-bin' --gtid '1c2e68d6-bd30-11e4-bead-7a8d323d17d8:11'' 150225 20:51:52 [Note] WSREP: sst_donor_thread signaled with 0 150225 20:51:52 [Note] WSREP: Flushing tables for SST... 150225 20:51:52 [Note] WSREP: Provider paused at 1c2e68d6-bd30-11e4-bead-7a8d323d17d8:11 (16) 150225 20:51:52 [Note] WSREP: Tables flushed. 150225 20:51:54 [Note] WSREP: resuming provider at 16 150225 20:51:54 [Note] WSREP: Provider resumed. 150225 20:51:54 [Note] WSREP: 0.0 (db1.dev): State transfer to 1.0 (db2.dev) complete. 150225 20:51:54 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 11) 150225 20:51:54 [Note] WSREP: Member 0.0 (db1.dev) synced with group. 150225 20:51:54 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 11) 150225 20:51:54 [Note] WSREP: Synchronized with group, ready for connections 150225 20:51:54 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150225 20:51:55 [Note] WSREP: (1c2c1a76, 'tcp://0.0.0.0:4567') turning message relay requesting off 150225 20:51:55 [Note] WSREP: 1.0 (db2.dev): State transfer from 0.0 (db1.dev) complete. 150225 20:51:55 [Note] WSREP: Member 1.0 (db2.dev) synced with group. 150225 20:52:07 [Note] WSREP: (1c2c1a76, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 150225 20:52:08 [Note] WSREP: declaring 1fc6c39c at tcp://10.2.0.104:4567 stable 150225 20:52:08 [Note] WSREP: declaring 295d9868 at tcp://10.2.0.105:4567 stable 150225 20:52:09 [Note] WSREP: Node 1c2c1a76 state prim 150225 20:52:09 [Note] WSREP: view(view_id(PRIM,1c2c1a76,3) memb { 1c2c1a76,0 1fc6c39c,0 295d9868,0 } joined { } left { } partitioned { }) 150225 20:52:09 [Note] WSREP: save pc into disk 150225 20:52:09 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3 150225 20:52:09 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 2a4555ae-bd30-11e4-a64a-96feb7e65668 150225 20:52:09 [Note] WSREP: STATE EXCHANGE: sent state msg: 2a4555ae-bd30-11e4-a64a-96feb7e65668 150225 20:52:09 [Note] WSREP: STATE EXCHANGE: got state msg: 2a4555ae-bd30-11e4-a64a-96feb7e65668 from 1 (db2.dev) 150225 20:52:09 [Note] WSREP: STATE EXCHANGE: got state msg: 2a4555ae-bd30-11e4-a64a-96feb7e65668 from 0 (db1.dev) 150225 20:52:09 [Note] WSREP: STATE EXCHANGE: got state msg: 2a4555ae-bd30-11e4-a64a-96feb7e65668 from 2 (db3.dev) 150225 20:52:09 [Note] WSREP: Quorum results: version = 3, component = PRIMARY, conf_id = 2, members = 2/3 (joined/total), act_id = 11, last_appl. = 0, protocols = 0/7/3 (gcs/repl/appl), group UUID = 1c2e68d6-bd30-11e4-bead-7a8d323d17d8 150225 20:52:09 [Note] WSREP: Flow-control interval: [28, 28] 150225 20:52:09 [Note] WSREP: New cluster view: global state: 1c2e68d6-bd30-11e4-bead-7a8d323d17d8:11, view# 3: Primary, number of nodes: 3, my index: 0, protocol version 3 150225 20:52:09 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150225 20:52:09 [Note] WSREP: REPL Protocols: 7 (3, 2) 150225 20:52:09 [Note] WSREP: Service thread queue flushed. 150225 20:52:09 [Note] WSREP: Assign initial position for certification: 11, protocol version: 3 150225 20:52:09 [Note] WSREP: Service thread queue flushed. 150225 20:52:09 [Note] WSREP: Member 2.0 (db3.dev) requested state transfer from '*any*'. Selected 0.0 (db1.dev)(SYNCED) as donor. 150225 20:52:09 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 11) 150225 20:52:09 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150225 20:52:09 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '10.2.0.105:4444/rsync_sst' --auth '(null)' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --binlog 'mysqld-bin' --gtid '1c2e68d6-bd30-11e4-bead-7a8d323d17d8:11'' 150225 20:52:09 [Note] WSREP: sst_donor_thread signaled with 0 150225 20:52:09 [Note] WSREP: Flushing tables for SST... 150225 20:52:09 [Note] WSREP: Provider paused at 1c2e68d6-bd30-11e4-bead-7a8d323d17d8:11 (21) 150225 20:52:09 [Note] WSREP: Tables flushed. 150225 20:52:11 [Note] WSREP: (1c2c1a76, 'tcp://0.0.0.0:4567') turning message relay requesting off 150225 20:52:11 [Note] WSREP: resuming provider at 21 150225 20:52:11 [Note] WSREP: Provider resumed. 150225 20:52:11 [Note] WSREP: 0.0 (db1.dev): State transfer to 2.0 (db3.dev) complete. 150225 20:52:11 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 11) 150225 20:52:11 [Note] WSREP: Member 0.0 (db1.dev) synced with group. 150225 20:52:11 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 11) 150225 20:52:11 [Note] WSREP: Synchronized with group, ready for connections 150225 20:52:11 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150225 20:52:12 [Note] WSREP: 2.0 (db3.dev): State transfer from 0.0 (db1.dev) complete. 150225 20:52:12 [Note] WSREP: Member 2.0 (db3.dev) synced with group. 150225 20:52:43 mysqld_safe A mysqld process already exists 150225 20:52:53 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:52:53 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:52:53 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:52:53 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:53:57 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:53:57 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:53:57 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:53:57 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:54:58 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:54:58 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:54:58 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:54:58 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:55:59 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:55:59 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:55:59 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:55:59 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:57:01 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:57:01 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:57:01 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:57:01 [Warning] IP address '10.2.0.101' could not be resolved: Temporary failure in name resolution 150225 20:58:28 [Note] /usr/sbin/mysqld: Normal shutdown 150225 20:58:28 [Note] WSREP: Stop replication 150225 20:58:28 [Note] WSREP: Closing send monitor... 150225 20:58:28 [Note] WSREP: Closed send monitor. 150225 20:58:28 [Note] WSREP: gcomm: terminating thread 150225 20:58:28 [Note] WSREP: gcomm: joining thread 150225 20:58:28 [Note] WSREP: gcomm: closing backend 150225 20:58:28 [Note] WSREP: view(view_id(NON_PRIM,1c2c1a76,3) memb { 1c2c1a76,0 } joined { } left { } partitioned { 1fc6c39c,0 295d9868,0 }) 150225 20:58:28 [Note] WSREP: view((empty)) 150225 20:58:28 [Note] WSREP: gcomm: closed 150225 20:58:28 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 150225 20:58:28 [Note] WSREP: Flow-control interval: [16, 16] 150225 20:58:28 [Note] WSREP: Received NON-PRIMARY. 150225 20:58:28 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 11) 150225 20:58:28 [Note] WSREP: Received self-leave message. 150225 20:58:28 [Note] WSREP: Flow-control interval: [0, 0] 150225 20:58:28 [Note] WSREP: Received SELF-LEAVE. Closing connection. 150225 20:58:28 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 11) 150225 20:58:28 [Note] WSREP: RECV thread exiting 0: Success 150225 20:58:28 [Note] WSREP: New cluster view: global state: 1c2e68d6-bd30-11e4-bead-7a8d323d17d8:11, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 150225 20:58:28 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150225 20:58:28 [Note] WSREP: New cluster view: global state: 1c2e68d6-bd30-11e4-bead-7a8d323d17d8:11, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 3 150225 20:58:28 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150225 20:58:28 [Note] WSREP: applier thread exiting (code:0) 150225 20:58:28 [Note] WSREP: recv_thread() joined. 150225 20:58:28 [Note] WSREP: Closing replication queue. 150225 20:58:28 [Note] WSREP: Closing slave action queue. 150225 20:58:30 [Note] WSREP: rollbacker thread exiting 150225 20:58:30 [Note] Event Scheduler: Purging the queue. 0 events 150225 20:58:30 [Note] WSREP: dtor state: CLOSED 150225 20:58:30 [Note] WSREP: mon: entered 11 oooe fraction 0 oool fraction 0 150225 20:58:30 [Note] WSREP: mon: entered 11 oooe fraction 0 oool fraction 0 150225 20:58:30 [Note] WSREP: mon: entered 25 oooe fraction 0 oool fraction 0 150225 20:58:30 [Note] WSREP: cert index usage at exit 0 150225 20:58:30 [Note] WSREP: cert trx map usage at exit 0 150225 20:58:30 [Note] WSREP: deps set usage at exit 0 150225 20:58:30 [Note] WSREP: avg deps dist 1 150225 20:58:30 [Note] WSREP: avg cert interval 0 150225 20:58:30 [Note] WSREP: cert index size 7 150225 20:58:30 [Note] WSREP: Service thread queue flushed. 150225 20:58:30 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 150225 20:58:30 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 11, in use: 0, in pool: 11 150225 20:58:30 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 150225 20:58:30 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 11) 150225 20:58:30 [Note] WSREP: Flushing memory map to disk... 150225 20:58:30 [Note] InnoDB: FTS optimize thread exiting. 150225 20:58:30 [Note] InnoDB: Starting shutdown... 150225 20:58:31 [Note] InnoDB: Shutdown completed; log sequence number 1618807 150225 20:58:31 [Note] /usr/sbin/mysqld: Shutdown complete 150225 20:58:31 mysqld_safe mysqld from pid file /var/lib/mysql/db1.dev.pid ended 150225 20:58:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150225 20:58:32 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.tZGcoq' --pid-file='/var/lib/mysql/db1.dev-recover.pid' 150225 20:58:34 mysqld_safe WSREP: Recovered position 1c2e68d6-bd30-11e4-bead-7a8d323d17d8:11 150225 20:58:34 [Note] WSREP: wsrep_start_position var submitted: '1c2e68d6-bd30-11e4-bead-7a8d323d17d8:11' 150225 20:58:34 [Note] WSREP: Read nil XID from storage engines, skipping position init 150225 20:58:34 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' 150225 20:58:34 [Note] WSREP: wsrep_load(): Galera 25.3.9(r0) by Codership Oy loaded successfully. 150225 20:58:34 [Note] WSREP: CRC-32C: using hardware acceleration. 150225 20:58:34 [Note] WSREP: Found saved state: 1c2e68d6-bd30-11e4-bead-7a8d323d17d8:11 150225 20:58:34 [Note] WSREP: Passing config to GCS: base_host = 10.2.0.103; 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 150225 20:58:34 [Note] WSREP: Service thread queue flushed. 150225 20:58:34 [Note] WSREP: Assign initial position for certification: 11, protocol version: -1 150225 20:58:34 [Note] WSREP: wsrep_sst_grab() 150225 20:58:34 [Note] WSREP: Start replication 150225 20:58:34 [Note] WSREP: 'wsrep-new-cluster' option used, bootstrapping the cluster 150225 20:58:34 [Note] WSREP: Setting initial position to 1c2e68d6-bd30-11e4-bead-7a8d323d17d8:11 150225 20:58:34 [Note] WSREP: protonet asio version 0 150225 20:58:34 [Note] WSREP: Using CRC-32C for message checksums. 150225 20:58:34 [Note] WSREP: backend: asio 150225 20:58:34 [Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory) 150225 20:58:34 [Note] WSREP: restore pc from disk failed 150225 20:58:34 [Note] WSREP: GMCast version 0 150225 20:58:34 [Note] WSREP: (10179e0b, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 150225 20:58:34 [Note] WSREP: (10179e0b, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 150225 20:58:34 [Note] WSREP: EVS version 0 150225 20:58:34 [Note] WSREP: start_prim is enabled, turn off pc_recovery 150225 20:58:34 [Note] WSREP: Node 10179e0b state prim 150225 20:58:34 [Note] WSREP: view(view_id(PRIM,10179e0b,1) memb { 10179e0b,0 } joined { } left { } partitioned { }) 150225 20:58:34 [Note] WSREP: save pc into disk 150225 20:58:34 [Note] WSREP: discarding pending addr without UUID: tcp://10.2.0.104:4567 150225 20:58:34 [Note] WSREP: discarding pending addr proto entry 0x7f79b7cd2500 150225 20:58:34 [Note] WSREP: discarding pending addr without UUID: tcp://10.2.0.105:4567 150225 20:58:34 [Note] WSREP: discarding pending addr proto entry 0x7f79b7cd25c0 150225 20:58:34 [Note] WSREP: gcomm: connected 150225 20:58:34 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 150225 20:58:34 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 150225 20:58:34 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 150225 20:58:34 [Note] WSREP: Waiting for SST to complete. 150225 20:58:34 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 101a5460-bd31-11e4-9807-2fecd5c7c846 150225 20:58:34 [Note] WSREP: STATE EXCHANGE: sent state msg: 101a5460-bd31-11e4-9807-2fecd5c7c846 150225 20:58:34 [Note] WSREP: STATE EXCHANGE: got state msg: 101a5460-bd31-11e4-9807-2fecd5c7c846 from 0 (db1.dev) 150225 20:58:34 [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 = 1c2e68d6-bd30-11e4-bead-7a8d323d17d8 150225 20:58:34 [Note] WSREP: Flow-control interval: [16, 16] 150225 20:58:34 [Note] WSREP: Restored state OPEN -> JOINED (11) 150225 20:58:34 [Note] WSREP: Member 0.0 (db1.dev) synced with group. 150225 20:58:34 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 11) 150225 20:58:34 [Note] WSREP: New cluster view: global state: 1c2e68d6-bd30-11e4-bead-7a8d323d17d8:11, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3 150225 20:58:34 [Note] WSREP: SST complete, seqno: 11 150225 20:58:34 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150225 20:58:34 [Note] InnoDB: The InnoDB memory heap is disabled 150225 20:58:34 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150225 20:58:34 [Note] InnoDB: Memory barrier is not used 150225 20:58:34 [Note] InnoDB: Compressed tables use zlib 1.2.3 150225 20:58:34 [Note] InnoDB: Using Linux native AIO 150225 20:58:34 [Note] InnoDB: Using CPU crc32 instructions 150225 20:58:34 [Note] InnoDB: Initializing buffer pool, size = 798.0M 150225 20:58:34 [Note] InnoDB: Completed initialization of buffer pool 150225 20:58:34 [Note] InnoDB: Highest supported file format is Barracuda. 150225 20:58:34 [Note] InnoDB: 128 rollback segment(s) are active. 150225 20:58:34 [Note] InnoDB: Waiting for purge to start 150225 20:58:35 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-71.0 started; log sequence number 1618817 150225 20:58:35 [Note] Plugin 'FEEDBACK' is disabled. 150225 20:58:35 [Note] Server socket created on IP: '::'. 150225 20:58:35 [Note] Event Scheduler: Loaded 0 events 150225 20:58:35 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150225 20:58:35 [Note] WSREP: REPL Protocols: 7 (3, 2) 150225 20:58:35 [Note] WSREP: Service thread queue flushed. 150225 20:58:35 [Note] WSREP: Assign initial position for certification: 11, protocol version: 3 150225 20:58:35 [Note] WSREP: Service thread queue flushed. 150225 20:58:35 [Note] WSREP: Synchronized with group, ready for connections 150225 20:58:35 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150225 20:58:35 [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: 0x7f79b7c8f788: lock: 0x7f79b7c83788: lock: 0x7f79b7c69588: lock: 0x7f79b7c68188: lock: 0x7f79b7c66388: lock: 0x7f79b7c64f88: lock: 0x7f79b7d56b88: lock: 0x7f79b7d98388: lock: 0x7f79b7c80788: lock: 0x7f79b7c61d88: lock: 0x7f795441a508: 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 150225 20:58:47 [Note] WSREP: (10179e0b, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 150225 20:58:49 [Note] WSREP: declaring 17c0cf6f at tcp://10.2.0.104:4567 stable 150225 20:58:49 [Note] WSREP: declaring 295d9868 at tcp://10.2.0.105:4567 stable 150225 20:58:49 [Warning] WSREP: 10179e0b conflicting prims: my prim: view_id(PRIM,10179e0b,1) other prim: view_id(PRIM,295d9868,5) 150225 20:58:49 [ERROR] WSREP: caught exception in PC, state dump to stderr follows: pc::Proto{uuid=10179e0b,start_prim=1,npvo=0,ignore_sb=0,ignore_quorum=0,state=1,last_sent_seq=14,checksum=0,instances= 10179e0b,prim=1,un=0,last_seq=14,last_prim=view_id(PRIM,10179e0b,1),to_seq=13,weight=1,segment=0 ,state_msgs= 10179e0b,pcmsg{ type=STATE, seq=0, flags= 0, node_map { 10179e0b,prim=1,un=0,last_seq=14,last_prim=view_id(PRIM,10179e0b,1),to_seq=13,weight=1,segment=0 }} 17c0cf6f,pcmsg{ type=STATE, seq=0, flags= 0, node_map { 17c0cf6f,prim=0,un=0,last_seq=4294967295,last_prim=view_id(NON_PRIM,00000000,0),to_seq=-1,weight=1,segment=0 }} ,current_view=view(view_id(REG,10179e0b,6) memb { 10179e0b,0 17c0cf6f,0 295d9868,0 } joined { 17c0cf6f,0 295d9868,0 } left { } partitioned { }),pc_view=view(view_id(PRIM,10179e0b,1) memb { 10179e0b,0 } joined { } left { } partitioned { }),mtu=32636} 150225 20:58:49 [Note] WSREP: {v=0,t=1,ut=255,o=4,s=0,sr=0,as=-1,f=4,src=295d9868,srcvid=view_id(REG,10179e0b,6),insvid=view_id(UNKNOWN,00000000,0),ru=00000000,r=[-1,-1],fs=2236,nl=( ) } 64 150225 20:58:49 [ERROR] WSREP: exception caused by message: {v=0,t=3,ut=255,o=1,s=0,sr=-1,as=0,f=4,src=295d9868,srcvid=view_id(REG,10179e0b,6),insvid=view_id(UNKNOWN,00000000,0),ru=00000000,r=[-1,-1],fs=2238,nl=( ) } state after handling message: evs::proto(evs::proto(10179e0b, OPERATIONAL, view_id(REG,10179e0b,6)), OPERATIONAL) { current_view=view(view_id(REG,10179e0b,6) memb { 10179e0b,0 17c0cf6f,0 295d9868,0 } joined { } left { } partitioned { }), input_map=evs::input_map: {aru_seq=0,safe_seq=0,node_index=node: {idx=0,range=[1,0],safe_seq=0} node: {idx=1,range=[1,0],safe_seq=0} node: {idx=2,range=[1,0],safe_seq=0} }, fifo_seq=44, last_sent=0, known: 10179e0b at {o=1,s=0,i=1,fs=-1,} 17c0cf6f at tcp://10.2.0.104:4567 {o=1,s=0,i=1,fs=12,} 295d9868 at tcp://10.2.0.105:4567 {o=1,s=0,i=1,fs=2238,} }150225 20:58:49 [ERROR] WSREP: exception from gcomm, backend must be restarted: 10179e0b aborting due to conflicting prims: older overrides (FATAL) at gcomm/src/pc_proto.cpp:handle_state():982 150225 20:58:49 [Note] WSREP: gcomm: terminating thread 150225 20:58:49 [Note] WSREP: gcomm: joining thread 150225 20:58:49 [Note] WSREP: gcomm: closing backend 150225 20:58:49 [Note] WSREP: Forced PC close 150225 20:58:49 [Warning] WSREP: discarding 1 messages from message index 150225 20:58:49 [Note] WSREP: gcomm: closed 150225 20:58:49 [Note] WSREP: Received self-leave message. 150225 20:58:49 [Note] WSREP: comp msg error in core 103 150225 20:58:49 [Note] WSREP: Closing send monitor... 150225 20:58:49 [Note] WSREP: Closed send monitor. 150225 20:58:49 [Note] WSREP: Closing replication queue. 150225 20:58:49 [Note] WSREP: Closing slave action queue. 150225 20:58:49 [Note] WSREP: Shifting SYNCED -> CLOSED (TO: 22) 150225 20:58:49 [Note] WSREP: RECV thread exiting -103: Software caused connection abort 150225 20:58:49 [Note] WSREP: New cluster view: global state: 00000000-0000-0000-0000-000000000000:0, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version -1 150225 20:58:49 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 150225 20:58:49 [Note] WSREP: applier thread exiting (code:6) 150225 20:59:14 [Note] /usr/sbin/mysqld: Normal shutdown 150225 20:59:14 [Note] WSREP: Stop replication 150225 20:59:16 [Note] WSREP: rollbacker thread exiting 150225 20:59:16 [Note] Event Scheduler: Purging the queue. 0 events 150225 20:59:37 [Warning] /usr/sbin/mysqld: Forcing close of thread 34 user: ''