Bug #76472 | Failing assertion: index_id == index->id in btr0sea.cc line 1161 | ||
---|---|---|---|
Submitted: | 24 Mar 2015 10:21 | Modified: | 24 Mar 2015 11:34 |
Reporter: | Ramesh Sivaraman | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
Version: | 5.6.23, 5.6.25 | OS: | Linux (CentOS 7) |
Assigned to: | CPU Architecture: | Any |
[24 Mar 2015 10:21]
Ramesh Sivaraman
[24 Mar 2015 10:22]
Ramesh Sivaraman
Testcase bundle
Attachment: 1427105013_bug.tar.gz (application/gzip, text), 109.69 KiB.
[24 Mar 2015 11:34]
MySQL Verification Team
Hello Ramesh, Thank you for the report and test case. Confirmed that 5.6.25 debug build is affected/ Thanks, Umesh
[24 Mar 2015 11:35]
MySQL Verification Team
// 5.6.25 - only debug build affected scripts/mysql_install_db --basedir=/export/umesh/mysql-5.6.25 --datadir=/export/umesh/mysql-5.6.25/76472 bin/mysqld-debug --basedir=/export/umesh/mysql-5.6.25 --datadir=/export/umesh/mysql-5.6.25/76472 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.6.25/76472/log.err 2>&1 & - build commit: 7f58410b3f11eddb38ff8c57a7a58095f7db2910 date: 2015-03-23 14:34:22 +0530 build-date: 2015-03-23 10:21:42 +0100 short: 7f58410 branch: mysql-5.6 MySQL source 5.6.25 [umshastr@hod03]/export/umesh/mysql-5.6.25: bin/mysql -uroot -p -S /tmp/mysql_ushastry.sock test --force < 1427105013.sql Enter password: 1 1 ERROR 1215 (HY000) at line 6: Cannot add foreign key constraint ERROR 1286 (42000) at line 9: Unknown storage engine 'NDB' c1 c2 c3 c4 c5 c6 1 NULL 0 3.14159200 ERROR 1050 (42S01) at line 19: Table 'm3' already exists hex(c1) hex(c2) 1 3130 @@session.auto_increment_increment = VARIABLE_VALUE 1 ERROR 1146 (42S02) at line 40: Table 'test.t5' doesn't exist ERROR 1136 (21S01) at line 44: Column count doesn't match value count at row 1 ERROR 1054 (42S22) at line 45: Unknown column 'c' in 'field list' ERROR 1064 (42000) at line 48: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE CONTINUE HANDLER for 1012 begin select "before RESIGNAL"' at line 1 ERROR 1146 (42S02) at line 51: Table 'test.t2' doesn't exist ERROR 1054 (42S22) at line 54: Unknown column 'c1' in 'field list' ERROR 1232 (42000) at line 58: Incorrect argument type to variable 'innodb_autoextend_increment' ERROR 1054 (42S22) at line 64: Unknown column 'a' in 'field list' [umshastr@hod03]/export/umesh/mysql-5.6.25: bin/mysql -uroot -p -S /tmp/mysql_ushastry.sock test --force < 1427105013.sql Enter password: ERROR 177 (HY000) at line 1: Too many active concurrent transactions ERROR 1007 (HY000) at line 1: Can't create database 'test'; database exists 1 1 ERROR 1215 (HY000) at line 6: Cannot add foreign key constraint ERROR 1050 (42S01) at line 8: Table 't3' already exists ERROR 1286 (42000) at line 9: Unknown storage engine 'NDB' c1 c2 c3 c4 c5 c6 1 NULL 0 3.14159200 ERROR 1050 (42S01) at line 13: Table 'm3' already exists ERROR 1050 (42S01) at line 14: Table 't4' already exists ERROR 1025 (HY000) at line 15: Error on rename of './test/t4' to './test/#sql2-55a5-2' (errno: 177 - Too many active concurrent transactions) ERROR 1050 (42S01) at line 16: Table 't246' already exists ERROR 1050 (42S01) at line 17: Table 't922' already exists ERROR 1050 (42S01) at line 19: Table 'm3' already exists ERROR 1050 (42S01) at line 21: Table 't575' already exists ERROR 1050 (42S01) at line 23: Table 't505' already exists hex(c1) hex(c2) 1 3130 @@session.auto_increment_increment = VARIABLE_VALUE 1 ERROR 1146 (42S02) at line 40: Table 'test.t5' doesn't exist ERROR 1136 (21S01) at line 44: Column count doesn't match value count at row 1 ERROR 1054 (42S22) at line 45: Unknown column 'c' in 'field list' ERROR 1064 (42000) at line 48: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE CONTINUE HANDLER for 1012 begin select "before RESIGNAL"' at line 1 ERROR 1146 (42S02) at line 51: Table 'test.t2' doesn't exist ERROR 1054 (42S22) at line 54: Unknown column 'c1' in 'field list' ERROR 1232 (42000) at line 58: Incorrect argument type to variable 'innodb_autoextend_increment' ERROR 1054 (42S22) at line 64: Unknown column 'a' in 'field list' [umshastr@hod03]/export/umesh/mysql-5.6.25: bin/mysql -uroot -p -S /tmp/mysql_ushastry.sock test --force < 1427105013.sql Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql_ushastry.sock' (111) [1]+ Aborted (core dumped) bin/mysqld-debug --basedir=/export/umesh/mysql-5.6.25 --datadir=/export/umesh/mysql-5.6.25/76472 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.6.25/76472/log.err 2>&1
[24 Mar 2015 11:36]
MySQL Verification Team
(gdb) bt #0 0x00007f0b6051f771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000ae1373 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/mysys/stacktrace.c:422 #2 0x0000000000745fca in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007f0b5f1255c9 in raise () from /lib64/libc.so.6 #5 0x00007f0b5f126cd8 in abort () from /lib64/libc.so.6 #6 0x0000000000d5818b in btr_search_drop_page_hash_index (block=0x7f0b3cd12a40) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/innobase/btr/btr0sea.cc:1161 #7 0x0000000000d3534b in btr_free_root (space=0, zip_size=0, root_page_no=437, mtr=0x7f0b35dd4580) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/innobase/btr/btr0btr.cc:1730 #8 0x0000000000d8edfe in dict_drop_index_tree (rec=0x7f0b3d26c992 "", mtr=0x7f0b35dd4580) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/innobase/dict/dict0crea.cc:778 #9 0x0000000000ccea7c in row_upd_clust_step (node=0x7f0b0009deb8, thr=0x7f0b000a0bb0) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/innobase/row/row0upd.cc:2372 #10 0x0000000000ccef33 in row_upd (node=0x7f0b0009deb8, thr=0x7f0b000a0bb0) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/innobase/row/row0upd.cc:2521 #11 0x0000000000ccf394 in row_upd_step (thr=0x7f0b000a0bb0) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/innobase/row/row0upd.cc:2673 #12 0x0000000000c51415 in que_thr_step (thr=0x7f0b000a0bb0) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/innobase/que/que0que.cc:1061 #13 0x0000000000c516e4 in que_run_threads_low (thr=0x7f0b000a0bb0) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/innobase/que/que0que.cc:1141 #14 0x0000000000c5188c in que_run_threads (thr=0x7f0b000a0bb0) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/innobase/que/que0que.cc:1182 #15 0x0000000000c52334 in que_eval_sql (info=0x7f0b00011c38, sql=0x110d268 "PROCEDURE DROP_TABLE_PROC () IS\nsys_foreign_id CHAR;\ntable_id CHAR;\nindex_id CHAR;\nforeign_id CHAR;\nspace_id INT;\nfound INT;\nDECLARE CURSOR cur_fk IS\nSELECT ID FROM SYS_FOREIGN\nWHERE FOR_NAME = :table"..., reserve_dict_mutex=0, trx=0x7f0b000956c8) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/innobase/que/que0que.cc:1259 #16 0x0000000000c95962 in row_drop_table_for_mysql (name=0x7f0b35dd5730 "tmp/#sql55a5_2_2", trx=0x7f0b000956c8, drop_db=false, nonatomic=true) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/innobase/row/row0mysql.cc:4203 #17 0x0000000000baf853 in ha_innobase::delete_table (this=0x7f0b00004ff0, name=0x7f0b00092508 "/tmp/#sql55a5_2_2") at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/innobase/handler/ha_innodb.cc:10021 #18 0x000000000064d527 in handler::ha_delete_table (this=0x7f0b00004ff0, name=0x7f0b00092508 "/tmp/#sql55a5_2_2") at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/handler.cc:4492 #19 0x000000000078c826 in rm_temporary_table (base=0x1f4f0d0, path=0x7f0b00092508 "/tmp/#sql55a5_2_2") at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_base.cc:6286 #20 0x000000000078fb7d in close_temporary (table=0x7f0b00091910, free_share=true, delete_table=true) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_base.cc:2227 #21 0x000000000078fffc in close_temporary_tables (thd=0x2600650) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_base.cc:1570 #22 0x00000000007b21f5 in THD::cleanup (this=0x2600650) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_class.cc:1513 #23 0x00000000007b23de in THD::release_resources (this=0x2600650) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_class.cc:1575 #24 0x000000000063ab33 in one_thread_per_connection_end (thd=0x2600650, block_pthread=true) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/mysqld.cc:2752 #25 0x00000000007bb2f4 in do_handle_one_connection (thd_arg=0x2600650) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_connect.cc:989 #26 0x00000000007bb357 in handle_one_connection (arg=0x2600650) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_connect.cc:898 #27 0x0000000000b92d9c in pfs_spawn_thread (arg=0x2624420) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/perfschema/pfs.cc:1860 #28 0x00007f0b6051adf3 in start_thread () from /lib64/libpthread.so.0 #29 0x00007f0b5f1e647d in clone () from /lib64/libc.so.6 (gdb)
[24 Mar 2015 12:16]
MySQL Verification Team
// no luck with 5.7.8 other than once crashed with (gdb) bt #0 0x00007f1a33be7771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000184b359 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-14782754-1427128309.57/mysqlcom-pro-5.7.8-rc/mysys/stacktrace.c:247 #2 0x0000000000e66bcc in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-14782754-1427128309.57/mysqlcom-pro-5.7.8-rc/sql/signal_handler.cc:220 #3 <signal handler called> #4 0x00007f1a327ed5c9 in raise () from /lib64/libc.so.6 #5 0x00007f1a327eecd8 in abort () from /lib64/libc.so.6 #6 0x00007f1a327e6536 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007f1a327e65e2 in __assert_fail () from /lib64/libc.so.6 #8 0x00000000014c2c59 in THD::send_statement_status (this=0x7f19ac0089e0) at /export/home/pb2/build/sb_0-14782754-1427128309.57/mysqlcom-pro-5.7.8-rc/sql/sql_class.cc:4706 #9 0x000000000151cab6 in dispatch_command (thd=0x7f19ac0089e0, com_data=0x7f1a28410e10, command=COM_QUERY) at /export/home/pb2/build/sb_0-14782754-1427128309.57/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:1692 #10 0x000000000151a068 in do_command (thd=0x7f19ac0089e0) at /export/home/pb2/build/sb_0-14782754-1427128309.57/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:851 #11 0x0000000001647006 in handle_connection (arg=0x417b680) at /export/home/pb2/build/sb_0-14782754-1427128309.57/mysqlcom-pro-5.7.8-rc/sql/conn_handler/connection_handler_per_thread.cc:299 #12 0x0000000001c061a6 in pfs_spawn_thread (arg=0x408cee0) at /export/home/pb2/build/sb_0-14782754-1427128309.57/mysqlcom-pro-5.7.8-rc/storage/perfschema/pfs.cc:2147 #13 0x00007f1a33be2df3 in start_thread () from /lib64/libpthread.so.0 #14 0x00007f1a328ae47d in clone () from /lib64/libc.so.6