-- Logs begin at Thu 2019-12-05 14:22:51 CST, end at Mon 2020-01-13 11:18:25 CST. -- Jan 10 12:06:21 instance-4 sh[81244]: WSREP: Recovered position 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72214825 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] /usr/sbin/mysqld (mysqld 10.4.8-MariaDB) starting as process 81342 ... Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72214825 Jan 10 12:06:21 instance-4 mysqld[81342]: wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so' Jan 10 12:06:21 instance-4 mysqld[81342]: wsrep loader: [INFO] wsrep_load(): Galera 26.4.3(r4535) by Codership Oy loaded successfully. Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: CRC-32C: using hardware acceleration. Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: Found saved state: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72214825, safe_to_bootstrap: 0 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: GCache DEBUG: opened preamble: Jan 10 12:06:21 instance-4 mysqld[81342]: Version: 2 Jan 10 12:06:21 instance-4 mysqld[81342]: UUID: 747e2df8-001d-11ea-a5d7-f2055d8c0e67 Jan 10 12:06:21 instance-4 mysqld[81342]: Seqno: 72177626 - 72214825 Jan 10 12:06:21 instance-4 mysqld[81342]: Offset: 1280 Jan 10 12:06:21 instance-4 mysqld[81342]: Synced: 1 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 747e2df8-001d-11ea-a5d7-f2055d8c0e67, offset: 1280 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete. Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete. Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 72177626-72214825 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/61780008 bytes) complete. Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (61780008/61780008 bytes) complete. Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 3/37203 locked buffers Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): used space: 61780008/134217728 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.20.1; 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 = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; 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 = 1; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: Service thread queue flushed. Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: ####### Assign initial position for certification: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72214825, protocol version: -1 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: Start replication Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: Connecting with bootstrap option: 0 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: Setting GCS initial position to 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72214825 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: protonet asio version 0 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: Using CRC-32C for message checksums. Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: backend: asio Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: restore pc from disk failed Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: GMCast version 0 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: EVS version 1 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: gcomm: connecting to group 'galera_cluster', peer '192.168.10.1:,192.168.10.2:,192.168.20.2:,192.168.30.1:' Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection established to d8484337 tcp://192.168.20.2:4567 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection established to 00d05e50 tcp://192.168.30.1:4567 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection established to d9df3ac1 tcp://192.168.10.2:4567 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection established to 256935a4 tcp://192.168.10.1:4567 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: EVS version upgrade 0 -> 1 Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: declaring 00d05e50 at tcp://192.168.30.1:4567 stable Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: declaring 256935a4 at tcp://192.168.10.1:4567 stable Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: declaring d8484337 at tcp://192.168.20.2:4567 stable Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: declaring d9df3ac1 at tcp://192.168.10.2:4567 stable Jan 10 12:06:21 instance-4 mysqld[81342]: 2020-01-10 12:06:21 0 [Note] WSREP: PC protocol upgrade 0 -> 1 Jan 10 12:06:22 instance-4 mysqld[81342]: 2020-01-10 12:06:22 0 [Note] WSREP: Node 00d05e50 state prim Jan 10 12:06:22 instance-4 mysqld[81342]: 2020-01-10 12:06:22 0 [Note] WSREP: view(view_id(PRIM,00d05e50,257) memb { Jan 10 12:06:22 instance-4 mysqld[81342]: 00d05e50,0 Jan 10 12:06:22 instance-4 mysqld[81342]: 256935a4,0 Jan 10 12:06:22 instance-4 mysqld[81342]: d8484337,1 Jan 10 12:06:22 instance-4 mysqld[81342]: d9df3ac1,0 Jan 10 12:06:22 instance-4 mysqld[81342]: e8684f23,1 Jan 10 12:06:22 instance-4 mysqld[81342]: } joined { Jan 10 12:06:22 instance-4 mysqld[81342]: } left { Jan 10 12:06:22 instance-4 mysqld[81342]: } partitioned { Jan 10 12:06:22 instance-4 mysqld[81342]: }) Jan 10 12:06:22 instance-4 mysqld[81342]: 2020-01-10 12:06:22 0 [Note] WSREP: save pc into disk Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: gcomm: connected Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: Opened channel 'galera_cluster' Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 4, memb_num = 5 Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: STATE EXCHANGE: sent state msg: e90fe12a-33d3-11ea-89e2-db5d64667273 Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: STATE EXCHANGE: got state msg: e90fe12a-33d3-11ea-89e2-db5d64667273 from 0 (instance-5) Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: STATE EXCHANGE: got state msg: e90fe12a-33d3-11ea-89e2-db5d64667273 from 1 (instance-1) Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: STATE EXCHANGE: got state msg: e90fe12a-33d3-11ea-89e2-db5d64667273 from 2 (instance-3) Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: STATE EXCHANGE: got state msg: e90fe12a-33d3-11ea-89e2-db5d64667273 from 3 (instance-2) Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 1 [Note] WSREP: Starting rollbacker thread 1 Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: Starting applier thread 2 Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: STATE EXCHANGE: got state msg: e90fe12a-33d3-11ea-89e2-db5d64667273 from 4 (instance-4) Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: Quorum results: Jan 10 12:06:23 instance-4 mysqld[81342]: version = 6, Jan 10 12:06:23 instance-4 mysqld[81342]: component = PRIMARY, Jan 10 12:06:23 instance-4 mysqld[81342]: conf_id = 234, Jan 10 12:06:23 instance-4 mysqld[81342]: members = 4/5 (joined/total), Jan 10 12:06:23 instance-4 mysqld[81342]: act_id = 72215064, Jan 10 12:06:23 instance-4 mysqld[81342]: last_appl. = 72214965, Jan 10 12:06:23 instance-4 mysqld[81342]: protocols = 2/10/4 (gcs/repl/appl), Jan 10 12:06:23 instance-4 mysqld[81342]: vote policy= 0, Jan 10 12:06:23 instance-4 mysqld[81342]: group UUID = 747e2df8-001d-11ea-a5d7-f2055d8c0e67 Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: Flow-control interval: [36, 36] Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 72215065) Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: ####### processing CC 72215065, local, ordered Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: REPL Protocols: 10 (5, 3) Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: ####### My UUID: e8684f23-33d3-11ea-8507-be386e5a2c43 Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: Server instance-4 connected to cluster at position 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72215065 with ID e8684f23-33d3-11ea-8507-be386e5a2c43 Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: Server status change disconnected -> connected Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: State transfer required: Jan 10 12:06:23 instance-4 mysqld[81342]: Group state: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72215065 Jan 10 12:06:23 instance-4 mysqld[81342]: Local state: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72214825 Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: Server status change connected -> joiner Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '192.168.20.1' --datadir '/var/lib/mysql/' --parent '81342' --mysqld-args --wsrep_start_position=747e2df8-001d-11ea-a5d7-f2055d8c0e67:72214825' Jan 10 12:06:23 instance-4 rsyncd[81401]: rsyncd version 3.1.2 starting, listening on port 4444 Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: Prepared SST request: rsync|192.168.20.1:4444/rsync_sst Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: Service thread queue flushed. Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: 5 Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: ####### IST uuid:747e2df8-001d-11ea-a5d7-f2055d8c0e67 f: 72214826, l: 72215065, STRv: 3 Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: IST receiver addr using tcp://192.168.20.1:4568 Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: Prepared IST receiver for 72214826-72215065, listening at: tcp://192.168.20.1:4568 Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: Member 4.1 (instance-4) requested state transfer from '*any*'. Selected 2.1 (instance-3)(SYNCED) as donor. Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 72215105) Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 2 [Note] WSREP: Requesting state transfer: success, donor: 2 Jan 10 12:06:23 instance-4 rsyncd[81422]: connect from instance-3.us.bank-dns.com (192.168.20.2) Jan 10 12:06:23 instance-4 rsyncd[81422]: rsync to rsync_sst/ from instance-3.us.bank-dns.com (192.168.20.2) Jan 10 12:06:23 instance-4 rsyncd[81422]: receiving file list Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: 2.1 (instance-3): State transfer to 4.1 (instance-4) complete. Jan 10 12:06:23 instance-4 mysqld[81342]: 2020-01-10 12:06:23 0 [Note] WSREP: Member 2.1 (instance-3) synced with group. Jan 10 12:06:24 instance-4 mysqld[81342]: WSREP_SST: [INFO] Joiner cleanup. rsync PID: 81401 (20200110 12:06:24.511) Jan 10 12:06:25 instance-4 mysqld[81342]: WSREP_SST: [INFO] Joiner cleanup done. (20200110 12:06:25.020) Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 3 [Note] WSREP: SST received Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 3 [Note] WSREP: Server status change joiner -> initializing Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: Using Linux native AIO Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: Uses event mutexes Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: Number of pools: 1 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: Using SSE2 crc32 instructions Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: Completed initialization of buffer pool Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: 10.4.8 started; log sequence number 82782755260; transaction id 148817534 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] Plugin 'FEEDBACK' is disabled. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] Server socket created on IP: '0.0.0.0'. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Server initialized Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Server status change initializing -> initialized Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 3 [Note] WSREP: Server status change initialized -> joined Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 3 [Note] WSREP: Recovered position from storage: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72214825 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] Reading of all Master_info entries succeeded Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] Added new Master_info '' to hash table Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] /usr/sbin/mysqld: ready for connections. Jan 10 12:06:25 instance-4 mysqld[81342]: Version: '10.4.8-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 3 [Note] WSREP: Recovered view from SST: Jan 10 12:06:25 instance-4 mysqld[81342]: id: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72213611 Jan 10 12:06:25 instance-4 mysqld[81342]: status: primary Jan 10 12:06:25 instance-4 mysqld[81342]: protocol_version: 4 Jan 10 12:06:25 instance-4 mysqld[81342]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Jan 10 12:06:25 instance-4 mysqld[81342]: final: no Jan 10 12:06:25 instance-4 mysqld[81342]: own_index: -1 Jan 10 12:06:25 instance-4 mysqld[81342]: members(5): Jan 10 12:06:25 instance-4 mysqld[81342]: 0: 00d05e50-190f-11ea-a6b5-b3cd598e7997, instance-5 Jan 10 12:06:25 instance-4 mysqld[81342]: 1: 256935a4-0dd1-11ea-b711-26dc927a2be3, instance-1 Jan 10 12:06:25 instance-4 mysqld[81342]: 2: b58614f1-33d1-11ea-8ae0-dbb397996484, instance-4 Jan 10 12:06:25 instance-4 mysqld[81342]: 3: d8484337-33d3-11ea-bceb-02c7e8cff150, instance-3 Jan 10 12:06:25 instance-4 mysqld[81342]: 4: d9df3ac1-0e99-11ea-b568-af27cd3fd4c7, instance-2 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 12 [Note] WSREP: Recovered cluster id 747e2df8-001d-11ea-a5d7-f2055d8c0e67 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 3 [Note] WSREP: SST received: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72214825 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 2 [Note] WSREP: Installed new state from SST: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72214825 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 2 [Note] WSREP: Receiving IST: 240 writesets, seqnos 72214826-72215065 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: ####### IST applying starts with 72214826 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: ####### IST current seqno initialized to 72214826 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Receiving IST... 0.0% ( 0/240 events) complete. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: REPL Protocols: 10 (5, 3) Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Service thread queue flushed. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: ####### Assign initial position for certification: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72214825, protocol version: 5 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: ####### processing CC 72214826, from IST, ordered Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: REPL Protocols: 10 (5, 3) Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: ####### ST not required Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Skipping cert index reset Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: ####### Adjusting cert position: 72214825 -> 72214826 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Service thread queue flushed. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: ####### Setting monitor position to 72214826 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Lowest cert indnex boundary for CC from group: 72214826 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Min available from gcache for CC from group: 72177626 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 2 [Note] WSREP: ================================================ Jan 10 12:06:25 instance-4 mysqld[81342]: View: Jan 10 12:06:25 instance-4 mysqld[81342]: id: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72214826 Jan 10 12:06:25 instance-4 mysqld[81342]: status: primary Jan 10 12:06:25 instance-4 mysqld[81342]: protocol_version: 4 Jan 10 12:06:25 instance-4 mysqld[81342]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Jan 10 12:06:25 instance-4 mysqld[81342]: final: no Jan 10 12:06:25 instance-4 mysqld[81342]: own_index: -1 Jan 10 12:06:25 instance-4 mysqld[81342]: members(4): Jan 10 12:06:25 instance-4 mysqld[81342]: 0: 00d05e50-190f-11ea-a6b5-b3cd598e7997, instance-5 Jan 10 12:06:25 instance-4 mysqld[81342]: 1: 256935a4-0dd1-11ea-b711-26dc927a2be3, instance-1 Jan 10 12:06:25 instance-4 mysqld[81342]: 2: d8484337-33d3-11ea-bceb-02c7e8cff150, instance-3 Jan 10 12:06:25 instance-4 mysqld[81342]: 3: d9df3ac1-0e99-11ea-b568-af27cd3fd4c7, instance-2 Jan 10 12:06:25 instance-4 mysqld[81342]: ================================================= Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: IST preload starting at 72214966 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: ####### processing CC 72215065, from IST, ordered Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] InnoDB: Buffer pool(s) load completed at 200110 12:06:25 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: REPL Protocols: 10 (5, 3) Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: ####### ST not required Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Skipping cert index reset Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: ####### Adjusting cert position: 72215064 -> 72215065 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Service thread queue flushed. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: ####### Setting monitor position to 72215065 Jan 10 12:06:25 instance-4 systemd[1]: Started MariaDB 10.4.8 database server. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Lowest cert indnex boundary for CC from group: 72214966 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Min available from gcache for CC from group: 72177626 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Receiving IST...100.0% (240/240 events) complete. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 2 [Note] WSREP: ================================================ Jan 10 12:06:25 instance-4 mysqld[81342]: View: Jan 10 12:06:25 instance-4 mysqld[81342]: id: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72215065 Jan 10 12:06:25 instance-4 mysqld[81342]: status: primary Jan 10 12:06:25 instance-4 mysqld[81342]: protocol_version: 4 Jan 10 12:06:25 instance-4 mysqld[81342]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Jan 10 12:06:25 instance-4 mysqld[81342]: final: no Jan 10 12:06:25 instance-4 mysqld[81342]: own_index: 4 Jan 10 12:06:25 instance-4 mysqld[81342]: members(5): Jan 10 12:06:25 instance-4 mysqld[81342]: 0: 00d05e50-190f-11ea-a6b5-b3cd598e7997, instance-5 Jan 10 12:06:25 instance-4 mysqld[81342]: 1: 256935a4-0dd1-11ea-b711-26dc927a2be3, instance-1 Jan 10 12:06:25 instance-4 mysqld[81342]: 2: d8484337-33d3-11ea-bceb-02c7e8cff150, instance-3 Jan 10 12:06:25 instance-4 mysqld[81342]: 3: d9df3ac1-0e99-11ea-b568-af27cd3fd4c7, instance-2 Jan 10 12:06:25 instance-4 mysqld[81342]: 4: e8684f23-33d3-11ea-8507-be386e5a2c43, instance-4 Jan 10 12:06:25 instance-4 mysqld[81342]: ================================================= Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 2 [Note] WSREP: IST received: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72215065 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 2 [Note] WSREP: Lowest cert indnex boundary for CC from group: 72214966 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 2 [Note] WSREP: Min available from gcache for CC from group: 72177626 Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: 4.1 (instance-4): State transfer from 2.1 (instance-3) complete. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 72215210) Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Member 4.1 (instance-4) synced with group. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 72215211) Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 2 [Note] WSREP: Server instance-4 synced with group Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 2 [Note] WSREP: Server status change joined -> synced Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 2 [Note] WSREP: Synchronized with group, ready for connections Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:06:25 instance-4 mysqld[81342]: 2020-01-10 12:06:25 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') turning message relay requesting off Jan 10 12:09:02 instance-4 mysqld[81342]: 2020-01-10 12:09:02 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection to peer 256935a4 with addr tcp://192.168.10.1:4567 timed out, no messages seen in PT3S Jan 10 12:09:02 instance-4 mysqld[81342]: 2020-01-10 12:09:02 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://192.168.10.1:4567 Jan 10 12:09:04 instance-4 mysqld[81342]: 2020-01-10 12:09:04 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') reconnecting to 256935a4 (tcp://192.168.10.1:4567), attempt 0 Jan 10 12:09:04 instance-4 mysqld[81342]: 2020-01-10 12:09:04 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection to peer d9df3ac1 with addr tcp://192.168.10.2:4567 timed out, no messages seen in PT3S Jan 10 12:09:04 instance-4 mysqld[81342]: 2020-01-10 12:09:04 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection to peer d8484337 with addr tcp://192.168.20.2:4567 timed out, no messages seen in PT3S Jan 10 12:09:04 instance-4 mysqld[81342]: 2020-01-10 12:09:04 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection to peer 00d05e50 with addr tcp://192.168.30.1:4567 timed out, no messages seen in PT3S Jan 10 12:09:05 instance-4 mysqld[81342]: 2020-01-10 12:09:05 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') reconnecting to d9df3ac1 (tcp://192.168.10.2:4567), attempt 0 Jan 10 12:09:06 instance-4 mysqld[81342]: 2020-01-10 12:09:06 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') reconnecting to d8484337 (tcp://192.168.20.2:4567), attempt 0 Jan 10 12:09:06 instance-4 mysqld[81342]: 2020-01-10 12:09:06 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') reconnecting to 00d05e50 (tcp://192.168.30.1:4567), attempt 0 Jan 10 12:09:06 instance-4 mysqld[81342]: 2020-01-10 12:09:06 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,257)) suspecting node: 00d05e50 Jan 10 12:09:06 instance-4 mysqld[81342]: 2020-01-10 12:09:06 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,257)) suspected node without join message, declaring inactive Jan 10 12:09:06 instance-4 mysqld[81342]: 2020-01-10 12:09:06 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,257)) suspecting node: 256935a4 Jan 10 12:09:06 instance-4 mysqld[81342]: 2020-01-10 12:09:06 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,257)) suspected node without join message, declaring inactive Jan 10 12:09:06 instance-4 mysqld[81342]: 2020-01-10 12:09:06 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,257)) suspecting node: d8484337 Jan 10 12:09:06 instance-4 mysqld[81342]: 2020-01-10 12:09:06 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,257)) suspected node without join message, declaring inactive Jan 10 12:09:06 instance-4 mysqld[81342]: 2020-01-10 12:09:06 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,257)) suspecting node: d9df3ac1 Jan 10 12:09:06 instance-4 mysqld[81342]: 2020-01-10 12:09:06 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,257)) suspected node without join message, declaring inactive Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 0 [Note] WSREP: view(view_id(NON_PRIM,00d05e50,257) memb { Jan 10 12:09:07 instance-4 mysqld[81342]: e8684f23,1 Jan 10 12:09:07 instance-4 mysqld[81342]: } joined { Jan 10 12:09:07 instance-4 mysqld[81342]: } left { Jan 10 12:09:07 instance-4 mysqld[81342]: } partitioned { Jan 10 12:09:07 instance-4 mysqld[81342]: 00d05e50,0 Jan 10 12:09:07 instance-4 mysqld[81342]: 256935a4,0 Jan 10 12:09:07 instance-4 mysqld[81342]: d8484337,1 Jan 10 12:09:07 instance-4 mysqld[81342]: d9df3ac1,0 Jan 10 12:09:07 instance-4 mysqld[81342]: }) Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 0 [Note] WSREP: view(view_id(NON_PRIM,e8684f23,258) memb { Jan 10 12:09:07 instance-4 mysqld[81342]: e8684f23,1 Jan 10 12:09:07 instance-4 mysqld[81342]: } joined { Jan 10 12:09:07 instance-4 mysqld[81342]: } left { Jan 10 12:09:07 instance-4 mysqld[81342]: } partitioned { Jan 10 12:09:07 instance-4 mysqld[81342]: 00d05e50,0 Jan 10 12:09:07 instance-4 mysqld[81342]: 256935a4,0 Jan 10 12:09:07 instance-4 mysqld[81342]: d8484337,1 Jan 10 12:09:07 instance-4 mysqld[81342]: d9df3ac1,0 Jan 10 12:09:07 instance-4 mysqld[81342]: }) Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 0 [Note] WSREP: Flow-control interval: [16, 16] Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 0 [Note] WSREP: Received NON-PRIMARY. Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 72224061) Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 0 [Note] WSREP: Flow-control interval: [16, 16] Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 0 [Note] WSREP: Received NON-PRIMARY. Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: ####### processing CC -1, local, ordered Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: ####### My UUID: e8684f23-33d3-11ea-8507-be386e5a2c43 Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: ####### ST not required Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: ================================================ Jan 10 12:09:07 instance-4 mysqld[81342]: View: Jan 10 12:09:07 instance-4 mysqld[81342]: id: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:-1 Jan 10 12:09:07 instance-4 mysqld[81342]: status: non-primary Jan 10 12:09:07 instance-4 mysqld[81342]: protocol_version: 4 Jan 10 12:09:07 instance-4 mysqld[81342]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Jan 10 12:09:07 instance-4 mysqld[81342]: final: no Jan 10 12:09:07 instance-4 mysqld[81342]: own_index: 0 Jan 10 12:09:07 instance-4 mysqld[81342]: members(1): Jan 10 12:09:07 instance-4 mysqld[81342]: 0: e8684f23-33d3-11ea-8507-be386e5a2c43, instance-4 Jan 10 12:09:07 instance-4 mysqld[81342]: ================================================= Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: Non-primary view Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: Server status change synced -> connected Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: ####### processing CC -1, local, ordered Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: ####### My UUID: e8684f23-33d3-11ea-8507-be386e5a2c43 Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: ####### ST not required Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: ================================================ Jan 10 12:09:07 instance-4 mysqld[81342]: View: Jan 10 12:09:07 instance-4 mysqld[81342]: id: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:-1 Jan 10 12:09:07 instance-4 mysqld[81342]: status: non-primary Jan 10 12:09:07 instance-4 mysqld[81342]: protocol_version: 4 Jan 10 12:09:07 instance-4 mysqld[81342]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Jan 10 12:09:07 instance-4 mysqld[81342]: final: no Jan 10 12:09:07 instance-4 mysqld[81342]: own_index: 0 Jan 10 12:09:07 instance-4 mysqld[81342]: members(1): Jan 10 12:09:07 instance-4 mysqld[81342]: 0: e8684f23-33d3-11ea-8507-be386e5a2c43, instance-4 Jan 10 12:09:07 instance-4 mysqld[81342]: ================================================= Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: Non-primary view Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: Server status change connected -> connected Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:09:07 instance-4 mysqld[81342]: 2020-01-10 12:09:07 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection established to d9df3ac1 tcp://192.168.10.2:4567 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection established to d8484337 tcp://192.168.20.2:4567 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection established to 00d05e50 tcp://192.168.30.1:4567 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: declaring 00d05e50 at tcp://192.168.30.1:4567 stable Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: declaring 256935a4 at tcp://192.168.10.1:4567 stable Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: declaring d8484337 at tcp://192.168.20.2:4567 stable Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: declaring d9df3ac1 at tcp://192.168.10.2:4567 stable Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection established to 256935a4 tcp://192.168.10.1:4567 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Node 00d05e50 state prim Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: view(view_id(PRIM,00d05e50,259) memb { Jan 10 12:10:08 instance-4 mysqld[81342]: 00d05e50,0 Jan 10 12:10:08 instance-4 mysqld[81342]: 256935a4,0 Jan 10 12:10:08 instance-4 mysqld[81342]: d8484337,1 Jan 10 12:10:08 instance-4 mysqld[81342]: d9df3ac1,0 Jan 10 12:10:08 instance-4 mysqld[81342]: e8684f23,1 Jan 10 12:10:08 instance-4 mysqld[81342]: } joined { Jan 10 12:10:08 instance-4 mysqld[81342]: } left { Jan 10 12:10:08 instance-4 mysqld[81342]: } partitioned { Jan 10 12:10:08 instance-4 mysqld[81342]: }) Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: save pc into disk Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 4, memb_num = 5 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 6f7f3cb1-33d4-11ea-86a7-a32ed42bedcb Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: STATE EXCHANGE: got state msg: 6f7f3cb1-33d4-11ea-86a7-a32ed42bedcb from 0 (instance-5) Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: STATE EXCHANGE: got state msg: 6f7f3cb1-33d4-11ea-86a7-a32ed42bedcb from 1 (instance-1) Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: STATE EXCHANGE: got state msg: 6f7f3cb1-33d4-11ea-86a7-a32ed42bedcb from 2 (instance-3) Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: STATE EXCHANGE: got state msg: 6f7f3cb1-33d4-11ea-86a7-a32ed42bedcb from 3 (instance-2) Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: STATE EXCHANGE: got state msg: 6f7f3cb1-33d4-11ea-86a7-a32ed42bedcb from 4 (instance-4) Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Quorum results: Jan 10 12:10:08 instance-4 mysqld[81342]: version = 6, Jan 10 12:10:08 instance-4 mysqld[81342]: component = PRIMARY, Jan 10 12:10:08 instance-4 mysqld[81342]: conf_id = 236, Jan 10 12:10:08 instance-4 mysqld[81342]: members = 4/5 (joined/total), Jan 10 12:10:08 instance-4 mysqld[81342]: act_id = 72227710, Jan 10 12:10:08 instance-4 mysqld[81342]: last_appl. = 72223952, Jan 10 12:10:08 instance-4 mysqld[81342]: protocols = 2/10/4 (gcs/repl/appl), Jan 10 12:10:08 instance-4 mysqld[81342]: vote policy= 0, Jan 10 12:10:08 instance-4 mysqld[81342]: group UUID = 747e2df8-001d-11ea-a5d7-f2055d8c0e67 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Flow-control interval: [36, 36] Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 72227711) Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: ####### processing CC 72227711, local, ordered Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: REPL Protocols: 10 (5, 3) Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: ####### My UUID: e8684f23-33d3-11ea-8507-be386e5a2c43 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: State transfer required: Jan 10 12:10:08 instance-4 mysqld[81342]: Group state: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72227711 Jan 10 12:10:08 instance-4 mysqld[81342]: Local state: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72224061 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: Server status change connected -> joiner Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: You have configured 'rsync' state snapshot transfer method which cannot be performed on a running server. Wsrep provider won't be able to fall back to it if other means of state transfer are unavailable. In that case you will need to restart the server. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Service thread queue flushed. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: 5 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: ####### IST uuid:747e2df8-001d-11ea-a5d7-f2055d8c0e67 f: 72224062, l: 72227711, STRv: 3 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: IST receiver addr using tcp://192.168.20.1:4568 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: Prepared IST receiver for 72224062-72227711, listening at: tcp://192.168.20.1:4568 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Member 4.1 (instance-4) requested state transfer from '*any*'. Selected 2.1 (instance-3)(SYNCED) as donor. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 72227712) Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: Requesting state transfer: success, donor: 2 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: Receiving IST: 3650 writesets, seqnos 72224062-72227711 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: ####### IST applying starts with 72224062 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: ####### IST current seqno initialized to 72223953 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Receiving IST... 0.0% ( 0/3759 events) complete. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: IST preload starting at 72223953 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Service thread queue flushed. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:72223952, protocol version: 5 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: ####### processing CC 72224119, from IST, ordered Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: REPL Protocols: 10 (5, 3) Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: ####### ST not required Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Skipping cert index reset Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: ####### Adjusting cert position: 72224118 -> 72224119 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Service thread queue flushed. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: ####### Setting monitor position to 72224119 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Lowest cert indnex boundary for CC from group: 72223953 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Min available from gcache for CC from group: 72177626 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: ================================================ Jan 10 12:10:08 instance-4 mysqld[81342]: View: Jan 10 12:10:08 instance-4 mysqld[81342]: id: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72224119 Jan 10 12:10:08 instance-4 mysqld[81342]: status: primary Jan 10 12:10:08 instance-4 mysqld[81342]: protocol_version: 4 Jan 10 12:10:08 instance-4 mysqld[81342]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Jan 10 12:10:08 instance-4 mysqld[81342]: final: no Jan 10 12:10:08 instance-4 mysqld[81342]: own_index: -1 Jan 10 12:10:08 instance-4 mysqld[81342]: members(4): Jan 10 12:10:08 instance-4 mysqld[81342]: 0: 00d05e50-190f-11ea-a6b5-b3cd598e7997, instance-5 Jan 10 12:10:08 instance-4 mysqld[81342]: 1: 256935a4-0dd1-11ea-b711-26dc927a2be3, instance-1 Jan 10 12:10:08 instance-4 mysqld[81342]: 2: d8484337-33d3-11ea-bceb-02c7e8cff150, instance-3 Jan 10 12:10:08 instance-4 mysqld[81342]: 3: d9df3ac1-0e99-11ea-b568-af27cd3fd4c7, instance-2 Jan 10 12:10:08 instance-4 mysqld[81342]: ================================================= Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: Server status change joiner -> joined Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: 2.1 (instance-3): State transfer to 4.1 (instance-4) complete. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Member 2.1 (instance-3) synced with group. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: ####### processing CC 72227711, from IST, ordered Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: REPL Protocols: 10 (5, 3) Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: ####### ST not required Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Skipping cert index reset Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: ####### Adjusting cert position: 72227710 -> 72227711 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Service thread queue flushed. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: ####### Setting monitor position to 72227711 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Lowest cert indnex boundary for CC from group: 72223953 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Min available from gcache for CC from group: 72177626 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Receiving IST...100.0% (3759/3759 events) complete. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: ================================================ Jan 10 12:10:08 instance-4 mysqld[81342]: View: Jan 10 12:10:08 instance-4 mysqld[81342]: id: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72227711 Jan 10 12:10:08 instance-4 mysqld[81342]: status: primary Jan 10 12:10:08 instance-4 mysqld[81342]: protocol_version: 4 Jan 10 12:10:08 instance-4 mysqld[81342]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Jan 10 12:10:08 instance-4 mysqld[81342]: final: no Jan 10 12:10:08 instance-4 mysqld[81342]: own_index: 4 Jan 10 12:10:08 instance-4 mysqld[81342]: members(5): Jan 10 12:10:08 instance-4 mysqld[81342]: 0: 00d05e50-190f-11ea-a6b5-b3cd598e7997, instance-5 Jan 10 12:10:08 instance-4 mysqld[81342]: 1: 256935a4-0dd1-11ea-b711-26dc927a2be3, instance-1 Jan 10 12:10:08 instance-4 mysqld[81342]: 2: d8484337-33d3-11ea-bceb-02c7e8cff150, instance-3 Jan 10 12:10:08 instance-4 mysqld[81342]: 3: d9df3ac1-0e99-11ea-b568-af27cd3fd4c7, instance-2 Jan 10 12:10:08 instance-4 mysqld[81342]: 4: e8684f23-33d3-11ea-8507-be386e5a2c43, instance-4 Jan 10 12:10:08 instance-4 mysqld[81342]: ================================================= Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: IST received: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72227711 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: Lowest cert indnex boundary for CC from group: 72223953 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: Min available from gcache for CC from group: 72177626 Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: 4.1 (instance-4): State transfer from 2.1 (instance-3) complete. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 72227731) Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Member 4.1 (instance-4) synced with group. Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 72227732) Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: Server instance-4 synced with group Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: Server status change joined -> synced Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: Synchronized with group, ready for connections Jan 10 12:10:08 instance-4 mysqld[81342]: 2020-01-10 12:10:08 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:10:11 instance-4 mysqld[81342]: 2020-01-10 12:10:11 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') turning message relay requesting off Jan 10 12:11:09 instance-4 mysqld[81342]: 2020-01-10 12:11:09 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection to peer 256935a4 with addr tcp://192.168.10.1:4567 timed out, no messages seen in PT3S Jan 10 12:11:09 instance-4 mysqld[81342]: 2020-01-10 12:11:09 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection to peer d9df3ac1 with addr tcp://192.168.10.2:4567 timed out, no messages seen in PT3S Jan 10 12:11:09 instance-4 mysqld[81342]: 2020-01-10 12:11:09 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection to peer 00d05e50 with addr tcp://192.168.30.1:4567 timed out, no messages seen in PT3S Jan 10 12:11:09 instance-4 mysqld[81342]: 2020-01-10 12:11:09 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection to peer d8484337 with addr tcp://192.168.20.2:4567 timed out, no messages seen in PT3S Jan 10 12:11:09 instance-4 mysqld[81342]: 2020-01-10 12:11:09 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://192.168.10.1:4567 tcp://192.168.10.2:4567 tcp://192.168.20.2:4567 tcp://192.168.30.1:4567 Jan 10 12:11:10 instance-4 mysqld[81342]: 2020-01-10 12:11:10 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') reconnecting to 256935a4 (tcp://192.168.10.1:4567), attempt 0 Jan 10 12:11:11 instance-4 mysqld[81342]: 2020-01-10 12:11:11 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') reconnecting to d9df3ac1 (tcp://192.168.10.2:4567), attempt 0 Jan 10 12:11:11 instance-4 mysqld[81342]: 2020-01-10 12:11:11 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') reconnecting to d8484337 (tcp://192.168.20.2:4567), attempt 0 Jan 10 12:11:11 instance-4 mysqld[81342]: 2020-01-10 12:11:11 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') reconnecting to 00d05e50 (tcp://192.168.30.1:4567), attempt 0 Jan 10 12:11:11 instance-4 mysqld[81342]: 2020-01-10 12:11:11 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,259)) suspecting node: 00d05e50 Jan 10 12:11:11 instance-4 mysqld[81342]: 2020-01-10 12:11:11 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,259)) suspected node without join message, declaring inactive Jan 10 12:11:11 instance-4 mysqld[81342]: 2020-01-10 12:11:11 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,259)) suspecting node: 256935a4 Jan 10 12:11:11 instance-4 mysqld[81342]: 2020-01-10 12:11:11 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,259)) suspected node without join message, declaring inactive Jan 10 12:11:11 instance-4 mysqld[81342]: 2020-01-10 12:11:11 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,259)) suspecting node: d8484337 Jan 10 12:11:11 instance-4 mysqld[81342]: 2020-01-10 12:11:11 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,259)) suspected node without join message, declaring inactive Jan 10 12:11:11 instance-4 mysqld[81342]: 2020-01-10 12:11:11 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,259)) suspecting node: d9df3ac1 Jan 10 12:11:11 instance-4 mysqld[81342]: 2020-01-10 12:11:11 0 [Note] WSREP: evs::proto(e8684f23, OPERATIONAL, view_id(REG,00d05e50,259)) suspected node without join message, declaring inactive Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 0 [Note] WSREP: view(view_id(NON_PRIM,00d05e50,259) memb { Jan 10 12:11:12 instance-4 mysqld[81342]: e8684f23,1 Jan 10 12:11:12 instance-4 mysqld[81342]: } joined { Jan 10 12:11:12 instance-4 mysqld[81342]: } left { Jan 10 12:11:12 instance-4 mysqld[81342]: } partitioned { Jan 10 12:11:12 instance-4 mysqld[81342]: 00d05e50,0 Jan 10 12:11:12 instance-4 mysqld[81342]: 256935a4,0 Jan 10 12:11:12 instance-4 mysqld[81342]: d8484337,1 Jan 10 12:11:12 instance-4 mysqld[81342]: d9df3ac1,0 Jan 10 12:11:12 instance-4 mysqld[81342]: }) Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 0 [Note] WSREP: view(view_id(NON_PRIM,e8684f23,260) memb { Jan 10 12:11:12 instance-4 mysqld[81342]: e8684f23,1 Jan 10 12:11:12 instance-4 mysqld[81342]: } joined { Jan 10 12:11:12 instance-4 mysqld[81342]: } left { Jan 10 12:11:12 instance-4 mysqld[81342]: } partitioned { Jan 10 12:11:12 instance-4 mysqld[81342]: 00d05e50,0 Jan 10 12:11:12 instance-4 mysqld[81342]: 256935a4,0 Jan 10 12:11:12 instance-4 mysqld[81342]: d8484337,1 Jan 10 12:11:12 instance-4 mysqld[81342]: d9df3ac1,0 Jan 10 12:11:12 instance-4 mysqld[81342]: }) Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 0 [Note] WSREP: Flow-control interval: [16, 16] Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 0 [Note] WSREP: Received NON-PRIMARY. Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 72231062) Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 0 [Note] WSREP: Flow-control interval: [16, 16] Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 0 [Note] WSREP: Received NON-PRIMARY. Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: ####### processing CC -1, local, ordered Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: ####### My UUID: e8684f23-33d3-11ea-8507-be386e5a2c43 Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: ####### ST not required Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: ================================================ Jan 10 12:11:12 instance-4 mysqld[81342]: View: Jan 10 12:11:12 instance-4 mysqld[81342]: id: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:-1 Jan 10 12:11:12 instance-4 mysqld[81342]: status: non-primary Jan 10 12:11:12 instance-4 mysqld[81342]: protocol_version: 4 Jan 10 12:11:12 instance-4 mysqld[81342]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Jan 10 12:11:12 instance-4 mysqld[81342]: final: no Jan 10 12:11:12 instance-4 mysqld[81342]: own_index: 0 Jan 10 12:11:12 instance-4 mysqld[81342]: members(1): Jan 10 12:11:12 instance-4 mysqld[81342]: 0: e8684f23-33d3-11ea-8507-be386e5a2c43, instance-4 Jan 10 12:11:12 instance-4 mysqld[81342]: ================================================= Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: Non-primary view Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: Server status change synced -> connected Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: ####### processing CC -1, local, ordered Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: ####### My UUID: e8684f23-33d3-11ea-8507-be386e5a2c43 Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: ####### ST not required Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: ================================================ Jan 10 12:11:12 instance-4 mysqld[81342]: View: Jan 10 12:11:12 instance-4 mysqld[81342]: id: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:-1 Jan 10 12:11:12 instance-4 mysqld[81342]: status: non-primary Jan 10 12:11:12 instance-4 mysqld[81342]: protocol_version: 4 Jan 10 12:11:12 instance-4 mysqld[81342]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Jan 10 12:11:12 instance-4 mysqld[81342]: final: no Jan 10 12:11:12 instance-4 mysqld[81342]: own_index: 0 Jan 10 12:11:12 instance-4 mysqld[81342]: members(1): Jan 10 12:11:12 instance-4 mysqld[81342]: 0: e8684f23-33d3-11ea-8507-be386e5a2c43, instance-4 Jan 10 12:11:12 instance-4 mysqld[81342]: ================================================= Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: Non-primary view Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: Server status change connected -> connected Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:11:12 instance-4 mysqld[81342]: 2020-01-10 12:11:12 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:12:25 instance-4 mysqld[81342]: 2020-01-10 12:12:25 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') reconnecting to 256935a4 (tcp://192.168.10.1:4567), attempt 30 Jan 10 12:12:26 instance-4 mysqld[81342]: 2020-01-10 12:12:26 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') reconnecting to d9df3ac1 (tcp://192.168.10.2:4567), attempt 30 Jan 10 12:12:26 instance-4 mysqld[81342]: 2020-01-10 12:12:26 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') reconnecting to d8484337 (tcp://192.168.20.2:4567), attempt 30 Jan 10 12:12:26 instance-4 mysqld[81342]: 2020-01-10 12:12:26 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') reconnecting to 00d05e50 (tcp://192.168.30.1:4567), attempt 30 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection established to d8484337 tcp://192.168.20.2:4567 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection established to 00d05e50 tcp://192.168.30.1:4567 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection established to d9df3ac1 tcp://192.168.10.2:4567 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: declaring 00d05e50 at tcp://192.168.30.1:4567 stable Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: declaring 256935a4 at tcp://192.168.10.1:4567 stable Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: declaring d8484337 at tcp://192.168.20.2:4567 stable Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: declaring d9df3ac1 at tcp://192.168.10.2:4567 stable Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: Node 00d05e50 state prim Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: view(view_id(PRIM,00d05e50,261) memb { Jan 10 12:13:11 instance-4 mysqld[81342]: 00d05e50,0 Jan 10 12:13:11 instance-4 mysqld[81342]: 256935a4,0 Jan 10 12:13:11 instance-4 mysqld[81342]: d8484337,1 Jan 10 12:13:11 instance-4 mysqld[81342]: d9df3ac1,0 Jan 10 12:13:11 instance-4 mysqld[81342]: e8684f23,1 Jan 10 12:13:11 instance-4 mysqld[81342]: } joined { Jan 10 12:13:11 instance-4 mysqld[81342]: } left { Jan 10 12:13:11 instance-4 mysqld[81342]: } partitioned { Jan 10 12:13:11 instance-4 mysqld[81342]: }) Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: save pc into disk Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 4, memb_num = 5 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: STATE EXCHANGE: sent state msg: dc912c69-33d4-11ea-a462-de0276be5559 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: STATE EXCHANGE: got state msg: dc912c69-33d4-11ea-a462-de0276be5559 from 2 (instance-3) Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: STATE EXCHANGE: got state msg: dc912c69-33d4-11ea-a462-de0276be5559 from 3 (instance-2) Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: STATE EXCHANGE: got state msg: dc912c69-33d4-11ea-a462-de0276be5559 from 4 (instance-4) Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: STATE EXCHANGE: got state msg: dc912c69-33d4-11ea-a462-de0276be5559 from 0 (instance-5) Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: STATE EXCHANGE: got state msg: dc912c69-33d4-11ea-a462-de0276be5559 from 1 (instance-1) Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: Quorum results: Jan 10 12:13:11 instance-4 mysqld[81342]: version = 6, Jan 10 12:13:11 instance-4 mysqld[81342]: component = PRIMARY, Jan 10 12:13:11 instance-4 mysqld[81342]: conf_id = 238, Jan 10 12:13:11 instance-4 mysqld[81342]: members = 4/5 (joined/total), Jan 10 12:13:11 instance-4 mysqld[81342]: act_id = 72237959, Jan 10 12:13:11 instance-4 mysqld[81342]: last_appl. = 72237833, Jan 10 12:13:11 instance-4 mysqld[81342]: protocols = 2/10/4 (gcs/repl/appl), Jan 10 12:13:11 instance-4 mysqld[81342]: vote policy= 0, Jan 10 12:13:11 instance-4 mysqld[81342]: group UUID = 747e2df8-001d-11ea-a5d7-f2055d8c0e67 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: Flow-control interval: [36, 36] Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 72237960) Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 2 [Note] WSREP: ####### processing CC 72237960, local, ordered Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 2 [Note] WSREP: REPL Protocols: 10 (5, 3) Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 2 [Note] WSREP: ####### My UUID: e8684f23-33d3-11ea-8507-be386e5a2c43 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 2 [Note] WSREP: State transfer required: Jan 10 12:13:11 instance-4 mysqld[81342]: Group state: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72237960 Jan 10 12:13:11 instance-4 mysqld[81342]: Local state: 747e2df8-001d-11ea-a5d7-f2055d8c0e67:72231062 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 2 [Note] WSREP: Server status change connected -> joiner Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 2 [Note] WSREP: You have configured 'rsync' state snapshot transfer method which cannot be performed on a running server. Wsrep provider won't be able to fall back to it if other means of state transfer are unavailable. In that case you will need to restart the server. Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: Service thread queue flushed. Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: 5 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 2 [Note] WSREP: ####### IST uuid:747e2df8-001d-11ea-a5d7-f2055d8c0e67 f: 72231063, l: 72237960, STRv: 3 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 2 [Note] WSREP: IST receiver addr using tcp://192.168.20.1:4568 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 2 [Note] WSREP: Prepared IST receiver for 72231063-72237960, listening at: tcp://192.168.20.1:4568 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection established to 256935a4 tcp://192.168.10.1:4567 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: Member 4.1 (instance-4) requested state transfer from '*any*'. Selected 2.1 (instance-3)(SYNCED) as donor. Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 72237961) Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 2 [Note] WSREP: Requesting state transfer: success, donor: 2 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 2 [Note] WSREP: Receiving IST: 6898 writesets, seqnos 72231063-72237960 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: ####### IST applying starts with 72231063 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: ####### IST current seqno initialized to 72231063 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: Receiving IST... 0.0% ( 0/6898 events) complete. Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: Service thread queue flushed. Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:72231062, protocol version: 5 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: ####### processing CC 72231129, from IST, ordered Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: REPL Protocols: 10 (5, 3) Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: ####### ST not required Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: Skipping cert index reset Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: ####### Adjusting cert position: 72231062 -> 72231129 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: Service thread queue flushed. Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: ####### Setting monitor position to 72231129 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: Lowest cert indnex boundary for CC from group: 72231129 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: Min available from gcache for CC from group: 72177626 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: 2.1 (instance-3): State transfer to 4.1 (instance-4) complete. Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: Member 2.1 (instance-3) synced with group. Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: IST preload starting at 72237834 Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: ####### processing CC 72237960, from IST, ordered Jan 10 12:13:11 instance-4 mysqld[81342]: 2020-01-10 12:13:11 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') connection established to 256935a4 tcp://192.168.10.1:4567 Jan 10 12:13:15 instance-4 mysqld[81342]: 2020-01-10 12:13:15 0 [Note] WSREP: (e8684f23, 'tcp://0.0.0.0:4567') turning message relay requesting off Jan 10 12:14:00 instance-4 systemd[1]: Stopping MariaDB 10.4.8 database server... Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: Shutdown replication Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: Server status change joiner -> disconnecting Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: Closing send monitor... Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: Closed send monitor. Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: gcomm: terminating thread Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: gcomm: joining thread Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: gcomm: closing backend Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: view(view_id(NON_PRIM,00d05e50,261) memb { Jan 10 12:14:00 instance-4 mysqld[81342]: e8684f23,1 Jan 10 12:14:00 instance-4 mysqld[81342]: } joined { Jan 10 12:14:00 instance-4 mysqld[81342]: } left { Jan 10 12:14:00 instance-4 mysqld[81342]: } partitioned { Jan 10 12:14:00 instance-4 mysqld[81342]: 00d05e50,0 Jan 10 12:14:00 instance-4 mysqld[81342]: 256935a4,0 Jan 10 12:14:00 instance-4 mysqld[81342]: d8484337,1 Jan 10 12:14:00 instance-4 mysqld[81342]: d9df3ac1,0 Jan 10 12:14:00 instance-4 mysqld[81342]: }) Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: PC protocol downgrade 1 -> 0 Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: view((empty)) Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: gcomm: closed Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: Flow-control interval: [16, 16] Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: Received NON-PRIMARY. Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: Shifting JOINER -> OPEN (TO: 72240790) Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: New SELF-LEAVE. Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: Flow-control interval: [0, 0] Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: -1) Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: RECV thread exiting 0: Success Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: recv_thread() joined. Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: Closing replication queue. Jan 10 12:14:00 instance-4 mysqld[81342]: 2020-01-10 12:14:00 0 [Note] WSREP: Closing slave action queue.