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] Shane Bester 
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]

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.072 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.