2023-11-17 12:57:07 11512962 [Warning] Aborted connection 11512962 to db: 'unconnected' user: 'unauthenticated' host: '10.29.94.112' (This connection closed normally without authentication)
Warning: Memory not freed: 72
2023-11-17 14:58:53 11524691 [Warning] Aborted connection 11524691 to db: 'webdb' user: 'epommak' host: 'localhost' (Got an error reading communication packets)
2023-11-17 15:02:06 11625394 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait timeout index `contr_subs_ba_billing_account_id_1608dca4_fk_contracts` table `webdb`.`contracts_subscriptionbarring`
 query DELETE FROM `contracts_subscriptionbarring` WHERE `contracts_subscriptionbarring`.`id` IN (323405786)
2023-11-17 15:02:57 11625394 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait timeout index `contr_subs_ba_billing_account_id_1608dca4_fk_contracts` table `webdb`.`contracts_subscriptionbarring`
 query DELETE FROM `contracts_subscriptionbarring` WHERE `contracts_subscriptionbarring`.`id` IN (323405786)
2023-11-17 15:03:53 11625394 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait timeout index `contr_subs_ba_billing_account_id_1608dca4_fk_contracts` table `webdb`.`contracts_subscriptionbarring`
 query DELETE FROM `contracts_subscriptionbarring` WHERE `contracts_subscriptionbarring`.`id` IN (323405786)
