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

    • Type: Technical task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.0.8
    • Component/s: None
    • Labels:
      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

            • Assignee:
              monty Michael Widenius
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: