2020-08-18 16:11:45 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2020-08-18 16:11:45 0 [Note] WSREP: Shutdown replication 2020-08-18 16:11:45 0 [Note] WSREP: Server status change synced -> disconnecting 2020-08-18 16:11:45 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-08-18 16:11:45 0 [Note] WSREP: Closing send monitor... 2020-08-18 16:11:45 0 [Note] WSREP: Closed send monitor. 2020-08-18 16:11:45 0 [Note] WSREP: gcomm: terminating thread 2020-08-18 16:11:45 0 [Note] WSREP: gcomm: joining thread 2020-08-18 16:11:45 0 [Note] WSREP: gcomm: closing backend 2020-08-18 16:11:45 0 [Note] WSREP: view(view_id(NON_PRIM,7600bd31-bcc2,3) memb { 7600bd31-bcc2,0 } joined { } left { } partitioned { e846d3e9-9479,0 f5f42bf4-ad6d,0 }) 2020-08-18 16:11:45 0 [Note] WSREP: PC protocol downgrade 1 -> 0 2020-08-18 16:11:45 0 [Note] WSREP: view((empty)) 2020-08-18 16:11:45 0 [Note] WSREP: gcomm: closed 2020-08-18 16:11:45 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2020-08-18 16:11:45 0 [Note] WSREP: Flow-control interval: [320, 400] 2020-08-18 16:11:45 0 [Note] WSREP: Received NON-PRIMARY. 2020-08-18 16:11:45 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 3533859514) 2020-08-18 16:11:45 0 [Note] WSREP: New SELF-LEAVE. 2020-08-18 16:11:45 18 [Note] WSREP: ================================================ View: id: 394d272d-aad7-11e7-9e76-4ade72d47c25:-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: 7600bd31-dbe1-11ea-bcc2-d787ea0772fd, thor03 ================================================= 2020-08-18 16:11:45 18 [Note] WSREP: Non-primary view 2020-08-18 16:11:45 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-08-18 16:11:45 0 [Note] WSREP: Flow-control interval: [0, 0] 2020-08-18 16:11:45 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2020-08-18 16:11:45 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: -1) 2020-08-18 16:11:45 0 [Note] WSREP: RECV thread exiting 0: Success 2020-08-18 16:11:45 0 [Note] WSREP: recv_thread() joined. 2020-08-18 16:11:45 0 [Note] WSREP: Closing replication queue. 2020-08-18 16:11:45 0 [Note] WSREP: Closing slave action queue. 2020-08-18 16:11:45 18 [Note] WSREP: ================================================ View: id: 394d272d-aad7-11e7-9e76-4ade72d47c25:-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): ================================================= 2020-08-18 16:11:45 18 [Note] WSREP: Non-primary view 2020-08-18 16:11:45 18 [Note] WSREP: Server status change disconnecting -> disconnected 2020-08-18 16:11:45 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-08-18 16:11:45 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-08-18 16:11:45 18 [Note] WSREP: Applier thread exiting ret: 0 thd: 18 2020-08-18 16:11:45 0 [Note] WSREP: killing local connection: 1695181 2020-08-18 16:11:45 51 [Note] WSREP: Applier thread exiting ret: 6 thd: 51 2020-08-18 16:11:45 19 [Note] WSREP: Applier thread exiting ret: 6 thd: 19 2020-08-18 16:11:45 11 [Note] WSREP: Applier thread exiting ret: 6 thd: 11 2020-08-18 16:11:45 47 [Note] WSREP: Applier thread exiting ret: 6 thd: 47 2020-08-18 16:11:45 82 [Note] WSREP: Applier thread exiting ret: 6 thd: 82 2020-08-18 16:11:45 54 [Note] WSREP: Applier thread exiting ret: 6 thd: 54 2020-08-18 16:11:45 40 [Note] WSREP: Applier thread exiting ret: 6 thd: 40 2020-08-18 16:11:45 74 [Note] WSREP: Applier thread exiting ret: 6 thd: 74 2020-08-18 16:11:45 75 [Note] WSREP: Applier thread exiting ret: 6 thd: 75 2020-08-18 16:11:45 48 [Note] WSREP: Applier thread exiting ret: 6 thd: 48 2020-08-18 16:11:45 22 [Note] WSREP: Applier thread exiting ret: 6 thd: 22 2020-08-18 16:11:45 16 [Note] WSREP: Applier thread exiting ret: 6 thd: 16 2020-08-18 16:11:45 25 [Note] WSREP: Applier thread exiting ret: 6 thd: 25 2020-08-18 16:11:45 43 [Note] WSREP: Applier thread exiting ret: 6 thd: 43 2020-08-18 16:11:45 46 [Note] WSREP: Applier thread exiting ret: 6 thd: 46 2020-08-18 16:11:45 26 [Note] WSREP: Applier thread exiting ret: 6 thd: 26 2020-08-18 16:11:45 79 [Note] WSREP: Applier thread exiting ret: 6 thd: 79 2020-08-18 16:11:45 44 [Note] WSREP: Applier thread exiting ret: 6 thd: 44 2020-08-18 16:11:45 62 [Note] WSREP: Applier thread exiting ret: 6 thd: 62 2020-08-18 16:11:45 59 [Note] WSREP: Applier thread exiting ret: 6 thd: 59 2020-08-18 16:11:45 36 [Note] WSREP: Applier thread exiting ret: 6 thd: 36 2020-08-18 16:11:45 78 [Note] WSREP: Applier thread exiting ret: 6 thd: 78 2020-08-18 16:11:45 85 [Note] WSREP: Applier thread exiting ret: 6 thd: 85 2020-08-18 16:11:45 88 [Note] WSREP: Applier thread exiting ret: 6 thd: 88 2020-08-18 16:11:45 45 [Note] WSREP: Applier thread exiting ret: 6 thd: 45 2020-08-18 16:11:45 34 [Note] WSREP: Applier thread exiting ret: 6 thd: 34 2020-08-18 16:11:45 35 [Note] WSREP: Applier thread exiting ret: 6 thd: 35 2020-08-18 16:11:45 87 [Note] WSREP: Applier thread exiting ret: 6 thd: 87 2020-08-18 16:11:45 64 [Note] WSREP: Applier thread exiting ret: 6 thd: 64 2020-08-18 16:11:45 49 [Note] WSREP: Applier thread exiting ret: 6 thd: 49 2020-08-18 16:11:45 10 [Note] WSREP: Applier thread exiting ret: 6 thd: 10 2020-08-18 16:11:45 14 [Note] WSREP: Applier thread exiting ret: 6 thd: 14 2020-08-18 16:11:45 23 [Note] WSREP: Applier thread exiting ret: 6 thd: 23 2020-08-18 16:11:45 77 [Note] WSREP: Applier thread exiting ret: 6 thd: 77 2020-08-18 16:11:45 13 [Note] WSREP: Applier thread exiting ret: 6 thd: 13 2020-08-18 16:11:45 58 [Note] WSREP: Applier thread exiting ret: 6 thd: 58 2020-08-18 16:11:45 86 [Note] WSREP: Applier thread exiting ret: 6 thd: 86 2020-08-18 16:11:45 31 [Note] WSREP: Applier thread exiting ret: 6 thd: 31 2020-08-18 16:11:45 68 [Note] WSREP: Applier thread exiting ret: 6 thd: 68 2020-08-18 16:11:45 60 [Note] WSREP: Applier thread exiting ret: 6 thd: 60 2020-08-18 16:11:45 83 [Note] WSREP: Applier thread exiting ret: 6 thd: 83 2020-08-18 16:11:45 38 [Note] WSREP: Applier thread exiting ret: 6 thd: 38 2020-08-18 16:11:45 72 [Note] WSREP: Applier thread exiting ret: 6 thd: 72 2020-08-18 16:11:45 20 [Note] WSREP: Applier thread exiting ret: 6 thd: 20 2020-08-18 16:11:45 70 [Note] WSREP: Applier thread exiting ret: 6 thd: 70 2020-08-18 16:11:45 53 [Note] WSREP: Applier thread exiting ret: 6 thd: 53 2020-08-18 16:11:45 30 [Note] WSREP: Applier thread exiting ret: 6 thd: 30 2020-08-18 16:11:45 27 [Note] WSREP: Applier thread exiting ret: 6 thd: 27 2020-08-18 16:11:45 69 [Note] WSREP: Applier thread exiting ret: 6 thd: 69 2020-08-18 16:11:45 37 [Note] WSREP: Applier thread exiting ret: 6 thd: 37 2020-08-18 16:11:45 17 [Note] WSREP: Applier thread exiting ret: 6 thd: 17 2020-08-18 16:11:45 24 [Note] WSREP: Applier thread exiting ret: 6 thd: 24 2020-08-18 16:11:45 67 [Note] WSREP: Applier thread exiting ret: 6 thd: 67 2020-08-18 16:11:45 42 [Note] WSREP: Applier thread exiting ret: 6 thd: 42 2020-08-18 16:11:45 33 [Note] WSREP: Applier thread exiting ret: 6 thd: 33 2020-08-18 16:11:45 56 [Note] WSREP: Applier thread exiting ret: 6 thd: 56 2020-08-18 16:11:45 15 [Note] WSREP: Applier thread exiting ret: 6 thd: 15 2020-08-18 16:11:45 66 [Note] WSREP: Applier thread exiting ret: 6 thd: 66 2020-08-18 16:11:45 29 [Note] WSREP: Applier thread exiting ret: 6 thd: 29 2020-08-18 16:11:45 80 [Note] WSREP: Applier thread exiting ret: 6 thd: 80 2020-08-18 16:11:45 63 [Note] WSREP: Applier thread exiting ret: 6 thd: 63 2020-08-18 16:11:45 76 [Note] WSREP: Applier thread exiting ret: 6 thd: 76 2020-08-18 16:11:45 57 [Note] WSREP: Applier thread exiting ret: 6 thd: 57 2020-08-18 16:11:45 84 [Note] WSREP: Applier thread exiting ret: 6 thd: 84 2020-08-18 16:11:45 65 [Note] WSREP: Applier thread exiting ret: 6 thd: 65 2020-08-18 16:11:45 52 [Note] WSREP: Applier thread exiting ret: 6 thd: 52 2020-08-18 16:11:45 2 [Note] WSREP: Applier thread exiting ret: 6 thd: 2 2020-08-18 16:11:45 21 [Note] WSREP: Applier thread exiting ret: 6 thd: 21 2020-08-18 16:11:45 81 [Note] WSREP: Applier thread exiting ret: 6 thd: 81 2020-08-18 16:11:45 12 [Note] WSREP: Applier thread exiting ret: 6 thd: 12 2020-08-18 16:11:45 55 [Note] WSREP: Applier thread exiting ret: 6 thd: 55 2020-08-18 16:11:45 73 [Note] WSREP: Applier thread exiting ret: 6 thd: 73 2020-08-18 16:11:45 28 [Note] WSREP: Applier thread exiting ret: 6 thd: 28 2020-08-18 16:11:45 32 [Note] WSREP: Applier thread exiting ret: 6 thd: 32 2020-08-18 16:11:45 71 [Note] WSREP: Applier thread exiting ret: 6 thd: 71 2020-08-18 16:11:45 41 [Note] WSREP: Applier thread exiting ret: 6 thd: 41 2020-08-18 16:11:45 39 [Note] WSREP: Applier thread exiting ret: 6 thd: 39 2020-08-18 16:11:45 61 [Note] WSREP: Applier thread exiting ret: 6 thd: 61 2020-08-18 16:11:45 50 [Note] WSREP: Applier thread exiting ret: 6 thd: 50 ## mysqld is still running at this point, logins fail. ## This was the subsequent restart...D 2020-08-18 16:26:28 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 394d272d-aad7-11e7-9e76-4ade72d47c25:3533928176 2020-08-18 16:26:28 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so' 2020-08-18 16:26:28 0 [Note] WSREP: wsrep_load(): Galera 26.4.4(r4599) by Codership Oy loaded successfully. 2020-08-18 16:26:28 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2020-08-18 16:26:28 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 0 2020-08-18 16:26:28 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: 394d272d-aad7-11e7-9e76-4ade72d47c25 Seqno: 3533905503 - 3533905503 Offset: 23926504 Synced: 1 2020-08-18 16:26:28 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 394d272d-aad7-11e7-9e76-4ade72d47c25, offset: 23926504 2020-08-18 16:26:28 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete. 2020-08-18 16:26:28 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete. 2020-08-18 16:26:28 0 [Note] WSREP: Recovering GCache ring buffer: didn't recover any events. 2020-08-18 16:26:28 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.124.3; 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 = 0.8; gcs.fc_limit = 400; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum 2020-08-18 16:26:28 0 [Note] WSREP: Start replication 2020-08-18 16:26:28 0 [Note] WSREP: Connecting with bootstrap option: 0 2020-08-18 16:26:28 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1 2020-08-18 16:26:28 0 [Note] WSREP: protonet asio version 0 2020-08-18 16:26:28 0 [Note] WSREP: Using CRC-32C for message checksums. 2020-08-18 16:26:28 0 [Note] WSREP: backend: asio 2020-08-18 16:26:28 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2020-08-18 16:26:28 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) 2020-08-18 16:26:28 0 [Note] WSREP: restore pc from disk failed 2020-08-18 16:26:28 0 [Note] WSREP: GMCast version 0 2020-08-18 16:26:28 0 [Note] WSREP: (18571e20-88f1, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2020-08-18 16:26:28 0 [Note] WSREP: (18571e20-88f1, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2020-08-18 16:26:28 0 [Note] WSREP: EVS version 1 2020-08-18 16:26:28 0 [Note] WSREP: gcomm: connecting to group 'thor', peer '192.168.124.1:,192.168.124.2:,192.168.124.3:' 2020-08-18 16:26:28 0 [Note] WSREP: (18571e20-88f1, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://192.168.124.3:4567 2020-08-18 16:26:28 0 [Note] WSREP: (18571e20-88f1, 'tcp://0.0.0.0:4567') connection established to f5f42bf4-ad6d tcp://192.168.124.2:4567 2020-08-18 16:26:28 0 [Note] WSREP: (18571e20-88f1, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2020-08-18 16:26:28 0 [Note] WSREP: (18571e20-88f1, 'tcp://0.0.0.0:4567') connection established to e846d3e9-9479 tcp://192.168.124.1:4567 2020-08-18 16:26:28 0 [Note] WSREP: EVS version upgrade 0 -> 1 2020-08-18 16:26:28 0 [Note] WSREP: declaring e846d3e9-9479 at tcp://192.168.124.1:4567 stable 2020-08-18 16:26:28 0 [Note] WSREP: declaring f5f42bf4-ad6d at tcp://192.168.124.2:4567 stable 2020-08-18 16:26:28 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2020-08-18 16:26:28 0 [Note] WSREP: Node e846d3e9-9479 state prim 2020-08-18 16:26:28 0 [Note] WSREP: view(view_id(PRIM,18571e20-88f1,9) memb { 18571e20-88f1,0 e846d3e9-9479,0 f5f42bf4-ad6d,0 } joined { } left { } partitioned { }) 2020-08-18 16:26:28 0 [Note] WSREP: save pc into disk 2020-08-18 16:26:28 0 [Note] WSREP: gcomm: connected 2020-08-18 16:26:28 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2020-08-18 16:26:28 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2020-08-18 16:26:28 0 [Note] WSREP: Opened channel 'thor' 2020-08-18 16:26:28 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3 2020-08-18 16:26:28 1 [Note] WSREP: Starting rollbacker thread 1 2020-08-18 16:26:28 2 [Note] WSREP: Starting applier thread 2 2020-08-18 16:26:28 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 18a3a35f-e191-11ea-b165-a72e1d0f1014 2020-08-18 16:26:28 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 18a3a35f-e191-11ea-b165-a72e1d0f1014 2020-08-18 16:26:28 0 [Note] WSREP: STATE EXCHANGE: got state msg: 18a3a35f-e191-11ea-b165-a72e1d0f1014 from 0 (thor03) 2020-08-18 16:26:28 0 [Note] WSREP: STATE EXCHANGE: got state msg: 18a3a35f-e191-11ea-b165-a72e1d0f1014 from 1 (thor01) 2020-08-18 16:26:28 0 [Note] WSREP: STATE EXCHANGE: got state msg: 18a3a35f-e191-11ea-b165-a72e1d0f1014 from 2 (thor02) 2020-08-18 16:26:28 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 8, members = 2/3 (joined/total), act_id = 3533941313, last_appl. = 3533941196, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 394d272d-aad7-11e7-9e76-4ade72d47c25 2020-08-18 16:26:28 0 [Note] WSREP: Flow-control interval: [554, 693] 2020-08-18 16:26:28 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3533941314) 2020-08-18 16:26:28 2 [Note] WSREP: ####### processing CC 3533941314, local, ordered 2020-08-18 16:26:28 2 [Note] WSREP: Process first view: 394d272d-aad7-11e7-9e76-4ade72d47c25 my uuid: 18571e20-e191-11ea-88f1-da9badb26465 2020-08-18 16:26:28 2 [Note] WSREP: Server thor03 connected to cluster at position 394d272d-aad7-11e7-9e76-4ade72d47c25:3533941314 with ID 18571e20-e191-11ea-88f1-da9badb26465 2020-08-18 16:26:28 2 [Note] WSREP: Server status change disconnected -> connected 2020-08-18 16:26:28 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-08-18 16:26:28 2 [Note] WSREP: ####### My UUID: 18571e20-e191-11ea-88f1-da9badb26465 2020-08-18 16:26:28 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes 2020-08-18 16:26:28 0 [Note] WSREP: Service thread queue flushed. 2020-08-18 16:26:28 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2020-08-18 16:26:28 2 [Note] WSREP: State transfer required: Group state: 394d272d-aad7-11e7-9e76-4ade72d47c25:3533941314 Local state: 00000000-0000-0000-0000-000000000000:-1 2020-08-18 16:26:28 2 [Note] WSREP: Server status change connected -> joiner 2020-08-18 16:26:28 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-08-18 16:26:28 0 [Note] WSREP: Joiner monitor thread started to monitor 2020-08-18 16:26:28 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '192.168.124.3' --datadir '/var/lib/mysql/' --parent '284403' --mysqld-args --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --wsrep_on=on --wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so --log-error=/var/lib/mysql/mysql-error.log --open-files-limit=10240 --pid-file=/var/lib/mysql/mysql.pid --wsrep_start_position=394d272d-aad7-11e7-9e76-4ade72d47c25:3533928176' 2020-08-18 16:26:28 2 [Note] WSREP: Prepared SST request: rsync|192.168.124.3:4444/rsync_sst 2020-08-18 16:26:28 2 [Note] WSREP: ####### IST uuid:00000000-0000-0000-0000-000000000000 f: 0, l: 3533941314, STRv: 3 2020-08-18 16:26:28 2 [Note] WSREP: IST receiver addr using tcp://192.168.124.3:4568 2020-08-18 16:26:28 2 [Note] WSREP: Prepared IST receiver for 0-3533941314, listening at: tcp://192.168.124.3:4568 2020-08-18 16:26:28 0 [Note] WSREP: Member 0.0 (thor03) requested state transfer from 'thor01,'. Selected 1.0 (thor01)(SYNCED) as donor. 2020-08-18 16:26:28 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 3533941348) 2020-08-18 16:26:28 2 [Note] WSREP: Requesting state transfer: success, donor: 1 2020-08-18 16:26:28 2 [Note] WSREP: Resetting GCache seqno map due to different histories. 2020-08-18 16:26:28 2 [Note] WSREP: GCache history reset: 394d272d-aad7-11e7-9e76-4ade72d47c25:0 -> 394d272d-aad7-11e7-9e76-4ade72d47c25:3533941314 2020-08-18 16:26:31 0 [Note] WSREP: (18571e20-88f1, 'tcp://0.0.0.0:4567') turning message relay requesting off 2020-08-18 16:29:36 0 [Note] WSREP: 1.0 (thor01): State transfer to 0.0 (thor03) complete. 2020-08-18 16:29:36 0 [Note] WSREP: Member 1.0 (thor01) synced with group. WSREP_SST: [INFO] Joiner cleanup. rsync PID: 284517 (20200818 16:29:37.015) WSREP_SST: [INFO] Joiner cleanup done. (20200818 16:29:37.519) 2020-08-18 16:29:37 3 [Note] WSREP: SST received 2020-08-18 16:29:37 3 [Note] WSREP: Server status change joiner -> initializing 2020-08-18 16:29:37 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-08-18 16:29:37 0 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2020-08-18 16:29:37 0 [Note] InnoDB: Using Linux native AIO 2020-08-18 16:29:37 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-08-18 16:29:37 0 [Note] InnoDB: Uses event mutexes 2020-08-18 16:29:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2020-08-18 16:29:37 0 [Note] InnoDB: Number of pools: 1 2020-08-18 16:29:37 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-08-18 16:29:37 0 [Note] InnoDB: Initializing buffer pool, total size = 10G, instances = 10, chunk size = 128M 2020-08-18 16:29:37 0 [Note] InnoDB: Completed initialization of buffer pool 2020-08-18 16:29:38 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-08-18 16:29:38 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=72281115980458 2020-08-18 16:29:38 0 [Note] InnoDB: 9 transaction(s) which must be rolled back or cleaned up in total 9 row operations to undo 2020-08-18 16:29:38 0 [Note] InnoDB: Trx id counter is 14701119100 2020-08-18 16:29:38 0 [Note] InnoDB: Starting final batch to recover 1352 pages from redo log. 2020-08-18 16:29:41 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-08-18 16:29:41 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2020-08-18 16:29:41 0 [Note] InnoDB: Rolled back recovered transaction 14701118759 2020-08-18 16:29:41 0 [Note] InnoDB: Rolled back recovered transaction 14701103254 2020-08-18 16:29:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-08-18 16:29:41 0 [Note] InnoDB: Rolled back recovered transaction 14701118755 2020-08-18 16:29:41 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-08-18 16:29:41 0 [Note] InnoDB: Rolled back recovered transaction 14701118758 2020-08-18 16:29:41 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-08-18 16:29:41 0 [Note] InnoDB: Rolled back recovered transaction 14701116167 2020-08-18 16:29:41 0 [Note] InnoDB: Rolled back recovered transaction 14701118756 2020-08-18 16:29:41 0 [Note] InnoDB: Rolled back recovered transaction 14701106975 2020-08-18 16:29:41 0 [Note] InnoDB: Rolled back recovered transaction 14701118757 2020-08-18 16:29:41 0 [Note] InnoDB: Rolled back recovered transaction 14701095461 2020-08-18 16:29:41 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2020-08-18 16:29:41 0 [Note] InnoDB: Waiting for purge to start 2020-08-18 16:29:41 0 [Note] InnoDB: 10.4.14 started; log sequence number 72281117039540; transaction id 14701119111 2020-08-18 16:29:41 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/ib_buffer_pool 2020-08-18 16:29:41 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-08-18 16:29:41 0 [Note] Server socket created on IP: '::'. 2020-08-18 16:29:41 0 [Note] Server socket created on IP: '::'. 2020-08-18 16:29:41 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2020-08-18 16:29:41 0 [Note] WSREP: Server initialized 2020-08-18 16:29:41 0 [Note] WSREP: Server status change initializing -> initialized 2020-08-18 16:29:41 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-08-18 16:29:41 3 [Note] WSREP: Server status change initialized -> joined 2020-08-18 16:29:41 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-08-18 16:29:41 3 [Note] WSREP: Recovered position from storage: 394d272d-aad7-11e7-9e76-4ade72d47c25:3533941348 2020-08-18 16:29:41 24 [Note] WSREP: Starting applier thread 24 2020-08-18 16:29:41 65 [Note] WSREP: Starting applier thread 65 2020-08-18 16:29:41 72 [Note] WSREP: Starting applier thread 72 2020-08-18 16:29:41 76 [Note] WSREP: Starting applier thread 76 2020-08-18 16:29:41 82 [Note] WSREP: Starting applier thread 82 2020-08-18 16:29:41 86 [Note] WSREP: Starting applier thread 86 2020-08-18 16:29:41 23 [Note] WSREP: Starting applier thread 23 2020-08-18 16:29:41 14 [Note] WSREP: Starting applier thread 14 2020-08-18 16:29:41 40 [Note] WSREP: Starting applier thread 40 2020-08-18 16:29:41 26 [Note] WSREP: Starting applier thread 26 2020-08-18 16:29:41 73 [Note] WSREP: Starting applier thread 73 2020-08-18 16:29:41 27 [Note] WSREP: Starting applier thread 27 2020-08-18 16:29:41 79 [Note] WSREP: Starting applier thread 79 2020-08-18 16:29:41 46 [Note] WSREP: Starting applier thread 46 2020-08-18 16:29:41 20 [Note] WSREP: Starting applier thread 20 2020-08-18 16:29:41 31 [Note] WSREP: Starting applier thread 31 2020-08-18 16:29:41 19 [Note] WSREP: Starting applier thread 19 2020-08-18 16:29:41 15 [Note] WSREP: Starting applier thread 15 2020-08-18 16:29:41 61 [Note] WSREP: Starting applier thread 61 2020-08-18 16:29:41 52 [Note] WSREP: Starting applier thread 52 2020-08-18 16:29:41 21 [Note] WSREP: Starting applier thread 21 2020-08-18 16:29:41 33 [Note] WSREP: Starting applier thread 33 2020-08-18 16:29:41 34 [Note] WSREP: Starting applier thread 34 2020-08-18 16:29:41 53 [Note] WSREP: Starting applier thread 53 2020-08-18 16:29:41 36 [Note] WSREP: Starting applier thread 36 2020-08-18 16:29:41 49 [Note] WSREP: Starting applier thread 49 2020-08-18 16:29:41 16 [Note] WSREP: Starting applier thread 16 2020-08-18 16:29:41 59 [Note] WSREP: Starting applier thread 59 2020-08-18 16:29:41 13 [Note] WSREP: Starting applier thread 13 2020-08-18 16:29:41 62 [Note] WSREP: Starting applier thread 62 2020-08-18 16:29:41 57 [Note] WSREP: Starting applier thread 57 2020-08-18 16:29:41 64 [Note] WSREP: Starting applier thread 64 2020-08-18 16:29:41 30 [Note] WSREP: Starting applier thread 30 2020-08-18 16:29:41 60 [Note] WSREP: Starting applier thread 60 2020-08-18 16:29:41 35 [Note] WSREP: Starting applier thread 35 2020-08-18 16:29:41 66 [Note] WSREP: Starting applier thread 66 2020-08-18 16:29:41 63 [Note] WSREP: Starting applier thread 63 2020-08-18 16:29:41 37 [Note] WSREP: Starting applier thread 37 2020-08-18 16:29:41 51 [Note] WSREP: Starting applier thread 51 2020-08-18 16:29:41 67 [Note] WSREP: Starting applier thread 67 2020-08-18 16:29:41 39 [Note] WSREP: Starting applier thread 39 2020-08-18 16:29:41 38 [Note] WSREP: Starting applier thread 38 2020-08-18 16:29:41 69 [Note] WSREP: Starting applier thread 69 2020-08-18 16:29:41 68 [Note] WSREP: Starting applier thread 68 2020-08-18 16:29:41 50 [Note] WSREP: Starting applier thread 50 2020-08-18 16:29:41 54 [Note] WSREP: Starting applier thread 54 2020-08-18 16:29:41 25 [Note] WSREP: Starting applier thread 25 2020-08-18 16:29:41 89 [Note] WSREP: Starting applier thread 89 2020-08-18 16:29:41 70 [Note] WSREP: Starting applier thread 70 2020-08-18 16:29:41 22 [Note] WSREP: Starting applier thread 22 2020-08-18 16:29:41 17 [Note] WSREP: Starting applier thread 17 2020-08-18 16:29:41 56 [Note] WSREP: Starting applier thread 56 2020-08-18 16:29:41 71 [Note] WSREP: Starting applier thread 71 2020-08-18 16:29:41 41 [Note] WSREP: Starting applier thread 41 2020-08-18 16:29:41 42 [Note] WSREP: Starting applier thread 42 2020-08-18 16:29:41 32 [Note] WSREP: Starting applier thread 32 2020-08-18 16:29:41 74 [Note] WSREP: Starting applier thread 74 2020-08-18 16:29:41 75 [Note] WSREP: Starting applier thread 75 2020-08-18 16:29:41 18 [Note] WSREP: Starting applier thread 18 2020-08-18 16:29:41 87 [Note] WSREP: Starting applier thread 87 2020-08-18 16:29:41 43 [Note] WSREP: Starting applier thread 43 2020-08-18 16:29:41 44 [Note] WSREP: Starting applier thread 44 2020-08-18 16:29:41 77 [Note] WSREP: Starting applier thread 77 2020-08-18 16:29:41 78 [Note] WSREP: Starting applier thread 78 2020-08-18 16:29:41 28 [Note] WSREP: Starting applier thread 28 2020-08-18 16:29:41 12 [Note] WSREP: Starting applier thread 12 2020-08-18 16:29:41 10 [Note] WSREP: Starting applier thread 10 2020-08-18 16:29:41 55 [Note] WSREP: Starting applier thread 55 2020-08-18 16:29:41 81 [Note] WSREP: Starting applier thread 81 2020-08-18 16:29:41 80 [Note] WSREP: Starting applier thread 80 2020-08-18 16:29:41 48 [Note] WSREP: Starting applier thread 48 2020-08-18 16:29:41 45 [Note] WSREP: Starting applier thread 45 2020-08-18 16:29:41 47 [Note] WSREP: Starting applier thread 47 2020-08-18 16:29:41 11 [Note] WSREP: Starting applier thread 11 2020-08-18 16:29:41 83 [Note] WSREP: Starting applier thread 83 2020-08-18 16:29:41 84 [Note] WSREP: Starting applier thread 84 2020-08-18 16:29:41 29 [Note] WSREP: Starting applier thread 29 2020-08-18 16:29:41 58 [Note] WSREP: Starting applier thread 58 2020-08-18 16:29:41 85 [Note] WSREP: Starting applier thread 85 2020-08-18 16:29:41 0 [Note] Reading of all Master_info entries succeeded 2020-08-18 16:29:41 0 [Note] Added new Master_info '' to hash table 2020-08-18 16:29:41 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.4.14-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2020-08-18 16:29:41 3 [Note] WSREP: Recovered view from SST: id: 394d272d-aad7-11e7-9e76-4ade72d47c25:3533941314 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: 0 members(3): 0: 18571e20-e191-11ea-88f1-da9badb26465, thor03 1: e846d3e9-dbe0-11ea-9479-4ee31b8158f4, thor01 2: f5f42bf4-dbe0-11ea-ad6d-b62d280fd19e, thor02 2020-08-18 16:29:41 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-08-18 16:29:41 91 [Note] WSREP: Recovered cluster id 394d272d-aad7-11e7-9e76-4ade72d47c25 2020-08-18 16:29:41 3 [Note] WSREP: SST received: 394d272d-aad7-11e7-9e76-4ade72d47c25:3533941348 2020-08-18 16:29:41 0 [Note] WSREP: Joiner monitor thread ended with total time 193 sec 2020-08-18 16:29:41 2 [Note] WSREP: Installed new state from SST: 394d272d-aad7-11e7-9e76-4ade72d47c25:3533941348 2020-08-18 16:29:41 2 [Note] WSREP: Cert. index preload up to 3533941348 2020-08-18 16:29:41 0 [Note] WSREP: ####### IST applying starts with 3533941349 2020-08-18 16:29:41 0 [Note] WSREP: ####### IST current seqno initialized to 3533941197 2020-08-18 16:29:41 0 [Note] WSREP: Receiving IST... 0.0% ( 0/118 events) complete. 2020-08-18 16:29:41 0 [Note] WSREP: IST preload starting at 3533941197 2020-08-18 16:29:41 0 [Note] WSREP: Service thread queue flushed. 2020-08-18 16:29:41 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:3533941196, protocol version: 5 2020-08-18 16:29:41 0 [Note] WSREP: REPL Protocols: 10 (5) 2020-08-18 16:29:41 0 [Note] WSREP: ####### Adjusting cert position: 3533941313 -> 3533941314 2020-08-18 16:29:41 0 [Note] WSREP: Service thread queue flushed. 2020-08-18 16:29:41 0 [Note] WSREP: Lowest cert indnex boundary for CC from preload: 3533941197 2020-08-18 16:29:41 0 [Note] WSREP: Min available from gcache for CC from preload: 3533941197 2020-08-18 16:29:41 0 [Note] WSREP: Receiving IST...100.0% (118/118 events) complete. 2020-08-18 16:29:41 2 [Note] WSREP: Cert. index preloaded up to 3533941314 2020-08-18 16:29:41 2 [Note] WSREP: Lowest cert indnex boundary for CC from sst: 3533941197 2020-08-18 16:29:41 2 [Note] WSREP: Min available from gcache for CC from sst: 3533941197 2020-08-18 16:29:41 0 [Note] WSREP: 0.0 (thor03): State transfer from 1.0 (thor01) complete. 2020-08-18 16:29:41 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 3533946546) 2020-08-18 16:29:42 0 [Note] WSREP: Member 0.0 (thor03) synced with group. 2020-08-18 16:29:42 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3533946719) 2020-08-18 16:29:42 86 [Note] WSREP: Server thor03 synced with group 2020-08-18 16:29:42 86 [Note] WSREP: Server status change joined -> synced 2020-08-18 16:29:42 86 [Note] WSREP: Synchronized with group, ready for connections 2020-08-18 16:29:42 86 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-08-18 16:30:51 0 [Note] InnoDB: Buffer pool(s) load completed at 200818 16:30:51