Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Done
-
None
Description
Please check this crash if its related:-
|
Commit id:-origin/MDEV-37152 366233ebd3135c52d93f41623db1f8e1f984e97f
|
|
# 2025-09-24T02:08:23 [3165712] Thread 1 (Thread 0x7c012c22d6c0 (LWP 3172473)):
|
# 2025-09-24T02:08:23 [3165712] #0 __pthread_kill_implementation (no_tid=0, signo=11, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
|
# 2025-09-24T02:08:23 [3165712] #1 __pthread_kill_internal (signo=11, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
|
# 2025-09-24T02:08:23 [3165712] #2 __GI___pthread_kill (threadid=<optimized out>, signo=11) at ./nptl/pthread_kill.c:89
|
# 2025-09-24T02:08:23 [3165712] #3 0x00005cf46bd2112c in my_write_core (sig=11) at /data/Server/MDEV-37152/mysys/stacktrace.c:424
|
# 2025-09-24T02:08:23 [3165712] #4 0x00005cf46b7c3262 in handle_fatal_signal (sig=11) at /data/Server/MDEV-37152/sql/signal_handler.cc:298
|
# 2025-09-24T02:08:23 [3165712] #5 <signal handler called>
|
# 2025-09-24T02:08:23 [3165712] #6 THD::get_stmt_da (this=0x0) at /data/Server/MDEV-37152/sql/sql_class.h:4680
|
# 2025-09-24T02:08:23 [3165712] #7 THD::raise_condition (this=this@entry=0x0, sql_errno=sql_errno@entry=1088, sqlstate=sqlstate@entry=0x5cf46bfc5437 "", level=level@entry=Sql_state_errno_level::WARN_LEVEL_WARN, msg=msg@entry=0x7c012c228220 "Error updating stats for table 't9' after table rebuild: Lock wait timeout") at /data/Server/MDEV-37152/sql/sql_class.h:5169
|
# 2025-09-24T02:08:23 [3165712] #8 0x00005cf46b4fc510 in push_warning (thd=thd@entry=0x0, level=level@entry=Sql_state_errno_level::WARN_LEVEL_WARN, code=code@entry=1088, msg=msg@entry=0x7c012c228220 "Error updating stats for table 't9' after table rebuild: Lock wait timeout") at /data/Server/MDEV-37152/sql/sql_error.cc:755
|
# 2025-09-24T02:08:23 [3165712] #9 0x00005cf46b4fc719 in push_warning_printf (thd=0x0, level=level@entry=Sql_state_errno_level::WARN_LEVEL_WARN, code=code@entry=1088, format=format@entry=0x5cf46beb23b8 "Error updating stats for table '%s' after table rebuild: %s") at /data/Server/MDEV-37152/sql/sql_error.cc:790
|
# 2025-09-24T02:08:23 [3165712] #10 0x00005cf46ba1b048 in alter_stats_rebuild (table=0x7c0070182490, table_name=0x7c00681f8195 "t9", trx=trx@entry=0x7c0116c03a00) at /data/Server/MDEV-37152/storage/innobase/handler/handler0alter.cc:11277
|
# 2025-09-24T02:08:23 [3165712] #11 0x00005cf46ba2d8f5 in ha_innobase::commit_inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=<optimized out>, commit=<optimized out>) at /data/Server/MDEV-37152/storage/innobase/handler/handler0alter.cc:11959
|
# 2025-09-24T02:08:23 [3165712] #12 0x00005cf46b7cde81 in handler::ha_commit_inplace_alter_table (this=0x7c00680b20e8, altered_table=altered_table@entry=0x7c012c2290f0, ha_alter_info=ha_alter_info@entry=0x7c012c229030, commit=commit@entry=true) at /data/Server/MDEV-37152/sql/handler.cc:5628
|
# 2025-09-24T02:08:23 [3165712] #13 0x00005cf46b5ffad5 in mysql_inplace_alter_table (thd=thd@entry=0x7c0068000d58, table_list=0x7c00680138f8, table=table@entry=0x7c00682b56d8, altered_table=altered_table@entry=0x7c012c2290f0, ha_alter_info=ha_alter_info@entry=0x7c012c229030, target_mdl_request=target_mdl_request@entry=0x7c012c229920, ddl_log_state=0x7c012c228ff0, trigger_param=0x7c012c2294e0, alter_ctx=0x7c012c22a560, partial_alter=@0x7c012c228f6e: false, start_alter_id=@0x7c012c228f78: 0, if_exists=false) at /data/Server/MDEV-37152/sql/sql_table.cc:8189
|
# 2025-09-24T02:08:23 [3165712] #14 0x00005cf46b603c2a in mysql_alter_table (thd=thd@entry=0x7c0068000d58, new_db=new_db@entry=0x7c00680058e0, new_name=<optimized out>, create_info=create_info@entry=0x7c012c22b400, table_list=<optimized out>, table_list@entry=0x7c00680138f8, recreate_info=recreate_info@entry=0x7c012c22b250, alter_info=<optimized out>, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at /data/Server/MDEV-37152/sql/sql_table.cc:11558
|
# 2025-09-24T02:08:23 [3165712] #15 0x00005cf46b6736db in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7c0068000d58) at /data/Server/MDEV-37152/sql/sql_alter.cc:701
|
# 2025-09-24T02:08:23 [3165712] #16 0x00005cf46b53e5eb in mysql_execute_command (thd=thd@entry=0x7c0068000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/MDEV-37152/sql/sql_parse.cc:5876
|
# 2025-09-24T02:08:23 [3165712] #17 0x00005cf46b53f177 in mysql_parse (thd=thd@entry=0x7c0068000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7c012c22c400) at /data/Server/MDEV-37152/sql/sql_parse.cc:7899
|
# 2025-09-24T02:08:23 [3165712] #18 0x00005cf46b5407ec in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7c0068000d58, packet=packet@entry=0x7c006800b049 "ALTER TABLE t9 /*!100301 NOWAIT */ FORCE, LOCK=NONE /* E_R Thread9 QNO 288153 CON_ID 22 */ ", packet_length=packet_length@entry=92, blocking=blocking@entry=true) at /data/Server/MDEV-37152/sql/sql_parse.cc:1905
|
# 2025-09-24T02:08:23 [3165712] #19 0x00005cf46b541c8a in do_command (thd=thd@entry=0x7c0068000d58, blocking=blocking@entry=true) at /data/Server/MDEV-37152/sql/sql_parse.cc:1418
|
# 2025-09-24T02:08:23 [3165712] #20 0x00005cf46b66c3b5 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5cf46f36bdf8, put_in_cache=put_in_cache@entry=true) at /data/Server/MDEV-37152/sql/sql_connect.cc:1497
|
# 2025-09-24T02:08:23 [3165712] #21 0x00005cf46b66c5c6 in handle_one_connection (arg=0x5cf46f36bdf8) at /data/Server/MDEV-37152/sql/sql_connect.cc:1409
|
# 2025-09-24T02:08:23 [3165712] #22 0x00007c012c69ca94 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
|
# 2025-09-24T02:08:23 [3165712] #23 0x00007c012c729c3c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Core dump is present on SDP:-
/data/results/1758703102/000486
Attachments
Issue Links
- is caused by
-
MDEV-37152 buf_page_get_gen -> buf_pool->stat.n_page_gets++ high cpu utilisation
-
- Closed
-