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: | |
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
[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]