2019-10-26  3:45:02 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2019-10-26  3:45:02 0 [Note] WSREP: Shutdown replication
2019-10-26  3:45:02 0 [Note] WSREP: Server status change synced -> disconnecting
2019-10-26  3:45:02 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2019-10-26  3:45:02 0 [Note] WSREP: Closing send monitor...
2019-10-26  3:45:02 0 [Note] WSREP: Closed send monitor.
2019-10-26  3:45:02 0 [Note] WSREP: gcomm: terminating thread
2019-10-26  3:45:02 0 [Note] WSREP: gcomm: joining thread
2019-10-26  3:45:02 0 [Note] WSREP: gcomm: closing backend
2019-10-26  3:45:02 0 [Note] WSREP: view(view_id(NON_PRIM,2c9d3ddb,158) memb {
        9c9507c2,0
} joined {
} left {
} partitioned {
        2c9d3ddb,0
        5902428d,0
})
2019-10-26  3:45:02 0 [Note] WSREP: PC protocol downgrade 1 -> 0
2019-10-26  3:45:02 0 [Note] WSREP: view((empty))
2019-10-26  3:45:02 0 [Note] WSREP: gcomm: closed
2019-10-26  3:45:02 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
2019-10-26  3:45:02 0 [Note] WSREP: Writing down CC checksum: eda9e783 06a7b0a2 4f1cc57e d95483b5 at offset 120
2019-10-26  3:45:02 0 [Note] WSREP: Flow-control interval: [16, 16]
2019-10-26  3:45:02 0 [Note] WSREP: Trying to continue unpaused monitor
2019-10-26  3:45:02 0 [Note] WSREP: Received NON-PRIMARY.
2019-10-26  3:45:02 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 260219848)
2019-10-26  3:45:02 0 [Note] WSREP: Received self-leave message.
2019-10-26  3:45:02 0 [Note] WSREP: Writing down CC checksum: 6c22f7f6 aa7fd261 477376c8 d0651338 at offset 64
2019-10-26  3:45:02 0 [Note] WSREP: Flow-control interval: [0, 0]
2019-10-26  3:45:02 0 [Note] WSREP: Trying to continue unpaused monitor
2019-10-26  3:45:02 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2019-10-26  3:45:02 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: -1)
2019-10-26  3:45:02 0 [Note] WSREP: RECV thread exiting 0: Success
2019-10-26  3:45:02 0 [Note] WSREP: recv_thread() joined.
2019-10-26  3:45:02 0 [Note] WSREP: Closing replication queue.
2019-10-26  3:45:02 18 [Note] WSREP: ####### processing CC -1, local, ordered
2019-10-26  3:45:02 0 [Note] WSREP: Closing slave action queue.
2019-10-26  3:45:02 18 [Note] WSREP: ####### drain monitors upto 260219848
2019-10-26  3:45:02 18 [Note] WSREP: ####### My UUID: 9c9507c2-f4a0-11e9-9787-cf7b0eff47a2
2019-10-26  3:45:02 18 [Note] WSREP: ####### ST not required
2019-10-26  3:45:02 18 [Note] WSREP: ================================================
View:
  id: 05f55365-1970-11e9-89d3-d7b7715e6b83:-1
  status: non-primary
  protocol_version: 4
  capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
  final: no
  own_index: 0
  members(1):
        0: 9c9507c2-f4a0-11e9-9787-cf7b0eff47a2, node6
=================================================
2019-10-26  3:45:02 18 [Note] WSREP: Non-primary view
2019-10-26  3:45:02 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2019-10-26  3:45:02 18 [Note] WSREP: ####### processing CC -1, local, ordered
2019-10-26  3:45:02 18 [Note] WSREP: ####### drain monitors upto 260219848
2019-10-26  3:45:02 18 [Note] WSREP: ####### My UUID: 9c9507c2-f4a0-11e9-9787-cf7b0eff47a2
2019-10-26  3:45:02 18 [Note] WSREP: ####### ST not required
2019-10-26  3:45:02 18 [Note] WSREP: ================================================
View:
  id: 05f55365-1970-11e9-89d3-d7b7715e6b83:-1
  status: non-primary
  protocol_version: 4
  capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
  final: yes
  own_index: -1
  members(0):
