2023-08-31 9:17:46 1023 [ERROR] WSREP: FSM: no such a transition APPLYING -> COMMITTED 230831 9:17:46 [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.6.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=18 max_threads=1002 thread_count=17 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2337543 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f36a00008e8 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 = 0x7f3d4f7b2b98 thread_stack 0x49000 ??:0(my_print_stacktrace)[0x55fa30f2833e] ??:0(handle_fatal_signal)[0x55fa30a08295] ??:0(__restore_rt)[0x7f3d83f5fd40] :0(__GI_raise)[0x7f3d832bbb8f] :0(__GI_abort)[0x7f3d8328eea5] src/fsm.hpp:56(galera::FSM::shift_to(galera::TrxHandle::State, int))[0x7f3d792a84c5] src/replicator_smm.cpp:1438(galera::ReplicatorSMM::commit_order_leave(galera::TrxHandleSlave&, wsrep_buf const*))[0x7f3d792c206f] src/wsrep_provider.cpp:828(galera_commit_order_leave)[0x7f3d792a1aba] ??:0(wsrep::wsrep_provider_v26::commit_order_leave(wsrep::ws_handle const&, wsrep::ws_meta const&, wsrep::mutable_buffer const&))[0x55fa30fca75c] ??:0(wsrep::transaction::ordered_commit())[0x55fa30fc0229] ??:0(MYSQL_BIN_LOG::queue_for_group_commit(MYSQL_BIN_LOG::group_commit_entry*))[0x55fa30af00ab] ??:0(MYSQL_BIN_LOG::write_transaction_to_binlog_events(MYSQL_BIN_LOG::group_commit_entry*))[0x55fa30af640a] ??:0(MYSQL_BIN_LOG::write_transaction_to_binlog(THD*, binlog_cache_mngr*, Log_event*, bool, bool, bool, bool))[0x55fa30af69d2] ??:0(MYSQL_BIN_LOG::write_transaction_to_binlog(THD*, binlog_cache_mngr*, Log_event*, bool, bool, bool, bool))[0x55fa30af6ac9] ??:0(MYSQL_BIN_LOG::write_transaction_to_binlog(THD*, binlog_cache_mngr*, Log_event*, bool, bool, bool, bool))[0x55fa30af6cab] ??:0(MYSQL_BIN_LOG::write_transaction_to_binlog(THD*, binlog_cache_mngr*, Log_event*, bool, bool, bool, bool))[0x55fa30af709f] ??:0(ha_rollback_trans(THD*, bool))[0x55fa30a0c560] ??:0(ha_commit_trans(THD*, bool))[0x55fa30a0d349] ??:0(trans_commit_stmt(THD*))[0x55fa30901733] ??:0(mysql_execute_command(THD*, bool))[0x55fa307f4528] ??:0(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55fa3074efa8] ??:0(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55fa307569c9] ??:0(sp_instr_stmt::execute(THD*, unsigned int*))[0x55fa307573f5] ??:0(sp_head::execute(THD*, bool))[0x55fa307523f7] ??:0(sp_head::execute_procedure(THD*, List*))[0x55fa30753a9a] ??:0(LEX::mark_first_table_as_inserting())[0x55fa307ec659] ??:0(Sql_cmd_call::execute(THD*))[0x55fa307efa96] ??:0(mysql_execute_command(THD*, bool))[0x55fa307f5519] ??:0(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55fa307e7703] ??:0(mysql_init_multi_delete(LEX*))[0x55fa307e71ab] ??:0(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55fa307f25ea] ??:0(do_command(THD*, bool))[0x55fa307f2ed0] ??:0(do_handle_one_connection(CONNECT*, bool))[0x55fa308f20e7] ??:0(handle_one_connection)[0x55fa308f242d] ??:0(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x55fa30c2a13d] ??:0(start_thread)[0x7f3d83f551da] :0(__GI___clone)[0x7f3d832a6e73] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f36a002ca08): INSERT INTO SMS_PORT_REQUESTS ( DATE_ENTERED, MOBILE, CSS_DB, EXCH, NODEID, TERM_START ) VALUES ( SYSDATE(), NAME_CONST('MOBILE_IN',_latin1'07483437881' COLLATE 'latin1_swedish_ci'), NAME_CONST('DB_IN',_latin1'EA' COLLATE 'latin1_swedish_ci'), NAME_CONST('EXCH_IN',_latin1'NWS' COLLATE 'latin1_swedish_ci'), NAME_CONST('NODEID_IN',_latin1'NMCNFP' COLLATE 'latin1_swedish_ci'), NAME_CONST('TERMSTART_IN',8) ) Connection ID (thread ID): 1023 Status: KILL_QUERY 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,not_null_range_scan=off 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 /data/mariadata/mysql Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size 8388608 unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes 127401 127401 processes Max open files 32768 32768 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 127401 127401 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: |/opt/dynatrace/oneagent/agent/rdp -p %p -P %P -c %c -e %e -s %s -a %P %u %g %s %t %c %h %e Kernel version: Linux version 4.18.0-477.15.1.el8_8.x86_64 (mockbuild@host-100-100-224-19) (gcc version 8.5.0 20210514 (Red Hat 8.5.0-18.0.2) (GCC)) #1 SMP Thu Jul 20 11:31:48 PDT 2023 2023-08-31 9:17:53 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024735 2023-08-31 9:17:53 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so' 2023-08-31 9:17:53 0 [Note] WSREP: wsrep_load(): Galera 26.4.13(rfe497aeb) by Codership Oy loaded successfully. 2023-08-31 9:17:53 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration. 2023-08-31 9:17:53 0 [Note] WSREP: Found saved state: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:-1, safe_to_bootstrap: 0 2023-08-31 9:17:53 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05 Seqno: -1 - -1 Offset: -1 Synced: 0 2023-08-31 9:17:53 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05, offset: -1 2023-08-31 9:17:53 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/524288024 bytes) complete. 2023-08-31 9:17:53 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (524288024/524288024 bytes) complete. 2023-08-31 9:17:53 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 16020836-16024743 2023-08-31 9:17:53 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/516464000 bytes) complete. 2023-08-31 9:17:53 0 [Note] WSREP: Recovering GCache ring buffer: found 0/3908 locked buffers 2023-08-31 9:17:53 0 [Note] WSREP: Recovering GCache ring buffer: free space: 7824000/524288000 2023-08-31 9:17:53 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (516464000/516464000 bytes) complete. 2023-08-31 9:17:53 0 [Note] WSREP: Passing config to GCS: base_dir = /data/mariadata/mysql/; base_host = 10.13.237.30; 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 = /data/mariadata/mysql/; gcache.keep_pages_size = 0; gcache.keep_plaintext_size = 500M; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 500M; gcache.recover = yes; gcache.size = 500M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.fc_single_primary = 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; gmcas 2023-08-31 9:17:53 0 [Note] WSREP: Service thread queue flushed. 2023-08-31 9:17:53 0 [Note] WSREP: ####### Assign initial position for certification: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024735, protocol version: -1 2023-08-31 9:17:53 0 [Note] WSREP: Start replication 2023-08-31 9:17:53 0 [Note] WSREP: Connecting with bootstrap option: 0 2023-08-31 9:17:53 0 [Note] WSREP: Setting GCS initial position to c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024735 2023-08-31 9:17:53 0 [Note] WSREP: protonet asio version 0 2023-08-31 9:17:53 0 [Note] WSREP: Using CRC-32C for message checksums. 2023-08-31 9:17:53 0 [Note] WSREP: backend: asio 2023-08-31 9:17:53 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2023-08-31 9:17:53 0 [Note] WSREP: restore pc from disk successfully 2023-08-31 9:17:53 0 [Note] WSREP: GMCast version 0 2023-08-31 9:17:53 0 [Note] WSREP: (902a3da4-af60, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2023-08-31 9:17:53 0 [Note] WSREP: (902a3da4-af60, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2023-08-31 9:17:53 0 [Note] WSREP: EVS version 1 2023-08-31 9:17:53 0 [Note] WSREP: gcomm: connecting to group 'galera-prod', peer '10.13.237.28:,10.13.237.29:,10.13.237.30:' 2023-08-31 9:17:53 0 [Note] WSREP: (902a3da4-af60, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://10.13.237.30:4567 2023-08-31 9:17:53 0 [Note] WSREP: (902a3da4-af60, 'tcp://0.0.0.0:4567') connection established to 213ecf6f-a3a9 tcp://10.13.237.29:4567 2023-08-31 9:17:53 0 [Note] WSREP: (902a3da4-af60, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2023-08-31 9:17:53 0 [Note] WSREP: (902a3da4-af60, 'tcp://0.0.0.0:4567') connection established to a564b541-b726 tcp://10.13.237.28:4567 2023-08-31 9:17:53 0 [Note] WSREP: EVS version upgrade 0 -> 1 2023-08-31 9:17:53 0 [Note] WSREP: declaring 213ecf6f-a3a9 at tcp://10.13.237.29:4567 stable 2023-08-31 9:17:53 0 [Note] WSREP: declaring a564b541-b726 at tcp://10.13.237.28:4567 stable 2023-08-31 9:17:53 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2023-08-31 9:17:53 0 [Note] WSREP: Node 213ecf6f-a3a9 state prim 2023-08-31 9:17:53 0 [Note] WSREP: view(view_id(PRIM,213ecf6f-a3a9,15) memb { 213ecf6f-a3a9,0 902a3da4-af60,0 a564b541-b726,0 } joined { } left { } partitioned { }) 2023-08-31 9:17:53 0 [Note] WSREP: save pc into disk 2023-08-31 9:17:53 0 [Note] WSREP: clear restored view 2023-08-31 9:17:54 0 [Note] WSREP: gcomm: connected 2023-08-31 9:17:54 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2023-08-31 9:17:54 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2023-08-31 9:17:54 0 [Note] WSREP: Opened channel 'galera-prod' 2023-08-31 9:17:54 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3 2023-08-31 9:17:54 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2023-08-31 9:17:54 0 [Note] WSREP: STATE EXCHANGE: sent state msg: e2446d06-47d6-11ee-b907-6a13be9447a4 2023-08-31 9:17:54 0 [Note] WSREP: STATE EXCHANGE: got state msg: e2446d06-47d6-11ee-b907-6a13be9447a4 from 0 (blp21152017) 2023-08-31 9:17:54 0 [Note] WSREP: STATE EXCHANGE: got state msg: e2446d06-47d6-11ee-b907-6a13be9447a4 from 2 (blp21152016) 2023-08-31 9:17:54 1 [Note] WSREP: Starting rollbacker thread 1 2023-08-31 9:17:54 2 [Note] WSREP: Starting applier thread 2 2023-08-31 9:17:54 0 [Note] WSREP: STATE EXCHANGE: got state msg: e2446d06-47d6-11ee-b907-6a13be9447a4 from 1 (blp21152018) 2023-08-31 9:17:54 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 14, members = 2/3 (joined/total), act_id = 16024760, last_appl. = 16024724, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05 2023-08-31 9:17:54 0 [Note] WSREP: Flow-control interval: [28, 28] 2023-08-31 9:17:54 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 16024761) 2023-08-31 9:17:54 2 [Note] WSREP: ####### processing CC 16024761, local, ordered 2023-08-31 9:17:54 2 [Note] WSREP: Process first view: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05 my uuid: 902a3da4-3f15-11ee-af60-b706fe188821 2023-08-31 9:17:54 2 [Note] WSREP: Server blp21152018 connected to cluster at position c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024761 with ID 902a3da4-3f15-11ee-af60-b706fe188821 2023-08-31 9:17:54 2 [Note] WSREP: Server status change disconnected -> connected 2023-08-31 9:17:54 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-08-31 9:17:54 2 [Note] WSREP: ####### My UUID: 902a3da4-3f15-11ee-af60-b706fe188821 2023-08-31 9:17:54 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes 2023-08-31 9:17:54 0 [Note] WSREP: Service thread queue flushed. 2023-08-31 9:17:54 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2023-08-31 9:17:54 2 [Note] WSREP: State transfer required: Group state: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024761 Local state: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024735 2023-08-31 9:17:54 2 [Note] WSREP: Server status change connected -> joiner 2023-08-31 9:17:54 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-08-31 9:17:54 0 [Note] WSREP: Joiner monitor thread started to monitor 2023-08-31 9:17:54 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '10.13.237.30' --datadir '/data/mariadata/mysql/' --parent 2581250 --progress 0 --binlog '/data/mariadata/binlogs/mariadb-bin' --mysqld-args --wsrep_start_position=c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024735,5-1-16024123' WSREP_SST: [INFO] rsync SST started on joiner (20230831 09:17:54.527) 2023-08-31 9:17:54 2 [Note] WSREP: ####### IST uuid:c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05 f: 16024736, l: 16024761, STRv: 3 2023-08-31 9:17:54 2 [Note] WSREP: IST receiver addr using tcp://10.13.237.30:4568 2023-08-31 9:17:54 2 [Note] WSREP: Prepared IST receiver for 16024736-16024761, listening at: tcp://10.13.237.30:4568 2023-08-31 9:17:54 0 [Note] WSREP: Member 1.0 (blp21152018) requested state transfer from '*any*'. Selected 0.0 (blp21152017)(SYNCED) as donor. 2023-08-31 9:17:54 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 16024762) 2023-08-31 9:17:54 2 [Note] WSREP: Requesting state transfer: success, donor: 0 2023-08-31 9:17:55 0 [Note] WSREP: 0.0 (blp21152017): State transfer to 1.0 (blp21152018) complete. 2023-08-31 9:17:55 0 [Note] WSREP: Member 0.0 (blp21152017) synced with group. WSREP_SST: [INFO] Galera co-ords from recovery: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024735 5 (20230831 09:17:55.808) WSREP_SST: [INFO] rsync IST completed on joiner (20230831 09:17:55.811) WSREP_SST: [INFO] Joiner cleanup: rsync PID=2581380, stunnel PID=0 (20230831 09:17:55.815) WSREP_SST: [INFO] Joiner cleanup done. (20230831 09:17:56.359) 2023-08-31 9:17:56 3 [Note] WSREP: SST received 2023-08-31 9:17:56 3 [Note] WSREP: Server status change joiner -> initializing 2023-08-31 9:17:56 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-08-31 9:17:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-08-31 9:17:56 0 [Note] InnoDB: Number of pools: 1 2023-08-31 9:17:56 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-08-31 9:17:56 0 [Note] InnoDB: Using Linux native AIO 2023-08-31 9:17:56 0 [Note] InnoDB: Initializing buffer pool, total size = 25769803776, chunk size = 134217728 2023-08-31 9:17:56 0 [Note] InnoDB: Completed initialization of buffer pool 2023-08-31 9:17:56 0 [Note] InnoDB: 128 rollback segments are active. 2023-08-31 9:17:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2023-08-31 9:17:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2023-08-31 9:17:56 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2023-08-31 9:17:56 0 [Note] InnoDB: 10.6.11 started; log sequence number 1480374449537; transaction id 60696287 2023-08-31 9:17:56 0 [Note] InnoDB: Loading buffer pool(s) from /data/mariadata/mysql/ib_buffer_pool 2023-08-31 9:17:56 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-08-31 9:17:56 0 [Note] Server socket created on IP: '0.0.0.0'. 2023-08-31 9:17:56 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2023-08-31 9:17:56 0 [Note] WSREP: Server initialized 2023-08-31 9:17:56 0 [Note] WSREP: Server status change initializing -> initialized 2023-08-31 9:17:56 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-08-31 9:17:56 3 [Note] WSREP: Recovered position from storage: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024735 2023-08-31 9:17:56 3 [Note] WSREP: Recovered view from SST: id: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:15936645 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: -1 members(3): 0: 213ecf6f-3f1b-11ee-a3a9-1b9e106b662b, blp21152017 1: 902a3da4-3f15-11ee-af5f-b706fe188821, blp21152018 2: a564b541-3eca-11ee-b726-a2aa4392ef31, blp21152016 2023-08-31 9:17:56 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-08-31 9:17:56 7 [Note] WSREP: Starting applier thread 7 2023-08-31 9:17:56 9 [Note] WSREP: Starting applier thread 9 2023-08-31 9:17:56 11 [Note] WSREP: Recovered cluster id c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05 2023-08-31 9:17:56 6 [Note] WSREP: Starting applier thread 6 2023-08-31 9:17:56 0 [Note] /usr/sbin/mariadbd: ready for connections. Version: '10.6.11-MariaDB-log' socket: '/data/mariadata/mysql/mysql.sock' port: 3306 MariaDB Server 2023-08-31 9:17:56 3 [Note] WSREP: SST received: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024735 2023-08-31 9:17:56 3 [Note] WSREP: SST succeeded for position c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024735 2023-08-31 9:17:56 0 [Note] WSREP: Joiner monitor thread ended with total time 2 sec 2023-08-31 9:17:56 2 [Note] WSREP: Installed new state from SST: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024735 2023-08-31 9:17:56 2 [Note] WSREP: Receiving IST: 26 writesets, seqnos 16024736-16024761 2023-08-31 9:17:56 0 [Note] WSREP: ####### IST applying starts with 16024736 2023-08-31 9:17:56 0 [Note] WSREP: ####### IST current seqno initialized to 16024724 2023-08-31 9:17:56 0 [Note] WSREP: Receiving IST... 0.0% ( 0/38 events) complete. 2023-08-31 9:17:56 0 [Note] WSREP: IST preload starting at 16024724 2023-08-31 9:17:56 0 [Note] WSREP: Service thread queue flushed. 2023-08-31 9:17:56 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:16024723, protocol version: 5 2023-08-31 9:17:56 0 [Note] InnoDB: Buffer pool(s) load completed at 230831 9:17:56 2023-08-31 9:17:56 0 [Note] WSREP: (902a3da4-af60, 'tcp://0.0.0.0:4567') turning message relay requesting off 2023-08-31 9:18:00 0 [Note] WSREP: REPL Protocols: 10 (5) 2023-08-31 9:18:00 0 [Note] WSREP: ####### Adjusting cert position: 16024759 -> 16024760 2023-08-31 9:18:00 0 [Note] WSREP: Service thread queue flushed. 2023-08-31 9:18:00 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 16024724 2023-08-31 9:18:00 0 [Note] WSREP: Min available from gcache for CC from ist: 16020836 2023-08-31 9:18:00 7 [Note] WSREP: ================================================ View: id: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024760 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(2): 0: 213ecf6f-3f1b-11ee-a3a9-1b9e106b662b, blp21152017 1: a564b541-3eca-11ee-b726-a2aa4392ef31, blp21152016 ================================================= 2023-08-31 9:18:00 7 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-08-31 9:18:00 0 [Note] WSREP: REPL Protocols: 10 (5) 2023-08-31 9:18:00 0 [Note] WSREP: ####### Adjusting cert position: 16024760 -> 16024761 2023-08-31 9:18:00 0 [Note] WSREP: Service thread queue flushed. 2023-08-31 9:18:00 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 16024724 2023-08-31 9:18:00 0 [Note] WSREP: Min available from gcache for CC from ist: 16020836 2023-08-31 9:18:00 0 [Note] WSREP: Receiving IST...100.0% (38/38 events) complete. 2023-08-31 9:18:00 9 [Note] WSREP: ================================================ View: id: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024761 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 1 members(3): 0: 213ecf6f-3f1b-11ee-a3a9-1b9e106b662b, blp21152017 1: 902a3da4-3f15-11ee-af60-b706fe188821, blp21152018 2: a564b541-3eca-11ee-b726-a2aa4392ef31, blp21152016 ================================================= 2023-08-31 9:18:00 9 [Note] WSREP: Server status change initialized -> joined 2023-08-31 9:18:00 9 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-08-31 9:18:00 9 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-08-31 9:18:00 2 [Note] WSREP: Draining apply monitors after IST up to 16024761 2023-08-31 9:18:00 2 [Note] WSREP: IST received: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:16024761 2023-08-31 9:18:00 2 [Note] WSREP: Lowest cert index boundary for CC from sst: 16024724 2023-08-31 9:18:00 2 [Note] WSREP: Min available from gcache for CC from sst: 16020836 2023-08-31 9:18:00 0 [Note] WSREP: 1.0 (blp21152018): State transfer from 0.0 (blp21152017) complete. 2023-08-31 9:18:00 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 16024766) 2023-08-31 9:18:00 0 [Note] WSREP: Processing event queue:... 0.0% (0/3 events) complete. 2023-08-31 9:18:00 0 [Note] WSREP: Member 1.0 (blp21152018) synced with group. 2023-08-31 9:18:00 0 [Note] WSREP: Processing event queue:...100.0% (4/4 events) complete. 2023-08-31 9:18:00 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 16024766) 2023-08-31 9:18:00 7 [Note] WSREP: Server blp21152018 synced with group 2023-08-31 9:18:00 7 [Note] WSREP: Server status change joined -> synced 2023-08-31 9:18:00 7 [Note] WSREP: Synchronized with group, ready for connections 2023-08-31 9:18:00 7 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-08-31 9:53:53 12 [Warning] Aborted connection 12 to db: 'sdautomation' user: 'SDUSER' host: 'blp21152024.iuser.iroot.adidom.com' (Got an error reading communication packets)