Bug #74876 InnoDB: Failing assertion: inode in file fsp0fsp.cc line 1887 | fseg_inode_get
Submitted: 15 Nov 2014 5:02 Modified: 16 Feb 2015 20:15
Reporter: Roel Van de Paar Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S6 (Debug Builds)
Version:5.6.20, 5.6.23, 5.7.5-m15, 5.7.6 OS:Any
Assigned to: CPU Architecture:Any
Tags: debug

[15 Nov 2014 5:02] Roel Van de Paar
Description:
2014-11-15 15:58:08 7f9cfc8cd700  InnoDB: Assertion failure in thread 140312228714240 in file fsp0fsp.cc line 1887
InnoDB: Failing assertion: inode
[...]
Some pointers may be invalid and cause the dump to abort.
Query (7f9c5ec1f010): ANALYZE TABLE t1

Lots of other resulting errors in error log also

(gdb) bt
#0  0x00007ff3de8a1771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000a9035e in my_write_core (sig=6) at /bzr/mysql-5.6/mysys/stacktrace.c:422
#2  0x0000000000723688 in handle_fatal_signal (sig=6) at /bzr/mysql-5.6/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007ff3dd6ad5c9 in raise () from /lib64/libc.so.6
#5  0x00007ff3dd6aecd8 in abort () from /lib64/libc.so.6
#6  0x0000000000daabb0 in fseg_inode_get (header=0x7ff35e0e4054 "", space=0, zip_size=0, mtr=0x7ff3dee94c50) at /bzr/mysql-5.6/storage/innobase/fsp/fsp0fsp.cc:1887
#7  0x0000000000dab801 in fseg_n_reserved_pages (header=0x7ff35e0e4054 "", used=0x7ff3dee94bf0, mtr=0x7ff3dee94c50) at /bzr/mysql-5.6/storage/innobase/fsp/fsp0fsp.cc:2216
#8  0x0000000000cff30c in btr_get_size (index=0x7ff34106e178, flag=2, mtr=0x7ff3dee94c50) at /bzr/mysql-5.6/storage/innobase/btr/btr0btr.cc:1219
#9  0x0000000000d898d5 in dict_stats_analyze_index (index=0x7ff34106e178) at /bzr/mysql-5.6/storage/innobase/dict/dict0stats.cc:1910
#10 0x0000000000d8a369 in dict_stats_update_persistent (table=0x7ff341082378) at /bzr/mysql-5.6/storage/innobase/dict/dict0stats.cc:2209
#11 0x0000000000d8bf0f in dict_stats_update (table=0x7ff341082378, stats_upd_option=DICT_STATS_RECALC_PERSISTENT) at /bzr/mysql-5.6/storage/innobase/dict/dict0stats.cc:3127
#12 0x0000000000b702a0 in ha_innobase::info_low (this=0x7ff341080010, flag=28, is_analyze=true) at /bzr/mysql-5.6/storage/innobase/handler/ha_innodb.cc:10834
#13 0x0000000000b70c8c in ha_innobase::analyze (this=0x7ff341080010, thd=0x7ff34b324000, check_opt=0x7ff34b326f28) at /bzr/mysql-5.6/storage/innobase/handler/ha_innodb.cc:11180
#14 0x000000000063bd21 in handler::ha_analyze (this=0x7ff341080010, thd=0x7ff34b324000, check_opt=0x7ff34b326f28) at /bzr/mysql-5.6/sql/handler.cc:4287
#15 0x000000000097e965 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=0x7ff34b324000, tables=0x7ff34101f0e8, check_opt=0x7ff34b326f28, operator_name=0xf8dc97 "analyze", lock_type=TL_READ_NO_INSERT, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x63bca0 <handler::ha_analyze(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /bzr/mysql-5.6/sql/sql_admin.cc:654
#16 0x00000000009800be in Sql_cmd_analyze_table::execute (this=0x7ff34101f650, thd=0x7ff34b324000) at /bzr/mysql-5.6/sql/sql_admin.cc:1076
#17 0x00000000007d5ea3 in mysql_execute_command (thd=0x7ff34b324000) at /bzr/mysql-5.6/sql/sql_parse.cc:4945
#18 0x00000000007d8fa4 in mysql_parse (thd=0x7ff34b324000, rawbuf=0x7ff34101f010 "ANALYZE TABLE t1", length=16, parser_state=0x7ff3dee98e70) at /bzr/mysql-5.6/sql/sql_parse.cc:6245
#19 0x00000000007cc557 in dispatch_command (command=COM_QUERY, thd=0x7ff34b324000, packet=0x7ff34b362001 "", packet_length=16) at /bzr/mysql-5.6/sql/sql_parse.cc:1332
#20 0x00000000007cb646 in do_command (thd=0x7ff34b324000) at /bzr/mysql-5.6/sql/sql_parse.cc:1034
#21 0x0000000000793a61 in do_handle_one_connection (thd_arg=0x7ff34b324000) at /bzr/mysql-5.6/sql/sql_connect.cc:982
#22 0x000000000079354a in handle_one_connection (arg=0x7ff34b324000) at /bzr/mysql-5.6/sql/sql_connect.cc:898
#23 0x0000000000ade888 in pfs_spawn_thread (arg=0x7ff3d7f49b00) at /bzr/mysql-5.6/storage/perfschema/pfs.cc:1860
#24 0x00007ff3de89cdf3 in start_thread () from /lib64/libpthread.so.0
#25 0x00007ff3dd76e01d in clone () from /lib64/libc.so.6

