Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5491 CREATE OR REPLACE TABLE
  3. MDEV-5517

Assertion `thd->transaction.stmt.is_empty()' fails in Locked_tables_list::unlock_locked_tables on CREATE OR REPLACE on a locked table

    XMLWordPrintable

Details

    • Technical task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 10.0.8
    • None
    • None

    Description

      --source include/have_innodb.inc
       
      create table t1 (i int) engine=InnoDB;
      lock table t1 write;
      create or replace table t1 (j int);

      mariadb-monty/sql/sql_base.cc:2704: void Locked_tables_list::unlock_locked_tables(THD*): Assertion `thd->transaction.stmt.is_empty()' failed.
      140110 21:23:22 [ERROR] mysqld got signal 6 ;

      #6  0x00007f052eae9621 in *__GI___assert_fail (assertion=0xfc97e8 "thd->transaction.stmt.is_empty()", file=<optimized out>, line=2704, function=0xfcc320 "void Locked_tables_list::unlock_locked_tables(THD*)") at assert.c:81
      #7  0x0000000000606459 in Locked_tables_list::unlock_locked_tables (this=0x7f0527ff7ba8, thd=0x7f0527ff4070) at mariadb-monty/sql/sql_base.cc:2704
      #8  0x000000000070a727 in mysql_rm_table_no_locks (thd=0x7f0527ff4070, tables=0x7f05187fbe60, if_exists=false, drop_temporary=false, drop_view=false, dont_log_query=true) at mariadb-monty/sql/sql_table.cc:2619
      #9  0x000000000070fd82 in create_table_impl (thd=0x7f0527ff4070, db=0x7f052250a750 "test", table_name=0x7f052250a148 "t1", path=0x7f05187fc8c0 "./test/t1", create_info=0x7f05187fccd0, alter_info=0x7f05187fcc40, create_table_mode=0, is_trans=0x7f05187fcb66, key_info=0x7f05187fcae8, key_count=0x7f05187fcae4, frm=0x7f05187fcad0) at mariadb-monty/sql/sql_table.cc:4607
      #10 0x000000000071056f in mysql_create_table_no_lock (thd=0x7f0527ff4070, db=0x7f052250a750 "test", table_name=0x7f052250a148 "t1", create_info=0x7f05187fccd0, alter_info=0x7f05187fcc40, is_trans=0x7f05187fcb66, create_table_mode=0) at mariadb-monty/sql/sql_table.cc:4787
      #11 0x00000000007106c6 in mysql_create_table (thd=0x7f0527ff4070, create_table=0x7f052250a180, create_info=0x7f05187fccd0, alter_info=0x7f05187fcc40) at mariadb-monty/sql/sql_table.cc:4833
      #12 0x0000000000665921 in mysql_execute_command (thd=0x7f0527ff4070) at mariadb-monty/sql/sql_parse.cc:3009
      #13 0x000000000066eb90 in mysql_parse (thd=0x7f0527ff4070, rawbuf=0x7f052250a088 "create or replace table t1 (j int)", length=34, parser_state=0x7f05187fd630) at mariadb-monty/sql/sql_parse.cc:6383
      #14 0x0000000000661ade in dispatch_command (command=COM_QUERY, thd=0x7f0527ff4070, packet=0x7f0525da3071 "create or replace table t1 (j int)", packet_length=34) at mariadb-monty/sql/sql_parse.cc:1296
      #15 0x0000000000660e80 in do_command (thd=0x7f0527ff4070) at mariadb-monty/sql/sql_parse.cc:993
      #16 0x000000000077a779 in do_handle_one_connection (thd_arg=0x7f0527ff4070) at mariadb-monty/sql/sql_connect.cc:1379
      #17 0x000000000077a4cc in handle_one_connection (arg=0x7f0527ff4070) at mariadb-monty/sql/sql_connect.cc:1293
      #18 0x0000000000a9d651 in pfs_spawn_thread (arg=0x7f0525ffe8b0) at mariadb-monty/storage/perfschema/pfs.cc:1853
      #19 0x00007f0530049b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
      #20 0x00007f052eb98a7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      revision-id: monty@askmonty.org-20140110153917-3r8owmbgslg2552n
      revno: 3965
      branch-nick: mariadb-monty
      BUILD/compile-pentium-debug-max-no-ndb

      Attachments

        Activity

          People

            monty Michael Widenius
            elenst Elena Stepanova
            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.