2023-11-17 23:55:53 0 [ERROR] WSREP: Corrupt buffer header: addr: 0x7f538ae54ac8, seqno: 2819301969123618871, size: 824193073, ctx: 0x2d31312d33323032, flags: 14903. store: 48, type: 56
231117 23:55:53 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.
Server version: 10.5.6-MariaDB-log
key_buffer_size=134217728
read_buffer_size=1048576
max_used_connections=8601
max_threads=65537
thread_count=6334
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 268945649 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x40000
Can't start addr2line
/usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x55917faa60ae]
/usr/sbin/mariadbd(handle_fatal_signal+0x307)[0x55917f4a75d7]
/lib64/libpthread.so.0(+0xf630)[0x7f5624055630]
/lib64/libc.so.6(gsignal+0x37)[0x7f56220ae387]
/lib64/libc.so.6(abort+0x148)[0x7f56220afa78]
/usr/lib64/galera/libgalera_smm.so(+0x66a6c)[0x7f554ae56a6c]
/usr/lib64/galera/libgalera_smm.so(+0x66f1c)[0x7f554ae56f1c]
/usr/lib64/galera/libgalera_smm.so(+0x66fb9)[0x7f554ae56fb9]
/usr/lib64/galera/libgalera_smm.so(+0x74c46)[0x7f554ae64c46]
/usr/lib64/galera/libgalera_smm.so(+0x12ed0a)[0x7f554af1ed0a]
/usr/lib64/galera/libgalera_smm.so(+0x145191)[0x7f554af35191]
/usr/lib64/galera/libgalera_smm.so(+0x15110c)[0x7f554af4110c]
/lib64/libpthread.so.0(+0x7ea5)[0x7f562404dea5]
/lib64/libc.so.6(clone+0x6d)[0x7f562217696d]
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /var/lib/mysql/datadir
Resource Limits:
Fatal signal 11 while backtracing
2023-11-17 23:56:00 11513011 [Warning] Aborted connection 11513011 to db: 'unconnected' user: 'maxscale' host: '10.29.94.83' (Got an error reading communication packets)
2023-11-17 23:58:49 0 [Note] WSREP: Loading provider /usr/lib64/galera/libgalera_smm.so initial position: e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373279591
2023-11-17 23:58:49 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so'
2023-11-17 23:58:49 0 [Note] WSREP: wsrep_load(): Galera 26.4.5(rb3764ab) by Codership Oy <info@codership.com> loaded successfully.
2023-11-17 23:58:49 0 [Note] WSREP: CRC-32C: using hardware acceleration.
2023-11-17 23:58:49 0 [Note] WSREP: Found saved state: e80cfb73-4188-11ed-9f6d-eb5893c33e43:-1, safe_to_bootstrap: 0
2023-11-17 23:58:49 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 2
UUID: e80cfb73-4188-11ed-9f6d-eb5893c33e43
Seqno: 9360334645 - 9367584762
Offset: 8705631792
Synced: 1
2023-11-17 23:58:49 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: e80cfb73-4188-11ed-9f6d-eb5893c33e43, offset: 8705631792
2023-11-17 23:58:49 0 [Note] WSREP: GCache::RingBuffer initial scan...  0.0% (          0/16106127384 bytes) complete.
2023-11-17 23:58:51 0 [Warning] WSREP: Failed to scan the last segment to the end. Last events may be missing. Last recovered event: e80cfb73-4188-11ed-9f6d-eb5893c33e43:9370907336
2023-11-17 23:58:51 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (16106127384/16106127384 bytes) complete.
2023-11-17 23:58:51 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 9369978429-9370907336
2023-11-17 23:58:51 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...  0.0% (         0/8705580736 bytes) complete.
2023-11-17 23:58:51 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (8705580736/8705580736 bytes) complete.
2023-11-17 23:58:51 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/928908 locked buffers
2023-11-17 23:58:51 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): free space: 7400546624/16106127360
2023-11-17 23:58:51 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/datadir/; base_host = 10.29.95.52; 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/datadir/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 15G; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 64; 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; 
2023-11-17 23:58:51 0 [Note] WSREP: Service thread queue flushed.
2023-11-17 23:58:51 0 [Note] WSREP: ####### Assign initial position for certification: e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373279591, protocol version: -1
2023-11-17 23:58:51 0 [Note] WSREP: GCache history reset: e80cfb73-4188-11ed-9f6d-eb5893c33e43:9370907336 -> e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373279591
2023-11-17 23:58:51 0 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): full reset
2023-11-17 23:58:51 0 [Note] WSREP: Start replication
2023-11-17 23:58:51 0 [Note] WSREP: Connecting with bootstrap option: 0
2023-11-17 23:58:51 0 [Note] WSREP: Setting GCS initial position to e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373279591
2023-11-17 23:58:51 0 [Note] WSREP: protonet asio version 0
2023-11-17 23:58:51 0 [Note] WSREP: Using CRC-32C for message checksums.
2023-11-17 23:58:51 0 [Note] WSREP: initializing ssl context
2023-11-17 23:58:51 0 [Note] WSREP: backend: asio
2023-11-17 23:58:51 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 
2023-11-17 23:58:51 0 [Note] WSREP: restore pc from disk successfully
2023-11-17 23:58:51 0 [Note] WSREP: GMCast version 0
2023-11-17 23:58:51 0 [Note] WSREP: (9da4ac53-b61e, 'ssl://0.0.0.0:4567') listening at ssl://0.0.0.0:4567
2023-11-17 23:58:51 0 [Note] WSREP: (9da4ac53-b61e, 'ssl://0.0.0.0:4567') multicast: , ttl: 1
2023-11-17 23:58:51 0 [Note] WSREP: EVS version 1
2023-11-17 23:58:51 0 [Note] WSREP: gcomm: connecting to group 'DC1PROD', peer '10.29.95.52:,10.29.95.53:,10.29.95.54:,10.29.95.55:,10.29.95.56:'
2023-11-17 23:58:51 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.29.95.53:4567 local endpoint ssl://10.29.95.52:60056 cipher: ECDHE-RSA-AES256-GCM-SHA384 compression: none
2023-11-17 23:58:51 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.29.95.55:4567 local endpoint ssl://10.29.95.52:34748 cipher: ECDHE-RSA-AES256-GCM-SHA384 compression: none
2023-11-17 23:58:51 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.29.95.52:55344 local endpoint ssl://10.29.95.52:4567 cipher: ECDHE-RSA-AES256-GCM-SHA384 compression: none
2023-11-17 23:58:51 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.29.95.52:4567 local endpoint ssl://10.29.95.52:55344 cipher: ECDHE-RSA-AES256-GCM-SHA384 compression: none
2023-11-17 23:58:51 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.29.95.56:4567 local endpoint ssl://10.29.95.52:34786 cipher: ECDHE-RSA-AES256-GCM-SHA384 compression: none
2023-11-17 23:58:51 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.29.95.54:4567 local endpoint ssl://10.29.95.52:46282 cipher: ECDHE-RSA-AES256-GCM-SHA384 compression: none
2023-11-17 23:58:51 0 [Note] WSREP: (9da4ac53-b61e, 'ssl://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address ssl://10.29.95.52:4567
2023-11-17 23:58:51 0 [Note] WSREP: (9da4ac53-b61e, 'ssl://0.0.0.0:4567') connection established to cc9edfe5-8389 ssl://10.29.95.53:4567
2023-11-17 23:58:51 0 [Note] WSREP: (9da4ac53-b61e, 'ssl://0.0.0.0:4567') connection established to fef47869-b4c7 ssl://10.29.95.55:4567
2023-11-17 23:58:51 0 [Note] WSREP: (9da4ac53-b61e, 'ssl://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 
2023-11-17 23:58:51 0 [Note] WSREP: (9da4ac53-b61e, 'ssl://0.0.0.0:4567') connection established to a70eb28d-8cc5 ssl://10.29.95.54:4567
2023-11-17 23:58:51 0 [Note] WSREP: (9da4ac53-b61e, 'ssl://0.0.0.0:4567') connection established to d1bdb5f9-b5bc ssl://10.29.95.56:4567
2023-11-17 23:58:51 0 [Note] WSREP: EVS version upgrade 0 -> 1
2023-11-17 23:58:51 0 [Note] WSREP: declaring a70eb28d-8cc5 at ssl://10.29.95.54:4567 stable
2023-11-17 23:58:51 0 [Note] WSREP: declaring cc9edfe5-8389 at ssl://10.29.95.53:4567 stable
2023-11-17 23:58:51 0 [Note] WSREP: declaring d1bdb5f9-b5bc at ssl://10.29.95.56:4567 stable
2023-11-17 23:58:51 0 [Note] WSREP: declaring fef47869-b4c7 at ssl://10.29.95.55:4567 stable
2023-11-17 23:58:51 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2023-11-17 23:58:51 0 [Note] WSREP: Node a70eb28d-8cc5 state prim
2023-11-17 23:58:51 0 [Note] WSREP: view(view_id(PRIM,9da4ac53-b61e,522) memb {
        9da4ac53-b61e,0
        a70eb28d-8cc5,0
        cc9edfe5-8389,0
        d1bdb5f9-b5bc,0
        fef47869-b4c7,0
} joined {
} left {
} partitioned {
})
2023-11-17 23:58:51 0 [Note] WSREP: save pc into disk
2023-11-17 23:58:51 0 [Note] WSREP: clear restored view
2023-11-17 23:58:52 0 [Note] WSREP: gcomm: connected
2023-11-17 23:58:52 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2023-11-17 23:58:52 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2023-11-17 23:58:52 0 [Note] WSREP: Opened channel 'DC1PROD'
2023-11-17 23:58:52 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 5
2023-11-17 23:58:52 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 7ec3e358-8594-11ee-b7bc-4661676e515d
2023-11-17 23:58:52 1 [Note] WSREP: Starting rollbacker thread 1
2023-11-17 23:58:52 2 [Note] WSREP: Starting applier thread 2
2023-11-17 23:58:52 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 7ec3e358-8594-11ee-b7bc-4661676e515d
2023-11-17 23:58:52 0 [Note] WSREP: STATE EXCHANGE: got state msg: 7ec3e358-8594-11ee-b7bc-4661676e515d from 0 (kiel1-qt-wdb1)
2023-11-17 23:58:52 0 [Note] WSREP: STATE EXCHANGE: got state msg: 7ec3e358-8594-11ee-b7bc-4661676e515d from 1 (kiel1-qt-wdb3)
2023-11-17 23:58:52 0 [Note] WSREP: STATE EXCHANGE: got state msg: 7ec3e358-8594-11ee-b7bc-4661676e515d from 2 (kiel1-qt-wdb2)
2023-11-17 23:58:52 0 [Note] WSREP: STATE EXCHANGE: got state msg: 7ec3e358-8594-11ee-b7bc-4661676e515d from 3 (kiel1-qt-wdb5)
2023-11-17 23:58:52 0 [Note] WSREP: STATE EXCHANGE: got state msg: 7ec3e358-8594-11ee-b7bc-4661676e515d from 4 (kiel1-qt-wdb4)
2023-11-17 23:58:52 0 [Note] WSREP: Quorum results:
        version    = 6,
        component  = PRIMARY,
        conf_id    = 387,
        members    = 4/5 (joined/total),
        act_id     = 9373313938,
        last_appl. = 9373313867,
        protocols  = 2/10/4 (gcs/repl/appl),
        vote policy= 0,
        group UUID = e80cfb73-4188-11ed-9f6d-eb5893c33e43
2023-11-17 23:58:52 0 [Note] WSREP: Flow-control interval: [143, 143]
2023-11-17 23:58:52 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 9373313939)
2023-11-17 23:58:52 2 [Note] WSREP: ####### processing CC 9373313939, local, ordered
2023-11-17 23:58:52 2 [Note] WSREP: Process first view: e80cfb73-4188-11ed-9f6d-eb5893c33e43 my uuid: 9da4ac53-4721-11ee-b61e-171033c2816d
2023-11-17 23:58:52 2 [Note] WSREP: Server kiel1-qt-wdb1 connected to cluster at position e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373313939 with ID 9da4ac53-4721-11ee-b61e-171033c2816d
2023-11-17 23:58:52 2 [Note] WSREP: Server status change disconnected -> connected
2023-11-17 23:58:52 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-17 23:58:52 2 [Note] WSREP: ####### My UUID: 9da4ac53-4721-11ee-b61e-171033c2816d
2023-11-17 23:58:52 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes
2023-11-17 23:58:52 0 [Note] WSREP: Service thread queue flushed.
2023-11-17 23:58:52 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2023-11-17 23:58:52 2 [Note] WSREP: State transfer required: 
        Group state: e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373313939
        Local state: e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373279591
2023-11-17 23:58:52 2 [Note] WSREP: Server status change connected -> joiner
2023-11-17 23:58:52 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-17 23:58:52 0 [Note] WSREP: Joiner monitor thread started to monitor
2023-11-17 23:58:52 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '10.29.95.52' --datadir '/var/lib/mysql/datadir/' --parent '54724' --binlog '/binlogs/mysql-bin' --mysqld-args --wsrep_start_position=e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373279591'
WSREP_SST: [INFO] Streaming with xbstream (20231117 23:58:52.561)
WSREP_SST: [INFO] Using socat as streamer (20231117 23:58:52.564)
WSREP_SST: [INFO] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr stdio | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20231117 23:58:52.597)
2023-11-17 23:58:52 2 [Note] WSREP: Prepared SST request: mariabackup|10.29.95.52:4444/xtrabackup_sst//1
2023-11-17 23:58:52 2 [Note] WSREP: ####### IST uuid:e80cfb73-4188-11ed-9f6d-eb5893c33e43 f: 9373279592, l: 9373313939, STRv: 3
2023-11-17 23:58:52 2 [Note] WSREP: IST receiver addr using ssl://10.29.95.52:4568
2023-11-17 23:58:52 2 [Note] WSREP: IST receiver using ssl
2023-11-17 23:58:52 2 [Note] WSREP: Prepared IST receiver for 9373279592-9373313939, listening at: ssl://10.29.95.52:4568
2023-11-17 23:58:52 0 [Note] WSREP: Member 0.0 (kiel1-qt-wdb1) requested state transfer from 'kiel1-qt-wdb2,kiel1-qt-wdb3,'. Selected 1.0 (kiel1-qt-wdb3)(SYNCED) as donor.
2023-11-17 23:58:52 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 9373314128)
2023-11-17 23:58:52 2 [Note] WSREP: Requesting state transfer: success, donor: 1
2023-11-17 23:58:53 0 [Note] WSREP: 1.0 (kiel1-qt-wdb3): State transfer to 0.0 (kiel1-qt-wdb1) complete.
2023-11-17 23:58:53 0 [Note] WSREP: Member 1.0 (kiel1-qt-wdb3) synced with group.
WSREP_SST: [INFO] xtrabackup_ist received from donor: Running IST (20231117 23:58:53.119)
WSREP_SST: [INFO] Galera co-ords from recovery: e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373279591 0 (20231117 23:58:53.123)
WSREP_SST: [INFO] Total time on joiner: 0 seconds (20231117 23:58:53.127)
WSREP_SST: [INFO] Removing the sst_in_progress file (20231117 23:58:53.129)
2023-11-17 23:58:53 3 [Note] WSREP: SST received
2023-11-17 23:58:53 3 [Note] WSREP: Server status change joiner -> initializing
2023-11-17 23:58:53 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-17 23:58:53 0 [Note] CONNECT: Version 1.07.0001 November 12, 2019
2023-11-17 23:58:53 0 [Note] InnoDB: Using Linux native AIO
2023-11-17 23:58:53 0 [Note] InnoDB: Uses event mutexes
2023-11-17 23:58:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2023-11-17 23:58:53 0 [Note] InnoDB: Number of pools: 1
2023-11-17 23:58:53 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
2023-11-17 23:58:53 0 [Note] InnoDB: Initializing buffer pool, total size = 386547056640, chunk size = 134217728
2023-11-17 23:58:55 0 [Note] WSREP: (9da4ac53-b61e, 'ssl://0.0.0.0:4567') turning message relay requesting off
2023-11-17 23:58:55 0 [Note] WSREP: (9da4ac53-b61e, 'ssl://0.0.0.0:4567') turning message relay requesting off
2023-11-17 23:59:04 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-17 23:59:04 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2023-11-17 23:59:05 0 [Note] InnoDB: 128 rollback segments are active.
2023-11-17 23:59:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-17 23:59:05 0 [Note] InnoDB: Setting file '/var/lib/mysql/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-17 23:59:05 0 [Note] InnoDB: File '/var/lib/mysql/innodb/ibtmp1' size is now 12 MB.
2023-11-17 23:59:05 0 [Note] InnoDB: 10.5.6 started; log sequence number 57817200559489; transaction id 45334754891
2023-11-17 23:59:05 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/innodb/ib_buffer_pool
2023-11-17 23:59:05 0 [Note] InnoDB: Cannot open '/var/lib/mysql/innodb/ib_buffer_pool' for reading: No such file or directory
2023-11-17 23:59:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-17 23:59:05 0 [ERROR] mariadbd: Plugin 'unix_socket' already installed
231117 23:59:05 server_audit: server_audit_excl_users set to 'backup,bssapi,cdt,db_cal,dbssprov,django,keycloak,maxscale,mnpservice,pamela,replica,webdb'.
231117 23:59:05 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED.
231117 23:59:05 server_audit: logging started to the file server_audit.log.
2023-11-17 23:59:05 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-11-17 23:59:05 0 [Warning] 'proxies_priv' entry '@% root@kiel1-qt-wdb1' ignored in --skip-name-resolve mode.
2023-11-17 23:59:05 0 [Note] WSREP: wsrep_init_schema_and_SR 0x0
2023-11-17 23:59:05 0 [Note] WSREP: Server initialized
2023-11-17 23:59:05 0 [Note] WSREP: Server status change initializing -> initialized
2023-11-17 23:59:05 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-17 23:59:05 3 [Note] WSREP: Server status change initialized -> joined
2023-11-17 23:59:05 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-17 23:59:05 3 [Note] WSREP: Recovered position from storage: e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373279591
2023-11-17 23:59:05 12 [Note] WSREP: Starting applier thread 12
2023-11-17 23:59:05 29 [Note] WSREP: Starting applier thread 29
2023-11-17 23:59:05 35 [Note] WSREP: Starting applier thread 35
2023-11-17 23:59:05 7 [Note] WSREP: Starting applier thread 7
2023-11-17 23:59:05 33 [Note] WSREP: Starting applier thread 33
2023-11-17 23:59:05 17 [Note] WSREP: Starting applier thread 17
2023-11-17 23:59:05 31 [Note] WSREP: Starting applier thread 31
2023-11-17 23:59:05 19 [Note] WSREP: Starting applier thread 19
2023-11-17 23:59:05 44 [Note] WSREP: Starting applier thread 44
2023-11-17 23:59:05 6 [Note] WSREP: Starting applier thread 6
2023-11-17 23:59:05 24 [Note] WSREP: Starting applier thread 24
2023-11-17 23:59:05 21 [Note] WSREP: Starting applier thread 21
2023-11-17 23:59:05 18 [Note] WSREP: Starting applier thread 18
2023-11-17 23:59:05 26 [Note] WSREP: Starting applier thread 26
2023-11-17 23:59:05 23 [Note] WSREP: Starting applier thread 23
2023-11-17 23:59:05 47 [Note] WSREP: Starting applier thread 47
2023-11-17 23:59:05 9 [Note] WSREP: Starting applier thread 9
2023-11-17 23:59:05 50 [Note] WSREP: Starting applier thread 50
2023-11-17 23:59:05 11 [Note] WSREP: Starting applier thread 11
2023-11-17 23:59:05 36 [Note] WSREP: Starting applier thread 36
2023-11-17 23:59:05 37 [Note] WSREP: Starting applier thread 37
2023-11-17 23:59:05 42 [Note] WSREP: Starting applier thread 42
2023-11-17 23:59:05 14 [Note] WSREP: Starting applier thread 14
2023-11-17 23:59:05 27 [Note] WSREP: Starting applier thread 27
2023-11-17 23:59:05 20 [Note] WSREP: Starting applier thread 20
2023-11-17 23:59:05 30 [Note] WSREP: Starting applier thread 30
2023-11-17 23:59:05 34 [Note] WSREP: Starting applier thread 34
2023-11-17 23:59:05 41 [Note] WSREP: Starting applier thread 41
2023-11-17 23:59:05 25 [Note] WSREP: Starting applier thread 25
2023-11-17 23:59:05 3 [Note] WSREP: Recovered view from SST:
  id: e80cfb73-4188-11ed-9f6d-eb5893c33e43:9308210403
  status: primary
  protocol_version: 4
  capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
  final: no
  own_index: -1
  members(5):
        0: 9da4ac53-4721-11ee-b61c-171033c2816d, kiel1-qt-wdb1
        1: a70eb28d-4721-11ee-8cc5-baf94f65d88e, kiel1-qt-wdb3
        2: cc9edfe5-2732-11ee-8389-dbd9f1531d04, kiel1-qt-wdb2
        3: d1bdb5f9-640a-11ee-b5bc-0ba8e53eaa68, kiel1-qt-wdb5
        4: fef47869-3c67-11ee-b4c7-22942cb9efa0, kiel1-qt-wdb4
