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

Assertion `!table->pos_in_locked_tables' failed in tc_release_table

    XMLWordPrintable

    Details

      Description

      For branch preview-10.10-ddl only, the following SQL:

      CREATE TABLE t (a INT) ENGINE=InnoDB;
      LOCK TABLES mysql.time_zone READ,t WRITE;
      CREATE OR REPLACE TABLE t (b INT) ENGINE=SEQUENCE;
      

      Leads to:

      10.10.0 7a41e4fbc62c5e917d9cb4dc045e21c983d4e73f (Debug)

      mysqld: /test/preview-10.10-ddl_dbg/sql/table_cache.cc:446: void tc_release_table(TABLE*): Assertion `!table->pos_in_locked_tables' failed.
      

      10.10.0 7a41e4fbc62c5e917d9cb4dc045e21c983d4e73f (Debug)

      Core was generated by `/test/MDEV-16329_preview-10.10-ddl_MD270822-mariadb-10.10.0-linux-x86_64-dbg/bi'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      [Current thread is 1 (Thread 0x14c7584ae700 (LWP 1264775))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x000014c771005859 in __GI_abort () at abort.c:79
      #2  0x000014c771005729 in __assert_fail_base (fmt=0x14c77119b588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5651c5684aa4 "!table->pos_in_locked_tables", file=0x5651c5684b98 "/test/preview-10.10-ddl_dbg/sql/table_cache.cc", line=446, function=<optimized out>) at assert.c:92
      #3  0x000014c771016fd6 in __GI___assert_fail (assertion=assertion@entry=0x5651c5684aa4 "!table->pos_in_locked_tables", file=file@entry=0x5651c5684b98 "/test/preview-10.10-ddl_dbg/sql/table_cache.cc", line=line@entry=446, function=function@entry=0x5651c5684a86 "void tc_release_table(TABLE*)") at assert.c:101
      #4  0x00005651c4c8b2aa in tc_release_table (table=table@entry=0x14c71801ddf8) at /test/preview-10.10-ddl_dbg/sql/table_cache.cc:446
      #5  0x00005651c49bbf00 in close_thread_table (thd=thd@entry=0x14c718000db8, table_ptr=table_ptr@entry=0x14c718000ea8) at /test/preview-10.10-ddl_dbg/sql/sql_base.cc:999
      #6  0x00005651c49bc380 in close_thread_tables (thd=thd@entry=0x14c718000db8) at /test/preview-10.10-ddl_dbg/sql/sql_base.cc:942
      #7  0x00005651c49bd84a in Locked_tables_list::unlock_locked_tables (this=this@entry=0x14c718004df0, thd=thd@entry=0x14c718000db8) at /test/preview-10.10-ddl_dbg/sql/sql_base.cc:2551
      #8  0x00005651c49de949 in THD::cleanup (this=this@entry=0x14c718000db8) at /test/preview-10.10-ddl_dbg/sql/sql_class.cc:1529
      #9  0x00005651c49150c9 in unlink_thd (thd=0x14c718000db8) at /test/preview-10.10-ddl_dbg/sql/mysqld.cc:2751
      #10 0x00005651c4bad994 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5651c6dfedb8, put_in_cache=put_in_cache@entry=true) at /test/preview-10.10-ddl_dbg/sql/sql_connect.cc:1429
      #11 0x00005651c4badcc3 in handle_one_connection (arg=0x5651c6dfedb8) at /test/preview-10.10-ddl_dbg/sql/sql_connect.cc:1312
      #12 0x000014c771516609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #13 0x000014c771102133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              Roel Roel Van de Paar
              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.