=================================================
2019-10-26  3:45:02 18 [Note] WSREP: Non-primary view
2019-10-26  3:45:02 18 [Note] WSREP: Server status change disconnecting -> disconnected
2019-10-26  3:45:02 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2019-10-26  3:45:02 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2019-10-26  3:45:02 1 [Note] WSREP: Applier thread exiting ret: 6 thd: 1
2019-10-26  3:45:02 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 23 [Note] WSREP: Applier thread exiting ret: 6 thd: 23
2019-10-26  3:45:02 21 [Note] WSREP: Applier thread exiting ret: 6 thd: 21
2019-10-26  3:45:02 20 [Note] WSREP: Applier thread exiting ret: 6 thd: 20
2019-10-26  3:45:02 21 [Warning] Aborted connection 21 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 20 [Warning] Aborted connection 20 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 25 [Note] WSREP: Applier thread exiting ret: 6 thd: 25
2019-10-26  3:45:02 25 [Warning] Aborted connection 25 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 19 [Note] WSREP: Applier thread exiting ret: 6 thd: 19
2019-10-26  3:45:02 19 [Warning] Aborted connection 19 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 23 [Warning] Aborted connection 23 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 24 [Note] WSREP: Applier thread exiting ret: 6 thd: 24
2019-10-26  3:45:02 14 [Note] WSREP: Applier thread exiting ret: 6 thd: 14
2019-10-26  3:45:02 24 [Warning] Aborted connection 24 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 14 [Warning] Aborted connection 14 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 13 [Note] WSREP: Applier thread exiting ret: 6 thd: 13
2019-10-26  3:45:02 13 [Warning] Aborted connection 13 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 16 [Note] WSREP: Applier thread exiting ret: 6 thd: 16
2019-10-26  3:45:02 22 [Note] WSREP: Applier thread exiting ret: 6 thd: 22
2019-10-26  3:45:02 15 [Note] WSREP: Applier thread exiting ret: 6 thd: 15
2019-10-26  3:45:02 22 [Warning] Aborted connection 22 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 15 [Warning] Aborted connection 15 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 17 [Note] WSREP: Applier thread exiting ret: 6 thd: 17
2019-10-26  3:45:02 12 [Note] WSREP: Applier thread exiting ret: 6 thd: 12
2019-10-26  3:45:02 17 [Warning] Aborted connection 17 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 12 [Warning] Aborted connection 12 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 11 [Warning] Aborted connection 11 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 18 [Note] WSREP: Applier thread exiting ret: 0 thd: 18
2019-10-26  3:45:02 18 [Warning] Aborted connection 18 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 1089184
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 1089158
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 1089147
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 1089124
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 1089123
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 1089046
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 1089044
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 1088855
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 1035417
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 992624
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 921557
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 917859
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 827605
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 808131
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 610602
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 517906
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 509317
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 229805
2019-10-26  3:45:02 0 [Note] WSREP: killing local connection: 110656
2019-10-26  3:45:02 2 [Note] WSREP: rollbacker thread exiting 2
2019-10-26  3:45:02 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2019-10-26  3:45:02 0 [Note] Event Scheduler: Purging the queue. 0 events
2019-10-26  3:45:03 0 [Note] InnoDB: FTS optimize thread exiting.
2019-10-26  3:45:03 0 [Note] WSREP: dtor state: CLOSED
2019-10-26  3:45:03 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0.999928, misses: 306, in use: 82, in pool: 224
2019-10-26  3:45:03 0 [Note] WSREP: mon: entered 4264997 oooe fraction 0 oool fraction 0
2019-10-26  3:45:03 0 [Note] WSREP: mon: entered 4264997 oooe fraction 0.0408781 oool fraction 0.00343236
2019-10-26  3:45:03 0 [Note] WSREP: mon: entered 4350099 oooe fraction 0 oool fraction 1.1494e-06
2019-10-26  3:45:03 0 [Note] WSREP: cert index usage at exit 91351
2019-10-26  3:45:03 0 [Note] WSREP: cert trx map usage at exit 82
2019-10-26  3:45:03 0 [Note] WSREP: deps set usage at exit 0
2019-10-26  3:45:03 0 [Note] WSREP: avg deps dist 54.9895
2019-10-26  3:45:03 0 [Note] WSREP: avg cert interval 2757.11
2019-10-26  3:45:03 0 [Note] WSREP: cert index size 91351
2019-10-26  3:45:03 0 [Note] WSREP: Service thread queue flushed.
2019-10-26  3:45:03 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
2019-10-26  3:45:03 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0.999989, misses: 16, in use: 0, in pool: 16
2019-10-26  3:45:03 0 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: -1)
2019-10-26  3:45:03 0 [Note] WSREP: Flushing memory map to disk...
2019-10-26  3:45:03 0 [Note] InnoDB: Starting shutdown...
2019-10-26  3:45:03 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2019-10-26  3:45:03 0 [Note] InnoDB: Instance 0, restricted to 16024 pages due to innodb_buf_pool_dump_pct=25
2019-10-26  3:45:03 0 [Note] InnoDB: Instance 1, restricted to 16024 pages due to innodb_buf_pool_dump_pct=25
2019-10-26  3:45:03 0 [Note] InnoDB: Instance 2, restricted to 16024 pages due to innodb_buf_pool_dump_pct=25
2019-10-26  3:45:03 0 [Note] InnoDB: Instance 3, restricted to 16024 pages due to innodb_buf_pool_dump_pct=25
2019-10-26  3:45:03 0 [Note] InnoDB: Instance 4, restricted to 16024 pages due to innodb_buf_pool_dump_pct=25
2019-10-26  3:45:03 0 [Note] InnoDB: Instance 5, restricted to 16024 pages due to innodb_buf_pool_dump_pct=25
2019-10-26  3:45:03 0 [Note] InnoDB: Instance 6, restricted to 16024 pages due to innodb_buf_pool_dump_pct=25
2019-10-26  3:45:03 0 [Note] InnoDB: Instance 7, restricted to 16024 pages due to innodb_buf_pool_dump_pct=25
2019-10-26  3:45:03 0 [Note] InnoDB: Buffer pool(s) dump completed at 191026  3:45:03
2019-10-26  3:45:06 0 [Note] InnoDB: Shutdown completed; log sequence number 5465596126104; transaction id 5763140740
2019-10-26  3:45:06 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-10-26  3:45:06 0 [Note] /usr/sbin/mysqld: Shutdown complete

