Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.6.22, 10.11.12, 11.4.6, 11.8.2
-
Can result in hang or crash
-
Q3/2025 Maintenance
Description
SET GLOBAL innodb_defragment_stats_accuracy=1; |
SET GLOBAL innodb_limit_optimistic_insert_debug=2; |
CREATE TABLE t (f INT,f2 CHAR(1),KEY k1 (f2),FULLTEXT KEY(f2),FOREIGN KEY(f2) REFERENCES t (f3)) ENGINE=InnoDB; |
Leads to:
CS 10.11.14 11d1ac7285221ab4df7d9ef7cc8ee949b01c9b32 (Debug, Clang) Build 09/06/2025 |
mariadbd: /test/10.11_dbg/storage/innobase/sync/srw_lock.cc:696: void srw_lock_debug::rd_lock(): Assertion `!have_any()' failed.
|
CS 10.11.14 11d1ac7285221ab4df7d9ef7cc8ee949b01c9b32 (Debug, Clang) Build 09/06/2025 |
Core was generated by `/test/MD090625-mariadb-10.11.14-linux-x86_64-dbg/bin/mariadbd --no-defaults --m'.
|
Program terminated with signal SIGABRT, Aborted.
|
Download failed: Invalid argument. Continuing without source file ./nptl/./nptl/pthread_kill.c.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
 |
