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

Assertion `table->s->db_create_options == part_table->s->db_create_options' failed in compare_table_with_partition

    XMLWordPrintable

Details

    Description

      --source include/have_partition.inc
       
      CREATE TABLE t1 (i INT NOT NULL, KEY (i)) ROW_FORMAT=DYNAMIC PARTITION BY KEY(i) PARTITIONS 2;
      CREATE TABLE t2 (i INT NOT NULL, KEY (i));
      ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2;
       
      # Cleanup
      DROP TABLE t1, t2;
      

      10.0 6559ba71a564

      mysqld: /data/src/10.0/sql/sql_partition_admin.cc:238: bool compare_table_with_partition(THD*, TABLE*, TABLE*, partition_element*): Assertion `table->s->db_create_options == part_table->s->db_create_options' failed.
      171214 12:43:46 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f738819cee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x00000000009c0dce in compare_table_with_partition (thd=0x7f73822a2070, table=0x7f738089f070, part_table=0x7f738089e470, part_elem=0x7f7380b87e68) at /data/src/10.0/sql/sql_partition_admin.cc:237
      #9  0x00000000009c1c1a in Sql_cmd_alter_table_exchange_partition::exchange_partition (this=0x7f73808fadc8, thd=0x7f73822a2070, table_list=0x7f73808fa1a0, alter_info=0x7f738a26ba40) at /data/src/10.0/sql/sql_partition_admin.cc:590
      #10 0x00000000009c07df in Sql_cmd_alter_table_exchange_partition::execute (this=0x7f73808fadc8, thd=0x7f73822a2070) at /data/src/10.0/sql/sql_partition_admin.cc:92
      #11 0x000000000065398b in mysql_execute_command (thd=0x7f73822a2070) at /data/src/10.0/sql/sql_parse.cc:5114
      #12 0x0000000000656dc2 in mysql_parse (thd=0x7f73822a2070, rawbuf=0x7f73808fa088 "ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2", length=50, parser_state=0x7f738a26c640) at /data/src/10.0/sql/sql_parse.cc:6569
      #13 0x0000000000649901 in dispatch_command (command=COM_QUERY, thd=0x7f73822a2070, packet=0x7f73837e5071 "ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2", packet_length=50) at /data/src/10.0/sql/sql_parse.cc:1296
      #14 0x0000000000648c01 in do_command (thd=0x7f73822a2070) at /data/src/10.0/sql/sql_parse.cc:999
      #15 0x0000000000768ab8 in do_handle_one_connection (thd_arg=0x7f73822a2070) at /data/src/10.0/sql/sql_connect.cc:1377
      #16 0x000000000076882a in handle_one_connection (arg=0x7f73822a2070) at /data/src/10.0/sql/sql_connect.cc:1292
      #17 0x0000000000ac9564 in pfs_spawn_thread (arg=0x7f73821a2370) at /data/src/10.0/storage/perfschema/pfs.cc:1861
      #18 0x00007f7389ea0494 in start_thread (arg=0x7f738a26d700) at pthread_create.c:333
      #19 0x00007f738825993f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Reproducible on 10.x and MySQL 5.6, 5.7, with InnoDB and MyISAM. Also filed as https://bugs.mysql.com/bug.php?id=88916

      Attachments

        Issue Links

          Activity

            People

              nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.