abort in dict_table_check_for_dup_indexes | InnoDB: Assertion failure in thread <nr> in file dict0dict.cc line 5917

[Roel Van de Paar]

Thread 1 (LWP 22443):
+bt
#0 0x000000340cc0c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000686bde in handle_fatal_signal (sig=6) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/signal_handler.cc:251
#2 <signal handler called>
#3 0x000000340c4328a5 in raise () from /lib64/libc.so.6
#4 0x000000340c434085 in abort () from /lib64/libc.so.6
#5 0x0000000000b9d44e in dict_table_check_for_dup_indexes (table=<optimized out>, check=CHECK_ABORTED_OK) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc:5917
#6 0x0000000000a192c2 in ha_innobase::prepare_inplace_alter_table (this=0x7f01f8033280, altered_table=0x7f01f407f070, ha_alter_info=0x7f023c13dad0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/handler0alter.cc:3304
#7 0x0000000000c58686 in ha_partition::prepare_inplace_alter_table (this=0x7f01f804da70, altered_table=0x7f01f407f070, ha_alter_info=0x7f023c13dad0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/ha_partition.cc:7920
#8 0x000000000077dc9b in mysql_inplace_alter_table (thd=0x23a9710, table_list=0x7f01f4004e08, table=0x7f01f80811f0, altered_table=0x7f01f407f070, ha_alter_info=0x7f023c13dad0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f023c13d7d0, alter_ctx=0x7f023c13c1b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:6454
#9 0x00000000007839b7 in mysql_alter_table (thd=<optimized out>, new_db=0x7f01f407f070 "@\371\a\364\001\177", new_name=0x7f01f4035390 "\f", create_info=<optimized out>, table_list=0x7f01f4004e08, alter_info=0x7f023c13e270, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:8354
#10 0x0000000000892ca7 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x23a9710) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_alter.cc:317
#11 0x000000000072102b in mysql_execute_command (thd=0x23a9710) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5157
#12 0x0000000000727818 in mysql_parse (thd=0x23a9710, rawbuf=0x23abad8 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#13 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x23a9710, packet=0x23ad6a1 " ALTER TABLE table1_key_pk_parts_2_int ADD INDEX `test_idx` USING BTREE (`col_int_key` , `col_int`, `pk` ) ", packet_length=107) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#14 0x0000000000729a47 in do_command (thd=0x23a9710) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#15 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#16 0x00000000006ed727 in handle_one_connection (arg=0x23a9710) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#17 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#18 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#19 0x000000340c4e890d in clone () from /lib64/libc.so.6

2013-07-14 11:46:58 22407 [ERROR] /ssd/Percona-Server-5.6.12-rc60.4-405-debug.Linux.x86_64/bin/mysqld: Sort aborted: Lock wait timeout exceeded; try restarting transaction
2013-07-14 11:46:59 7f023c140700 InnoDB: Assertion failure in thread 139647574607616 in file dict0dict.cc line 5917
InnoDB: We intentionally generate a memory trap.
[...]
Query (7f01f4004c50): ALTER TABLE table1_key_pk_parts_2_int ADD INDEX `test_idx` USING BTREE (`col_int_key` , `col_int`, `pk` )
Connection ID (thread ID): 10
Status: NOT_KILLED

[Roel Van de Paar (roel11)]

No yy file available

[Laurynas Biveinis (laurynas-biveinis)]

Upstream.

[Roel Van de Paar (roel11)]

Laurynas, feel free to remove 56qual tag if this bug is "as good as certain" upstream.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-708