Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8
-
Can result in hang or crash
Description
Assertion found on debug build
origin/10.11 2f5bad2f2bbe1c43bf796edb67b93fc64d3c3157 |
# 2025-10-14T20:53:35 [378791] | 2025-10-14 20:53:14 107 [ERROR] InnoDB: Unable to drop table `test`.`FTS_0000000000000756_BEING_DELETED`: Too many concurrent transactions
|
# 2025-10-14T20:53:35 [378791] | 2025-10-14 20:53:14 0x788952fb46c0 InnoDB: Assertion failure in file /data/Server/10.11E/storage/innobase/que/que0que.cc line 659
|
# 2025-10-14T20:53:35 [378791] | InnoDB: Failing assertion: trx->error_state == DB_SUCCESS
|
Stacktrace |
# 2025-10-14T20:54:11 [378791] #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
|
# 2025-10-14T20:54:11 [378791] #1 __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
|
# 2025-10-14T20:54:11 [378791] #2 __GI___pthread_kill (threadid=<optimized out>, signo=6) at ./nptl/pthread_kill.c:89
|
# 2025-10-14T20:54:11 [378791] #3 0x0000598c2aacfb01 in my_write_core (sig=6) at /data/Server/10.11E/mysys/stacktrace.c:424
|
# 2025-10-14T20:54:11 [378791] #4 0x0000598c2a566190 in handle_fatal_signal (sig=6) at /data/Server/10.11E/sql/signal_handler.cc:298
|
# 2025-10-14T20:54:11 [378791] #5 <signal handler called>
|
# 2025-10-14T20:54:11 [378791] #6 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
|
# 2025-10-14T20:54:11 [378791] #7 __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
|
# 2025-10-14T20:54:11 [378791] #8 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
|
# 2025-10-14T20:54:11 [378791] #9 0x0000788970a4526e in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
|
# 2025-10-14T20:54:11 [378791] #10 0x0000788970a288ff in __GI_abort () at ./stdlib/abort.c:79
|
# 2025-10-14T20:54:11 [378791] #11 0x0000598c2a9685ae in ut_dbg_assertion_failed (expr=expr@entry=0x598c2ac4c9f0 "trx->error_state == DB_SUCCESS", file=file@entry=0x598c2ac92bd0 "/data/Server/10.11E/storage/innobase/que/que0que.cc", line=line@entry=659) at /data/Server/10.11E/storage/innobase/ut/ut0dbg.cc:60
|
# 2025-10-14T20:54:11 [378791] #12 0x0000598c2a89b79b in que_eval_sql (info=info@entry=0x7888a8073a30, sql=sql@entry=0x598c2ace25a8 "PROCEDURE DROP_VIRTUAL() IS\nBEGIN\nDELETE FROM SYS_VIRTUAL WHERE TABLE_ID=:id;\nEND;\n", trx=trx@entry=0x788970415980) at /data/Server/10.11E/storage/innobase/que/que0que.cc:659
|
# 2025-10-14T20:54:11 [378791] #13 0x0000598c2aa0eb71 in trx_t::drop_table (this=this@entry=0x788970415980, table=...) at /data/Server/10.11E/storage/innobase/dict/drop.cc:183
|
# 2025-10-14T20:54:11 [378791] #14 0x0000598c2aa3e1c2 in fts_drop_table (trx=trx@entry=0x788970415980, table_name=<optimized out>, table_name@entry=0x788952fae8f0 "test/FTS_", '0' <repeats 13 times>, "756_BEING_DELETED_CACHE", rename=rename@entry=false) at /data/Server/10.11E/storage/innobase/fts/fts0fts.cc:1404
|
# 2025-10-14T20:54:11 [378791] #15 0x0000598c2aa3e726 in fts_drop_common_tables (trx=trx@entry=0x788970415980, fts_table=fts_table@entry=0x788952faebd0, rename=rename@entry=false) at /data/Server/10.11E/storage/innobase/fts/fts0fts.cc:1695
|
# 2025-10-14T20:54:11 [378791] #16 0x0000598c2aa3e77f in fts_drop_tables (trx=trx@entry=0x788970415980, table=...) at /data/Server/10.11E/storage/innobase/fts/fts0fts.cc:1772
|
# 2025-10-14T20:54:11 [378791] #17 0x0000598c2aa0eab7 in trx_t::drop_table (this=this@entry=0x788970415980, table=...) at /data/Server/10.11E/storage/innobase/dict/drop.cc:196
|
# 2025-10-14T20:54:11 [378791] #18 0x0000598c2a7a7170 in ha_innobase::delete_table (this=<optimized out>, name=<optimized out>) at /data/Server/10.11E/storage/innobase/handler/ha_innodb.cc:13744
|
# 2025-10-14T20:54:11 [378791] #19 0x0000598c2a56c0f2 in hton_drop_table (hton=<optimized out>, path=<optimized out>) at /data/Server/10.11E/sql/handler.cc:577
|
# 2025-10-14T20:54:11 [378791] #20 0x0000598c2a571f8c in ha_delete_table (thd=thd@entry=0x7888a8000d58, hton=hton@entry=0x598c2d6a9088, path=path@entry=0x788952fafdf0 "./test/#sql-backup-5dd06-6b", db=db@entry=0x788952fb1620, alias=alias@entry=0x788952fb0110, generate_warning=generate_warning@entry=false) at /data/Server/10.11E/sql/handler.cc:3266
|
# 2025-10-14T20:54:11 [378791] #21 0x0000598c2a3acc09 in quick_rm_table (thd=thd@entry=0x7888a8000d58, base=base@entry=0x598c2d6a9088, db=db@entry=0x788952fb1620, table_name=table_name@entry=0x788952fb0110, flags=3, table_path=table_path@entry=0x0) at /data/Server/10.11E/sql/sql_table.cc:2109
|
# 2025-10-14T20:54:11 [378791] #22 0x0000598c2a3c147c in mysql_alter_table (thd=thd@entry=0x7888a8000d58, new_db=new_db@entry=0x7888a80058f0, new_name=<optimized out>, create_info=create_info@entry=0x788952fb24b0, table_list=<optimized out>, table_list@entry=0x7888a80137c0, recreate_info=recreate_info@entry=0x788952fb2300, alter_info=<optimized out>, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at /data/Server/10.11E/sql/sql_table.cc:11861
|
# 2025-10-14T20:54:11 [378791] #23 0x0000598c2a42f3b1 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7888a8000d58) at /data/Server/10.11E/sql/sql_alter.cc:688
|
# 2025-10-14T20:54:11 [378791] #24 0x0000598c2a301963 in mysql_execute_command (thd=thd@entry=0x7888a8000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/10.11E/sql/sql_parse.cc:6169
|
# 2025-10-14T20:54:11 [378791] #25 0x0000598c2a302506 in mysql_parse (thd=thd@entry=0x7888a8000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x788952fb3400) at /data/Server/10.11E/sql/sql_parse.cc:8184
|
# 2025-10-14T20:54:11 [378791] #26 0x0000598c2a303b72 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7888a8000d58, packet=packet@entry=0x7888a800b049 " ALTER TABLE t1 MODIFY col_text TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, ALGORITHM = DEFAULT /* E_R Thread15 QNO 652 CON_ID 107 */ ", packet_length=packet_length@entry=146, blocking=blocking@entry=true) at /data/Server/10.11E/sql/sql_parse.cc:1906
|
# 2025-10-14T20:54:11 [378791] #27 0x0000598c2a305010 in do_command (thd=thd@entry=0x7888a8000d58, blocking=blocking@entry=true) at /data/Server/10.11E/sql/sql_parse.cc:1419
|
# 2025-10-14T20:54:11 [378791] #28 0x0000598c2a4280e3 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x598c2d9a6538, put_in_cache=put_in_cache@entry=true) at /data/Server/10.11E/sql/sql_connect.cc:1475
|
# 2025-10-14T20:54:11 [378791] #29 0x0000598c2a4282f4 in handle_one_connection (arg=0x598c2d9a6538) at /data/Server/10.11E/sql/sql_connect.cc:1387
|
# 2025-10-14T20:54:11 [378791] #30 0x0000788970a9ca94 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
|
# 2025-10-14T20:54:11 [378791] #31 0x0000788970b29c3c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Core dump is present on SDP
/data/results/1760480250/TBR-1945
Attachments
Issue Links
- relates to
-
MDEV-25180 Atomic ALTER TABLE
-
- Closed
-
-
MDEV-37672 void trx_assign_rseg_low(trx_t*): Assertion `!look_for_rollover || start_scan_slot != slot' failed
-
- In Progress
-