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

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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18858 Assertion `table->s->db_options_in_use == part_table->s->db_options_in_use' failed in compare_table_with_partition

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23357 Server crashes in Sql_cmd_alter_table_exchange_partition::exchange_partition

          • Major - Major loss of function.
          • Closed
          links to

          Web Link Bug #88916 Assertion `table->s->db_create_options == part_table->s->db_create_options'

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.2 [ 14601 ]
            Affects Version/s 10.0 [ 16000 ]
            Affects Version/s 10.1 [ 16100 ]
            Affects Version/s 10.2 [ 14601 ]
            Affects Version/s 10.3 [ 22126 ]
            Assignee Elena Stepanova [ elenst ]
            Description [travis log|https://api.travis-ci.org/v3/job/315651129/log.txt]
            {noformat:title=10.3 }
            mysqld: /home/travis/src/sql/sql_partition_admin.cc:249: bool compare_table_with_partition(THD*, TABLE*, TABLE*, partition_element*, uint): Assertion `table->s->db_create_options == part_table->s->db_create_options' failed.
            171213 11:06:43 [ERROR] mysqld got signal 6 ;

            Query (0x7f4414013818): ALTER TABLE q EXCHANGE PARTITION p1 WITH TABLE a /* QNO 1601 CON_ID 14 */
            Connection ID (thread ID): 14
            Status: NOT_KILLED
            {noformat}
            {noformat}
            #6 0x00007f446b8d1bf6 in __assert_fail_base (fmt=0x7f446ba26018 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55b02ed56f38 "table->s->db_create_options == part_table->s->db_create_options", file=file@entry=0x55b02ed56de8 "/home/travis/src/sql/sql_partition_admin.cc", line=line@entry=249, function=function@entry=0x55b02ed57540 <compare_table_with_partition(THD*, TABLE*, TABLE*, partition_element*, unsigned int)::__PRETTY_FUNCTION__> "bool compare_table_with_partition(THD*, TABLE*, TABLE*, partition_element*, uint)") at assert.c:92
            #7 0x00007f446b8d1ca2 in __GI___assert_fail (assertion=0x55b02ed56f38 "table->s->db_create_options == part_table->s->db_create_options", file=0x55b02ed56de8 "/home/travis/src/sql/sql_partition_admin.cc", line=249, function=0x55b02ed57540 <compare_table_with_partition(THD*, TABLE*, TABLE*, partition_element*, unsigned int)::__PRETTY_FUNCTION__> "bool compare_table_with_partition(THD*, TABLE*, TABLE*, partition_element*, uint)") at assert.c:101
            #8 0x000055b02e51545b in compare_table_with_partition (thd=0x7f4414000c00, table=0x7f440c6cc2d0, part_table=0x7f441405f570, part_elem=0x7f44142fdd20, part_id=1) at /home/travis/src/sql/sql_partition_admin.cc:248
            #9 0x000055b02e516327 in Sql_cmd_alter_table_exchange_partition::exchange_partition (this=0x7f44140145e0, thd=0x7f4414000c00, table_list=0x7f4414013958, alter_info=0x7f446842c270) at /home/travis/src/sql/sql_partition_admin.cc:593
            #10 0x000055b02e514de3 in Sql_cmd_alter_table_exchange_partition::execute (this=0x7f44140145e0, thd=0x7f4414000c00) at /home/travis/src/sql/sql_partition_admin.cc:96
            #11 0x000055b02e06d377 in mysql_execute_command (thd=0x7f4414000c00) at /home/travis/src/sql/sql_parse.cc:6248
            #12 0x000055b02e071d51 in mysql_parse (thd=0x7f4414000c00, rawbuf=0x7f4414013818 "ALTER TABLE q EXCHANGE PARTITION p1 WITH TABLE a /* QNO 1601 CON_ID 14 */", length=73, parser_state=0x7f446842d620, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7963
            #13 0x000055b02e05f71b in dispatch_command (command=COM_QUERY, thd=0x7f4414000c00, packet=0x7f441400b051 "ALTER TABLE q EXCHANGE PARTITION p1 WITH TABLE a /* QNO 1601 CON_ID 14 */ ", packet_length=74, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1825
            #14 0x000055b02e05e15b in do_command (thd=0x7f4414000c00) at /home/travis/src/sql/sql_parse.cc:1370
            #15 0x000055b02e1b7848 in do_handle_one_connection (connect=0x55b031ca9b80) at /home/travis/src/sql/sql_connect.cc:1420
            #16 0x000055b02e1b75d5 in handle_one_connection (arg=0x55b031ca9b80) at /home/travis/src/sql/sql_connect.cc:1326
            #17 0x00007f446c493184 in start_thread (arg=0x7f446842e700) at pthread_create.c:312
            #18 0x00007f446b99fffd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
            {noformat}

            {noformat}
            perl /home/travis/rqg//run-scenario.pl --grammar=conf/partitioning/partitions.yy --duration=400 --rpl-mode=mixed --threads=6 --queries=100M --redefine=/home/travis/rqg/conf/mariadb/instant_add.yy --mysqld=--max-statement-time=30 --reporters=Backtrace,ErrorLog,Deadlock --scenario=Restart --engine=InnoDB --mysqld=--innodb_stats_persistent=0 --seed=1513163173 --basedir=/home/travis/server --vardir=/home/travis/logs/vardir1_3
            {noformat}
            		{code:sql}
            --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;
            {code}

            {noformat:title=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
            {noformat}

            Reproducible on 10.x and MySQL 5.6, 5.7.
            Labels upstream
            Summary [Draft] Assertion `table->s->db_create_options == part_table->s->db_create_options' failed in compare_table_with_partition Assertion `table->s->db_create_options == part_table->s->db_create_options' failed in compare_table_with_partition
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Description {code:sql}
            --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;
            {code}

            {noformat:title=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
            {noformat}

            Reproducible on 10.x and MySQL 5.6, 5.7.             		{code:sql}
            --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;
            {code}

            {noformat:title=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
            {noformat}

            Reproducible on 10.x and MySQL 5.6, 5.7, filed as https://bugs.mysql.com/bug.php?id=88916
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Attachment threads [ 44784 ]
            elenst Elena Stepanova made changes -
            Description {code:sql}
            --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;
            {code}

            {noformat:title=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
            {noformat}

            Reproducible on 10.x and MySQL 5.6, 5.7, filed as https://bugs.mysql.com/bug.php?id=88916             		{code:sql}
            --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;
            {code}

            {noformat:title=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
            {noformat}

            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
            alice Alice Sherepa made changes -
            Affects Version/s 10.3 [ 22126 ]
            alice Alice Sherepa made changes -
            Affects Version/s 10.4 [ 22408 ]
            Affects Version/s 10.5 [ 23123 ]
            alice Alice Sherepa made changes -
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            alice Alice Sherepa made changes -
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.1 [ 16100 ]
            Roel Roel Van de Paar made changes -
            Affects Version/s 10.6 [ 24028 ]
            elenst Elena Stepanova made changes -
            Assignee Oleksandr Byelkin [ sanja ]
            elenst Elena Stepanova made changes -
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Alexey Botchkov [ holyfoot ]
            alice Alice Sherepa made changes -
            Fix Version/s 10.6 [ 24028 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 84415 ] MariaDB v4 [ 143992 ]
            holyfoot Alexey Botchkov made changes -
            Assignee Alexey Botchkov [ holyfoot ] Nayuta Yanagisawa [ JIRAUSER47117 ]
            alice Alice Sherepa made changes -
            Affects Version/s 10.7 [ 24805 ]
            alice Alice Sherepa made changes -
            Fix Version/s 10.7 [ 24805 ]
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            Status Confirmed [ 10101 ] In Review [ 10002 ]
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            Fix Version/s 10.2 [ 14601 ]
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.9 [ 26905 ]
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            Fix Version/s 10.3.36 [ 27513 ]
            Fix Version/s 10.4.26 [ 27511 ]
            Fix Version/s 10.5.17 [ 27509 ]
            Fix Version/s 10.6.9 [ 27507 ]
            Fix Version/s 10.7.5 [ 27505 ]
            Fix Version/s 10.8.4 [ 27503 ]
            Fix Version/s 10.9.2 [ 27115 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.7 [ 24805 ]
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.9 [ 26905 ]
            Resolution Fixed [ 1 ]
            Status In Review [ 10002 ] Closed [ 6 ]

            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.