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

Assertion `col->prtype == prtype' failed in innobase_rename_or_enlarge_column_try upon CHANGE COLUMN

    XMLWordPrintable

    Details

      Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
      ALTER TABLE t1 DROP PRIMARY KEY;
      ALTER TABLE t1 ADD d INT;
      ALTER TABLE t1 CHANGE pk f INT;
       
      # Cleanup
      DROP TABLE t1;
      

      10.4 5a087444

      mysqld: /data/src/10.4/storage/innobase/handler/handler0alter.cc:9087: bool innobase_rename_or_enlarge_column_try(const dict_table_t*, trx_t*, const char*, ulint, const Field&, bool): Assertion `col->prtype == prtype' failed.
      190301 12:39:06 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f2ce5087ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x0000557bd691ef7a in innobase_rename_or_enlarge_column_try (user_table=0x7f2c8c048328, trx=0x7f2cdac5b268, table_name=0x7f2c8c1a2485 "t1", pos=0, f=..., is_v=false) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:9087
      #9  0x0000557bd691f34a in innobase_rename_or_enlarge_columns_try (ha_alter_info=0x7f2cda370900, ctx=0x7f2c8c016b00, altered_table=0x7f2c8c0667f0, table=0x7f2c8c150840, trx=0x7f2cdac5b268, table_name=0x7f2c8c1a2485 "t1") at /data/src/10.4/storage/innobase/handler/handler0alter.cc:9158
      #10 0x0000557bd693030f in commit_try_norebuild (ha_alter_info=0x7f2cda370900, ctx=0x7f2c8c016b00, altered_table=0x7f2c8c0667f0, old_table=0x7f2c8c150840, trx=0x7f2cdac5b268, table_name=0x7f2c8c1a2485 "t1") at /data/src/10.4/storage/innobase/handler/handler0alter.cc:10140
      #11 0x0000557bd69222b0 in ha_innobase::commit_inplace_alter_table (this=0x7f2c8c051548, altered_table=0x7f2c8c0667f0, ha_alter_info=0x7f2cda370900, commit=true) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:10824
      #12 0x0000557bd659ecd4 in handler::ha_commit_inplace_alter_table (this=0x7f2c8c051548, altered_table=0x7f2c8c0667f0, ha_alter_info=0x7f2cda370900, commit=true) at /data/src/10.4/sql/handler.cc:4677
      #13 0x0000557bd6335491 in mysql_inplace_alter_table (thd=0x7f2c8c000b00, table_list=0x7f2c8c015590, table=0x7f2c8c150840, altered_table=0x7f2c8c0667f0, ha_alter_info=0x7f2cda370900, inplace_supported=HA_ALTER_INPLACE_INSTANT, target_mdl_request=0x7f2cda370b30, alter_ctx=0x7f2cda3710e0) at /data/src/10.4/sql/sql_table.cc:7695
      #14 0x0000557bd633bb05 in mysql_alter_table (thd=0x7f2c8c000b00, new_db=0x7f2c8c005290, new_name=0x7f2c8c005690, create_info=0x7f2cda371cd0, table_list=0x7f2c8c015590, alter_info=0x7f2cda371c10, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:9922
      #15 0x0000557bd63c9f44 in Sql_cmd_alter_table::execute (this=0x7f2c8c015d68, thd=0x7f2c8c000b00) at /data/src/10.4/sql/sql_alter.cc:499
      #16 0x0000557bd625b2e4 in mysql_execute_command (thd=0x7f2c8c000b00) at /data/src/10.4/sql/sql_parse.cc:6346
      #17 0x0000557bd626048c in mysql_parse (thd=0x7f2c8c000b00, rawbuf=0x7f2c8c0154a8 "ALTER TABLE t1 CHANGE pk f INT", length=30, parser_state=0x7f2cda373180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8157
      #18 0x0000557bd624bb7a in dispatch_command (command=COM_QUERY, thd=0x7f2c8c000b00, packet=0x7f2c8c139ff1 "ALTER TABLE t1 CHANGE pk f INT", packet_length=30, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1829
      #19 0x0000557bd624a34e in do_command (thd=0x7f2c8c000b00) at /data/src/10.4/sql/sql_parse.cc:1358
      #20 0x0000557bd63c3e59 in do_handle_one_connection (connect=0x557bda235de0) at /data/src/10.4/sql/sql_connect.cc:1399
      #21 0x0000557bd63c3bca in handle_one_connection (arg=0x557bda235de0) at /data/src/10.4/sql/sql_connect.cc:1302
      #22 0x0000557bd68bab51 in pfs_spawn_thread (arg=0x557bda27bc50) at /data/src/10.4/storage/perfschema/pfs.cc:1862
      #23 0x00007f2ce6d5e494 in start_thread (arg=0x7f2cda374700) at pthread_create.c:333
      #24 0x00007f2ce514493f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Not reproducible on 10.3.
      No obvious effect 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:
              4 Start watching this issue

                Dates

                Created:
                Updated: