InnoDB: Failing assertion: seg_inode in fsp0fsp.cc line 3246

[Ramesh Sivaraman]

2014-10-19 19:40:31 7fcc100f6700 InnoDB: Assertion failure in thread 140514419500800 in file fsp0fsp.cc line 3246
InnoDB: Failing assertion: seg_inode

*** Asserting query

CHECK TABLE t6

*** GDB info

#0 0x00007fcc2dd51771 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 0x00007fcc2c9555c9 in raise () from /lib64/libc.so.6
#5 0x00007fcc2c956cd8 in abort () from /lib64/libc.so.6
#6 0x0000000000d39d05 in fseg_page_is_free (seg_header=0x7fcc0b49404a "", space=110, page=3) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/fsp/fsp0fsp.cc:3246
#7 0x0000000000c8b90b in btr_validate_level (index=0x7fcbd40f90e8, trx=0x7fcbd4018e08, level=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0btr.cc:4710
#8 0x0000000000c8ca36 in btr_validate_index (index=0x7fcbd40f90e8, trx=0x7fcbd4018e08) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0btr.cc:5050
#9 0x0000000000adfd3f in ha_innobase::check (this=0x7fcbd429d120, thd=0x2bf75e0, check_opt=0x2bfa908) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/handler/ha_innodb.cc:12090
#10 0x0000000000645b27 in handler::ha_check (this=0x7fcbd429d120, thd=0x2bf75e0, check_opt=0x2bfa908) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.cc:4276
#11 0x00000000009a0eb8 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *)) (thd=0x2bf75e0, tables=0x7fcbd4005170, check_opt=0x2bfa908, operator_name=0xfe9bf4 "check", lock_type=TL_READ_NO_INSERT, open_for_modify=false, repair_table_use_frm=false, extra_open_options=32, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x645a02 <handler::ha_check(THD*, st_ha_check_opt*)>, view_operator_func=0x88322b <view_checksum(THD*, TABLE_LIST*)>) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_admin.cc:654
#12 0x00000000009a27e6 in Sql_cmd_check_table::execute (this=0x7fcbd40056d8, thd=0x2bf75e0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_admin.cc:1108
#13 0x00000000007e9da3 in mysql_execute_command (thd=0x2bf75e0) 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
#14 0x00000000007ed193 in mysql_parse (thd=0x2bf75e0, rawbuf=0x7fcbd40050a0 "CHECK TABLE t6", length=14, parser_state=0x7fcc100f4e30) 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
#15 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x2bf75e0, packet=0x33f4141 "", packet_length=15) 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
#16 0x00000000007de528 in do_command (thd=0x2bf75e0) 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
#17 0x00000000007a64e5 in do_handle_one_connection (thd_arg=0x2bf75e0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1532
#18 0x00000000007a5fed in handle_one_connection (arg=0x2bf75e0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1443
#19 0x0000000000dc5bac in pfs_spawn_thread (arg=0x3367130) 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
#20 0x00007fcc2dd4cdf3 in start_thread () from /lib64/libpthread.so.0
#21 0x00007fcc2ca1601d in clone () from /lib64/libc.so.6

[Ramesh Sivaraman (rameshvs02)]

Core, GDB, error log etc

[Ramesh Sivaraman (rameshvs02)]

Single threaded run, single mysqld involved

[Ramesh Sivaraman (rameshvs02)]

**** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
SET global innodb_rollback_segments=-7;
SET GLOBAL innodb_corrupt_table_action='warn';
set global innodb_trx_rseg_n_slots_debug=1;
create TABLE t1(f1 date);
DROP TABLE t1;
CHECK TABLE t1 EXTENDED;

When we remove "SET GLOBAL innodb_corrupt_table_action='warn';" from above testcase, getting similar assertion and it is found in upstream : http://bugs.mysql.com/bug.php?id=74663.

*** ** testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
SET global innodb_rollback_segments=-7;
set global innodb_trx_rseg_n_slots_debug=1;
create TABLE t1(f1 date);
DROP TABLE t1;
CHECK TABLE t1 EXTENDED;

**** GDB
#0 0x00007f7280597771 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 0x00007f727f19b5c9 in raise () from /lib64/libc.so.6
#5 0x00007f727f19ccd8 in abort () from /lib64/libc.so.6
#6 0x0000000000d36cd4 in fseg_inode_get (header=0x7f720e7ec04a "", space=6, zip_size=0, mtr=0x7f7280b85280) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/fsp/fsp0fsp.cc:1899
#7 0x0000000000d39cd4 in fseg_page_is_free (seg_header=0x7f720e7ec04a "", space=6, page=3) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/fsp/fsp0fsp.cc:3244
#8 0x0000000000c8b90b in btr_validate_level (index=0x7f71c286bff8, trx=0x7f71c28ca478, level=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0btr.cc:4710
#9 0x0000000000c8ca36 in btr_validate_index (index=0x7f71c286bff8, trx=0x7f71c28ca478) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0btr.cc:5050
#10 0x0000000000adfd3f in ha_innobase::check (this=0x7f71c28aa510, thd=0x7f71ebbf2000, check_opt=0x7f71ebbf5328) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/handler/ha_innodb.cc:12090
#11 0x0000000000645b27 in handler::ha_check (this=0x7f71c28aa510, thd=0x7f71ebbf2000, check_opt=0x7f71ebbf5328) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.cc:4276
#12 0x00000000009a0eb8 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *)) (thd=0x7f71ebbf2000, tables=0x7f71c281f0f0, check_opt=0x7f71ebbf5328, operator_name=0xfe9bf4 "check", lock_type=TL_READ_NO_INSERT, open_for_modify=false, repair_table_use_frm=false, extra_open_options=32, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, TH...

[Roel Van de Paar (roel11)]

See also bug 1385028

[Roel Van de Paar (roel11)]

See also usptream bugs;
https://bugs.mysql.com/bug.php?id=74663
https://bugs.mysql.com/bug.php?id=74682
https://bugs.mysql.com/bug.php?id=74876 ?

[Shahriyar Rzayev (rzayev-sehriyar)]

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