2017-07-23 14:21:10 140440152819584 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-07-23 14:21:10 140440152819584 [Note] InnoDB: Uses event mutexes 2017-07-23 14:21:10 140440152819584 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-07-23 14:21:10 140440152819584 [Note] InnoDB: Using Linux native AIO 2017-07-23 14:21:10 140440152819584 [Note] InnoDB: Number of pools: 1 2017-07-23 14:21:10 140440152819584 [Note] InnoDB: Using SSE2 crc32 instructions 2017-07-23 14:21:10 140440152819584 [Note] InnoDB: Initializing buffer pool, total size = 15G, instances = 15, chunk size = 128M 2017-07-23 14:21:10 140440152819584 [Note] InnoDB: Completed initialization of buffer pool 2017-07-23 14:21:11 140422705141504 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-07-23 14:21:11 140440152819584 [Note] InnoDB: Highest supported file format is Barracuda. 2017-07-23 14:21:11 140440152819584 [Note] InnoDB: 128 out of 128 rollback segments are active. 2017-07-23 14:21:11 140440152819584 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-07-23 14:21:11 140440152819584 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-07-23 14:21:11 140440152819584 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-07-23 14:21:11 140440152819584 [Note] InnoDB: Waiting for purge to start 2017-07-23 14:21:11 140440152819584 [Note] InnoDB: 5.7.18 started; log sequence number 30871587954 2017-07-23 14:21:11 140423007790848 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2017-07-23 14:21:11 140440152819584 [Note] Plugin 'FEEDBACK' is disabled. 2017-07-23 14:21:11 140440152819584 [Note] Server socket created on IP: '0.0.0.0'. 2017-07-23 14:21:11 140440152819584 [Note] WSREP: Initial position: cfead6e8-6637-11e7-b799-f7ab0009b84b:139118 2017-07-23 14:21:11 140440152819584 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' 2017-07-23 14:21:11 140440152819584 [Note] WSREP: wsrep_load(): Galera 25.3.20(r3703) by Codership Oy loaded successfully. 2017-07-23 14:21:11 140440152819584 [Note] WSREP: CRC-32C: using hardware acceleration. 2017-07-23 14:21:11 140440152819584 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat' 2017-07-23 14:21:11 140440152819584 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 1 2017-07-23 14:21:11 140440152819584 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.0.0.2; base_port = 10003; 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.recover = no; gcache.size = 512M; gcomm.thread_prio = ; 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.igno 2017-07-23 14:21:11 140440152819584 [Note] WSREP: GCache history reset: old(cfead6e8-6637-11e7-b799-f7ab0009b84b:0) -> new(00000000-0000-0000-0000-000000000000:-1) 2017-07-23 14:21:11 140440152819584 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 2017-07-23 14:21:11 140440152819584 [Note] WSREP: Start replication 2017-07-23 14:21:11 140440152819584 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 2017-07-23 14:21:11 140440152819584 [Note] WSREP: protonet asio version 0 2017-07-23 14:21:11 140440152819584 [Note] WSREP: Using CRC-32C for message checksums. 2017-07-23 14:21:11 140440152819584 [Note] WSREP: backend: asio 2017-07-23 14:21:11 140440152819584 [Note] WSREP: gcomm thread scheduling priority set to other:0 2017-07-23 14:21:11 140440152819584 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) 2017-07-23 14:21:11 140440152819584 [Note] WSREP: restore pc from disk failed 2017-07-23 14:21:11 140440152819584 [Note] WSREP: GMCast version 0 2017-07-23 14:21:11 140440152819584 [Note] WSREP: (08251679, 'tcp://0.0.0.0:10003') listening at tcp://0.0.0.0:10003 2017-07-23 14:21:11 140440152819584 [Note] WSREP: (08251679, 'tcp://0.0.0.0:10003') multicast: , ttl: 1 2017-07-23 14:21:11 140440152819584 [Note] WSREP: EVS version 0 2017-07-23 14:21:11 140440152819584 [Note] WSREP: gcomm: connecting to group 'mariadbcluster', peer '10.0.0.2:10003,10.0.0.3:10003,10.0.0.4:10003,10.0.0.5:10003' 2017-07-23 14:21:11 140440152819584 [Note] WSREP: (08251679, 'tcp://0.0.0.0:10003') connection established to 08251679 tcp://10.0.0.2:10003 2017-07-23 14:21:11 140440152819584 [Warning] WSREP: (08251679, 'tcp://0.0.0.0:10003') address 'tcp://10.0.0.2:10003' points to own listening address, blacklisting 2017-07-23 14:21:11 140440152819584 [Note] WSREP: (08251679, 'tcp://0.0.0.0:10003') connection established to 385c5d36 tcp://10.0.0.3:10003 2017-07-23 14:21:11 140440152819584 [Note] WSREP: (08251679, 'tcp://0.0.0.0:10003') turning message relay requesting on, nonlive peers: 2017-07-23 14:21:11 140440152819584 [Note] WSREP: declaring 385c5d36 at tcp://10.0.0.3:10003 stable 2017-07-23 14:21:11 140440152819584 [Note] WSREP: Node 385c5d36 state prim 2017-07-23 14:21:11 140440152819584 [Note] WSREP: view(view_id(PRIM,08251679,6) memb { 08251679,0 385c5d36,0 } joined { } left { } partitioned { }) 2017-07-23 14:21:11 140440152819584 [Note] WSREP: save pc into disk 2017-07-23 14:21:11 140440152819584 [Note] WSREP: discarding pending addr without UUID: tcp://10.0.0.4:10003 2017-07-23 14:21:11 140440152819584 [Note] WSREP: discarding pending addr proto entry 0x56140597d3d0 2017-07-23 14:21:11 140440152819584 [Note] WSREP: discarding pending addr without UUID: tcp://10.0.0.5:10003 2017-07-23 14:21:11 140440152819584 [Note] WSREP: discarding pending addr proto entry 0x56140597dba0 2017-07-23 14:21:12 140440152819584 [Note] WSREP: gcomm: connected 2017-07-23 14:21:12 140440152819584 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2017-07-23 14:21:12 140440152819584 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2017-07-23 14:21:12 140440152819584 [Note] WSREP: Opened channel 'mariadbcluster' 2017-07-23 14:21:12 140422935770880 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2017-07-23 14:21:12 140422935770880 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 0871b258-6f99-11e7-873d-ebeca4574b7c 2017-07-23 14:21:12 140422935770880 [Note] WSREP: STATE EXCHANGE: sent state msg: 0871b258-6f99-11e7-873d-ebeca4574b7c 2017-07-23 14:21:12 140440152819584 [Note] Reading of all Master_info entries succeded 2017-07-23 14:21:12 140440152819584 [Note] Added new Master_info '' to hash table 2017-07-23 14:21:12 140440152819584 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.7-MariaDB-10.2.7+maria~jessie-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution 2017-07-23 14:21:12 140422935770880 [Note] WSREP: STATE EXCHANGE: got state msg: 0871b258-6f99-11e7-873d-ebeca4574b7c from 0 (mysql1) 2017-07-23 14:21:12 140422935770880 [Note] WSREP: STATE EXCHANGE: got state msg: 0871b258-6f99-11e7-873d-ebeca4574b7c from 1 (mysql2) 2017-07-23 14:21:12 140422935770880 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 5, members = 1/2 (joined/total), act_id = 139118, last_appl. = -1, protocols = 0/7/3 (gcs/repl/appl), group UUID = cfead6e8-6637-11e7-b799-f7ab0009b84b 2017-07-23 14:21:12 140422935770880 [Note] WSREP: Flow-control interval: [23, 23] 2017-07-23 14:21:12 140422935770880 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 139118) 2017-07-23 14:21:12 140422927378176 [Note] WSREP: State transfer required: Group state: cfead6e8-6637-11e7-b799-f7ab0009b84b:139118 Local state: 00000000-0000-0000-0000-000000000000:-1 2017-07-23 14:21:12 140422927378176 [Note] WSREP: New cluster view: global state: cfead6e8-6637-11e7-b799-f7ab0009b84b:139118, view# 6: Primary, number of nodes: 2, my index: 0, protocol version 3 2017-07-23 14:21:12 140422927378176 [Warning] WSREP: Gap in state sequence. Need state transfer. 2017-07-23 14:21:14 140422927378176 [Note] WSREP: Prepared SST request: mysqldump|10.0.0.2:3306 2017-07-23 14:21:14 140422927378176 [Note] WSREP: REPL Protocols: 7 (3, 2) 2017-07-23 14:21:14 140422927378176 [Note] WSREP: Assign initial position for certification: 139118, protocol version: 3 2017-07-23 14:21:14 140422952556288 [Note] WSREP: Service thread queue flushed. 2017-07-23 14:21:14 140422927378176 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (cfead6e8-6637-11e7-b799-f7ab0009b84b): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable. 2017-07-23 14:21:14 140422935770880 [Note] WSREP: Member 0.0 (mysql1) requested state transfer from 'mysql2'. Selected 1.0 (mysql2)(SYNCED) as donor. 2017-07-23 14:21:14 140422935770880 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 139118) 2017-07-23 14:21:14 140422927378176 [Note] WSREP: Requesting state transfer: success, donor: 1 2017-07-23 14:21:14 140422927378176 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(cfead6e8-6637-11e7-b799-f7ab0009b84b:139118) 2017-07-23 14:21:15 140422944163584 [Note] WSREP: (08251679, 'tcp://0.0.0.0:10003') connection to peer 08251679 with addr tcp://10.0.0.2:10003 timed out, no messages seen in PT3S 2017-07-23 14:21:15 140422944163584 [Note] WSREP: (08251679, 'tcp://0.0.0.0:10003') turning message relay requesting off 2017-07-23 14:21:23 140423007790848 [Note] InnoDB: Buffer pool(s) load completed at 170723 14:21:23 2017-07-23 14:21:57 140422920709888 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2017-07-23 14:21:57 140422920709888 [Note] WSREP: Stop replication 2017-07-23 14:21:57 140422920709888 [Note] WSREP: Closing send monitor... 2017-07-23 14:21:57 140422920709888 [Note] WSREP: Closed send monitor. 2017-07-23 14:21:57 140422920709888 [Note] WSREP: gcomm: terminating thread 2017-07-23 14:21:57 140422920709888 [Note] WSREP: gcomm: joining thread 2017-07-23 14:21:57 140422920709888 [Note] WSREP: gcomm: closing backend 2017-07-23 14:22:01 140422920709888 [Note] WSREP: (08251679, 'tcp://0.0.0.0:10003') connection to peer 385c5d36 with addr tcp://10.0.0.3:10003 timed out, no messages seen in PT3S 2017-07-23 14:22:01 140422920709888 [Note] WSREP: (08251679, 'tcp://0.0.0.0:10003') turning message relay requesting on, nonlive peers: tcp://10.0.0.3:10003 2017-07-23 14:22:02 140422920709888 [Note] WSREP: (08251679, 'tcp://0.0.0.0:10003') reconnecting to 385c5d36 (tcp://10.0.0.3:10003), attempt 0 2017-07-23 14:22:03 140422920709888 [Note] WSREP: evs::proto(08251679, LEAVING, view_id(REG,08251679,6)) suspecting node: 385c5d36 2017-07-23 14:22:03 140422920709888 [Note] WSREP: evs::proto(08251679, LEAVING, view_id(REG,08251679,6)) suspected node without join message, declaring inactive 2017-07-23 14:22:03 140422920709888 [Note] WSREP: view(view_id(NON_PRIM,08251679,6) memb { 08251679,0 } joined { } left { } partitioned { 385c5d36,0 }) 2017-07-23 14:22:03 140422920709888 [Note] WSREP: view((empty)) 2017-07-23 14:22:03 140422920709888 [Note] WSREP: gcomm: closed 2017-07-23 14:22:03 140422935770880 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2017-07-23 14:22:03 140422935770880 [Note] WSREP: Flow-control interval: [16, 16] 2017-07-23 14:22:03 140422935770880 [Note] WSREP: Received NON-PRIMARY. 2017-07-23 14:22:03 140422935770880 [Note] WSREP: Shifting JOINER -> OPEN (TO: 139118) 2017-07-23 14:22:03 140422935770880 [Note] WSREP: Received self-leave message. 2017-07-23 14:22:03 140422935770880 [Note] WSREP: Flow-control interval: [0, 0] 2017-07-23 14:22:03 140422935770880 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2017-07-23 14:22:03 140422935770880 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 139118) 2017-07-23 14:22:03 140422935770880 [Note] WSREP: RECV thread exiting 0: Success 2017-07-23 14:22:03 140422920709888 [Note] WSREP: recv_thread() joined. 2017-07-23 14:22:03 140422920709888 [Note] WSREP: Closing replication queue. 2017-07-23 14:22:03 140422920709888 [Note] WSREP: Closing slave action queue. -- waiting for SST to finish, 12 minutes in this case 2017-07-23 14:34:06 140422921012992 [Note] WSREP: SST received: cfead6e8-6637-11e7-b799-f7ab0009b84b:139118 2017-07-23 14:34:06 140422921012992 [Note] WSREP: wsrep_start_position set to 'cfead6e8-6637-11e7-b799-f7ab0009b84b:139118' 2017-07-23 14:34:06 140422927378176 [ERROR] WSREP: gcs/src/gcs.cpp:_join():837: Sending JOIN failed: -103 (Software caused connection abort). 2017-07-23 14:34:06 140422927378176 [ERROR] WSREP: Failed to JOIN the cluster after SST 2017-07-23 14:34:06 140422927378176 [Note] WSREP: New cluster view: global state: cfead6e8-6637-11e7-b799-f7ab0009b84b:139118, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 2017-07-23 14:34:06 140422927378176 [Note] WSREP: New cluster view: global state: cfead6e8-6637-11e7-b799-f7ab0009b84b:139118, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 3 2017-07-23 14:34:06 140422927378176 [Note] WSREP: applier thread exiting (code:0) 2017-07-23 14:34:06 140422926468864 [Note] WSREP: applier thread exiting (code:6) 2017-07-23 14:34:06 140422926165760 [Note] WSREP: applier thread exiting (code:6) 2017-07-23 14:34:06 140422927075072 [Note] WSREP: applier thread exiting (code:6) 2017-07-23 14:34:06 140423150835456 [Note] WSREP: applier thread exiting (code:6) 2017-07-23 14:34:06 140422926771968 [Note] WSREP: applier thread exiting (code:6) 2017-07-23 14:34:06 140422925862656 [Note] WSREP: applier thread exiting (code:6) 2017-07-23 14:34:06 140422925559552 [Note] WSREP: applier thread exiting (code:6) 2017-07-23 14:34:06 140423151138560 [Note] WSREP: rollbacker thread exiting 2017-07-23 14:34:06 140422920709888 [Note] Event Scheduler: Purging the queue. 0 events 2017-07-23 14:34:06 140423049754368 [Note] InnoDB: FTS optimize thread exiting. 2017-07-23 14:34:06 140422920709888 [Note] WSREP: dtor state: CLOSED 2017-07-23 14:34:06 140422920709888 [Note] WSREP: apply mon: entered 0 2017-07-23 14:34:06 140422920709888 [Note] WSREP: apply mon: entered 0 2017-07-23 14:34:06 140422920709888 [Note] WSREP: mon: entered 3 oooe fraction 0 oool fraction 0.333333 2017-07-23 14:34:06 140422920709888 [Note] WSREP: cert index usage at exit 0 2017-07-23 14:34:06 140422920709888 [Note] WSREP: cert trx map usage at exit 0 2017-07-23 14:34:06 140422920709888 [Note] WSREP: deps set usage at exit 0 2017-07-23 14:34:06 140422920709888 [Note] WSREP: avg deps dist 0 2017-07-23 14:34:06 140422920709888 [Note] WSREP: avg cert interval 0 2017-07-23 14:34:06 140422920709888 [Note] WSREP: cert index size 0 2017-07-23 14:34:06 140422952556288 [Note] WSREP: Service thread queue flushed. 2017-07-23 14:34:06 140422920709888 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 2017-07-23 14:34:06 140422920709888 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2017-07-23 14:34:06 140422920709888 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2017-07-23 14:34:06 140422920709888 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 139118) 2017-07-23 14:34:06 140422920709888 [Note] WSREP: Flushing memory map to disk... 2017-07-23 14:34:06 140422920709888 [Note] InnoDB: Starting shutdown... 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 0, restricted to 16384 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 1, restricted to 16382 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 2, restricted to 16384 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 3, restricted to 16382 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 4, restricted to 16384 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 5, restricted to 16382 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 6, restricted to 16384 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 7, restricted to 16382 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 8, restricted to 16384 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 9, restricted to 16382 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 10, restricted to 16384 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 11, restricted to 16382 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 12, restricted to 16384 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 13, restricted to 16382 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Instance 14, restricted to 16384 pages due to innodb_buf_pool_dump_pct=25 2017-07-23 14:34:06 140423007790848 [Note] InnoDB: Buffer pool(s) dump completed at 170723 14:34:06 2017-07-23 14:34:08 140422920709888 [Note] InnoDB: Shutdown completed; log sequence number 38118101985 2017-07-23 14:34:08 140422920709888 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-07-23 14:34:08 140422920709888 [Note] /usr/sbin/mysqld: Shutdown complete