function=0x55a9c67b3108 "dberr_t trx_t::drop_table(const dict_table_t&)") at assert.c:101
#4 0x000055a9c60ca387 in trx_t::drop_table (this=0x3a38709ec380, table=...) at /data/MDEV-33104/10.11/storage/innobase/dict/drop.cc:156
#5 0x000055a9c5dc255d in commit_try_rebuild (ha_alter_info=0x70776ede9ef0, ctx=0x1523bc0dd2b8, altered_table=0x70776ede9fb0, old_table=0x321c5801e228, statistics_exist=true, trx=0x3a38709ec380,
table_name=0x321c58028c0a "D") at /data/MDEV-33104/10.11/storage/innobase/handler/handler0alter.cc:10337
#6 0x000055a9c5db0e09 in ha_innobase::commit_inplace_alter_table (this=0x321c58108690, altered_table=0x70776ede9fb0, ha_alter_info=0x70776ede9ef0, commit=true)
at /data/MDEV-33104/10.11/storage/innobase/handler/handler0alter.cc:11482
#7 0x000055a9c5a2f9b0 in handler::ha_commit_inplace_alter_table (this=0x321c58108690, altered_table=0x70776ede9fb0, ha_alter_info=0x70776ede9ef0, commit=true) at /data/MDEV-33104/10.11/sql/handler.cc:5292
#8 0x000055a9c57941a5 in mysql_inplace_alter_table (thd=0x1523bc002558, table_list=0x1523bc014c88, table=0x321c5801e228, altered_table=0x70776ede9fb0, ha_alter_info=0x70776ede9ef0,
if_exists=false) at /data/MDEV-33104/10.11/sql/sql_table.cc:7870
#9 0x000055a9c579dcb4 in mysql_alter_table (thd=0x1523bc002558, new_db=0x1523bc0070c0, new_name=0x1523bc007520, create_info=0x70776edec200, table_list=0x1523bc014c88, recreate_info=0x70776edec070,
alter_info=0x70776edec090, order_num=0, order=0x0, ignore=false, if_exists=false) at /data/MDEV-33104/10.11/sql/sql_table.cc:11015
#10 0x000055a9c5848ece in Sql_cmd_alter_table::execute (this=0x1523bc0153a0, thd=0x1523bc002558) at /data/MDEV-33104/10.11/sql/sql_alter.cc:688
#11 0x000055a9c56874b7 in mysql_execute_command (thd=0x1523bc002558, is_called_from_prepared_stmt=false) at /data/MDEV-33104/10.11/sql/sql_parse.cc:6075
#12 0x000055a9c568cf44 in mysql_parse (thd=0x1523bc002558, rawbuf=0x1523bc014b40 "/* WRK-5 QNO 4822 */ ALTER TABLE `simple_db`.`D` FORCE", length=55, parser_state=0x70776eded340)
at /data/MDEV-33104/10.11/sql/sql_parse.cc:8080
#13 0x000055a9c5679cd3 in dispatch_command (command=COM_QUERY, thd=0x1523bc002558, packet=0x1523bc00c7d9 "/* WRK-5 QNO 4822 */ ALTER TABLE `simple_db`.`D` FORCE ", packet_length=56, blocking=true)
at /data/MDEV-33104/10.11/sql/sql_parse.cc:1894
#14 0x000055a9c56788d0 in do_command (thd=0x1523bc002558, blocking=true) at /data/MDEV-33104/10.11/sql/sql_parse.cc:1407
#15 0x000055a9c583e029 in do_handle_one_connection (connect=0x55a9c8eeedf8, put_in_cache=true) at /data/MDEV-33104/10.11/sql/sql_connect.cc:1415
#16 0x000055a9c583ddb5 in handle_one_connection (arg=0x55a9c8eeedf8) at /data/MDEV-33104/10.11/sql/sql_connect.cc:1317
#17 0x00007dee5aebe609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#18 0x0000320b2a6de133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
I have an impression that the failure started happening not very long ago (but probably before Q4 2023 release). However, it's not impossible that its appearance was triggered not by code changes but by some test changes.
Effect on non-debug builds:
So far I haven't observed any visible problem on a non-debug build (no hang etc).
Attachments
Issue Links
relates to
MDEV-26990DDL_LOG error in the log and errno 168 Unknown (generic) error from engine upon concurrent DDL and DML
Stalled
MDEV-30761InnoDB: Failing assertion: table->n_rec_locks == 0 in dict0dict.cc line 1862
Confirmed
MDEV-32899InnoDB is holding shared dict_sys.latch while waiting for FOREIGN KEY child table lock on DDL
Closed
MDEV-34253ALTER .. FOREIGN KEY stuck in "Committing alter table to storage engine" does not obey innodb_lock_wait_timeout
Confirmed
MDEV-21175Remove dict_table_t::n_foreign_key_checks_running from InnoDB
Closed
MDEV-26217Failing assertion: list.count > 0 in ut_list_remove or Assertion `lock->trx == this' failed in dberr_t trx_t::drop_table
Closed
MDEV-26554Table-rebuilding DDL on parent table causes crash for INSERT into child table