230911 21:50:25 [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=940 max_threads=1002 thread_count=52 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: 0x55ba202f3d18 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 = 0x7f28ff5bdb98 thread_stack 0x49000 Can't start addr2line /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x55ba1d44133e] /usr/sbin/mariadbd(handle_fatal_signal+0x485)[0x55ba1cf21295] /lib64/libpthread.so.0(+0x12d40)[0x7f29446f7d40] /lib64/libc.so.6(gsignal+0x10f)[0x7f2943a53b8f] /lib64/libc.so.6(abort+0x127)[0x7f2943a26ea5] /usr/lib64/galera-4/libgalera_smm.so(+0x504c5)[0x7f2939a404c5] /usr/lib64/galera-4/libgalera_smm.so(+0x6a06f)[0x7f2939a5a06f] /usr/lib64/galera-4/libgalera_smm.so(+0x49aba)[0x7f2939a39aba] /usr/sbin/mariadbd(_ZN5wsrep18wsrep_provider_v2618commit_order_leaveERKNS_9ws_handleERKNS_7ws_metaERKNS_14mutable_bufferE+0x7c)[0x55ba1d4e375c] /usr/sbin/mariadbd(_ZN5wsrep11transaction14ordered_commitEv+0xb9)[0x55ba1d4d9229] /usr/sbin/mariadbd(_ZN13MYSQL_BIN_LOG22queue_for_group_commitEPNS_18group_commit_entryE+0x44b)[0x55ba1d0090ab] /usr/sbin/mariadbd(_ZN13MYSQL_BIN_LOG34write_transaction_to_binlog_eventsEPNS_18group_commit_entryE+0x1a)[0x55ba1d00f40a] /usr/sbin/mariadbd(_ZN13MYSQL_BIN_LOG27write_transaction_to_binlogEP3THDP17binlog_cache_mngrP9Log_eventbbbb+0x252)[0x55ba1d00f9d2] /usr/sbin/mariadbd(+0xa9dac9)[0x55ba1d00fac9] /usr/sbin/mariadbd(+0xa9dcab)[0x55ba1d00fcab] /usr/sbin/mariadbd(+0xa9e09f)[0x55ba1d01009f] /usr/sbin/mariadbd(_Z17ha_rollback_transP3THDb+0x140)[0x55ba1cf25560] /usr/sbin/mariadbd(_Z15ha_commit_transP3THDb+0x819)[0x55ba1cf26349] /usr/sbin/mariadbd(_Z17trans_commit_stmtP3THD+0x43)[0x55ba1ce1a733] /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0xb12)[0x55ba1cd0d528] /usr/sbin/mariadbd(_ZN18Prepared_statement7executeEP6Stringb+0x3df)[0x55ba1cd21b6f] /usr/sbin/mariadbd(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0x9d)[0x55ba1cd21e2d] /usr/sbin/mariadbd(_ZN18Prepared_statement17execute_immediateEPKcj+0xfd)[0x55ba1cd22f8d] /usr/sbin/mariadbd(_Z32mysql_sql_stmt_execute_immediateP3THD+0x1c9)[0x55ba1cd231d9] /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x3718)[0x55ba1cd1012e] /usr/sbin/mariadbd(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x38)[0x55ba1cc67fa8] /usr/sbin/mariadbd(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x169)[0x55ba1cc6f9c9] /usr/sbin/mariadbd(_ZN13sp_instr_stmt7executeEP3THDPj+0x5f5)[0x55ba1cc703f5] /usr/sbin/mariadbd(_ZN7sp_head7executeEP3THDb+0xa07)[0x55ba1cc6b3f7] /usr/sbin/mariadbd(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x5fa)[0x55ba1cc6ca9a] /usr/sbin/mariadbd(+0x793659)[0x55ba1cd05659] /usr/sbin/mariadbd(_ZN12Sql_cmd_call7executeEP3THD+0x15a)[0x55ba1cd08a96] /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x1b03)[0x55ba1cd0e519] /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x25c)[0x55ba1cd00703] /usr/sbin/mariadbd(+0x78e1ab)[0x55ba1cd001ab] /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x1de2)[0x55ba1cd0b5ea] /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x12f)[0x55ba1cd0bed0] /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3f7)[0x55ba1ce0b0e7] /usr/sbin/mariadbd(handle_one_connection+0x5d)[0x55ba1ce0b42d] /usr/sbin/mariadbd(+0xbd113d)[0x55ba1d14313d] /lib64/libpthread.so.0(+0x81da)[0x7f29446ed1da] /lib64/libc.so.6(clone+0x43)[0x7f2943a3ee73] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x55ba20e1bad0): INSERT INTO IWD.TBL_QMESSAGES ( WORKITEMTYPEPRODUCT, WORKITEMTYPESOURCE,WORKITEMTYPEQUEUE, PARAMETER1,PARAMETER2,^M WORKITEMCREATIONDATEANDTIME,WORKITEMID, PRIORITYSCORE,ENDBYTIME, COMMITTEDDATE,^M PROCESSED,ACTION, TIMEINSERTED, SendDateTime) ^M Select CIQ.WORKITEMTYPEPRODUCT, ^M 'CSS_HADES2', ^M CIQ.QUEUE_NAME,^M '',^M CIQ.PRIORITYSCORE||'~'||TEMP.VAL_SET_PARAM2DATE,^M IFNULL('Mon Sep 11 21:34:59.000 BST 2023', ''),^M ifnull(replace('GGR320LV/08','/','_'), '') || IFNULL('ACT', '')||'_'|| IFNULL('215024', ''),^M CIQ.PRIORITYSCORE,^M TEMP.VAL_SET_ACTDATE,^M IFNULL('2023-09-11 21:34:59.000000', ''),^M '0',^M 'CREATE',^M SYSDATE(),^M TEMP.VAL_SET_IWD_DATE^M FROM CONT.IWD_QUEUES CIQ,TEMP_TBL_QMESSAGES TEMP^M WHERE CIQ.L2CT2R = 'L2C' AND CIQ.QUEUE_NAME=IFNULL('BSQLLU', '') ^M AND CIQ.ACV_STATUS = IFNULL('ACT', '') ^M AND TEMP.VAL_PK_ORDER_ACT_NO = 'GGR32008LV'^M AND ROWNUM = 1 Connection ID (thread ID): 746322 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-09-11 21:51:13 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:85117407 2023-09-11 21:51:13 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so' 2023-09-11 21:51:13 0 [Note] WSREP: wsrep_load(): Galera 26.4.13(rfe497aeb) by Codership Oy loaded successfully. 2023-09-11 21:51:13 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration. 2023-09-11 21:51:13 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1 2023-09-11 21:51:13 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05 Seqno: -1 - -1 Offset: -1 Synced: 0 2023-09-11 21:51:13 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05, offset: -1 2023-09-11 21:51:13 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/524288024 bytes) complete. 2023-09-11 21:51:13 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (524288024/524288024 bytes) complete. 2023-09-11 21:51:13 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 84934262-85117409 2023-09-11 21:51:13 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/514490264 bytes) complete. 2023-09-11 21:51:13 0 [Note] WSREP: Recovering GCache ring buffer: found 0/183148 locked buffers 2023-09-11 21:51:13 0 [Note] WSREP: Recovering GCache ring buffer: free space: 9797736/524288000 2023-09-11 21:51:13 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (514490264/514490264 bytes) complete. 2023-09-11 21:51:13 0 [Note] WSREP: Passing config to GCS: base_dir = /data/mariadata/mysql/; base_host = 10.13.237.28; 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-09-11 21:51:13 0 [Note] WSREP: Start replication 2023-09-11 21:51:13 0 [Note] WSREP: Connecting with bootstrap option: 0 2023-09-11 21:51:13 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1 2023-09-11 21:51:13 0 [Note] WSREP: protonet asio version 0 2023-09-11 21:51:13 0 [Note] WSREP: Using CRC-32C for message checksums. 2023-09-11 21:51:13 0 [Note] WSREP: backend: asio 2023-09-11 21:51:13 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2023-09-11 21:51:13 0 [Note] WSREP: restore pc from disk successfully 2023-09-11 21:51:13 0 [Note] WSREP: GMCast version 0 2023-09-11 21:51:13 0 [Note] WSREP: (be4d0b0d-b1df, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2023-09-11 21:51:13 0 [Note] WSREP: (be4d0b0d-b1df, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2023-09-11 21:51:13 0 [Note] WSREP: EVS version 1 2023-09-11 21:51:13 0 [Note] WSREP: gcomm: connecting to group 'galera-prod', peer '10.13.237.28:,10.13.237.29:,10.13.237.30:' 2023-09-11 21:51:13 0 [Note] WSREP: (be4d0b0d-b1df, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://10.13.237.28:4567 2023-09-11 21:51:16 0 [Note] WSREP: EVS version upgrade 0 -> 1 2023-09-11 21:51:16 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2023-09-11 21:51:16 0 [Warning] WSREP: no nodes coming from prim view, prim not possible 2023-09-11 21:51:16 0 [Note] WSREP: view(view_id(NON_PRIM,be4d0b0d-b1df,13) memb { be4d0b0d-b1df,0 } joined { } left { } partitioned { }) 2023-09-11 21:51:16 0 [Note] WSREP: promote to primary component 2023-09-11 21:51:16 0 [Note] WSREP: view(view_id(PRIM,be4d0b0d-b1df,13) memb { be4d0b0d-b1df,0 } joined { } left { } partitioned { }) 2023-09-11 21:51:16 0 [Note] WSREP: save pc into disk 2023-09-11 21:51:16 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.13.237.29:4567 2023-09-11 21:51:16 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.13.237.30:4567 2023-09-11 21:51:16 0 [Note] WSREP: clear restored view 2023-09-11 21:51:16 0 [Note] WSREP: gcomm: connected 2023-09-11 21:51:16 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2023-09-11 21:51:16 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2023-09-11 21:51:16 0 [Note] WSREP: Opened channel 'galera-prod' 2023-09-11 21:51:16 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2023-09-11 21:51:16 0 [Note] WSREP: Flow-control interval: [16, 16] 2023-09-11 21:51:16 0 [Note] WSREP: Received NON-PRIMARY. 2023-09-11 21:51:16 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = yes, my_idx = 0, memb_num = 1 2023-09-11 21:51:16 1 [Note] WSREP: Starting rollbacker thread 1 2023-09-11 21:51:16 0 [Note] WSREP: Starting new group from scratch: f378ec8f-50e4-11ee-8cfa-c3324acaa9ee 2023-09-11 21:51:16 2 [Note] WSREP: Starting applier thread 2 2023-09-11 21:51:16 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: f378ef24-50e4-11ee-8860-b60c4d4d1a19 2023-09-11 21:51:16 0 [Note] WSREP: STATE EXCHANGE: sent state msg: f378ef24-50e4-11ee-8860-b60c4d4d1a19 2023-09-11 21:51:16 0 [Note] WSREP: STATE EXCHANGE: got state msg: f378ef24-50e4-11ee-8860-b60c4d4d1a19 from 0 (blp21152016) 2023-09-11 21:51:16 0 [Warning] WSREP: Quorum: No node with complete state: 2023-09-11 21:51:16 2 [Note] WSREP: ================================================ View: id: 00000000-0000-0000-0000-000000000000:-1 status: non-primary protocol_version: -1 capabilities: final: no own_index: 0 members(1): 0: be4d0b0d-4bc0-11ee-b1df-ebed4bce1b86, blp21152016 ================================================= 2023-09-11 21:51:16 2 [Note] WSREP: Non-primary view 2023-09-11 21:51:16 2 [Note] WSREP: Server status change disconnected -> connected 2023-09-11 21:51:16 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Version : 6 Flags : 0x5 Protocols : 2 / 10 / 4 State : NON-PRIMARY Desync count : 0 Prim state : NON-PRIMARY Prim UUID : f378ea7b-50e4-11ee-9630-f7eaf4c1cb73 Prim seqno : 0 First seqno : 84934263 Last seqno : 0 Commit cut : 0 Last vote : -1.0 Vote policy : 0 Prim JOINED : 1 State UUID : f378ef24-50e4-11ee-8860-b60c4d4d1a19 Group UUID : f378ec8f-50e4-11ee-8cfa-c3324acaa9ee Name : 'blp21152016' Incoming addr: '10.13.237.28:0' 2023-09-11 21:51:16 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-09-11 21:51:16 0 [Warning] WSREP: No re-merged primary component found. 2023-09-11 21:51:16 0 [Note] WSREP: Bootstrapped primary f378ea7b-50e4-11ee-9630-f7eaf4c1cb73 found: 1. 2023-09-11 21:51:16 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 0, members = 1/1 (joined/total), act_id = 0, last_appl. = 0, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = f378ec8f-50e4-11ee-8cfa-c3324acaa9ee 2023-09-11 21:51:16 0 [Note] WSREP: Flow-control interval: [16, 16] 2023-09-11 21:51:16 0 [Note] WSREP: Restored state OPEN -> JOINED (1) 2023-09-11 21:51:16 0 [Note] WSREP: Member 0.0 (blp21152016) synced with group. 2023-09-11 21:51:16 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 1) 2023-09-11 21:51:16 2 [Note] WSREP: ####### processing CC 1, local, ordered 2023-09-11 21:51:16 2 [Note] WSREP: Process first view: f378ec8f-50e4-11ee-8cfa-c3324acaa9ee my uuid: be4d0b0d-4bc0-11ee-b1df-ebed4bce1b86 2023-09-11 21:51:16 2 [Note] WSREP: Server blp21152016 connected to cluster at position f378ec8f-50e4-11ee-8cfa-c3324acaa9ee:1 with ID be4d0b0d-4bc0-11ee-b1df-ebed4bce1b86 2023-09-11 21:51:16 2 [Note] WSREP: Server status change connected -> connected 2023-09-11 21:51:16 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-09-11 21:51:16 2 [Note] WSREP: ####### My UUID: be4d0b0d-4bc0-11ee-b1df-ebed4bce1b86 2023-09-11 21:51:16 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: no 2023-09-11 21:51:16 0 [Note] WSREP: Service thread queue flushed. 2023-09-11 21:51:16 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2023-09-11 21:51:16 2 [Note] WSREP: REPL Protocols: 10 (5) 2023-09-11 21:51:16 2 [Note] WSREP: ####### Adjusting cert position: -1 -> 1 2023-09-11 21:51:16 0 [Note] WSREP: Service thread queue flushed. 2023-09-11 21:51:16 2 [Note] WSREP: GCache history reset: c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05:85117409 -> f378ec8f-50e4-11ee-8cfa-c3324acaa9ee:0 2023-09-11 21:51:16 2 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): discarded 514489272 bytes 2023-09-11 21:51:16 2 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): found 0/1 locked buffers 2023-09-11 21:51:16 2 [Note] WSREP: ================================================ View: id: f378ec8f-50e4-11ee-8cfa-c3324acaa9ee:1 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(1): 0: be4d0b0d-4bc0-11ee-b1df-ebed4bce1b86, blp21152016 ================================================= 2023-09-11 21:51:16 2 [Note] WSREP: Server status change connected -> joiner 2023-09-11 21:51:16 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-09-11 21:51:16 2 [Note] WSREP: Server status change joiner -> initializing 2023-09-11 21:51:16 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-09-11 21:51:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-09-11 21:51:16 0 [Note] InnoDB: Number of pools: 1 2023-09-11 21:51:16 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-09-11 21:51:16 0 [Note] InnoDB: Using Linux native AIO 2023-09-11 21:51:16 0 [Note] InnoDB: Initializing buffer pool, total size = 25769803776, chunk size = 134217728 2023-09-11 21:51:16 0 [Note] InnoDB: Completed initialization of buffer pool 2023-09-11 21:51:16 0 [Note] InnoDB: 128 rollback segments are active. 2023-09-11 21:51:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2023-09-11 21:51:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2023-09-11 21:51:16 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2023-09-11 21:51:16 0 [Note] InnoDB: 10.6.11 started; log sequence number 1997122774331; transaction id 331877189 2023-09-11 21:51:16 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-09-11 21:51:16 0 [Note] InnoDB: Loading buffer pool(s) from /data/mariadata/mysql/ib_buffer_pool 2023-09-11 21:51:16 0 [Note] Server socket created on IP: '0.0.0.0'. 2023-09-11 21:51:16 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2023-09-11 21:51:16 4 [Note] Event Scheduler: scheduler thread started with id 4 2023-09-11 21:51:16 0 [Note] WSREP: Server initialized 2023-09-11 21:51:16 0 [Note] WSREP: Server status change initializing -> initialized 2023-09-11 21:51:16 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-09-11 21:51:16 6 [Note] WSREP: Recovered cluster id c9a3c950-7d2f-11ed-9e25-5fc70c4f0d05 2023-09-11 21:51:16 7 [Note] WSREP: Starting applier thread 7 2023-09-11 21:51:16 2 [Note] WSREP: Server status change initialized -> joined 2023-09-11 21:51:16 8 [Note] WSREP: Starting applier thread 8 2023-09-11 21:51:16 9 [Note] WSREP: Starting applier thread 9 2023-09-11 21:51:16 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-09-11 21:51:16 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-09-11 21:51:16 2 [Note] WSREP: Lowest cert index boundary for CC from group: 1 2023-09-11 21:51:16 2 [Note] WSREP: Min available from gcache for CC from group: 1 2023-09-11 21:51:16 2 [Note] WSREP: Server blp21152016 synced with group 2023-09-11 21:51:16 2 [Note] WSREP: Server status change joined -> synced 2023-09-11 21:51:16 2 [Note] WSREP: Synchronized with group, ready for connections 2023-09-11 21:51:16 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2023-09-11 21:51:16 13 [Note] Slave I/O thread: Start asynchronous replication to master 'circrepluser@10.55.36.53:3306' in log 'mariadb-bin.000247' at position 499190311 2023-09-11 21:51:16 14 [Note] Slave SQL thread initialized, starting replication in log 'mariadb-bin.000247' at position 499190311, relay log '/data/mariadata/relaylogs/relay-bin.000001' position: 4; GTID position '0-2-3,5-1-85100466,6-2-4,21-1-12' 2023-09-11 21:51:16 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-09-11 21:51:16 13 [Note] Slave I/O thread: connected to master 'circrepluser@10.55.36.53:3306',replication starts at GTID position '5-1-85100466,0-2-3,21-1-12,6-2-4' 2023-09-11 21:51:16 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50397S), skipping check 2023-09-11 21:51:19 0 [Note] InnoDB: Buffer pool(s) load completed at 230911 21:51:19 2023-09-11 21:52:05 44 [Note] Start binlog_dump to slave_server(2), pos(mariadb-bin.001440, 826357036), using_gtid(1), gtid('5-1-85100466,0-2-3,21-1-12,6-2-4') 2023-09-11 21:56:20 37 [Warning] Aborted connection 37 to db: 'sdautomation' user: 'SDUSER' host: 'blp21152024.iuser.iroot.adidom.com' (Got an error reading communication packets) 2023-09-11 22:00:02 462 [Warning] Access denied for user 'dbmonitor'@'bwp21152010.iuser.iroot.adidom.com' (using password: YES) 2023-09-11 22:00:04 464 [Warning] Access denied for user 'dbmonitor'@'bwp21152010.iuser.iroot.adidom.com' (using password: YES)