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

Assertion `thd->transaction.stmt.is_empty()' failed in Locked_tables_list::unlock_locked_tables upon ALTER TABLE

    XMLWordPrintable

    Details

      Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (pk INT PRIMARY KEY, c CHAR(125)) ENGINE=InnoDB;
      LOCK TABLE t1 WRITE;
      ALTER TABLE t1 ADD vc TEXT AS (SUBSTR(c,5,8)) VIRTUAL;
      --error ER_CANT_DROP_FIELD_OR_KEY
      ALTER TABLE t1 DROP FOREIGN KEY fk;
       
      # Cleanup
      DROP TABLE t1;
      

      10.0 ada54101a71

      mysqld: /data/src/10.0/sql/sql_base.cc:2792: void Locked_tables_list::unlock_locked_tables(THD*): Assertion `thd->transaction.stmt.is_empty()' failed.
      180721  1:39:30 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f06478b6ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x00000000005ecff2 in Locked_tables_list::unlock_locked_tables (this=0x7f063c740878, thd=0x7f063c73d070) at /data/src/10.0/sql/sql_base.cc:2792
      #9  0x00000000005ed362 in Locked_tables_list::unlink_all_closed_tables (this=0x7f063c740878, thd=0x7f063c73d070, lock=0x0, reopen_count=0) at /data/src/10.0/sql/sql_base.cc:2970
      #10 0x00000000005ed4da in Locked_tables_list::reopen_tables (this=0x7f063c740878, thd=0x7f063c73d070, need_reopen=false) at /data/src/10.0/sql/sql_base.cc:3016
      #11 0x00000000007023a5 in mysql_inplace_alter_table (thd=0x7f063c73d070, table_list=0x7f06338fa180, table=0x7f063389e470, altered_table=0x7f0633a11070, ha_alter_info=0x7f064997a260, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f0649979cb0, alter_ctx=0x7f064997a840) at /data/src/10.0/sql/sql_table.cc:7269
      #12 0x000000000070662e in mysql_alter_table (thd=0x7f063c73d070, new_db=0x7f06338fa760 "test", new_name=0x0, create_info=0x7f064997b4e0, table_list=0x7f06338fa180, alter_info=0x7f064997b450, order_num=0, order=0x0, ignore=false) at /data/src/10.0/sql/sql_table.cc:8976
      #13 0x000000000076f339 in Sql_cmd_alter_table::execute (this=0x7f06338fa790, thd=0x7f063c73d070) at /data/src/10.0/sql/sql_alter.cc:312
      #14 0x00000000006547e4 in mysql_execute_command (thd=0x7f063c73d070) at /data/src/10.0/sql/sql_parse.cc:5118
      #15 0x0000000000657e3a in mysql_parse (thd=0x7f063c73d070, rawbuf=0x7f06338fa088 "ALTER TABLE t1 DROP FOREIGN KEY fk", length=34, parser_state=0x7f064997c640) at /data/src/10.0/sql/sql_parse.cc:6637
      #16 0x000000000064a75a in dispatch_command (command=COM_QUERY, thd=0x7f063c73d070, packet=0x7f063ca60071 "ALTER TABLE t1 DROP FOREIGN KEY fk", packet_length=34) at /data/src/10.0/sql/sql_parse.cc:1300
      #17 0x0000000000649a5a in do_command (thd=0x7f063c73d070) at /data/src/10.0/sql/sql_parse.cc:1003
      #18 0x000000000076aa8c in do_handle_one_connection (thd_arg=0x7f063c73d070) at /data/src/10.0/sql/sql_connect.cc:1377
      #19 0x000000000076a7fe in handle_one_connection (arg=0x7f063c73d070) at /data/src/10.0/sql/sql_connect.cc:1292
      #20 0x0000000000acc90a in pfs_spawn_thread (arg=0x7f063c6801f0) at /data/src/10.0/storage/perfschema/pfs.cc:1861
      #21 0x00007f06495ba494 in start_thread (arg=0x7f064997d700) at pthread_create.c:333
      #22 0x00007f064797393f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Reproducible on 10.0, 10.1.
      Couldn't reproduce on 10.2, 10.3.
      No visible problems on a non-debug build.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.