2023-11-17 23:59:05 46 [Note] WSREP: Starting applier thread 46
2023-11-17 23:59:05 43 [Note] WSREP: Starting applier thread 43
2023-11-17 23:59:05 13 [Note] WSREP: Starting applier thread 13
2023-11-17 23:59:05 22 [Note] WSREP: Starting applier thread 22
2023-11-17 23:59:05 38 [Note] WSREP: Starting applier thread 38
2023-11-17 23:59:05 0 [Note] Reading of all Master_info entries succeeded
2023-11-17 23:59:05 40 [Note] WSREP: Starting applier thread 40
2023-11-17 23:59:05 48 [Note] WSREP: Starting applier thread 48
2023-11-17 23:59:05 10 [Note] WSREP: Starting applier thread 10
2023-11-17 23:59:05 28 [Note] WSREP: Starting applier thread 28
2023-11-17 23:59:05 32 [Note] WSREP: Starting applier thread 32
2023-11-17 23:59:05 51 [Note] WSREP: Starting applier thread 51
2023-11-17 23:59:05 45 [Note] WSREP: Starting applier thread 45
2023-11-17 23:59:05 16 [Note] WSREP: Starting applier thread 16
2023-11-17 23:59:05 49 [Note] WSREP: Starting applier thread 49
2023-11-17 23:59:05 53 [Note] WSREP: Starting applier thread 53
2023-11-17 23:59:05 39 [Note] WSREP: Starting applier thread 39
2023-11-17 23:59:05 15 [Note] WSREP: Starting applier thread 15
2023-11-17 23:59:05 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-17 23:59:05 0 [Note] Added new Master_info '' to hash table
2023-11-17 23:59:05 0 [Note] /usr/sbin/mariadbd: ready for connections.
Version: '10.5.6-MariaDB-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
2023-11-17 23:59:05 55 [Note] WSREP: Recovered cluster id e80cfb73-4188-11ed-9f6d-eb5893c33e43
2023-11-17 23:59:05 3 [Note] WSREP: SST received: e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373279591
2023-11-17 23:59:05 0 [Note] WSREP: Joiner monitor thread ended with total time 13 sec
2023-11-17 23:59:05 2 [Note] WSREP: Installed new state from SST: e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373279591
2023-11-17 23:59:05 2 [Note] WSREP: Receiving IST: 34348 writesets, seqnos 9373279592-9373313939
2023-11-17 23:59:05 0 [Note] WSREP: ####### IST applying starts with 9373279592
2023-11-17 23:59:05 0 [Note] WSREP: ####### IST current seqno initialized to 9373279592
2023-11-17 23:59:05 0 [Note] WSREP: Receiving IST...  0.0% (    0/34348 events) complete.
2023-11-17 23:59:05 0 [Note] WSREP: Service thread queue flushed.
2023-11-17 23:59:05 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:9373279591, protocol version: 5
2023-11-17 23:59:05 0 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-17 23:59:05 0 [Note] WSREP: ####### Adjusting cert position: 9373279591 -> 9373279593
2023-11-17 23:59:05 0 [Note] WSREP: Service thread queue flushed.
2023-11-17 23:59:05 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 9373279593
2023-11-17 23:59:05 0 [Note] WSREP: Min available from gcache for CC from ist: 9373279592
2023-11-17 23:59:05 29 [Note] WSREP: ================================================
View:
  id: e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373279593
  status: primary
  protocol_version: 4
  capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
  final: no
  own_index: -1
  members(4):
        0: a70eb28d-4721-11ee-8cc5-baf94f65d88e, kiel1-qt-wdb3
        1: cc9edfe5-2732-11ee-8389-dbd9f1531d04, kiel1-qt-wdb2
        2: d1bdb5f9-640a-11ee-b5bc-0ba8e53eaa68, kiel1-qt-wdb5
        3: fef47869-3c67-11ee-b4c7-22942cb9efa0, kiel1-qt-wdb4