2019-10-26  3:45:46 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 05f55365-1970-11e9-89d3-d7b7715e6b83:260219848
wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
wsrep loader: [INFO] wsrep_load(): Galera 26.4.2(r4498) by Codership Oy <info@codership.com> loaded successfully.
2019-10-26  3:45:46 0 [Note] WSREP: CRC-32C: using hardware acceleration.
2019-10-26  3:45:46 0 [Note] WSREP: Found saved state: 05f55365-1970-11e9-89d3-d7b7715e6b83:260219848, safe_to_bootstrap: 0
2019-10-26  3:45:46 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 2
UUID: 05f55365-1970-11e9-89d3-d7b7715e6b83
Seqno: 260067316 - 260219848
Offset: 408814240
Synced: 1
2019-10-26  3:45:46 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 05f55365-1970-11e9-89d3-d7b7715e6b83, offset: 408814240
2019-10-26  3:45:46 0 [Note] WSREP: GCache::RingBuffer initial scan...  0.0% (         0/1073741848 bytes) complete.
2019-10-26  3:45:50 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (1073741848/1073741848 bytes) complete.
2019-10-26  3:45:50 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 260067316-260219848
2019-10-26  3:45:50 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...  0.0% (         0/1027775944 bytes) complete.
2019-10-26  3:45:50 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (1027775944/1027775944 bytes) complete.
2019-10-26  3:45:50 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/152533 locked buffers
2019-10-26  3:45:50 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): used space: 1027775944/1073741824
2019-10-26  3:45:50 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.253.253.95; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; 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 = yes; gcache.size = 1G; 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;
2019-10-26  3:45:50 0 [Note] WSREP: Start replication
2019-10-26  3:45:50 0 [Note] WSREP: Connecting with bootstrap option: 0
2019-10-26  3:45:50 0 [Note] WSREP: Setting GCS initial position to 05f55365-1970-11e9-89d3-d7b7715e6b83:260219848
2019-10-26  3:45:50 0 [Note] WSREP: protonet asio version 0
2019-10-26  3:45:50 0 [Note] WSREP: Using CRC-32C for message checksums.
2019-10-26  3:45:50 0 [Note] WSREP: backend: asio
2019-10-26  3:45:50 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2019-10-26  3:45:50 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2019-10-26  3:45:50 0 [Note] WSREP: restore pc from disk failed
2019-10-26  3:45:50 0 [Note] WSREP: GMCast version 0
2019-10-26  3:45:50 0 [Note] WSREP: (5697f486, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2019-10-26  3:45:50 0 [Note] WSREP: (5697f486, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2019-10-26  3:45:50 0 [Note] WSREP: EVS version 1
2019-10-26  3:45:50 0 [Note] WSREP: gcomm: connecting to group 'mariadb_cluster', peer '10.253.253.93:,10.253.253.94:,10.253.253.95:'
2019-10-26  3:45:50 0 [Note] WSREP: (5697f486, 'tcp://0.0.0.0:4567') connection established to 5697f486 tcp://10.253.253.95:4567
2019-10-26  3:45:50 0 [Warning] WSREP: (5697f486, 'tcp://0.0.0.0:4567') address 'tcp://10.253.253.95:4567' points to own listening address, blacklisting
2019-10-26  3:45:50 0 [Note] WSREP: (5697f486, 'tcp://0.0.0.0:4567') connection established to 5902428d tcp://10.253.253.93:4567
2019-10-26  3:45:50 0 [Note] WSREP: (5697f486, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
2019-10-26  3:45:50 0 [Note] WSREP: (5697f486, 'tcp://0.0.0.0:4567') connection established to 2c9d3ddb tcp://10.253.253.94:4567
2019-10-26  3:45:50 0 [Note] WSREP: EVS version upgrade 0 -> 1
2019-10-26  3:45:50 0 [Note] WSREP: declaring 2c9d3ddb at tcp://10.253.253.94:4567 stable
2019-10-26  3:45:50 0 [Note] WSREP: declaring 5902428d at tcp://10.253.253.93:4567 stable
2019-10-26  3:45:50 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2019-10-26  3:45:50 0 [Note] WSREP: Node 2c9d3ddb state prim
2019-10-26  3:45:50 0 [Note] WSREP: view(view_id(PRIM,2c9d3ddb,160) memb {
        2c9d3ddb,0
        5697f486,0
        5902428d,0
} joined {
} left {
} partitioned {
})
2019-10-26  3:45:50 0 [Note] WSREP: save pc into disk
2019-10-26  3:45:50 0 [Note] WSREP: gcomm: connected
2019-10-26  3:45:50 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2019-10-26  3:45:50 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2019-10-26  3:45:50 0 [Note] WSREP: Opened channel 'mariadb_cluster'
2019-10-26  3:45:50 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3
2019-10-26  3:45:50 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2019-10-26  3:45:50 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 54c06856-f792-11e9-a153-46b6ece22010
2019-10-26  3:45:50 0 [Note] WSREP: STATE EXCHANGE: got state msg: 54c06856-f792-11e9-a153-46b6ece22010 from 0 (node5)
2019-10-26  3:45:50 0 [Note] WSREP: STATE EXCHANGE: got state msg: 54c06856-f792-11e9-a153-46b6ece22010 from 2 (node4)
2019-10-26  3:45:50 2 [Note] WSREP: Starting rollbacker thread 2
2019-10-26  3:45:50 0 [Note] WSREP: STATE EXCHANGE: got state msg: 54c06856-f792-11e9-a153-46b6ece22010 from 1 (node6)
2019-10-26  3:45:50 0 [Note] WSREP: Quorum results:
        version    = 5,
        component  = PRIMARY,
        conf_id    = 156,
        members    = 2/3 (joined/total),
        act_id     = 260219863,
        last_appl. = 260219766,
        protocols  = 1/10/4 (gcs/repl/appl),
        vote policy= 0,
        group UUID = 05f55365-1970-11e9-89d3-d7b7715e6b83
2019-10-26  3:45:50 0 [Note] WSREP: Writing down CC checksum: 3a30a141 54b496f5 c26f72a1 d5addb9e at offset 240
2019-10-26  3:45:50 0 [Note] WSREP: Flow-control interval: [28, 28]
2019-10-26  3:45:50 0 [Note] WSREP: Trying to continue unpaused monitor
2019-10-26  3:45:50 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 260219864)
2019-10-26  3:45:50 1 [Note] WSREP: Starting applier thread 1
2019-10-26  3:45:50 1 [Note] WSREP: ####### processing CC 260219864, local, ordered
2019-10-26  3:45:50 1 [Note] WSREP: ####### drain monitors upto -1
2019-10-26  3:45:53 0 [Note] WSREP: (5697f486, 'tcp://0.0.0.0:4567') connection to peer 5697f486 with addr tcp://10.253.253.95:4567 timed out, no messages seen in PT3S
2019-10-26  3:45:53 0 [Note] WSREP: (5697f486, 'tcp://0.0.0.0:4567') turning message relay requesting off
2019-10-26  3:46:00 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.92S), skipping check
2019-10-26  3:46:39 1 [Note] WSREP: REPL Protocols: 10 (5, 3)
2019-10-26  3:46:39 1 [Note] WSREP: ####### My UUID: 5697f486-f792-11e9-849c-6eece5376a92
2019-10-26  3:46:39 1 [Note] WSREP: Server node6 connected to cluster at position 05f55365-1970-11e9-89d3-d7b7715e6b83:260219864 with ID 5697f486-f792-11e9-849c-6eece5376a92
2019-10-26  3:46:39 1 [Note] WSREP: Server status change disconnected -> connected
2019-10-26  3:46:39 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2019-10-26  3:46:39 1 [Note] WSREP: State transfer required:
        Group state: 05f55365-1970-11e9-89d3-d7b7715e6b83:260219864
        Local state: 05f55365-1970-11e9-89d3-d7b7715e6b83:260219848
2019-10-26  3:46:39 1 [Note] WSREP: Server status change connected -> joiner
2019-10-26  3:46:39 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2019-10-26  3:46:39 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '10.253.253.95' --datadir '/var/lib/mysql/' --parent '1852' --binlog '/var/log/mysql/binlog' --binlog-index '/var/log/mysql/binlog.index' --mysqld-args --wsrep_start_position=05f55365-1970-11e9-89d3-d7b7715e6b83:260219848'
WSREP_SST: [INFO] Streaming with xbstream (20191026 03:46:41.599)
WSREP_SST: [INFO] Using socat as streamer (20191026 03:46:41.601)
WSREP_SST: [INFO] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr stdio | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20191026 03:46:41.901)
2019-10-26  3:46:43 1 [Note] WSREP: Prepared SST request: mariabackup|10.253.253.95:4444/xtrabackup_sst//1
2019-10-26  3:46:43 1 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:0 (proto: 10), state transfer needed: yes
2019-10-26  3:46:43 0 [Note] WSREP: Service thread queue flushed.
2019-10-26  3:46:43 1 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:0, protocol version: 5
2019-10-26  3:46:43 1 [Note] WSREP: ####### IST uuid:05f55365-1970-11e9-89d3-d7b7715e6b83 f: 260219849, l: 260219864, STRv: 3
2019-10-26  3:46:43 1 [Note] WSREP: IST receiver addr using tcp://10.253.253.95:4568
2019-10-26  3:46:43 1 [Note] WSREP: Prepared IST receiver for 260219849-260219864, listening at: tcp://10.253.253.95:4568
2019-10-26  3:46:43 0 [Note] WSREP: Member 1.0 (node6) requested state transfer from '*any*'. Selected 0.0 (node5)(SYNCED) as donor.
2019-10-26  3:46:43 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 260219881)
2019-10-26  3:46:43 1 [Note] WSREP: Requesting state transfer: success, donor: 0
2019-10-26  3:46:43 0 [Note] WSREP: 0.0 (node5): State transfer to 1.0 (node6) complete.
2019-10-26  3:46:43 0 [Note] WSREP: Member 0.0 (node5) synced with group.
WSREP_SST: [INFO] xtrabackup_ist received from donor: Running IST (20191026 03:46:43.950)
WSREP_SST: [INFO] Galera co-ords from recovery: 05f55365-1970-11e9-89d3-d7b7715e6b83:260219848 6 (20191026 03:46:43.954)
WSREP_SST: [INFO] Total time on joiner: 0 seconds (20191026 03:46:43.957)
WSREP_SST: [INFO] Removing the sst_in_progress file (20191026 03:46:43.960)
2019-10-26  3:46:44 3 [Note] WSREP: SST received
2019-10-26  3:46:44 3 [Note] WSREP: Server status change joiner -> initializing
2019-10-26  3:46:44 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2019-10-26  3:46:44 0 [Note] InnoDB: Using Linux native AIO
2019-10-26  3:46:44 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-26  3:46:44 0 [Note] InnoDB: Uses event mutexes
2019-10-26  3:46:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2019-10-26  3:46:44 0 [Note] InnoDB: Number of pools: 1
2019-10-26  3:46:44 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-26  3:46:44 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2019-10-26  3:46:44 0 [Note] InnoDB: Initializing buffer pool, total size = 8G, instances = 8, chunk size = 128M
2019-10-26  3:46:44 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-26  3:46:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-26  3:46:44 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 1073741824 bytes
2019-10-26  3:46:44 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 1073741824 bytes
2019-10-26  3:46:45 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2019-10-26  3:46:45 0 [Note] InnoDB: New log files created, LSN=5465596126113
2019-10-26  3:46:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-26  3:46:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-26  3:46:52 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-26  3:46:52 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-10-26  3:46:52 0 [Note] InnoDB: Waiting for purge to start
2019-10-26  3:46:52 0 [Note] InnoDB: 10.4.8 started; log sequence number 5465596126220; transaction id 5763140742
2019-10-26  3:46:52 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2019-10-26  3:46:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-26  3:46:52 0 [Note] Server socket created on IP: '::'.
2019-10-26  3:46:52 0 [Warning] 'proxies_priv' entry '@% root@svrmysql1' ignored in --skip-name-resolve mode.
2019-10-26  3:46:52 0 [Note] WSREP: wsrep_init_schema_and_SR (nil)
2019-10-26  3:46:52 0 [Note] WSREP: Server initialized
2019-10-26  3:46:52 0 [Note] WSREP: Server status change initializing -> initialized
2019-10-26  3:46:52 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2019-10-26  3:46:52 3 [Note] WSREP: Server status change initialized -> joined
2019-10-26  3:46:52 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2019-10-26  3:46:52 3 [Note] WSREP: Recovered position from storage: 05f55365-1970-11e9-89d3-d7b7715e6b83:260219848
2019-10-26  3:46:52 11 [Note] WSREP: Starting applier thread 11
2019-10-26  3:46:52 15 [Note] WSREP: Starting applier thread 15
2019-10-26  3:46:52 16 [Note] WSREP: Starting applier thread 16
2019-10-26  3:46:52 12 [Note] WSREP: Starting applier thread 12
2019-10-26  3:46:52 13 [Note] WSREP: Starting applier thread 13
2019-10-26  3:46:52 14 [Note] WSREP: Starting applier thread 14
2019-10-26  3:46:52 17 [Note] WSREP: Starting applier thread 17
2019-10-26  3:46:52 18 [Note] WSREP: Starting applier thread 18
2019-10-26  3:46:52 19 [Note] WSREP: Starting applier thread 19
2019-10-26  3:46:52 21 [Note] WSREP: Starting applier thread 21
2019-10-26  3:46:52 20 [Note] WSREP: Starting applier thread 20
2019-10-26  3:46:52 22 [Note] WSREP: Starting applier thread 22
2019-10-26  3:46:52 24 [Note] WSREP: Starting applier thread 24
2019-10-26  3:46:52 23 [Note] WSREP: Starting applier thread 23
2019-10-26  3:46:52 25 [Note] WSREP: Starting applier thread 25
2019-10-26  3:46:52 0 [Note] Reading of all Master_info entries succeeded
2019-10-26  3:46:52 0 [Note] Added new Master_info '' to hash table
2019-10-26  3:46:52 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.4.8-MariaDB-1:10.4.8+maria~stretch-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2019-10-26  3:46:52 3 [Note] WSREP: Recovered view from SST:
  id: 05f55365-1970-11e9-89d3-d7b7715e6b83:259326930
  status: primary
  protocol_version: 4
  capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
  final: no
  own_index: -1
  members(3):
        0: 2c9d3ddb-f6c9-11e9-ba33-7ff81756a2b0, node5
        1: 5902428d-f709-11e9-920b-fbb88bc5b205, node4
        2: 9c9507c2-f4a0-11e9-9787-cf7b0eff47a2, node6