[Current thread is 1 (LWP 58721)]
|
(gdb) bt
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
|
#3 0x000074990ca4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x000074990ca288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x000074990ca2881b in __assert_fail_base (fmt=0x74990cbd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x596b0f928bcf "!have_any()", file=file@entry=0x596b0f928951 "/test/10.11_dbg/storage/innobase/sync/srw_lock.cc", line=line@entry=696, function=function@entry=0x596b0f928c80 "void srw_lock_debug::rd_lock()")at ./assert/assert.c:96
|
#6 0x000074990ca3b517 in __assert_fail (assertion=0x596b0f928bcf "!have_any()", file=0x596b0f928951 "/test/10.11_dbg/storage/innobase/sync/srw_lock.cc", line=696, function=0x596b0f928c80 "void srw_lock_debug::rd_lock()")at ./assert/assert.c:105
|
#7 0x0000596b0f29d956 in srw_lock_debug::rd_lock (this=0x596b10172440 <dict_sys+64>)at /test/10.11_dbg/storage/innobase/sync/srw_lock.cc:696
|
#8 0x0000596b0f02d1a9 in dict_sys_t::freeze (this=0x596b10172400 <dict_sys>)at include/dict0dict.h:1479
|
#9 0x0000596b0f3b2fc5 in dict_table_open_on_id (table_id=21, dict_locked=false, table_op=DICT_TABLE_OP_OPEN_ONLY_IF_CACHED, thd=0x749878003978, mdl=0x749897ffe980)at /test/10.11_dbg/storage/innobase/dict/dict0dict.cc:831
|
#10 0x0000596b0f3f6baf in dict_stats_process_entry_from_defrag_pool (thd=0x749878003978)at /test/10.11_dbg/storage/innobase/dict/dict0defrag_bg.cc:192
|
#11 0x0000596b0f3f6ad0 in dict_defrag_process_entries_from_defrag_pool (thd=0x749878003978)at /test/10.11_dbg/storage/innobase/dict/dict0defrag_bg.cc:209
|
#12 0x0000596b0f3f2c83 in dict_stats_func ()at /test/10.11_dbg/storage/innobase/dict/dict0stats_bg.cc:392
|
#13 0x0000596b0f49e1d4 in tpool::thread_pool_generic::timer_generic::run (this=0x596b417d0a90) at /test/10.11_dbg/tpool/tpool_generic.cc:335
|
#14 0x0000596b0f49e00d in tpool::thread_pool_generic::timer_generic::execute (arg=0x596b417d0a90) at /test/10.11_dbg/tpool/tpool_generic.cc:355
|
#15 0x0000596b0f4a1ecf in tpool::task::execute (this=0x596b417d0ad0)at /test/10.11_dbg/tpool/task.cc:37
|
#16 0x0000596b0f49ab03 in tpool::thread_pool_generic::worker_main (this=0x596b41712360, thread_var=0x596b417127b0)at /test/10.11_dbg/tpool/tpool_generic.cc:573
|
#17 0x0000596b0f49f304 in std::__invoke_impl<void, void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*>(__f=@0x596b4175f9a8: (void (tpool::thread_pool_generic::*)(class tpool::thread_pool_generic * const, struct tpool::worker_data *)) 0x596b0f49a9e0 <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>, __t=@0x596b4175f9a0: 0x596b41712360, __args=@0x596b4175f998: 0x596b417127b0)at /usr/bin/../lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/invoke.h:74
|
#18 0x0000596b0f49f225 in std::__invoke<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__fn=@0x596b4175f9a8: (void (tpool::thread_pool_generic::*)(class tpool::thread_pool_generic * const, struct tpool::worker_data *)) 0x596b0f49a9e0 <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>, __args=@0x596b4175f998: 0x596b417127b0, __args=@0x596b4175f998: 0x596b417127b0)at /usr/bin/../lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/invoke.h:96
|
#19 0x0000596b0f49f1f3 in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::_M_invoke<0ul, 1ul, 2ul> (this=0x596b4175f998)at /usr/bin/../lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/std_thread.h:292
|
#20 0x0000596b0f49f1a5 in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::operator() (this=0x596b4175f998)at /usr/bin/../lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/std_thread.h:299
|
#21 0x0000596b0f49f019 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> > >::_M_run (this=0x596b4175f990)at /usr/bin/../lib/gcc/x86_64-linux-gnu/13/../../../../include/c++/13/bits/std_thread.h:244
|
#22 0x000074990ceecdb4 in std::execute_native_thread_routine (__p=0x596b4175f990)at ../../../../../src/libstdc++-v3/src/c++11/thread.cc:104
|
#23 0x000074990ca9caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#24 0x000074990cb29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
CS 10.6 dbg 090625 888663ce12647c5aefee5e18accd80843d726741 !have_any()|SIGABRT|srw_lock_debug::rd_lock|dict_sys_t::freeze|dict_table_open_on_id|dict_stats_process_entry_from_defrag_pool
|
CS 10.6 opt 090625 888663ce12647c5aefee5e18accd80843d726741 No bug found
|
CS 10.11 dbg 090625 11d1ac7285221ab4df7d9ef7cc8ee949b01c9b32 !have_any()|SIGABRT|srw_lock_debug::rd_lock|dict_sys_t::freeze|dict_table_open_on_id|dict_stats_process_entry_from_defrag_pool
|
CS 10.11 opt 090625 11d1ac7285221ab4df7d9ef7cc8ee949b01c9b32 No bug found
|
CS 11.4 dbg 090625 8c6cbb336081a5e1ad781df4a9778b61e3b4d73f No bug found
|
CS 11.4 opt 090625 8c6cbb336081a5e1ad781df4a9778b61e3b4d73f No bug found
|
CS 11.8 dbg 170625 c095283ea6f9ef25cd1bd731b6984c7cbc7e4c3f No bug found
|
CS 11.8 opt 170625 c095283ea6f9ef25cd1bd731b6984c7cbc7e4c3f No bug found
|
CS 12.0 dbg 090625 f1102da37a3dcdc8b92e0205f0a8bd878704b168 No bug found
|
CS 12.0 opt 090625 f1102da37a3dcdc8b92e0205f0a8bd878704b168 No bug found
|
CS 12.1 dbg 090625 6a2afb42ba86188ccda0972f9c2df363f34e10a0 No bug found
|
CS 12.1 opt 090625 6a2afb42ba86188ccda0972f9c2df363f34e10a0 No bug found
|
ES 10.6 dbg 090625 6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62 No bug found
|
ES 10.6 opt 090625 6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62 No bug found
|
ES 11.4 dbg 090625 9cd12544ebfd0d52d2158af66b5aced58121cf1f No bug found
|
ES 11.4 opt 090625 9cd12544ebfd0d52d2158af66b5aced58121cf1f No bug found
|
ES 11.8 dbg 170625 b9f97a5bc42a4f23889996d2891bcbb0cafcf0bc No bug found
|
ES 11.8 opt 170625 b9f97a5bc42a4f23889996d2891bcbb0cafcf0bc No bug found
|
Attachments
Issue Links
- is caused by
-
MDEV-36122 Assertion failure ctx0->old_table->get_ref_count() == 1 in ha_innobase::commit_inplace_alter_table()
-
- Closed
-