How to repeat:
1. Open mysql client
2. Execute, 2-10 times this testcase;
   mysql> source pquery_thread-0.sql_out_out
3. If the issue does not repeat, shutdown and restart server, retry, up to 5 times
[15 Nov 2014 5:03] Roel Van de Paar
See bug #74663
[15 Nov 2014 5:07] Roel Van de Paar
pquery_thread-0.sql_out_out

Attachment: pquery_thread-0.sql_out_out (application/octet-stream, text), 3.36 KiB.

[15 Nov 2014 6:50] MySQL Verification Team
Hello Roel,

Thank you for the report.
Confirmed that only debug builds(5.6.23, 5.7.6) are affected.

Thanks,
Umesh
[15 Nov 2014 6:50] MySQL Verification Team
// 5.6.23 - 3rd attempt triggered the issue

scripts/mysql_install_db --basedir=/data/ushastry/server/mysql-advanced-5.6.23 --datadir=/tmp/bug --user=root
bin/mysqld-debug --basedir=/data/ushastry/server/mysql-advanced-5.6.23 --datadir=/tmp/bug --core --socket=/tmp/mysql.sock  --port=3306 --log-error=/tmp/bug/log.err --user=root 2>&1 &

(gdb) bt
#0  __pthread_kill (threadid=<value optimized out>, signo=<value optimized out>) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63
#1  0x0000000000affdab in my_write_core (sig=6) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/mysys/stacktrace.c:422
#2  0x000000000077ebbc in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x0000003deac32625 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#5  0x0000003deac33e05 in abort () at abort.c:92
#6  0x0000000000de144d in fseg_inode_get (header=0x7f6e353c0054 "", space=0, zip_size=0, mtr=0x7f6e2eeb9870)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/fsp/fsp0fsp.cc:1887
#7  0x0000000000de20f1 in fseg_n_reserved_pages (header=0x7f6e353c0054 "", used=0x7f6e2eeb9820, mtr=0x7f6e2eeb9870)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/fsp/fsp0fsp.cc:2216
#8  0x0000000000d33c29 in btr_get_size (index=0x7f6e00069b78, flag=2, mtr=0x7f6e2eeb9870)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/btr/btr0btr.cc:1219
#9  0x0000000000dbfa7b in dict_stats_analyze_index (index=0x7f6e00069b78) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/dict/dict0stats.cc:1910
#10 0x0000000000dc04dd in dict_stats_update_persistent (table=0x7f6e000686e8) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/dict/dict0stats.cc:2209
#11 0x0000000000dc20b1 in dict_stats_update (table=0x7f6e000686e8, stats_upd_option=DICT_STATS_RECALC_PERSISTENT)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/dict/dict0stats.cc:3127
#12 0x0000000000dc2396 in dict_stats_update (table=0x7f6e000686e8, stats_upd_option=DICT_STATS_FETCH_ONLY_IF_NOT_IN_MEMORY)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/dict/dict0stats.cc:3248
#13 0x0000000000b92a40 in dict_stats_init (table=0x7f6e000686e8) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/include/dict0stats.ic:174
#14 0x0000000000b980be in ha_innobase::open (this=0x7f6e00063970, name=0x7f6e00067c80 "./test/@0060ab@0060@0060cd@0060", mode=2, test_if_locked=2)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/handler/ha_innodb.cc:4892
#15 0x000000000068f1d3 in handler::ha_open (this=0x7f6e00063970, table_arg=0x7f6e0006dfc0, name=0x7f6e00067c80 "./test/@0060ab@0060@0060cd@0060", mode=2, test_if_locked=2)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/handler.cc:2505
#16 0x00000000008f0cfa in open_table_from_share (thd=0x2e91b50, share=0x7f6e00067950, alias=0x7f6e000050c8 "`ab``cd`", db_stat=39, prgflag=44, ha_open_flags=0, outparam=0x7f6e0006dfc0,
    is_create_table=false) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/table.cc:2344
