Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37123

void srw_lock_debug::rd_lock(): Assertion `!have_any()' failed.

    XMLWordPrintable

Details

    • 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

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              saahil Saahil Alam
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.