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

Assertion `tab_part_info->part_type == LIST_PARTITION' failed in prep_alter_part_table

    XMLWordPrintable

    Details

      Description

      --source include/have_partition.inc
       
      CREATE OR REPLACE TABLE t1 (i INT) PARTITION BY HASH(i) PARTITIONS 2;
      ALTER TABLE t1 ADD PARTITION (PARTITION px VERSIONING);
       
      # Cleanup
      DROP TABLE t1;
      

      bb-10.3-temporal 2ae2876a6ce4

      mysqld: /data/src/bb-10.3-temporal/sql/sql_partition.cc:4745: uint prep_alter_part_table(THD*, TABLE*, Alter_info*, HA_CREATE_INFO*, Alter_table_ctx*, bool*, bool*): Assertion `tab_part_info->part_type == LIST_PARTITION' failed.
      171217  2:24:49 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007ff42381dee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055a1fa8c195a in prep_alter_part_table (thd=0x7ff40c000b00, table=0x7ff40c091b80, alter_info=0x7ff41da8abe0, create_info=0x7ff41da8ac90, alter_ctx=0x7ff41da8a070, partition_changed=0x7ff41da8917b, fast_alter_table=0x7ff41da8917c) at /data/src/bb-10.3-temporal/sql/sql_partition.cc:4745
      #9  0x000055a1fa4f1a9e in mysql_alter_table (thd=0x7ff40c000b00, new_db=0x7ff40c015398 "test", new_name=0x0, create_info=0x7ff41da8ac90, table_list=0x7ff40c014d60, alter_info=0x7ff41da8abe0, order_num=0, order=0x0, ignore=false) at /data/src/bb-10.3-temporal/sql/sql_table.cc:9161
      #10 0x000055a1fa57af61 in Sql_cmd_alter_table::execute (this=0x7ff40c015710, thd=0x7ff40c000b00) at /data/src/bb-10.3-temporal/sql/sql_alter.cc:331
      #11 0x000055a1fa41e5a5 in mysql_execute_command (thd=0x7ff40c000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:6258
      #12 0x000055a1fa4230e4 in mysql_parse (thd=0x7ff40c000b00, rawbuf=0x7ff40c014c48 "ALTER TABLE t1 ADD PARTITION (PARTITION px VERSIONING)", length=54, parser_state=0x7ff41da8c5f0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:7988
      #13 0x000055a1fa4108a7 in dispatch_command (command=COM_QUERY, thd=0x7ff40c000b00, packet=0x7ff40c11ee21 "ALTER TABLE t1 ADD PARTITION (PARTITION px VERSIONING)", packet_length=54, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1826
      #14 0x000055a1fa40f2db in do_command (thd=0x7ff40c000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1371
      #15 0x000055a1fa575ada in do_handle_one_connection (connect=0x55a1fc995810) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420
      #16 0x000055a1fa575867 in handle_one_connection (arg=0x55a1fc995810) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326
      #17 0x000055a1faa0bcfc in pfs_spawn_thread (arg=0x55a1fc99d780) at /data/src/bb-10.3-temporal/storage/perfschema/pfs.cc:1863
      #18 0x00007ff4254f4494 in start_thread (arg=0x7ff41da8d700) at pthread_create.c:333
      #19 0x00007ff4238da93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Reproducible with InnoDB, MyISAM, Aria.

        Attachments

          Activity

            People

            Assignee:
            midenok Aleksey Midenkov
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.