=================================================
2023-11-17 23:59:05 29 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-17 23:59:05 0 [Note] WSREP: IST preload starting at 9373313868
2023-11-17 23:59:11 0 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-17 23:59:11 0 [Note] WSREP: ####### Adjusting cert position: 9373313938 -> 9373313939
2023-11-17 23:59:11 0 [Note] WSREP: Service thread queue flushed.
2023-11-17 23:59:11 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 9373313868
2023-11-17 23:59:11 0 [Note] WSREP: Min available from gcache for CC from ist: 9373279592
2023-11-17 23:59:11 0 [Note] WSREP: Receiving IST...100.0% (34348/34348 events) complete.
2023-11-17 23:59:11 19 [Note] WSREP: ================================================
View:
  id: e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373313939
  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(5):
        0: 9da4ac53-4721-11ee-b61e-171033c2816d, kiel1-qt-wdb1
        1: a70eb28d-4721-11ee-8cc5-baf94f65d88e, kiel1-qt-wdb3
        2: cc9edfe5-2732-11ee-8389-dbd9f1531d04, kiel1-qt-wdb2
        3: d1bdb5f9-640a-11ee-b5bc-0ba8e53eaa68, kiel1-qt-wdb5
        4: fef47869-3c67-11ee-b4c7-22942cb9efa0, kiel1-qt-wdb4
