Db abnormal restart with signal 11
Our side have encountered mariadb abnormal restart, our side used mariadb 10.6.19 the details log is as below: Anyone has encountered and any fix for this, seems alter sequence can trigger this event?
241111 16:11:42 [ERROR] mysqld got signal 11 ; Sorry, we probably made a mistake, and this is a bug.
Your assistance in bug reporting will enable us to fix this for the next release. 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.19-MariaDB-log source revision: 8f020508c87461bbeee551c3001acac56d506ae7 key_buffer_size=20971520 read_buffer_size=1048576 max_used_connections=639 max_threads=65546 thread_count=258 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 201589180 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.
/usr/sbin/mariadbd(_Z20wsrep_check_sequenceP3THDPK19sequence_definitionb+0x1b)[0x55e4219a3acb] /usr/sbin/mariadbd(_ZN22Sql_cmd_alter_sequence7executeEP3THD+0x539)[0x55e421ab8ba9] /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x2b38)[0x55e42190335d] /usr/sbin/mariadbd(_ZN18Prepared_statement7executeEP6Stringb+0x3e6)[0x55e4219158e6] /usr/sbin/mariadbd(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0x9d)[0x55e421915bed] /usr/sbin/mariadbd(_Z22mysql_sql_stmt_executeP3THD+0x193)[0x55e421915f03] /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x3769)[0x55e421903f8e] /usr/sbin/mariadbd(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x3f)[0x55e42184d8ff] 2024-11-11 16:11:48 0 [Note] WSREP: gcomm: closing backend /usr/sbin/mariadbd(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x16d)[0x55e42185679d] /usr/sbin/mariadbd(_ZN13sp_instr_stmt7executeEP3THDPj+0x5f5)[0x55e4218571c5] 2024-11-11 16:11:50 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT6.85271S), skipping check 2024-11-11 16:11:50 1829691 [Warning] Aborted connection 1829691 to db: 'bes_core' user: 'besdb_user' host: '172.24.150.136' (Got an error reading communication packets) /usr/sbin/mariadbd(_ZN7sp_head7executeEP3THDb+0xa17)[0x55e421851167] 2024-11-11 16:11:50 0 [Note] WSREP: view(view_id(NON_PRIM,05008704-bdd1,169) memb { ed13d45d-814d,0 } joined { } left { } partitioned { 05008704-bdd1,0 4f0f24ab-b89b,0 }) 2024-11-11 16:11:51 0 [Note] WSREP: PC protocol downgrade 1 -> 0 2024-11-11 16:11:51 0 [Note] WSREP: view((empty)) /usr/sbin/mariadbd(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x61a)[0x55e42185294a] /usr/sbin/mariadbd(+0x7bd5fb)[0x55e4218f65fb] 2024-11-11 16:11:51 0 [Note] WSREP: gcomm: closed 2024-11-11 16:11:52 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2024-11-11 16:11:52 0 [Note] WSREP: Flow-control interval: [12000, 12000] /usr/sbin/mariadbd(_ZN12Sql_cmd_call7executeEP3THD+0x157)[0x55e4218fb225] 2024-11-11 16:11:52 0 [Note] WSREP: Received NON-PRIMARY. 2024-11-11 16:11:52 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 3840394468) 2024-11-11 16:11:52 0 [Note] WSREP: New SELF-LEAVE. 2024-11-11 16:11:52 0 [Note] WSREP: Flow-control interval: [0, 0] 2024-11-11 16:11:52 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2024-11-11 16:11:52 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 3840394468) 2024-11-11 16:11:52 0 [Note] WSREP: RECV thread exiting 0: Success 2024-11-11 16:11:52 85 [Note] WSREP: ================================================
Thread pointer: 0x7f399c267248 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 = 0x7f4151d6eb18 thread_stack 0x49000 Can't start addr2line /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x55e422085c5e] /usr/sbin/mariadbd(handle_fatal_signal+0x475)[0x55e421b438a5] 2024-11-11 16:11:43 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown 2024-11-11 16:11:43 0 [Note] WSREP: Shutdown replication 2024-11-11 16:11:43 0 [Note] WSREP: Server status change synced -> disconnecting 2024-11-11 16:11:43 0 [Note] WSREP: Closing send monitor... 2024-11-11 16:11:43 0 [Note] WSREP: Closed send monitor. /lib64/libpthread.so.0(+0x12d10)[0x7f456464ad10] 2024-11-11 16:11:43 0 [Note] WSREP: gcomm: terminating thread 2024-11-11 16:11:43 0 [Note] WSREP: gcomm: joining thread View: id: ffdc91b5-7447-11ec-af59-e6d4f25cfd36:3840394468 status: non-primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 0 members(1): 0: ed13d45d-96d8-11ef-814d-5ab67284eec3, t1vdbs-tdffsbe-tdb04-1-02
2024-11-11 16:11:52 85 [Note] WSREP: Non-primary view 2024-11-11 16:11:52 85 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x2b38)[0x55e42190335d] 2024-11-11 16:11:53 1830170 [Warning] Aborted connection 1830170 to db: 'unconnected' user: 'gcis_pmm' host: 't1vdbs-gcissc-pmm01.dbaas.gcisdctr.hksarg' (Got an error writing communication packets) /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x275)[0x55e4218f132e] 2024-11-11 16:11:53 1830140 [Warning] Aborted connection 1830140 to db: 'unconnected' user: 'gcis_pmm' host: 't1vdbs-gcissc-pmm01.dbaas.gcisdctr.hksarg' (Got an error writing communication packets) /usr/sbin/mariadbd(+0x7b7af4)[0x55e4218f0af4] /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x2c0f)[0x55e4218ff328] /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x12d)[0x55e4218ffabe] 2024-11-11 16:11:54 0 [Note] WSREP: recv_thread() joined. 2024-11-11 16:11:54 0 [Note] WSREP: Closing send queue. 2024-11-11 16:11:54 0 [Note] WSREP: Closing receive queue. 2024-11-11 16:11:55 41 [Note] WSREP: ================================================ View: id: ffdc91b5-7447-11ec-af59-e6d4f25cfd36:3840394468 status: non-primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: yes own_index: -1 members(0):
2024-11-11 16:11:55 41 [Note] WSREP: Non-primary view /usr/sbin/mariadbd(_Z11tp_callbackP13TP_connection+0x83)[0x55e421acdaf3] 2024-11-11 16:11:55 41 [Note] WSREP: Server status change disconnecting -> disconnected 2024-11-11 16:11:55 41 [Note] WSREP: Server status change disconnecting -> disconnected 2024-11-11 16:11:55 41 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-11-11 16:11:55 41 [Note] WSREP: Applier thread exiting ret: 0 thd: 41 2024-11-11 16:11:55 64 [Note] WSREP: Applier thread exiting ret: 6 thd: 64