#17 0x00000000007c0a7b in open_table (thd=0x2e91b50, table_list=0x7f6e000050d8, ot_ctx=0x7f6e2eebaed0)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_base.cc:3159
#18 0x00000000007c3128 in open_and_process_table (thd=0x2e91b50, lex=0x2e93cc0, tables=0x7f6e000050d8, counter=0x7f6e2eebb048, flags=0, prelocking_strategy=0x7f6e2eebafc0,
    has_prelocking_list=false, ot_ctx=0x7f6e2eebaed0) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_base.cc:4648
#19 0x00000000007c3e36 in open_tables (thd=0x2e91b50, start=0x2e93cd0, counter=0x7f6e2eebb048, flags=0, prelocking_strategy=0x7f6e2eebafc0)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_base.cc:5088
#20 0x0000000000809fde in open_tables (thd=0x2e91b50, tables=0x2e93cd0, counter=0x7f6e2eebb048, flags=0)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_base.h:451
#21 0x000000000089b8c2 in mysql_create_table (thd=0x2e91b50, create_table=0x7f6e000050d8, create_info=0x7f6e2eebb660, alter_info=0x7f6e2eebb0b0)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_table.cc:5057
#22 0x000000000082ea9c in mysql_execute_command (thd=0x2e91b50) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_parse.cc:3061
#23 0x0000000000837fa9 in mysql_parse (thd=0x2e91b50, rawbuf=0x7f6e00004fd0 "CREATE TABLE ```ab````cd``` (i INT)", length=35, parser_state=0x7f6e2eebc680)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_parse.cc:6357
#24 0x000000000082a92b in dispatch_command (command=COM_QUERY, thd=0x2e91b50, packet=0x2fc03e1 "CREATE TABLE ```ab````cd``` (i INT)", packet_length=35)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_parse.cc:1332
#25 0x0000000000829990 in do_command (thd=0x2e91b50) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_parse.cc:1034
#26 0x00000000007f0d8f in do_handle_one_connection (thd_arg=0x2e91b50) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_connect.cc:982
#27 0x00000000007f0860 in handle_one_connection (arg=0x2e91b50) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_connect.cc:898
#28 0x0000000000e5f509 in pfs_spawn_thread (arg=0x2f83b10) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/perfschema/pfs.cc:1860
#29 0x0000003deb0079d1 in start_thread (arg=0x7f6e2eebd700) at pthread_create.c:301
#30 0x0000003deace89dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115
[15 Nov 2014 6:51] MySQL Verification Team
// 5.7.6

bin/mysql_install_db --basedir=/data/ushastry/server/mysql-advanced-5.7.6 --datadir=/tmp/bug --user=root -v
bin/mysqld-debug --basedir=/data/ushastry/server/mysql-advanced-5.7.6 --datadir=/tmp/bug --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=/tmp/bug/log.err --user=root 2>&1 &

(gdb) bt
#0  __pthread_kill (threadid=<value optimized out>, signo=<value optimized out>) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63
#1  0x0000000000f990a1 in my_write_core (sig=6) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/mysys/stacktrace.c:247
#2  0x000000000092d7cc in handle_fatal_signal (sig=6) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/signal_handler.cc:219
#3  <signal handler called>
#4  0x0000003deac32625 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#5  0x0000003deac33e05 in abort () at abort.c:92
#6  0x000000000121b81b in ut_dbg_assertion_failed (expr=0x17843f6 "inode", file=0x17838c0 "/pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/fsp/fsp0fsp.cc",
    line=2034) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/ut/ut0dbg.cc:67
