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

Assertion `bulk_insert == TRX_NO_BULK' failed in trx_t::assert_freed from innodb_shutdown

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
      SET unique_checks=0,foreign_key_checks=0;
      CREATE TABLE t (c INT) ENGINE=InnoDB;
      XA START 'a';
      INSERT INTO t VALUES (1);
      XA END 'a';
      XA PREPARE 'a';
      SHUTDOWN;
      

      Leads to:

      CS 11.4.6 da5a4d05b9da58705498a42b6ffa5d9211f446af (Debug) Build 06/05/2025

      mariadbd: /test/11.4_dbg/storage/innobase/include/trx0trx.h:1125: void trx_t::assert_freed() const: Assertion `bulk_insert == TRX_NO_BULK' failed.
      

      CS 11.4.6 da5a4d05b9da58705498a42b6ffa5d9211f446af (Debug) Build 06/05/2025

      Core was generated by `/test/MD060525-mariadb-11.4.6-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.
      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 1095296)]
      (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  0x0000720354a4526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x0000720354a288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x0000720354a2881b in __assert_fail_base (fmt=0x720354bd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x58826455ff01 "bulk_insert == TRX_NO_BULK", file=file@entry=0x58826455bc9f "/test/11.4_dbg/storage/innobase/include/trx0trx.h", line=line@entry=1125, function=function@entry=0x588264429315 "void trx_t::assert_freed() const")at ./assert/assert.c:94
      #6  0x0000720354a3b507 in __assert_fail (assertion=0x58826455ff01 "bulk_insert == TRX_NO_BULK", file=0x58826455bc9f "/test/11.4_dbg/storage/innobase/include/trx0trx.h", line=1125, function=0x588264429315 "void trx_t::assert_freed() const")at ./assert/assert.c:103
      #7  0x0000588265a5a927 in trx_t::assert_freed (this=0x720326e00b80)at include/trx0trx.h:1125
      #8  0x0000588265a4f74b in trx_t::free (this=0x720326e00b80)at /test/11.4_dbg/storage/innobase/trx/trx0trx.cc:384
      #9  0x0000588265a5007d in trx_free_at_shutdown (trx=0x720326e00b80)at /test/11.4_dbg/storage/innobase/trx/trx0trx.cc:529
      #10 0x0000588265a4ea6f in rw_trx_hash_t::rw_trx_hash_shutdown_destructor (arg=0x588268865b68 "") at include/trx0sys.h:422
      #11 0x0000588265b1fc72 in lf_hash_destroy (hash=0x588265f9da80 <trx_sys+49536>)at /test/11.4_dbg/mysys/lf_hash.cc:388
      #12 0x0000588265a4e5b3 in rw_trx_hash_t::destroy (this=0x588265f9da80 <trx_sys+49536>) at include/trx0sys.h:537
      #13 0x0000588265a4d335 in trx_sys_t::close (this=0x588265f91900 <trx_sys>)at /test/11.4_dbg/storage/innobase/trx/trx0sys.cc:366
      #14 0x0000588265a0d2ac in innodb_shutdown ()at /test/11.4_dbg/storage/innobase/srv/srv0start.cc:2112
      #15 0x00005882655f376e in innobase_end ()at /test/11.4_dbg/storage/innobase/handler/ha_innodb.cc:4275
      #16 0x0000588264c4a870 in ha_finalize_handlerton (plugin_=0x58826860d890)at /test/11.4_dbg/sql/handler.cc:599
      #17 0x00005882650dacb1 in plugin_deinitialize (plugin=0x58826860d890, ref_check=true) at /test/11.4_dbg/sql/sql_plugin.cc:1274
      #18 0x00005882650d8470 in reap_plugins ()at /test/11.4_dbg/sql/sql_plugin.cc:1345
      #19 0x00005882650dafb6 in plugin_shutdown ()at /test/11.4_dbg/sql/sql_plugin.cc:2100
      #20 0x0000588264bfbe6d in clean_up (print_message=true)at /test/11.4_dbg/sql/mysqld.cc:2005
      #21 0x0000588264bfe562 in mysqld_main (argc=12, argv=0x588268538698)at /test/11.4_dbg/sql/mysqld.cc:6091
      #22 0x0000588264bfad62 in main (argc=11, argv=0x7ffe29653888)at /test/11.4_dbg/sql/main.cc:34
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.5   dbg  060525  5c92b27d5433df7558f41ac5718481f87bdfa544  No bug found                  
      CS  10.5   opt  060525  5c92b27d5433df7558f41ac5718481f87bdfa544  No bug found                  
      CS  10.6   dbg  060525  c62671543976eb397576f1b57fb6817029bc21ee  No bug found                  
      CS  10.6   opt  060525  c62671543976eb397576f1b57fb6817029bc21ee  No bug found                  
      CS  10.11  dbg  060525  2263c8a1f7db9b308e1458d1ddc4203d006940d7  bulk_insert == TRX_NO_BULK|SIGABRT|trx_t::assert_freed|trx_t::free|trx_free_at_shutdown|rw_trx_hash_t::rw_trx_hash_shutdown_destructor
      CS  10.11  opt  060525  2263c8a1f7db9b308e1458d1ddc4203d006940d7  No bug found                  
      CS  11.4   dbg  060525  da5a4d05b9da58705498a42b6ffa5d9211f446af  bulk_insert == TRX_NO_BULK|SIGABRT|trx_t::assert_freed|trx_t::free|trx_free_at_shutdown|rw_trx_hash_t::rw_trx_hash_shutdown_destructor
      CS  11.4   opt  060525  da5a4d05b9da58705498a42b6ffa5d9211f446af  No bug found                  
      CS  11.8   dbg  060525  865b05bf4acf10e0d4b3359019ed7b2efe0be81d  No bug found                  
      CS  11.8   opt  060525  865b05bf4acf10e0d4b3359019ed7b2efe0be81d  No bug found                  
      CS  12.0   dbg  060525  51c0afcd248ad57095fdcf56efec2865ea49bd83  No bug found                  
      CS  12.0   opt  060525  51c0afcd248ad57095fdcf56efec2865ea49bd83  No bug found                  
      ES  10.5   dbg  060525  0d368ec0042a81d9549fc939fb742f82350b20ab  No bug found                  
      ES  10.5   opt  060525  0d368ec0042a81d9549fc939fb742f82350b20ab  No bug found                  
      ES  10.6   dbg  060525  6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62  No bug found                  
      ES  10.6   opt  060525  6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62  No bug found                  
      ES  11.4   dbg  060525  9cd12544ebfd0d52d2158af66b5aced58121cf1f  No bug found                  
      ES  11.4   opt  060525  9cd12544ebfd0d52d2158af66b5aced58121cf1f  No bug found                  
      MS  5.5    dbg  070123  bac287c315b1792e7ae33f91add6a60292f9bae8  No bug found                  
      MS  5.5    opt  070123  bac287c315b1792e7ae33f91add6a60292f9bae8  No bug found                  
      MS  5.6    dbg  070123  dab95781a1244104d6b87020ac2fc4d190ba2946  No bug found                  
      MS  5.6    opt  070123  dab95781a1244104d6b87020ac2fc4d190ba2946  No bug found                  
      MS  5.7    dbg  070525  f7680e98b6bbe3500399fbad465d08a6b75d7a5c  No bug found                  
      MS  5.7    opt  070525  f7680e98b6bbe3500399fbad465d08a6b75d7a5c  No bug found                  
      MS  8.0    dbg  060224  49ef33f7edadef3ae04665e73d1babd40179a4f1  No bug found                  
      MS  8.0    opt  060224  49ef33f7edadef3ae04665e73d1babd40179a4f1  No bug found                  
      MS  9.1    dbg  211024  61a3a1d8ef15512396b4c2af46e922a19bf2b174  No bug found                  
      MS  9.1    opt  211024  61a3a1d8ef15512396b4c2af46e922a19bf2b174  No bug found                  
      

      Testcase is CLI and MTR compatible. No UB/ASAN issues observed.

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              Roel Roel Van de Paar
              Thirunarayanan Balathandayuthapani Thirunarayanan Balathandayuthapani
              Marko Mäkelä Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.