2019-10-26  3:46:52 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2019-10-26  3:46:52 28 [Note] WSREP: Recovered cluster id 05f55365-1970-11e9-89d3-d7b7715e6b83
2019-10-26  3:46:52 3 [Note] WSREP: SST received: 05f55365-1970-11e9-89d3-d7b7715e6b83:260219848
2019-10-26  3:46:52 1 [Note] WSREP: Installed new state from SST: 05f55365-1970-11e9-89d3-d7b7715e6b83:260219848
2019-10-26  3:46:52 1 [Note] WSREP: Receiving IST: 16 writesets, seqnos 260219849-260219864
2019-10-26  3:46:52 0 [Note] WSREP: ####### IST applying starts with 260219849
2019-10-26  3:46:52 0 [ERROR] WSREP: got asio system error while reading IST stream: asio.misc:2
2019-10-26  3:46:52 0 [ERROR] WSREP: IST didn't contain all write sets, expected last: 260219864 last received: -1
2019-10-26  3:46:52 11 [ERROR] WSREP: Receiving IST failed, node restart required: IST receiver reported failure: 71 (Protocol error)
         at galera/src/replicator_smm.hpp:pop_front():320. Null event.
2019-10-26  3:46:53 11 [Note] WSREP: Closing send monitor...
2019-10-26  3:46:53 11 [Note] WSREP: Closed send monitor.
2019-10-26  3:46:53 11 [Note] WSREP: gcomm: terminating thread
2019-10-26  3:46:53 11 [Note] WSREP: gcomm: joining thread
2019-10-26  3:46:53 11 [Note] WSREP: gcomm: closing backend
2019-10-26  3:46:53 11 [Note] WSREP: view(view_id(NON_PRIM,2c9d3ddb,160) memb {
        5697f486,0
} joined {
} left {
} partitioned {
        2c9d3ddb,0
        5902428d,0
})
2019-10-26  3:46:53 11 [Note] WSREP: PC protocol downgrade 1 -> 0
2019-10-26  3:46:53 11 [Note] WSREP: view((empty))
2019-10-26  3:46:53 11 [Note] WSREP: gcomm: closed
2019-10-26  3:46:53 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
2019-10-26  3:46:53 0 [Note] WSREP: Writing down CC checksum: b0d33f0b e5e5981d 0844a616 8f9600fb at offset 120
2019-10-26  3:46:53 0 [Note] WSREP: Flow-control interval: [16, 16]
2019-10-26  3:46:53 0 [Note] WSREP: Trying to continue unpaused monitor
2019-10-26  3:46:53 0 [Note] WSREP: Received NON-PRIMARY.
2019-10-26  3:46:53 0 [Note] WSREP: Shifting JOINER -> OPEN (TO: 260219898)
2019-10-26  3:46:53 0 [Note] WSREP: Received self-leave message.
2019-10-26  3:46:53 0 [Note] WSREP: Writing down CC checksum: 6c22f7f6 aa7fd261 477376c8 d0651338 at offset 64
2019-10-26  3:46:53 0 [Note] WSREP: Flow-control interval: [0, 0]
2019-10-26  3:46:53 0 [Note] WSREP: Trying to continue unpaused monitor
2019-10-26  3:46:53 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2019-10-26  3:46:53 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: -1)
2019-10-26  3:46:53 0 [Note] WSREP: RECV thread exiting 0: Success
2019-10-26  3:46:53 11 [Note] WSREP: recv_thread() joined.
2019-10-26  3:46:53 11 [Note] WSREP: Closing replication queue.
2019-10-26  3:46:53 11 [Note] WSREP: Closing slave action queue.
2019-10-26  3:47:21 1 [Note] WSREP: IST received: 05f55365-1970-11e9-89d3-d7b7715e6b83:-1
2019-10-26  3:47:21 1 [Warning] WSREP: Sending JOIN failed: -103 (Software caused connection abort). Will retry in new primary component.
2019-10-26  3:47:21 1 [ERROR] WSREP: Failed to JOIN the cluster after SST
2019-10-26  3:47:21 1 [Note] WSREP: ####### processing CC -1, local, ordered
2019-10-26  3:47:21 1 [Note] WSREP: ####### drain monitors upto 0
2019-10-26  3:47:21 31 [Warning] Aborted connection 31 to db: 'information_schema' user: 'cmon' host: '10.253.253.87' (Got an error reading communication packets)
2019-10-26  3:47:47 42 [Warning] Aborted connection 42 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error writing communication packets)
2019-10-26  3:47:47 41 [Warning] Aborted connection 41 to db: 'information_schema' user: 'cmon' host: '10.253.253.87' (Got an error reading communication packets)
2019-10-26  3:48:13 1 [Note] WSREP: ####### My UUID: 5697f486-f792-11e9-849c-6eece5376a92
2019-10-26  3:48:13 1 [Note] WSREP: ####### ST not required
2019-10-26  3:48:13 51 [Warning] Aborted connection 51 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error writing communication packets)
2019-10-26  3:48:13 43 [Warning] Aborted connection 43 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error writing communication packets)
2019-10-26  3:48:13 52 [Warning] Aborted connection 52 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error writing communication packets)
2019-10-26  3:48:13 44 [Warning] Aborted connection 44 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error writing communication packets)
2019-10-26  3:48:13 53 [Warning] Aborted connection 53 to db: 'information_schema' user: 'cmon' host: '10.253.253.87' (Got an error reading communication packets)
2019-10-26  3:48:13 1 [Note] WSREP: ================================================
View:
  id: 05f55365-1970-11e9-89d3-d7b7715e6b83:-1
  status: non-primary
  protocol_version: 4
  capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
  final: no
  own_index: 0
  members(1):
        0: 5697f486-f792-11e9-849c-6eece5376a92, node6