#7  0x000000000130378c in fseg_inode_get (header=0x7fc9e4490054 "", space=0, page_size=..., mtr=0x7fc9f1ea3340)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/fsp/fsp0fsp.cc:2034
#8  0x00000000013044da in fseg_n_reserved_pages (header=0x7fc9e4490054 "", used=0x7fc9f1ea32e0, mtr=0x7fc9f1ea3340)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/fsp/fsp0fsp.cc:2366
#9  0x000000000123048d in btr_get_size (index=0x7fc9ac02d718, flag=2, mtr=0x7fc9f1ea3340) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:545
#10 0x00000000012ddf2d in dict_stats_analyze_index (index=0x7fc9ac02d718) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/dict/dict0stats.cc:1894
#11 0x00000000012de8e4 in dict_stats_update_persistent (table=0x7fc9ac043ad8) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/dict/dict0stats.cc:2195
#12 0x00000000012e07db in dict_stats_update (table=0x7fc9ac043ad8, stats_upd_option=DICT_STATS_RECALC_PERSISTENT)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/dict/dict0stats.cc:3094
#13 0x0000000001046d03 in ha_innobase::info_low (this=0x7fc9ac050060, flag=28, is_analyze=true)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:11488
#14 0x000000000104792e in ha_innobase::analyze (this=0x7fc9ac050060, thd=0x7fc9ac000d30, check_opt=0x7fc9ac003528)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:11917
#15 0x000000000099864d in handler::ha_analyze (this=0x7fc9ac050060, thd=0x7fc9ac000d30, check_opt=0x7fc9ac003528)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/handler.cc:4386
#16 0x0000000000e7a4b1 in mysql_admin_table (thd=0x7fc9ac000d30, tables=0x7fc9ac005db8, check_opt=0x7fc9ac003528, operator_name=0x1687357 "analyze", lock_type=TL_READ_NO_INSERT,
    open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0, operator_func=
    (int (handler::*)(handler *, THD *, HA_CHECK_OPT *)) 0x9985c8 <handler::ha_analyze(THD*, HA_CHECK_OPT*)>, view_operator_func=0)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_admin.cc:663
#17 0x0000000000e7bed2 in Sql_cmd_analyze_table::execute (this=0x7fc9ac006338, thd=0x7fc9ac000d30) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_admin.cc:1101
#18 0x0000000000cbb4f7 in mysql_execute_command (thd=0x7fc9ac000d30) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:4785
#19 0x0000000000cbce6a in mysql_parse (thd=0x7fc9ac000d30, parser_state=0x7fc9f1ea7660) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:5397
#20 0x0000000000cb0f2c in dispatch_command (command=COM_QUERY, thd=0x7fc9ac000d30, packet=0x7fc9ac009a61 "", packet_length=16)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:1249
#21 0x0000000000cafbd4 in do_command (thd=0x7fc9ac000d30) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:833
#22 0x0000000000dbe89c in handle_connection (arg=0x359c820) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298
#23 0x000000000138347f in pfs_spawn_thread (arg=0x33f2e40) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs.cc:2137
#24 0x0000003deb0079d1 in start_thread (arg=0x7fc9f1ea8700) at pthread_create.c:301
#25 0x0000003deace89dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115
[14 Feb 2015 7:11] Roel Van de Paar
Shorter testcase for 5.7.5-m15

DROP DATABASE test;CREATE DATABASE test;USE test;
DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_fetch_nonexistent';
CREATE TABLE t1 (a INT NOT NULL);
DROP TABLE t1;
CREATE TABLE mytable_ref (id INT,CONSTRAINT FOREIGN KEY (id) REFERENCES FOO(id) ON DELETE CASCADE) ENGINE=InnoDB;
DROP TABLE t1;
SET @@GLOBAL.INNODB_TRX_RSEG_N_SLOTS_DEBUG=1;
INSERT INTO t1  VALUES (INET6_ATON('1.2.3.4')),(INET6_ATON('255.255.255.255')),(INET6_ATON('::1.2.3.4')),(INET6_ATON('::ffff:255.255.255.255')),(INET6_ATON('::')),(INET6_ATON('::1')),(INET6_ATON('1020:3040:5060:7080:90A0:B0C0:D0E0:F010'));
SET GLOBAL INNODB_FILE_PER_TABLE=0;
CREATE TABLE `?s?R` (`?b?P` CHAR(20)) DEFAULT CHARSET=sjis ENGINE=InnoDB;

