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

XA: Assertion `!clust_index->online_log' failed in rollback_inplace_alter_table

    XMLWordPrintable

Details

    • 10.2.14

    Description

      --source include/have_innodb.inc
      --source include/have_partition.inc
       
      CREATE TABLE t1 (a INT, b INT) ENGINE=InnoDB PARTITION BY HASH(a) PARTITIONS 2;
      XA START 'xid';
      INSERT INTO t1 VALUES (1,10);
      --error ER_XAER_RMFAIL
      CREATE DATABASE IF NOT EXISTS db;
       
      --connect (con1,localhost,root,,test)
      SET innodb_lock_wait_timeout= 1, lock_wait_timeout= 2;
      ALTER TABLE t1 DROP COLUMN b;
       
      # Cleanup
      --disconnect con1
      --connection default
      XA END 'xid';
      XA ROLLBACK 'xid';
      DROP TABLE t1;
      

      10.0 9216a4f69f11

      mysqld: /data/src/10.0/storage/innobase/handler/handler0alter.cc:4366: bool rollback_inplace_alter_table(Alter_inplace_info*, const TABLE*, row_prebuilt_t*): Assertion `!clust_index->online_log' failed.
      180220 14:28:33 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fc189c50ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x00007fc18276c7d8 in rollback_inplace_alter_table (ha_alter_info=0x7fc18bcc7260, table=0x7fc17589e470, prebuilt=0x7fc175a12078) at /data/src/10.0/storage/innobase/handler/handler0alter.cc:4366
      #9  0x00007fc182769f39 in ha_innodb::commit_inplace_alter_table (this=0x7fc175880088, altered_table=0x7fc175ce4070, ha_alter_info=0x7fc18bcc7260, commit=false) at /data/src/10.0/storage/innobase/handler/handler0alter.cc:5640
      #10 0x0000000000842aad in handler::ha_commit_inplace_alter_table (this=0x7fc175880088, altered_table=0x7fc175ce4070, ha_alter_info=0x7fc18bcc7260, commit=false) at /data/src/10.0/sql/handler.cc:4226
      #11 0x0000000000df87ed in ha_partition::commit_inplace_alter_table (this=0x7fc17587f088, altered_table=0x7fc175ce4070, ha_alter_info=0x7fc18bcc7260, commit=false) at /data/src/10.0/sql/ha_partition.cc:8405
      #12 0x0000000000842aad in handler::ha_commit_inplace_alter_table (this=0x7fc17587f088, altered_table=0x7fc175ce4070, ha_alter_info=0x7fc18bcc7260, commit=false) at /data/src/10.0/sql/handler.cc:4226
      #13 0x0000000000701565 in mysql_inplace_alter_table (thd=0x7fc17e36f070, table_list=0x7fc175c22170, table=0x7fc17589e470, altered_table=0x7fc175ce4070, ha_alter_info=0x7fc18bcc7260, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7fc18bcc6cb0, alter_ctx=0x7fc18bcc7840) at /data/src/10.0/sql/sql_table.cc:7232
      #14 0x0000000000705852 in mysql_alter_table (thd=0x7fc17e36f070, new_db=0x7fc175c22750 "test", new_name=0x0, create_info=0x7fc18bcc84e0, table_list=0x7fc175c22170, alter_info=0x7fc18bcc8450, order_num=0, order=0x0, ignore=false) at /data/src/10.0/sql/sql_table.cc:8949
      #15 0x000000000076e2b1 in Sql_cmd_alter_table::execute (this=0x7fc175c22780, thd=0x7fc17e36f070) at /data/src/10.0/sql/sql_alter.cc:312
      #16 0x0000000000654607 in mysql_execute_command (thd=0x7fc17e36f070) at /data/src/10.0/sql/sql_parse.cc:5114
      #17 0x0000000000657a3e in mysql_parse (thd=0x7fc17e36f070, rawbuf=0x7fc175c22088 "ALTER TABLE t1 DROP COLUMN b", length=28, parser_state=0x7fc18bcc9640) at /data/src/10.0/sql/sql_parse.cc:6569
      #18 0x000000000064a57d in dispatch_command (command=COM_QUERY, thd=0x7fc17e36f070, packet=0x7fc17e375071 "ALTER TABLE t1 DROP COLUMN b", packet_length=28) at /data/src/10.0/sql/sql_parse.cc:1296
      #19 0x000000000064987d in do_command (thd=0x7fc17e36f070) at /data/src/10.0/sql/sql_parse.cc:999
      #20 0x0000000000769a04 in do_handle_one_connection (thd_arg=0x7fc17e36f070) at /data/src/10.0/sql/sql_connect.cc:1377
      #21 0x0000000000769776 in handle_one_connection (arg=0x7fc17e36f070) at /data/src/10.0/sql/sql_connect.cc:1292
      #22 0x0000000000aca0fc in pfs_spawn_thread (arg=0x7fc17e319b70) at /data/src/10.0/storage/perfschema/pfs.cc:1861
      #23 0x00007fc18b954494 in start_thread (arg=0x7fc18bcca700) at pthread_create.c:333
      #24 0x00007fc189d0d93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Reproducible on all of 10.x. Not reproducible on MariaDB 5.5, MySQL 5.6.39, 5.7.21.

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              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.