Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.1(EOL), 11.2, 11.4, 10.5.3, 10.4(EOL), 11.0(EOL), 11.3(EOL)
-
None
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
- relates to
-
MDEV-15563 Instant failure-free data type conversions
- Closed