Execute this testcase numerous times in the client, quickly after each other. It will crash after 5-30 times paste/paste/paste/...

After the server is restarted, sometimes another crash can be triggered with less statements from the testcase above. It may be that the server is "holding on" to a trx even across mysqld restarts.

(gdb) bt
#0  0x00007f80e35fa771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000e15cd8 in my_write_core (sig=6) at /bzr/testbuild/mysql-5.7.5-m15_dbg/mysys/stacktrace.c:247
#2  0x0000000000822044 in handle_fatal_signal (sig=6) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/signal_handler.cc:219
#3  <signal handler called>
#4  0x00007f80e21fe5c9 in raise () from /lib64/libc.so.6
#5  0x00007f80e21ffcd8 in abort () from /lib64/libc.so.6
#6  0x00000000010d4a9b in ut_dbg_assertion_failed (expr=0x151c02e "inode", file=0x151b510 "/bzr/testbuild/mysql-5.7.5-m15_dbg/storage/innobase/fsp/fsp0fsp.cc",line=2025) at /bzr/testbuild/mysql-5.7.5-m15_dbg/storage/innobase/ut/ut0dbg.cc:68
#7  0x00000000011ba00f in fseg_inode_get (header=0x7f8035c18054 "", space=31, page_size=..., mtr=0x7f80e3bee3a0) at /bzr/testbuild/mysql-5.7.5-m15_dbg/storage/innobase/fsp/fsp0fsp.cc:2025
#8  0x00000000011baccd in fseg_n_reserved_pages (header=0x7f8035c18054 "", used=0x7f80e3bee330, mtr=0x7f80e3bee3a0) at /bzr/testbuild/mysql-5.7.5-m15_dbg/storage/innobase/fsp/fsp0fsp.cc:2366
#9  0x00000000010e96fc in btr_get_size (index=0x7f80274acc98, flag=2, mtr=0x7f80e3bee3a0) at /bzr/testbuild/mysql-5.7.5-m15_dbg/storage/innobase/btr/btr0btr.cc:566
#10 0x0000000001195ccc in dict_stats_analyze_index (index=0x7f80274acc98) at /bzr/testbuild/mysql-5.7.5-m15_dbg/storage/innobase/dict/dict0stats.cc:1904
#11 0x000000000119668c in dict_stats_update_persistent (table=0x7f802753b318) at /bzr/testbuild/mysql-5.7.5-m15_dbg/storage/innobase/dict/dict0stats.cc:2205
#12 0x00000000011985cf in dict_stats_update (table=0x7f802753b318, stats_upd_option=DICT_STATS_RECALC_PERSISTENT) at /bzr/testbuild/mysql-5.7.5-m15_dbg/storage/innobase/dict/dict0stats.cc:3119
#13 0x0000000001198968 in dict_stats_update (table=0x7f802753b318, stats_upd_option=DICT_STATS_FETCH_ONLY_IF_NOT_IN_MEMORY) at /bzr/testbuild/mysql-5.7.5-m15_dbg/storage/innobase/dict/dict0stats.cc:3237
#14 0x0000000000f07e0d in dict_stats_init (table=0x7f802753b318) at /bzr/testbuild/mysql-5.7.5-m15_dbg/storage/innobase/include/dict0stats.ic:173
#15 0x0000000000f0e1b7 in ha_innobase::open (this=0x7f80274ad420, name=0x7f80274ad390 "./test/t", mode=2, test_if_locked=2) at /bzr/testbuild/mysql-5.7.5-m15_dbg/storage/innobase/handler/ha_innodb.cc:5094
#16 0x0000000000880baf in handler::ha_open (this=0x7f80274ad420, table_arg=0x7f8027464e10, name=0x7f80274ad390 "./test/t", mode=2, test_if_locked=2) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/handler.cc:2471
#17 0x0000000000c17a5c in open_table_from_share (thd=0x7f802741c000, share=0x7f80274ad020, alias=0x7f8027427938 "t", db_stat=39, prgflag=44, ha_open_flags=0, outparam=0x7f8027464e10, is_create_table=false) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/table.cc:2378
#18 0x0000000000acafb7 in open_table (thd=0x7f802741c000, table_list=0x7f8027427940, ot_ctx=0x7f80e3bf0a50) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_base.cc:3417
#19 0x0000000000acd770 in open_and_process_table (thd=0x7f802741c000, lex=0x7f802741e370, tables=0x7f8027427940, counter=0x7f80e3bf0ba8, flags=0, prelocking_strategy=0x7f80e3bf0b20, has_prelocking_list=false, ot_ctx=0x7f80e3bf0a50) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_base.cc:4903
#20 0x0000000000ace4fe in open_tables (thd=0x7f802741c000, start=0x7f802741e380, counter=0x7f80e3bf0ba8, flags=0, prelocking_strategy=0x7f80e3bf0b20) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_base.cc:5357
#21 0x0000000000ad95e3 in open_tables (thd=0x7f802741c000, tables=0x7f802741e380, counter=0x7f80e3bf0ba8, flags=0) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_base.h:452
#22 0x0000000000bbfec1 in mysql_create_table (thd=0x7f802741c000, create_table=0x7f8027427940, create_info=0x7f80e3bf1230, alter_info=0x7f80e3bf0cb0) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_table.cc:5073
#23 0x0000000000b487fe in mysql_execute_command (thd=0x7f802741c000) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_parse.cc:2933
#24 0x0000000000b4fcc1 in mysql_parse (thd=0x7f802741c000, parser_state=0x7f80e3bf1e60) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_parse.cc:5427
#25 0x0000000000b44814 in dispatch_command (command=COM_QUERY, thd=0x7f802741c000, packet=0x7f8027433011 "CREATE TABLE t (c INT)", packet_length=22) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_parse.cc:1250
#26 0x0000000000b4354d in do_command (thd=0x7f802741c000) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_parse.cc:834
#27 0x0000000000c4d4ce in handle_connection (arg=0x7f802bba2080) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/conn_handler/connection_handler_per_thread.cc:298
#28 0x0000000000e394b8 in pfs_spawn_thread (arg=0x7f80c5bf8a50) at /bzr/testbuild/mysql-5.7.5-m15_dbg/storage/perfschema/pfs.cc:2137
#29 0x00007f80e35f5df3 in start_thread () from /lib64/libpthread.so.0
#30 0x00007f80e22bf1ad in clone () from /lib64/libc.so.6
[14 Feb 2015 7:11] Roel Van de Paar
2015-02-14T06:45:26.008701Z 0 [Note] /sda/MS-mysql-5.7.5-m15-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.7.5-m15-debug'  socket: '/sda/MS-mysql-5.7.5-m15-linux-x86_64-debug/socket.sock'  port: 16633  MySQL Community Server (GPL)
2015-02-14T06:46:20.200005Z 1 [Warning] InnoDB: Cannot find a free slot for an undo log. Do you have too many active transactions running concurrently?
2015-02-14T06:46:20.200067Z 1 [Warning] InnoDB: Unable to delete statistics for table test.?s?R: Too many concurrent transactions. They can be deleted later using DELETE FROM mysql.innodb_index_stats WHERE database_name = 'test' AND table_name = '?s?R'; DELETE FROM mysql.innodb_table_stats WHERE database_name = 'test' AND table_name = '?s?R';
2015-02-14T06:46:20.206937Z 1 [Warning] InnoDB: Cannot find a free slot for an undo log. Do you have too many active transactions running concurrently?
[...]
2015-02-14T06:46:28.096157Z 1 [ERROR] InnoDB: Unknown error code 47 while dropping table: `test`.`t1`.
2015-02-14 17:46:28 0x7f9065cbf700  InnoDB: Assertion failure in thread 140258159884032 in file fsp0fsp.cc line 2025
InnoDB: Failing assertion: inode
[...]
2015-02-14T06:47:02.153495Z 0 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
[...]
2015-02-14T06:47:02.690759Z 0 [Note] /sda/MS-mysql-5.7.5-m15-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.7.5-m15-debug'  socket: '/sda/MS-mysql-5.7.5-m15-linux-x86_64-debug/socket.sock'  port: 16633  MySQL Community Server (GPL)
2015-02-14T06:47:03.737242Z 1 [ERROR] InnoDB: Trying to load index "GEN_CLUST_INDEX" for table "test"."?s?R", but the index tree has been freed!
2015-02-14T06:47:03.737292Z 1 [Note] InnoDB: Index is corrupt but forcing load into data dictionary
2015-02-14T06:47:03.760186Z 1 [ERROR] InnoDB: Trying to load index "GEN_CLUST_INDEX" for table "test"."t1", but the index tree has been freed!
2015-02-14T06:47:03.760222Z 1 [Note] InnoDB: Index is corrupt but forcing load into data dictionary
2015-02-14T06:47:04.380517Z 1 [Warning] InnoDB: Cannot find a free slot for an undo log. Do you have too many active transactions running concurrently?
2015-02-14T06:47:04.380590Z 1 [Warning] InnoDB: Unable to delete statistics for table test.t: Too many concurrent transactions. They can be deleted later using DELETE FROM mysql.innodb_index_stats WHERE database_name = 'test' AND table_name = 't'; DELETE FROM mysql.innodb_table_stats WHERE database_name = 'test' AND table_name = 't';
[14 Feb 2015 7:14] Roel Van de Paar
Error 47: ref bug 74363
[14 Feb 2015 7:19] Roel Van de Paar
Also see bug 74343
[16 Feb 2015 20:15] Roel Van de Paar
Any connection with bug 75913?
[14 Mar 2015 8:29] MySQL Verification Team
5.7.5-debug:
InnoDB: Assertion failure in thread 115664 in file fsp0fsp.cc line 2025
InnoDB: Failing assertion: inode

