Db abnormal restart with signal 11 - Source

Revision: 144311
User: Lim Kei Tsao
Date: 2024-11-19 07:26

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

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Db abnormal restart with signal 11 - Source

Answer

Products

Solutions

Resources

Company

Pricing

Download MariaDB