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

Assertion `(thd->state_flags & Open_tables_state::BACKUPS_AVAIL) || !thd->has_pending_row_events()' failed in close_thread_tables on CREATE TABLE

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      # mysqld options required for replay: --log-bin
      SET sql_mode='';
      CREATE TEMPORARY TABLE t ENGINE=MyISAM AS SELECT @a AS c;
      INSERT INTO t VALUES (0xABB0);
      SET autocommit=OFF;
      CREATE TABLE t (c INT PRIMARY KEY) ENGINE=MyISAM SELECT * FROM t FOR UPDATE;
      

      Leads to:

      CS 12.3.0 fa36b269f139252b81d4384fbed07b167855cabb (Debug, Clang 21.1.3-20250923) Build 05/02/2026

      mariadbd: /test/12.3_dbg/sql/sql_base.cc:999: int close_thread_tables(THD *): Assertion `(thd->state_flags & Open_tables_state::BACKUPS_AVAIL) || !thd->has_pending_row_events()' failed.
      

      CS 12.3.0 fa36b269f139252b81d4384fbed07b167855cabb (Debug, Clang 21.1.3-20250923) Build 05/02/2026

      Core was generated by `/test/MD050226-mariadb-12.3.0-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 160556)]
      (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  0x000074ad93e4526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x000074ad93e288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x000074ad93e2881b in __assert_fail_base (fmt=0x74ad93fd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x6522166679e3 "(thd->state_flags & Open_tables_state::BACKUPS_AVAIL) || !thd->has_pending_row_events()", file=file@entry=0x6522164c98c1 "/test/12.3_dbg/sql/sql_base.cc", line=line@entry=999, function=function@entry=0x65221651ed26 "int close_thread_tables(THD *)")at ./assert/assert.c:94
      #6  0x000074ad93e3b507 in __assert_fail (assertion=0x6522166679e3 "(thd->state_flags & Open_tables_state::BACKUPS_AVAIL) || !thd->has_pending_row_events()", file=0x6522164c98c1 "/test/12.3_dbg/sql/sql_base.cc", line=999, function=0x65221651ed26 "int close_thread_tables(THD *)")at ./assert/assert.c:103
      #7  0x00006522170900ad in close_thread_tables (thd=0x74ac48000d58)at /test/12.3_dbg/sql/sql_base.cc:998
      #8  0x000065221708fb4d in close_thread_tables_for_query (thd=0x74ac48000d58)at /test/12.3_dbg/sql/sql_base.cc:821
      #9  0x00006522171fbd5e in mysql_execute_command (thd=0x74ac48000d58, is_called_from_prepared_stmt=false) at /test/12.3_dbg/sql/sql_parse.cc:6003
      #10 0x00006522171eca58 in mysql_parse (thd=0x74ac48000d58, rawbuf=0x74ac48019f80 "CREATE TABLE t (c INT PRIMARY KEY) ENGINE=MyISAM SELECT * FROM t FOR UPDATE", length=75, parser_state=0x74ad8bfb2a00)at /test/12.3_dbg/sql/sql_parse.cc:7950
      #11 0x00006522171ea20e in dispatch_command (command=COM_QUERY, thd=0x74ac48000d58, packet=0x74ac4800b2d9 "CREATE TABLE t (c INT PRIMARY KEY) ENGINE=MyISAM SELECT * FROM t FOR UPDATE", packet_length=75, blocking=true)at /test/12.3_dbg/sql/sql_parse.cc:1896
      #12 0x00006522171ed4da in do_command (thd=0x74ac48000d58, blocking=true)at /test/12.3_dbg/sql/sql_parse.cc:1432
      #13 0x00006522173e542e in do_handle_one_connection (connect=0x65221a63c338, put_in_cache=true) at /test/12.3_dbg/sql/sql_connect.cc:1503
      #14 0x00006522173e5211 in handle_one_connection (arg=0x65221a56fc18)at /test/12.3_dbg/sql/sql_connect.cc:1415
      #15 0x000074ad93e9ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #16 0x000074ad93f29c3c 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  230126  cd02709a315c9f08965d6b8fb7e75baaae17a4f4  No bug found                  
      CS  10.6   opt  230126  cd02709a315c9f08965d6b8fb7e75baaae17a4f4  No bug found                  
      CS  10.11  dbg  230126  b061b5ab1f2cd2a6993e53dc24a865304ced14cd  No bug found                  
      CS  10.11  opt  230126  b061b5ab1f2cd2a6993e53dc24a865304ced14cd  No bug found                  
      CS  11.4   dbg  260126  b6d0e23d76fe5936b6a29379ab494852e4d493b1  No bug found                  
      CS  11.4   opt  260126  b6d0e23d76fe5936b6a29379ab494852e4d493b1  No bug found                  
      CS  11.8   dbg  230126  01ff5ae6b677bead4c41d91bf5afb25c593a1d02  No bug found                  
      CS  11.8   opt  230126  01ff5ae6b677bead4c41d91bf5afb25c593a1d02  No bug found                  
      CS  12.2   dbg  230126  6ca70dd64ce56da40fad3bcd0641493210dd0a4c  (thd->state_flags & Open_tables_state::BACKUPS_AVAIL) || !thd->has_pending_row_events()|SIGABRT|close_thread_tables|close_thread_tables_for_query|mysql_execute_command|mysql_parse
      CS  12.2   opt  230126  6ca70dd64ce56da40fad3bcd0641493210dd0a4c  No bug found                  
      CS  12.3   dbg  050226  fa36b269f139252b81d4384fbed07b167855cabb  (thd->state_flags & Open_tables_state::BACKUPS_AVAIL) || !thd->has_pending_row_events()|SIGABRT|close_thread_tables|close_thread_tables_for_query|mysql_execute_command|mysql_parse
      CS  12.3   opt  050226  fa36b269f139252b81d4384fbed07b167855cabb  No bug found                  
      ES  10.6   dbg  230126  0fe345fff3a0463224ca714831303d40fb83648b  No bug found                  
      ES  10.6   opt  230126  0fe345fff3a0463224ca714831303d40fb83648b  No bug found                  
      ES  11.4   dbg  230126  34f616d5fd2c649d0c79acb4e2423c90b8f10436  No bug found                  
      ES  11.4   opt  230126  34f616d5fd2c649d0c79acb4e2423c90b8f10436  No bug found                  
      ES  11.8   dbg  230126  405ee76b60c4ab82155f339136ed20d3b7363717  No bug found                  
      ES  11.8   opt  230126  405ee76b60c4ab82155f339136ed20d3b7363717  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                  
      

      Attachments

        Activity

          People

            midenok Aleksey Midenkov
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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