InnoDB: Failing assertion: 0 in file handler0alter.cc line 5694 | tablespace issues | abort (sig=6) in ha_innobase::commit_inplace_alter_table

[Roel Van de Paar]

2014-10-20 21:33:58 6384 [ERROR] /sda/Percona-Server-5.6.21-rel69.0-681.Linux.x86_64-debug/bin/mysqld: Sort aborted: Tablespace has been discarded for table 't2'
2014-10-20 21:33:58 6384 [ERROR] InnoDB: The table test/t2 doesn't have a corresponding tablespace, it was discarded.
2014-10-20 21:33:58 6384 [Note] InnoDB: Saving InnoDB page number: 1
2014-10-20 21:33:58 6384 [ERROR] InnoDB: Cannot delete tablespace 77 because it is not found in the tablespace memory cache.
2014-10-20 21:33:58 7fc2b0488700 InnoDB: cannot calculate statistics for table "test"."t2" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-10-20 21:34:08 6384 [ERROR] InnoDB: The table test/t2 doesn't have a corresponding tablespace, it was discarded.
2014-10-20 21:34:08 7fc2b0488700 InnoDB: cannot calculate statistics for table "test"."t2" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-10-20 21:34:08 6384 [ERROR] /sda/Percona-Server-5.6.21-rel69.0-681.Linux.x86_64-debug/bin/mysqld: Sort aborted: Tablespace has been discarded for table 't2'
2014-10-20 21:34:08 7fc2b0488700 InnoDB: cannot calculate statistics for table "test"."t2" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
2014-10-20 21:34:08 6384 [ERROR] InnoDB: Cannot delete tablespace 87 because it is not found in the tablespace memory cache.
2014-10-20 21:34:08 6384 [ERROR] InnoDB: dict_load_foreigns() returned 38 for alter table t2 row_format = dynamic
2014-10-20 21:34:08 7fc2b0447700 InnoDB: Assertion failure in thread 140474157659904 in file handler0alter.cc line 5694
InnoDB: Failing assertion: 0
[...]
10:34:08 UTC - mysqld got signal 6 ;
[...]
Query (7fc24c004e90): alter table t2 row_format = dynamic
Connection ID (thread ID): 4

Single threaded run, single mysqld involved

Thread 1 (Thread 0x7fc2b0447700 (LWP 6970)):
+bt
#0 0x00007fc2b9289771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab7586 in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/stacktrace.c:422
#2 0x000000000072f9ff in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007fc2b7e8d5c9 in raise () from /lib64/libc.so.6
#5 0x00007fc2b7e8ecd8 in abort () from /lib64/libc.so.6
#6 0x0000000000afa1bc in ha_innobase::commit_inplace_alter_table (this=0x7fc24c09cb50, altered_table=0x7fc250089100, ha_alter_info=0x7fc2b0443090, commit=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/handler/handler0alter.cc:5694
#7 0x00000000006463c6 in handler::ha_commit_inplace_alter_table (this=0x7fc24c09cb50, altered_table=0x7fc250089100, ha_alter_info=0x7fc2b0443090, commit=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.cc:4573
#8 0x00000000008573aa in mysql_inplace_alter_table (thd=0x321f460, table_list=0x7fc24c004f88, table=0x7fc24c0a1530, altered_table=0x7fc250089100, ha_alter_info=0x7fc2b0443090, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7fc2b0442ae0, alter_ctx=0x7fc2b04435f0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_table.cc:6654
#9 0x000000000085c080 in mysql_alter_table (thd=0x321f460, new_db=0x7fc24c0054e8 "test", new_name=0x0, create_info=0x7fc2b04444b0, table_list=0x7fc24c004f88, alter_info=0x7fc2b04443f0, order_num=0, order=0x0, ignore=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_table.cc:8638
#10 0x00000000009a3d65 in Sql_cmd_alter_table::execute (this=0x7fc24c0054f0, thd=0x321f460) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_alter.cc:317
#11 0x00000000007e9da3 in mysql_execute_command (thd=0x321f460) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:5411
#12 0x00000000007ed193 in mysql_parse (thd=0x321f460, rawbuf=0x7fc24c004e90 "alter table t2 row_format = dynamic", length=35, parser_state=0x7fc2b0445d50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
#13 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x321f460, packet=0x3a0f041 "alter table t2 row_format = dynamic;", packet_length=36) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
#14 0x00000000007de528 in do_command (thd=0x321f460) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
#15 0x00000000008c2c30 in threadpool_process_request (thd=0x321f460) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_common.cc:311
#16 0x00000000008c5572 in handle_event (connection=0x39bb020) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1553
#17 0x00000000008c57a2 in worker_main (param=0x1898400 <all_groups+2048>) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1606
#18 0x0000000000dc5bac in pfs_spawn_thread (arg=0x7fc24c004ba0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/perfschema/pfs.cc:1860
#19 0x00007fc2b9284df3 in start_thread () from /lib64/libpthread.so.0
#20 0x00007fc2b7f4e01d in clone () from /lib64/libc.so.6

[Ramesh Sivaraman (rameshvs02)]

This is an upstream bug : http://bugs.mysql.com/bug.php?id=74363

**** testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
create table t1(a int not null,b int not null,index idx(a));
CREATE TABLE t2(a INT KEY,b INT,INDEX ind (b),FOREIGN KEY (b) REFERENCES t1(a) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB;
ALTER TABLE t1 CHANGE a id INT;

[Shahriyar Rzayev (rzayev-sehriyar)]

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