=================================================
2023-11-17 23:59:11 19 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-17 23:59:11 2 [Note] WSREP: Draining apply monitors after IST up to 9373313939
2023-11-17 23:59:11 2 [Note] WSREP: IST received: e80cfb73-4188-11ed-9f6d-eb5893c33e43:9373313939
2023-11-17 23:59:11 2 [Note] WSREP: Lowest cert index boundary for CC from sst: 9373313868
2023-11-17 23:59:11 2 [Note] WSREP: Min available from gcache for CC from sst: 9373279592
2023-11-17 23:59:11 0 [Note] WSREP: 0.0 (kiel1-qt-wdb1): State transfer from 1.0 (kiel1-qt-wdb3) complete.
2023-11-17 23:59:11 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 9373317456)
2023-11-17 23:59:12 0 [Note] WSREP: Member 0.0 (kiel1-qt-wdb1) synced with group.
2023-11-17 23:59:12 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 9373317539)
2023-11-17 23:59:12 15 [Note] WSREP: Server kiel1-qt-wdb1 synced with group
2023-11-17 23:59:12 15 [Note] WSREP: Server status change joined -> synced
2023-11-17 23:59:12 15 [Note] WSREP: Synchronized with group, ready for connections
2023-11-17 23:59:12 15 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-17 23:59:27 1444 [Note] InnoDB: Number of pools: 2
2023-11-18  0:00:07 2622 [Note] InnoDB: Number of pools: 3
2023-11-18  0:00:17 4128 [Note] InnoDB: Number of pools: 4
2023-11-18  0:01:07 5840 [Note] InnoDB: Number of pools: 5