=================================================
2019-10-26  3:48:13 46 [Warning] Aborted connection 46 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error writing communication packets)
2019-10-26  3:48:13 47 [Warning] Aborted connection 47 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error writing communication packets)
2019-10-26  3:48:13 49 [Warning] Aborted connection 49 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error writing communication packets)
2019-10-26  3:48:13 45 [Warning] Aborted connection 45 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error writing communication packets)
2019-10-26  3:48:13 48 [Warning] Aborted connection 48 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error writing communication packets)
2019-10-26  3:48:13 35 [Warning] Aborted connection 35 to db: 'information_schema' user: 'cmon' host: '10.253.253.87' (Got an error reading communication packets)
2019-10-26  3:48:13 54 [Warning] Aborted connection 54 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error writing communication packets)
2019-10-26  3:48:13 59 [Warning] Aborted connection 59 to db: 'information_schema' user: 'cmon' host: '10.253.253.87' (Got an error writing communication packets)
2019-10-26  3:48:13 57 [Warning] Aborted connection 57 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error writing communication packets)
2019-10-26  3:48:13 1 [Note] WSREP: Non-primary view
2019-10-26  3:48:13 1 [Note] WSREP: Server status change joined -> connected
2019-10-26  3:48:13 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2019-10-26  3:48:13 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2019-10-26  3:48:13 1 [Note] WSREP: ####### processing CC -1, local, ordered
2019-10-26  3:48:13 1 [Note] WSREP: ####### drain monitors upto 0
2019-10-26  3:48:46 0 [Note] InnoDB: Buffer pool(s) load completed at 191026  3:48:46
2019-10-26  3:49:06 72 [Warning] Aborted connection 72 to db: 'information_schema' user: 'cmon' host: '10.253.253.87' (Got an error reading communication packets)
2019-10-26  3:49:06 1 [Note] WSREP: ####### My UUID: 5697f486-f792-11e9-849c-6eece5376a92
2019-10-26  3:49:06 1 [Note] WSREP: ####### ST not required
2019-10-26  3:49:06 1 [Note] WSREP: ================================================
View:
  id: 05f55365-1970-11e9-89d3-d7b7715e6b83:-1
  status: non-primary
  protocol_version: 4
  capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
  final: yes
  own_index: -1
  members(0):
=================================================
2019-10-26  3:49:06 1 [Note] WSREP: Non-primary view
2019-10-26  3:49:06 1 [Note] WSREP: Server status change connected -> disconnected
2019-10-26  3:49:06 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2019-10-26  3:49:06 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.