mysqld-debug.exe!my_sigabrt_handler()[my_thr_init.c:392]
mysqld-debug.exe!raise()[winsig.c:587]
mysqld-debug.exe!abort()[abort.c:75]
mysqld-debug.exe!ut_dbg_assertion_failed()[ut0dbg.cc:69]
mysqld-debug.exe!fseg_inode_get()[fsp0fsp.cc:2025]
mysqld-debug.exe!fseg_n_reserved_pages()[fsp0fsp.cc:2366]
mysqld-debug.exe!btr_get_size()[btr0btr.cc:566]
mysqld-debug.exe!dict_stats_analyze_index()[dict0stats.cc:1904]
mysqld-debug.exe!dict_stats_update_persistent()[dict0stats.cc:2205]
mysqld-debug.exe!dict_stats_update()[dict0stats.cc:3119]
mysqld-debug.exe!dict_stats_update()[dict0stats.cc:3237]
mysqld-debug.exe!dict_stats_init()[dict0stats.ic:173]
mysqld-debug.exe!ha_innobase::open()[ha_innodb.cc:5094]
mysqld-debug.exe!handler::ha_open()[handler.cc:2471]
mysqld-debug.exe!open_table_from_share()[table.cc:2387]
mysqld-debug.exe!open_table()[sql_base.cc:3417]
mysqld-debug.exe!open_and_process_table()[sql_base.cc:4903]
mysqld-debug.exe!open_tables()[sql_base.cc:5357]
mysqld-debug.exe!open_normal_and_derived_tables()[sql_base.cc:6086]
mysqld-debug.exe!mysql_delete()[sql_delete.cc:74]
mysqld-debug.exe!mysql_execute_command()[sql_parse.cc:3495]
mysqld-debug.exe!mysql_parse()[sql_parse.cc:5427]
mysqld-debug.exe!dispatch_command()[sql_parse.cc:1250]
mysqld-debug.exe!do_command()[sql_parse.cc:834]
mysqld-debug.exe!handle_connection()[connection_handler_per_thread.cc:298]
mysqld-debug.exe!pfs_spawn_thread()[pfs.cc:2137]
mysqld-debug.exe!pthread_start()[my_winthread.c:72]
mysqld-debug.exe!_callthreadstartex()[threadex.c:376]
mysqld-debug.exe!_threadstartex()[threadex.c:359]