Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
Can result in hang or crash
Description
Assertion found while testing 10.11-MDEV-36845
|
origin/10.11-MDEV-36845 a6e72663c4643af5673b7124e703e5a6c7994468 |
# 2025-11-17T12:24:14 [2024379] | mariadbd: /data/Server/10.11-MDEV-36845/storage/innobase/include/srw_lock.h:136: void srw_mutex_impl<spinloop>::destroy() [with bool spinloop = false]: Assertion `!is_locked_or_waiting()' failed.
|
|
StackTrace |
# 2025-11-17T12:32:49 [2024379] | #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=137354431792704) at ./nptl/pthread_kill.c:44
|
# 2025-11-17T12:32:49 [2024379] | #1 __pthread_kill_internal (signo=6, threadid=137354431792704) at ./nptl/pthread_kill.c:78
|
# 2025-11-17T12:32:49 [2024379] | #2 __GI___pthread_kill (threadid=137354431792704, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
|
# 2025-11-17T12:32:49 [2024379] | #3 0x00006b0e4aa32476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
|
# 2025-11-17T12:32:49 [2024379] | #4 0x00006b0e4aa187f3 in __GI_abort () at ./stdlib/abort.c:79
|
# 2025-11-17T12:32:49 [2024379] | #5 0x00006b0e4aa1871b in __assert_fail_base (fmt=0x6b0e4abcd130 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55c9d94dd2b5 "!is_locked_or_waiting()", file=0x55c9d94c1180 "/data/Server/10.11-MDEV-36845/storage/innobase/include/srw_lock.h", line=136, function=<optimized out>) at ./assert/assert.c:92
|
# 2025-11-17T12:32:49 [2024379] | #6 0x00006b0e4aa29e96 in __GI___assert_fail (assertion=0x55c9d94dd2b5 "!is_locked_or_waiting()", file=0x55c9d94c1180 "/data/Server/10.11-MDEV-36845/storage/innobase/include/srw_lock.h", line=136, function=0x55c9d94dd1e0 "void srw_mutex_impl<spinloop>::destroy() [with bool spinloop = false]") at ./assert/assert.c:101
|
# 2025-11-17T12:32:49 [2024379] | #7 0x000055c9d8bfff7c in srw_mutex_impl<false>::destroy (this=0x411c1012c720) at /data/Server/10.11-MDEV-36845/storage/innobase/include/srw_lock.h:136
|
# 2025-11-17T12:32:49 [2024379] | #8 sux_lock<ssux_lock_impl<true> >::free (this=this@entry=0x411c1012c708) at /data/Server/10.11-MDEV-36845/storage/innobase/include/sux_lock.h:82
|
# 2025-11-17T12:32:49 [2024379] | #9 0x000055c9d8f1d377 in dict_index_remove_from_cache_low (table=table@entry=0x6b0e3c05cb20, index=0x411c1012c5a0, lru_evict=lru_evict@entry=0) at /data/Server/10.11-MDEV-36845/storage/innobase/dict/dict0dict.cc:2156
|
# 2025-11-17T12:32:49 [2024379] | #10 0x000055c9d8f1dc6a in dict_sys_t::remove (this=0x55c9d9cfd6c0 <dict_sys>, table=table@entry=0x6b0e3c05cb20, lru=lru@entry=false, keep=keep@entry=false) at /data/Server/10.11-MDEV-36845/storage/innobase/dict/dict0dict.cc:1882
|
# 2025-11-17T12:32:49 [2024379] | #11 0x000055c9d8bda94e in innobase_reload_table (thd=<optimized out>, table=0x6b0e3c05cb20, table_name=..., ctx=...) at /data/Server/10.11-MDEV-36845/storage/innobase/handler/handler0alter.cc:10663
|
# 2025-11-17T12:32:49 [2024379] | #12 0x000055c9d8bec721 in ha_innobase::commit_inplace_alter_table (this=<optimized out>, altered_table=0x7cec521d40f0, ha_alter_info=0x7cec521d4030, commit=<optimized out>) at /data/Server/10.11-MDEV-36845/storage/innobase/handler/handler0alter.cc:11815
|
# 2025-11-17T12:32:49 [2024379] | #13 0x000055c9d88487d8 in handler::ha_commit_inplace_alter_table (this=0x78d22c0675b8, altered_table=altered_table@entry=0x7cec521d40f0, ha_alter_info=ha_alter_info@entry=0x7cec521d4030, commit=commit@entry=true) at /data/Server/10.11-MDEV-36845/sql/handler.cc:5433
|
# 2025-11-17T12:32:49 [2024379] | #14 0x000055c9d860f072 in mysql_inplace_alter_table (thd=thd@entry=0x78d22c000d58, table_list=0x78d22c0137d8, table=table@entry=0x6b0e400131c8, altered_table=altered_table@entry=0x7cec521d40f0, ha_alter_info=ha_alter_info@entry=0x7cec521d4030, target_mdl_request=target_mdl_request@entry=0x7cec521d4910, ddl_log_state=0x7cec521d3ff0, trigger_param=0x7cec521d44d0, alter_ctx=0x7cec521d54e0, partial_alter=@0x7cec521d3f8f: false, start_alter_id=@0x7cec521d3f98: 0, if_exists=false) at /data/Server/10.11-MDEV-36845/sql/sql_table.cc:8194
|
# 2025-11-17T12:32:49 [2024379] | #15 0x000055c9d8622386 in mysql_alter_table (thd=thd@entry=0x78d22c000d58, new_db=new_db@entry=0x78d22c005908, new_name=<optimized out>, create_info=create_info@entry=0x7cec521d6380, table_list=<optimized out>, table_list@entry=0x78d22c0137d8, recreate_info=recreate_info@entry=0x7cec521d61d0, alter_info=<optimized out>, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at /data/Server/10.11-MDEV-36845/sql/sql_table.cc:11408
|
# 2025-11-17T12:32:49 [2024379] | #16 0x000055c9d86a7e85 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x78d22c000d58) at /data/Server/10.11-MDEV-36845/sql/sql_alter.cc:688
|
# 2025-11-17T12:32:49 [2024379] | #17 0x000055c9d852d2b3 in mysql_execute_command (thd=thd@entry=0x78d22c000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/10.11-MDEV-36845/sql/sql_parse.cc:6202
|
# 2025-11-17T12:32:49 [2024379] | #18 0x000055c9d852e78f in mysql_parse (thd=thd@entry=0x78d22c000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7cec521d7370) at /data/Server/10.11-MDEV-36845/sql/sql_parse.cc:8219
|
# 2025-11-17T12:32:49 [2024379] | #19 0x000055c9d8530d2a in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x78d22c000d58, packet=packet@entry=0x78d22c00b069 " ALTER IGNORE TABLE test.t7_p ADD KEY IF NOT EXISTS `idx3` ( col_int /*!100800 ASC */ ), LOCK = EXCLUSIVE /* E_R Thread7 QNO 636 CON_ID 208 */ ", packet_length=packet_length@entry=144, blocking=blocking@entry=true) at /data/Server/10.11-MDEV-36845/sql/sql_parse.cc:1921
|
# 2025-11-17T12:32:49 [2024379] | #20 0x000055c9d8532bf2 in do_command (thd=thd@entry=0x78d22c000d58, blocking=blocking@entry=true) at /data/Server/10.11-MDEV-36845/sql/sql_parse.cc:1434
|
# 2025-11-17T12:32:49 [2024379] | #21 0x000055c9d869f128 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55c9da65a638, put_in_cache=put_in_cache@entry=true) at /data/Server/10.11-MDEV-36845/sql/sql_connect.cc:1475
|
# 2025-11-17T12:32:49 [2024379] | #22 0x000055c9d869f35d in handle_one_connection (arg=0x55c9da65a638) at /data/Server/10.11-MDEV-36845/sql/sql_connect.cc:1387
|
# 2025-11-17T12:32:49 [2024379] | #23 0x00006b0e4aa84ac3 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
# 2025-11-17T12:32:49 [2024379] | #24 0x00006b0e4ab15a04 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
|
RR trace is present on pluto:-
/data/results/1763373181/TBR-1863
Attachments
Issue Links
- duplicates
-
MDEV-37365 Crash when ALTER TABLE on parent runs concurrently with INSERT on child
-
- Confirmed
-