Mar 18 11:29:34 srv3 systemd[1]: Starting MariaDB 10.4.18 database server... Mar 18 11:29:38 srv3 mysqld[11061]: WSREP: Recovered position bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582 Mar 18 11:29:38 srv3 mysqld[11382]: 2021-03-18 11:29:38 0 [Note] /usr/sbin/mysqld (mysqld 10.4.18-MariaDB-1:10.4.18+maria~buster-log) starting as process 11382 ... Mar 18 11:29:38 srv3 mysqld[11382]: 2021-03-18 11:29:38 0 [Note] WSREP: wsrep_guess_ip() : xxx.xxx.xxx.xxx Mar 18 11:29:38 srv3 mysqld[11382]: 2021-03-18 11:29:38 0 [Note] WSREP: wsrep_guess_ip() : xxx.xxx.xxx.xxx Mar 18 11:29:38 srv3 mysqld[11382]: 2021-03-18 11:29:38 0 [Note] WSREP: Server initial position: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582 Mar 18 11:29:38 srv3 mysqld[11382]: 2021-03-18 11:29:38 0 [Note] WSREP: Loading provider /usr/lib/libgalera_smm.so initial position: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582 Mar 18 11:29:38 srv3 mysqld[11382]: 2021-03-18 11:29:38 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm.so' Mar 18 11:29:38 srv3 mysqld[11382]: 2021-03-18 11:29:38 0 [Note] WSREP: wsrep_load(): Galera 4.7(ree4f10fc) by Codership Oy loaded successfully. Mar 18 11:29:38 srv3 mysqld[11382]: 2021-03-18 11:29:38 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration. Mar 18 11:29:38 srv3 mysqld[11382]: 2021-03-18 11:29:38 0 [Note] WSREP: Found saved state: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582, safe_to_bootstrap: 0 Mar 18 11:29:38 srv3 mysqld[11382]: 2021-03-18 11:29:38 0 [Note] WSREP: GCache DEBUG: opened preamble: Mar 18 11:29:38 srv3 mysqld[11382]: Version: 2 Mar 18 11:29:38 srv3 mysqld[11382]: UUID: bd401d28-f285-11ea-9c06-4e99d1c864f6 Mar 18 11:29:38 srv3 mysqld[11382]: Seqno: 1612105893 - 1613577582 Mar 18 11:29:38 srv3 mysqld[11382]: Offset: 4189898904 Mar 18 11:29:38 srv3 mysqld[11382]: Synced: 1 Mar 18 11:29:38 srv3 mysqld[11382]: 2021-03-18 11:29:38 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: bd401d28-f285-11ea-9c06-4e99d1c864f6, offset: 4189898904 Mar 18 11:29:38 srv3 mysqld[11382]: 2021-03-18 11:29:38 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/4294967320 bytes) complete. Mar 18 11:29:39 srv3 mysqld[11382]: 2021-03-18 11:29:39 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (4294967320/4294967320 bytes) complete. Mar 18 11:29:39 srv3 mysqld[11382]: 2021-03-18 11:29:39 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 1612105893-1613577582 Mar 18 11:29:39 srv3 mysqld[11382]: 2021-03-18 11:29:39 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/4294953408 bytes) complete. Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (4294953408/4294953408 bytes) complete. Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/1471690 locked buffers Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): free space: 13888/4294967296 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = xxx.xxx.xxx.xxx; 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 = 4G; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: Service thread queue flushed. Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: ####### Assign initial position for certification: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582, protocol version: -1 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: SR storage init for: table Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: wsrep_start_replication Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: Start replication Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: Connecting with bootstrap option: 0 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: Setting GCS initial position to bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: protonet asio version 0 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: Using CRC-32C for message checksums. Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: backend: asio Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: restore pc from disk failed Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: GMCast version 0 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: (d88cac52-b227, 'ssl://0.0.0.0:4567') listening at ssl://0.0.0.0:4567 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: (d88cac52-b227, 'ssl://0.0.0.0:4567') multicast: , ttl: 1 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: EVS version 1 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: gcomm: connecting to group 'DS1', peer '10.0.1.2:,10.0.1.3:,10.0.1.4:' Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: (d88cac52-b227, 'ssl://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address ssl://10.0.1.4:4567 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: (d88cac52-b227, 'ssl://0.0.0.0:4567') connection established to 392d3dc7-bc88 ssl://10.0.1.3:4567 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: (d88cac52-b227, 'ssl://0.0.0.0:4567') turning message relay requesting on, nonlive peers: ssl://10.0.2.1:4567 ssl://10.0.2.2:4567 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: (d88cac52-b227, 'ssl://0.0.0.0:4567') connection established to dafec258-8a91 ssl://10.0.1.2:4567 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: (d88cac52-b227, 'ssl://0.0.0.0:4567') connection established to a22c801a-83c8 ssl://10.0.2.1:4567 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: (d88cac52-b227, 'ssl://0.0.0.0:4567') connection established to abcb93ce-b122 ssl://10.0.2.2:4567 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: Deferred close timer started for socket with remote endpoint: ssl://10.0.2.2:53206 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: Deferred close timer handle_wait asio.system:125 for 0x557835603c10 Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: Deferred close timer destruct Mar 18 11:29:40 srv3 mysqld[11382]: 2021-03-18 11:29:40 0 [Note] WSREP: (d88cac52-b227, 'ssl://0.0.0.0:4567') connection established to abcb93ce-b122 ssl://10.0.2.2:4567 Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: EVS version upgrade 0 -> 1 Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: declaring 392d3dc7-bc88 at ssl://10.0.1.3:4567 stable Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: declaring a22c801a-83c8 at ssl://10.0.2.1:4567 stable Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: declaring abcb93ce-b122 at ssl://10.0.2.2:4567 stable Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: declaring dafec258-8a91 at ssl://10.0.1.2:4567 stable Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: PC protocol upgrade 0 -> 1 Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: Node 392d3dc7-bc88 state prim Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: view(view_id(PRIM,392d3dc7-bc88,100) memb { Mar 18 11:29:41 srv3 mysqld[11382]: 392d3dc7-bc88,0 Mar 18 11:29:41 srv3 mysqld[11382]: a22c801a-83c8,0 Mar 18 11:29:41 srv3 mysqld[11382]: abcb93ce-b122,0 Mar 18 11:29:41 srv3 mysqld[11382]: d88cac52-b227,0 Mar 18 11:29:41 srv3 mysqld[11382]: dafec258-8a91,0 Mar 18 11:29:41 srv3 mysqld[11382]: } joined { Mar 18 11:29:41 srv3 mysqld[11382]: } left { Mar 18 11:29:41 srv3 mysqld[11382]: } partitioned { Mar 18 11:29:41 srv3 mysqld[11382]: }) Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: save pc into disk Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: gcomm: connected Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: Opened channel 'DS1' Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 3, memb_num = 5 Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: STATE EXCHANGE: sent state msg: d9299f34-87d4-11eb-bc75-a390948aa8b4 Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: STATE EXCHANGE: got state msg: d9299f34-87d4-11eb-bc75-a390948aa8b4 from 0 (srv2) Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: STATE EXCHANGE: got state msg: d9299f34-87d4-11eb-bc75-a390948aa8b4 from 1 (garb) Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: STATE EXCHANGE: got state msg: d9299f34-87d4-11eb-bc75-a390948aa8b4 from 2 (garb) Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: wsrep system thread 1, 0x7f2738000c08 starting Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 2 [Note] WSREP: wsrep system thread 2, 0x7f2734000c08 starting Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: STATE EXCHANGE: got state msg: d9299f34-87d4-11eb-bc75-a390948aa8b4 from 4 (srv1) Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 2 [Note] WSREP: Starting rollbacker thread 2 Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: Starting applier thread 1 Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: STATE EXCHANGE: got state msg: d9299f34-87d4-11eb-bc75-a390948aa8b4 from 3 (srv3) Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: Quorum results: Mar 18 11:29:41 srv3 mysqld[11382]: version = 6, Mar 18 11:29:41 srv3 mysqld[11382]: component = PRIMARY, Mar 18 11:29:41 srv3 mysqld[11382]: conf_id = 95, Mar 18 11:29:41 srv3 mysqld[11382]: members = 4/5 (joined/total), Mar 18 11:29:41 srv3 mysqld[11382]: act_id = 1613609852, Mar 18 11:29:41 srv3 mysqld[11382]: last_appl. = 1613609792, Mar 18 11:29:41 srv3 mysqld[11382]: protocols = 2/10/4 (gcs/repl/appl), Mar 18 11:29:41 srv3 mysqld[11382]: vote policy= 0, Mar 18 11:29:41 srv3 mysqld[11382]: group UUID = bd401d28-f285-11ea-9c06-4e99d1c864f6 Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: Flow-control interval: [36, 36] Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 1613609853) Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: ####### processing CC 1613609853, local, ordered Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: Process first view: bd401d28-f285-11ea-9c06-4e99d1c864f6 my uuid: d88cac52-87d4-11eb-b227-b222be318098 Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: Server srv3 connected to cluster at position bd401d28-f285-11ea-9c06-4e99d1c864f6:1613609853 with ID d88cac52-87d4-11eb-b227-b222be318098 Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: server srv3 state change: disconnected -> connected Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: Server status change disconnected -> connected Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: ####### My UUID: d88cac52-87d4-11eb-b227-b222be318098 Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: Service thread queue flushed. Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: State transfer required: Mar 18 11:29:41 srv3 mysqld[11382]: Group state: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613609853 Mar 18 11:29:41 srv3 mysqld[11382]: Local state: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582 Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: server srv3 state change: connected -> joiner Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: Server status change connected -> joiner Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 1 [Note] WSREP: wsrep_guess_ip() : xxx.xxx.xxx.xxx Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: Joiner monitor thread started to monitor Mar 18 11:29:41 srv3 mysqld[11382]: 2021-03-18 11:29:41 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address 'xxx.xxx.xxx.xxx' --datadir '/var/lib/mysql/' --parent '11382' --binlog '/var/log/mysql/mariadb-bin' --binlog-index '/var/log/mysql/mariadb-bin.index' --mysqld-args --wsrep_start_position=bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582' Mar 18 11:29:41 srv3 mysqld[11382]: WSREP_SST: [INFO] Logging all stderr of SST/Innobackupex to syslog (20210318 11:29:41.756) Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 1 [Note] WSREP: Prepared SST request: mariabackup|xxx.xxx.xxx.xxx:4444/xtrabackup_sst//1 Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 1 [Note] WSREP: ####### IST uuid:bd401d28-f285-11ea-9c06-4e99d1c864f6 f: 1613577583, l: 1613609853, STRv: 3 Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 1 [Note] WSREP: IST receiver addr using ssl://xxx.xxx.xxx.xxx:4568 Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 1 [Note] WSREP: IST receiver using ssl Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 1 [Note] WSREP: Prepared IST receiver for 1613577583-1613609853, listening at: ssl://xxx.xxx.xxx.xxx:4568 Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 0 [Note] WSREP: Member 3.0 (srv3) requested state transfer from '*any*'. Selected 4.0 (srv1)(SYNCED) as donor. Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 1613609997) Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 1 [Note] WSREP: Requesting state transfer: success, donor: 4 Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 0 [Note] WSREP: 4.0 (srv1): State transfer to 3.0 (srv3) complete. Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 0 [Note] WSREP: Member 4.0 (srv1) synced with group. Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 3 [Note] WSREP: SST received Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 3 [Note] WSREP: server srv3 state change: joiner -> initializing Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 3 [Note] WSREP: Server status change joiner -> initializing Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 0 [Note] InnoDB: Using Linux native AIO Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 0 [Note] InnoDB: Uses event mutexes Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 0 [Note] InnoDB: Number of pools: 1 Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 0 [Note] InnoDB: Using SSE2 crc32 instructions Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) Mar 18 11:29:42 srv3 mysqld[11382]: 2021-03-18 11:29:42 0 [Note] InnoDB: Initializing buffer pool, total size = 40G, instances = 40, chunk size = 128M Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] InnoDB: Completed initialization of buffer pool Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 4294967296 bytes Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] InnoDB: New log files created, LSN=19447398222896 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: (d88cac52-b227, 'ssl://0.0.0.0:4567') turning message relay requesting off Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] InnoDB: Waiting for purge to start Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] InnoDB: 10.4.18 started; log sequence number 19447398223372; transaction id 26832497540 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] Plugin 'FEEDBACK' is disabled. Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: wsrep_plugin_init() Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [ERROR] mysqld: Plugin 'innodb' already installed Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Warning] Plugin 'FEDERATED' is of maturity level gamma while the server is stable Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: ha_rollback_trans(0, TRUE) rolled back: (null): Plugin 'innodb' already installed; is_real 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: MYSQL_BIN_LOG::open(): Adding new xid_list_entry for mariadb-bin.061784 (1) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] Server socket created on IP: '0.0.0.0'. Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 10 [Note] WSREP: SQL: 202 CREATE TABLE IF NOT EXISTS mysql.wsrep_cluster(cluster_uuid CHAR(36) PRIMARY KEY,view_id BIGINT NOT NULL,view_seqno BIGINT NOT NULL,protocol_version INT NOT NULL,capabilities INT NOT NULL) ENGINE=InnoDB thd: 10 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 10 [Note] WSREP: SQL: 203 CREATE TABLE IF NOT EXISTS mysql.wsrep_cluster_members(node_uuid CHAR(36) PRIMARY KEY,cluster_uuid CHAR(36) NOT NULL,node_name CHAR(32) NOT NULL,node_incoming_address VARCHAR(256) NOT NULL) ENGINE=InnoDB thd: 10 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 10 [Note] WSREP: SQL: 199 CREATE TABLE IF NOT EXISTS mysql.wsrep_streaming_log(node_uuid CHAR(36), trx_id BIGINT, seqno BIGINT, flags INT NOT NULL, frag LONGBLOB NOT NULL, PRIMARY KEY (node_uuid, trx_id, seqno)) ENGINE=InnoDB thd: 10 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: Server initialized Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: server srv3 state change: initializing -> initialized Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: Server status change initializing -> initialized Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 3 [Note] WSREP: server srv3 state change: initialized -> joined Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 3 [Note] WSREP: Server status change initialized -> joined Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: Startup creating 15 applier threads running 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 3 [Note] WSREP: Read WSREPXid from InnoDB: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 3 [Note] WSREP: Recovered position from storage: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: wsrep system thread 11, 0x7f1c8c000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep system thread 17, 0x7f1c74000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep system thread 25, 0x7f1c54000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: Starting applier thread 11 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep system thread 18, 0x7f1c68000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep system thread 19, 0x7f1c6c000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep system thread 14, 0x7f1c78000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep system thread 20, 0x7f1c60000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep system thread 13, 0x7f1c84000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: wsrep system thread 21, 0x7f1c64000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: Starting applier thread 14 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep system thread 22, 0x7f1c58000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: wsrep system thread 12, 0x7f1c80000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: Starting applier thread 22 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: wsrep system thread 15, 0x7f1c7c000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: wsrep system thread 24, 0x7f1c50000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: Starting applier thread 17 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: Starting applier thread 25 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: Starting applier thread 18 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: Starting applier thread 19 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: wsrep system thread 16, 0x7f1c70000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: Starting applier thread 20 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: Starting applier thread 13 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: Starting applier thread 21 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: Starting applier thread 16 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: Starting applier thread 12 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: Starting applier thread 15 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: Starting applier thread 24 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: wsrep system thread 23, 0x7f1c5c000c08 starting Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: Starting applier thread 23 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] Reading of all Master_info entries succeeded Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] Added new Master_info '' to hash table Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] /usr/sbin/mysqld: ready for connections. Mar 18 11:29:43 srv3 mysqld[11382]: Version: '10.4.18-MariaDB-1:10.4.18+maria~buster-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 3 [Note] WSREP: Restored cluster view: Mar 18 11:29:43 srv3 mysqld[11382]: id: bd401d28-f285-11ea-9c06-4e99d1c864f6:1598701397 Mar 18 11:29:43 srv3 mysqld[11382]: status: primary Mar 18 11:29:43 srv3 mysqld[11382]: protocol_version: 4 Mar 18 11:29:43 srv3 mysqld[11382]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Mar 18 11:29:43 srv3 mysqld[11382]: final: no Mar 18 11:29:43 srv3 mysqld[11382]: own_index: -1 Mar 18 11:29:43 srv3 mysqld[11382]: members(5): Mar 18 11:29:43 srv3 mysqld[11382]: 0: 392d3dc7-865f-11eb-bc88-862108ff01ef, srv2 Mar 18 11:29:43 srv3 mysqld[11382]: 1: 529bf4d7-84af-11eb-b64e-72b01ddc0105, srv3 Mar 18 11:29:43 srv3 mysqld[11382]: 2: a22c801a-84ad-11eb-83c8-675ebd437f88, garb Mar 18 11:29:43 srv3 mysqld[11382]: 3: abcb93ce-84ad-11eb-b122-2275e9a2eb12, garb Mar 18 11:29:43 srv3 mysqld[11382]: 4: dafec258-8662-11eb-8a91-af36e33159ed, srv1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 3 [Note] WSREP: Recovered view from SST: Mar 18 11:29:43 srv3 mysqld[11382]: id: bd401d28-f285-11ea-9c06-4e99d1c864f6:1598701397 Mar 18 11:29:43 srv3 mysqld[11382]: status: primary Mar 18 11:29:43 srv3 mysqld[11382]: protocol_version: 4 Mar 18 11:29:43 srv3 mysqld[11382]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Mar 18 11:29:43 srv3 mysqld[11382]: final: no Mar 18 11:29:43 srv3 mysqld[11382]: own_index: -1 Mar 18 11:29:43 srv3 mysqld[11382]: members(5): Mar 18 11:29:43 srv3 mysqld[11382]: 0: 392d3dc7-865f-11eb-bc88-862108ff01ef, srv2 Mar 18 11:29:43 srv3 mysqld[11382]: 1: 529bf4d7-84af-11eb-b64e-72b01ddc0105, srv3 Mar 18 11:29:43 srv3 mysqld[11382]: 2: a22c801a-84ad-11eb-83c8-675ebd437f88, garb Mar 18 11:29:43 srv3 mysqld[11382]: 3: abcb93ce-84ad-11eb-b122-2275e9a2eb12, garb Mar 18 11:29:43 srv3 mysqld[11382]: 4: dafec258-8662-11eb-8a91-af36e33159ed, srv1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 3 [Note] WSREP: No applier in Wsrep_server_service::log_view(), skipping write to wsrep_schema Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 28 [Note] WSREP: Recovered cluster id bd401d28-f285-11ea-9c06-4e99d1c864f6 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 3 [Note] WSREP: SST received: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 3 [Note] WSREP: SST succeeded for position bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: Joiner monitor thread ended with total time 2 sec Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: Installed new state from SST: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: Receiving IST: 32271 writesets, seqnos 1613577583-1613609853 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: ####### IST applying starts with 1613577583 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: ####### IST current seqno initialized to 1613577583 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: Receiving IST... 0.0% ( 0/32271 events) complete. Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: REPL Protocols: 10 (5) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: Service thread queue flushed. Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: ####### Assign initial position for certification: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582, protocol version: 5 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: REPL Protocols: 10 (5) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: ####### Adjusting cert position: 1613577582 -> 1613577583 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: Service thread queue flushed. Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 1613577583 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 0 [Note] WSREP: Min available from gcache for CC from ist: 1612105902 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: ================================================ Mar 18 11:29:43 srv3 mysqld[11382]: View: Mar 18 11:29:43 srv3 mysqld[11382]: id: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577583 Mar 18 11:29:43 srv3 mysqld[11382]: status: primary Mar 18 11:29:43 srv3 mysqld[11382]: protocol_version: 4 Mar 18 11:29:43 srv3 mysqld[11382]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Mar 18 11:29:43 srv3 mysqld[11382]: final: no Mar 18 11:29:43 srv3 mysqld[11382]: own_index: -1 Mar 18 11:29:43 srv3 mysqld[11382]: members(4): Mar 18 11:29:43 srv3 mysqld[11382]: 0: 392d3dc7-865f-11eb-bc88-862108ff01ef, srv2 Mar 18 11:29:43 srv3 mysqld[11382]: 1: a22c801a-84ad-11eb-83c8-675ebd437f88, garb Mar 18 11:29:43 srv3 mysqld[11382]: 2: abcb93ce-84ad-11eb-b122-2275e9a2eb12, garb Mar 18 11:29:43 srv3 mysqld[11382]: 3: dafec258-8662-11eb-8a91-af36e33159ed, srv1 Mar 18 11:29:43 srv3 mysqld[11382]: ================================================= Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: Restored cluster view: Mar 18 11:29:43 srv3 mysqld[11382]: id: bd401d28-f285-11ea-9c06-4e99d1c864f6:1598701397 Mar 18 11:29:43 srv3 mysqld[11382]: status: primary Mar 18 11:29:43 srv3 mysqld[11382]: protocol_version: 4 Mar 18 11:29:43 srv3 mysqld[11382]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Mar 18 11:29:43 srv3 mysqld[11382]: final: no Mar 18 11:29:43 srv3 mysqld[11382]: own_index: -1 Mar 18 11:29:43 srv3 mysqld[11382]: members(5): Mar 18 11:29:43 srv3 mysqld[11382]: 0: 392d3dc7-865f-11eb-bc88-862108ff01ef, srv2 Mar 18 11:29:43 srv3 mysqld[11382]: 1: 529bf4d7-84af-11eb-b64e-72b01ddc0105, srv3 Mar 18 11:29:43 srv3 mysqld[11382]: 2: a22c801a-84ad-11eb-83c8-675ebd437f88, garb Mar 18 11:29:43 srv3 mysqld[11382]: 3: abcb93ce-84ad-11eb-b122-2275e9a2eb12, garb Mar 18 11:29:43 srv3 mysqld[11382]: 4: dafec258-8662-11eb-8a91-af36e33159ed, srv1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: Storing cluster view: Mar 18 11:29:43 srv3 mysqld[11382]: id: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577583 Mar 18 11:29:43 srv3 mysqld[11382]: status: primary Mar 18 11:29:43 srv3 mysqld[11382]: protocol_version: 4 Mar 18 11:29:43 srv3 mysqld[11382]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Mar 18 11:29:43 srv3 mysqld[11382]: final: no Mar 18 11:29:43 srv3 mysqld[11382]: own_index: -1 Mar 18 11:29:43 srv3 mysqld[11382]: members(4): Mar 18 11:29:43 srv3 mysqld[11382]: 0: 392d3dc7-865f-11eb-bc88-862108ff01ef, srv2 Mar 18 11:29:43 srv3 mysqld[11382]: 1: a22c801a-84ad-11eb-83c8-675ebd437f88, garb Mar 18 11:29:43 srv3 mysqld[11382]: 2: abcb93ce-84ad-11eb-b122-2275e9a2eb12, garb Mar 18 11:29:43 srv3 mysqld[11382]: 3: dafec258-8662-11eb-8a91-af36e33159ed, srv1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: SQL: 31 DELETE FROM mysql.wsrep_cluster thd: 11 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: SQL: 39 DELETE FROM mysql.wsrep_cluster_members thd: 11 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: Set WSREPXid for InnoDB: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577583 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_commit_empty(22) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_commit_empty(19) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_commit_empty(20) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_commit_empty(17) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: wsrep_commit_empty(16) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_commit_empty(14) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_commit_empty(25) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: assigned new next trx id: 6 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: assigned new next trx id: 12 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_commit_empty(18) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: wsrep_commit_empty(21) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: assigned new next trx id: 7 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: assigned new next trx id: 8 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: assigned new next trx id: 9 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: assigned new next trx id: 10 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: assigned new next trx id: 11 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: assigned new next trx id: 13 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: assigned new next trx id: 14 Mar 18 11:29:43 srv3 systemd[1]: Started MariaDB 10.4.18 database server. Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_before_commit: 1, 1613577590 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_before_commit: 1, 1613577589 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_before_commit: 1, 1613577587 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_before_commit: 1, 1613577588 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_before_commit: 1, 1613577585 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: wsrep_before_commit: 1, 1613577593 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 29 [Note] WSREP: assigned new next trx id: 15 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 30 [Note] WSREP: assigned new next trx id: 18 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 31 [Note] WSREP: assigned new next trx id: 21 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_before_commit: 1, 1613577584 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577584, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577585, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_after_apply 14 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_after_apply 22 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 32 [Note] WSREP: assigned new next trx id: 24 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_before_commit: 1, 1613577586 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577586, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_after_apply 25 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577587, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_after_apply 17 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577588, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_after_apply 18 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577589, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_after_apply 19 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577590, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_after_apply 20 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_commit_empty(13) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: assigned new next trx id: 41 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_before_commit: 1, 1613577591 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577591, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_after_apply 13 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: wsrep_before_commit: 1, 1613577592 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577592, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: wsrep_after_apply 21 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577593, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: wsrep_commit_empty(21) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: wsrep_commit_empty(1) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_commit_empty(19) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: assigned new next trx id: 66 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_commit_empty(17) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: assigned new next trx id: 65 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_commit_empty(18) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: wsrep_commit_empty(23) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_commit_empty(25) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: assigned new next trx id: 70 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: wsrep_commit_empty(24) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_commit_empty(22) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_commit_empty(20) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_commit_empty(13) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: assigned new next trx id: 75 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: assigned new next trx id: 76 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: wsrep_commit_empty(12) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: assigned new next trx id: 67 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: assigned new next trx id: 77 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: wsrep_commit_empty(15) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: assigned new next trx id: 69 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: wsrep_after_apply 16 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: assigned new next trx id: 71 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: assigned new next trx id: 72 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: assigned new next trx id: 73 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: assigned new next trx id: 74 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_commit_empty(14) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: assigned new next trx id: 68 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: assigned new next trx id: 78 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: wsrep_commit_empty(16) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: assigned new next trx id: 79 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: assigned new next trx id: 80 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 33 [Note] WSREP: assigned new next trx id: 81 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: wsrep_before_commit: 1, 1613577596 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: wsrep_before_commit: 1, 1613577598 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_before_commit: 1, 1613577604 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: wsrep_before_commit: 1, 1613577597 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: wsrep_before_commit: 1, 1613577608 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_before_commit: 1, 1613577607 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_before_commit: 1, 1613577600 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_before_commit: 1, 1613577605 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_before_commit: 1, 1613577602 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: wsrep_before_commit: 1, 1613577599 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_before_commit: 1, 1613577603 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_before_commit: 1, 1613577606 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: wsrep_before_commit: 1, 1613577609 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: wsrep_before_commit: 1, 1613577595 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: wsrep_before_commit: 1, 1613577594 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577594, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: wsrep_after_apply 12 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: wsrep_commit_empty(12) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: assigned new next trx id: 86 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577596, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577597, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577595, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577599, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: assigned new next trx id: 87 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577598, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577600, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: wsrep_after_apply 15 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: wsrep_after_apply 24 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: wsrep_commit_empty(15) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: wsrep_after_apply 11 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: wsrep_commit_empty(24) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: wsrep_after_apply 23 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: assigned new next trx id: 89 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: wsrep_after_apply 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_after_apply 14 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_commit_empty(14) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: wsrep_commit_empty(23) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: assigned new next trx id: 91 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: wsrep_commit_empty(11) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: assigned new next trx id: 88 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: assigned new next trx id: 90 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: wsrep_commit_empty(1) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: wsrep_before_commit: 1, 1613577610 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: assigned new next trx id: 93 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: assigned new next trx id: 92 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: wsrep_before_commit: 1, 1613577612 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: wsrep_before_commit: 1, 1613577611 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: wsrep_before_commit: 1, 1613577613 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: wsrep_before_commit: 1, 1613577615 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_before_commit: 1, 1613577616 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: wsrep_before_commit: 1, 1613577614 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_before_commit: 1, 1613577601 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577601, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_after_apply 22 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_commit_empty(22) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: assigned new next trx id: 94 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577602, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_after_apply 25 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577603, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577606, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_after_apply 17 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_after_apply 20 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_commit_empty(20) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577605, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 21 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: assigned new next trx id: 95 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_commit_empty(17) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577604, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: assigned new next trx id: 96 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_after_apply 18 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_after_apply 19 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 16 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_commit_empty(19) Mar 18 11:29:43 srv3 mysqld[11382]: mysqld: /home/buildbot/buildbot/build/mariadb-10.4.18/wsrep-lib/include/wsrep/client_state.hpp:508: int wsrep::client_state::ordered_commit(): Assertion `owning_thread_id_ == wsrep::this_thread::get_id()' failed. Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_commit_empty(18) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: assigned new next trx id: 98 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_commit_empty(25) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: assigned new next trx id: 97 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: assigned new next trx id: 99 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 12 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_after_commit: 1, 1, 1613577607, 0 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 15 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_after_apply 13 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 24 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_commit_empty(13) Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: assigned new next trx id: 100 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 11 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 23 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 1 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 14 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 210318 11:29:43 [ERROR] mysqld got signal 6 ; Mar 18 11:29:43 srv3 mysqld[11382]: This could be because you hit a bug. It is also possible that this binary Mar 18 11:29:43 srv3 mysqld[11382]: or one of the libraries it was linked against is corrupt, improperly built, Mar 18 11:29:43 srv3 mysqld[11382]: or misconfigured. This error can also be caused by malfunctioning hardware. Mar 18 11:29:43 srv3 mysqld[11382]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Mar 18 11:29:43 srv3 mysqld[11382]: We will try our best to scrape up some info that will hopefully help Mar 18 11:29:43 srv3 mysqld[11382]: diagnose the problem, but since we have already crashed, Mar 18 11:29:43 srv3 mysqld[11382]: something is definitely wrong and this may fail. Mar 18 11:29:43 srv3 mysqld[11382]: Server version: 10.4.18-MariaDB-1:10.4.18+maria~buster-log Mar 18 11:29:43 srv3 mysqld[11382]: key_buffer_size=134217728 Mar 18 11:29:43 srv3 mysqld[11382]: read_buffer_size=2097152 Mar 18 11:29:43 srv3 mysqld[11382]: max_used_connections=1 Mar 18 11:29:43 srv3 mysqld[11382]: max_threads=302 Mar 18 11:29:43 srv3 mysqld[11382]: thread_count=24 Mar 18 11:29:43 srv3 mysqld[11382]: It is possible that mysqld could use up to Mar 18 11:29:43 srv3 mysqld[11382]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1994007 K bytes of memory Mar 18 11:29:43 srv3 mysqld[11382]: Hope that's ok; if not, decrease some variables in the equation. Mar 18 11:29:43 srv3 mysqld[11382]: Thread pointer: 0x7f1c64000c08 Mar 18 11:29:43 srv3 mysqld[11382]: Attempting backtrace. You can use the following information to find out Mar 18 11:29:43 srv3 mysqld[11382]: where mysqld died. If you see no messages after this, something went Mar 18 11:29:43 srv3 mysqld[11382]: terribly wrong... Mar 18 11:29:43 srv3 mysqld[11382]: stack_bottom = 0x7f1cfc5f3e08 thread_stack 0x100000 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_before_commit: 1, 1613577618 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_before_commit: 1, 1613577622 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_before_commit: 1, 1613577620 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_before_commit: 1, 1613577621 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_before_commit: 1, 1613577623 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_before_commit: 1, 1613577617 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 22 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 25 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5578322e67fe] Mar 18 11:29:43 srv3 mysqld[11382]: /usr/sbin/mysqld(handle_fatal_signal+0x54d)[0x557831dd9b0d] Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_before_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_after_prepare: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_before_commit: 1, 1613577619 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 17 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 20 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 18 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 19 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: 2021-03-18 11:29:43 13 [Note] WSREP: wsrep_ordered_commit: 1 Mar 18 11:29:43 srv3 mysqld[11382]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x12730)[0x7f2854127730] Mar 18 11:29:44 srv3 mysqld[11382]: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x10b)[0x7f285356f7bb] Mar 18 11:29:44 srv3 mysqld[11382]: /lib/x86_64-linux-gnu/libc.so.6(abort+0x121)[0x7f285355a535] Mar 18 11:29:44 srv3 mysqld[11382]: /lib/x86_64-linux-gnu/libc.so.6(+0x2240f)[0x7f285355a40f] Mar 18 11:29:44 srv3 mysqld[11382]: /lib/x86_64-linux-gnu/libc.so.6(+0x30102)[0x7f2853568102] Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: Looking for 'mysql' as: /usr/bin/mysql Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: Phase 1/7: Checking and upgrading mysql database Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: Running 'mysqlcheck' with connection arguments: --port='3306' --socket='/var/run/mysqld/mysqld.sock' --host='localhost' --socket='/var/run/mysqld/mysqld.sock' --host='localhost' --socket='/var/run/mysqld/mysqld.sock' Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: # Connecting to localhost... Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: # Disconnecting from localhost... Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: Processing databases Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.column_stats OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.columns_priv OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.db OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.event OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.func OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.global_priv OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.gtid_slave_pos OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.help_category OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.help_keyword OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.help_relation OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.help_topic OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.index_stats OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.innodb_index_stats OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.innodb_table_stats OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.plugin OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.proc OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.procs_priv OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.proxies_priv OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.roles_mapping OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.servers OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.slave_master_info OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.slave_relay_log_info OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.slave_worker_info OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.table_stats OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.tables_priv OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.tempMix4 OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.time_zone OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.time_zone_leap_second OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.time_zone_name OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.time_zone_transition OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.time_zone_transition_type OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.transaction_registry OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.wsrep_cluster OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.wsrep_cluster_members OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.wsrep_streaming_log OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: Phase 2/7: Installing used storage engines... Skipped Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: Phase 3/7: Fixing views Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: Running 'mysqlcheck' with connection arguments: --port='3306' --socket='/var/run/mysqld/mysqld.sock' --host='localhost' --socket='/var/run/mysqld/mysqld.sock' --host='localhost' --socket='/var/run/mysqld/mysqld.sock' Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: Processing databases Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: information_schema Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: mysql.user OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: performance_schema Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.host_summary OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.host_summary_by_file_io OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.host_summary_by_file_io_type OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.host_summary_by_stages OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.host_summary_by_statement_latency OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.host_summary_by_statement_type OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.innodb_buffer_stats_by_schema OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.innodb_buffer_stats_by_table OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.innodb_lock_waits OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.io_by_thread_by_latency OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.io_global_by_file_by_bytes OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.io_global_by_file_by_latency OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.io_global_by_wait_by_bytes OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.io_global_by_wait_by_latency OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.latest_file_io OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.processlist OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.ps_check_lost_instrumentation OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.schema_index_statistics OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.schema_object_overview OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.schema_table_statistics OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.schema_table_statistics_with_buffer OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.schema_tables_with_full_table_scans OK Mar 18 11:29:44 srv3 /etc/mysql/debian-start[11756]: sys.schema_unused_indexes OK Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 34 [Note] WSREP: assigned new next trx id: 188 Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(wsrep_commit_ordered+0x91)[0x557831d5eea1] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(+0xb76a88)[0x557832097a88] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(+0xb75dda)[0x557832096dda] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(+0xb75f83)[0x557832096f83] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(+0xa511de)[0x557831f721de] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(+0xa515fc)[0x557831f725fc] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(_ZN6TC_LOG18run_commit_orderedEP3THDb+0x3d)[0x557831ebb0ad] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG23trx_group_commit_leaderEPNS_18group_commit_entryE+0x37e)[0x557831ec051e] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG34write_transaction_to_binlog_eventsEPNS_18group_commit_entryE+0x12b)[0x557831ec097b] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG27write_transaction_to_binlogEP3THDP17binlog_cache_mngrP9Log_eventbbb+0x1d7)[0x557831ec0f07] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(+0x9a0016)[0x557831ec1016] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(+0x9a0ab2)[0x557831ec1ab2] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG13log_and_orderEP3THDybbb+0x44)[0x557831ec1c34] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(_Z15ha_commit_transP3THDb+0xb09)[0x557831dde509] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(_Z12trans_commitP3THD+0x57)[0x557831cc8577] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(_ZN27Wsrep_high_priority_service6commitERKN5wsrep9ws_handleERKNS0_7ws_metaE+0x140)[0x557831d3eb90] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(+0xe389a6)[0x5578323599a6] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(_ZN5wsrep12server_state8on_applyERNS_21high_priority_serviceERKNS_9ws_handleERKNS_7ws_metaERKNS_12const_bufferE+0x15d)[0x55783235a4dd] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(+0xe4c804)[0x55783236d804] Mar 18 11:29:44 srv3 mysqld[11382]: src/trx_handle.cpp:387(galera::TrxHandleSlave::apply(void*, wsrep_cb_status (*)(void*, wsrep_ws_handle const*, unsigned int, wsrep_buf const*, wsrep_trx_meta const*, bool*), wsrep_trx_meta const&, bool&))[0x7f285299c5fb] Mar 18 11:29:44 srv3 mysqld[11382]: src/replicator_smm.cpp:504(galera::ReplicatorSMM::apply_trx(void*, galera::TrxHandleSlave&))[0x7f28529ace70] Mar 18 11:29:44 srv3 mysqld[11382]: src/gu_logger.hpp:96(galera::ReplicatorSMM::process_IST_writeset(void*, boost::shared_ptr const&))[0x7f28529c0e42] Mar 18 11:29:44 srv3 mysqld[11382]: src/replicator_str.cpp:1155(galera::ReplicatorSMM::recv_IST(void*))[0x7f28529c1396] Mar 18 11:29:44 srv3 mysqld[11382]: src/replicator_smm.cpp:396(galera::ReplicatorSMM::async_recv(void*))[0x7f28529afd53] Mar 18 11:29:44 srv3 mysqld[11382]: src/wsrep_provider.cpp:263(galera_recv)[0x7f285298b48b] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(_ZN5wsrep18wsrep_provider_v2611run_applierEPNS_21high_priority_serviceE+0xe)[0x55783236e4fe] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(+0x836dff)[0x557831d57dff] Mar 18 11:29:44 srv3 mysqld[11382]: /usr/sbin/mysqld(_Z15start_wsrep_THDPv+0x388)[0x557831d49ac8] Mar 18 11:29:44 srv3 mysqld[11382]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x7fa3)[0x7f285411cfa3] Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 0 [Note] WSREP: IST preload starting at 1613609793 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 36 [Note] WSREP: assigned new next trx id: 275 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 36 [Note] WSREP: assigned new next trx id: 276 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 36 [Note] WSREP: assigned new next trx id: 277 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 36 [Note] WSREP: assigned new next trx id: 278 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 36 [Note] WSREP: wsrep_commit_empty(36) Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 36 [Note] WSREP: assigned new next trx id: 279 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 35 [Note] WSREP: assigned new next trx id: 280 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 35 [Note] WSREP: assigned new next trx id: 281 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 35 [Note] WSREP: assigned new next trx id: 282 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 35 [Note] WSREP: assigned new next trx id: 283 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 35 [Note] WSREP: wsrep_commit_empty(35) Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 35 [Note] WSREP: assigned new next trx id: 284 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 35 [Note] WSREP: assigned new next trx id: 284 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 37 [Note] WSREP: assigned new next trx id: 288 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 37 [Note] WSREP: assigned new next trx id: 289 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 37 [Note] WSREP: assigned new next trx id: 290 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 37 [Note] WSREP: assigned new next trx id: 291 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 37 [Note] WSREP: wsrep_commit_empty(37) Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 37 [Note] WSREP: assigned new next trx id: 292 Mar 18 11:29:44 srv3 mysqld[11382]: 2021-03-18 11:29:44 37 [Note] WSREP: assigned new next trx id: 292 Mar 18 11:29:44 srv3 mysqld[11382]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f28536314cf] Mar 18 11:29:44 srv3 mysqld[11382]: Trying to get some variables. Mar 18 11:29:44 srv3 mysqld[11382]: Some pointers may be invalid and cause the dump to abort. Mar 18 11:29:44 srv3 mysqld[11382]: Query (0x0): (null) Mar 18 11:29:44 srv3 mysqld[11382]: Connection ID (thread ID): 21 Mar 18 11:29:44 srv3 mysqld[11382]: Status: NOT_KILLED Mar 18 11:29:44 srv3 mysqld[11382]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on Mar 18 11:29:44 srv3 mysqld[11382]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains Mar 18 11:29:44 srv3 mysqld[11382]: information that should help you find out what is causing the crash. Mar 18 11:29:44 srv3 mysqld[11382]: We think the query pointer is invalid, but we will try to print it anyway. Mar 18 11:29:44 srv3 mysqld[11382]: Query: Mar 18 11:29:44 srv3 mysqld[11382]: Writing a core file... Mar 18 11:29:44 srv3 mysqld[11382]: Working directory at /var/lib/mysql Mar 18 11:29:44 srv3 mysqld[11382]: Resource Limits: Mar 18 11:29:44 srv3 mysqld[11382]: Limit Soft Limit Hard Limit Units Mar 18 11:29:44 srv3 mysqld[11382]: Max cpu time unlimited unlimited seconds Mar 18 11:29:44 srv3 mysqld[11382]: Max file size unlimited unlimited bytes Mar 18 11:29:44 srv3 mysqld[11382]: Max data size unlimited unlimited bytes Mar 18 11:29:44 srv3 mysqld[11382]: Max stack size 8388608 unlimited bytes Mar 18 11:29:44 srv3 mysqld[11382]: Max core file size 0 unlimited bytes Mar 18 11:29:44 srv3 mysqld[11382]: Max resident set unlimited unlimited bytes Mar 18 11:29:44 srv3 mysqld[11382]: Max processes 257361 257361 processes Mar 18 11:29:44 srv3 mysqld[11382]: Max open files 16384 16384 files Mar 18 11:29:44 srv3 mysqld[11382]: Max locked memory 65536 65536 bytes Mar 18 11:29:44 srv3 mysqld[11382]: Max address space unlimited unlimited bytes Mar 18 11:29:44 srv3 mysqld[11382]: Max file locks unlimited unlimited locks Mar 18 11:29:44 srv3 mysqld[11382]: Max pending signals 257361 257361 signals Mar 18 11:29:44 srv3 mysqld[11382]: Max msgqueue size 819200 819200 bytes Mar 18 11:29:44 srv3 mysqld[11382]: Max nice priority 0 0 Mar 18 11:29:44 srv3 mysqld[11382]: Max realtime priority 0 0 Mar 18 11:29:44 srv3 mysqld[11382]: Max realtime timeout unlimited unlimited us Mar 18 11:29:44 srv3 mysqld[11382]: Core pattern: core Mar 18 11:29:45 srv3 systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT Mar 18 11:29:45 srv3 systemd[1]: mariadb.service: Failed with result 'signal'.