Bug #74747 Failing assertion: index->id == btr_page_get_index_id(page) btr0cur.cc line 899
| Submitted: | 8 Nov 2014 7:20 | Modified: | 5 Feb 2015 7:55 |
|---|---|---|---|
| Reporter: | Roel Van de Paar | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: DML | Severity: | S1 (Critical) |
| Version: | 5.6.20, 5.6.22, 5.7.5 | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[8 Nov 2014 7:20]
Roel Van de Paar
[8 Nov 2014 7:21]
Roel Van de Paar
Testcase
Attachment: attached_testcase.sql (application/octet-stream, text), 2.74 KiB.
[8 Nov 2014 7:30]
Roel Van de Paar
This was https://bugs.launchpad.net/mysql-server/+bug/1384596
[8 Nov 2014 9:05]
MySQL Verification Team
Hello Roel, Thank you for the bug report and test case. Confirmed with 5.6.22 that only debug build is affected. Thanks, Umesh
[8 Nov 2014 9:05]
MySQL Verification Team
// 5.6.22
(gdb) bt
#0 0x0000003deb00c8ac in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000b0011b in my_write_core (sig=6) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/mysys/stacktrace.c:422
#2 0x000000000077ecb8 in handle_fatal_signal (sig=6) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/signal_handler.cc:230
#3 <signal handler called>
#4 0x0000003deac32625 in raise () from /lib64/libc.so.6
#5 0x0000003deac33e05 in abort () from /lib64/libc.so.6
#6 0x0000000000d4508b in btr_cur_open_at_index_side_func (from_left=true, index=0x7fef280b8348, latch_mode=1, cursor=0x7fef28018360, level=0,
file=0x114afb8 "/pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/include/btr0pcur.ic", line=518, mtr=0x7fef57d4d2e0)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0cur.cc:899
#7 0x0000000000cb4773 in btr_pcur_open_at_index_side (from_left=true, index=0x7fef280b8348, latch_mode=1, pcur=0x7fef28018360, init_pcur=false, level=0, mtr=0x7fef57d4d2e0)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/include/btr0pcur.ic:518
#8 0x0000000000cbc746 in row_search_for_mysql (buf=0x7fef28034568 "\377", mode=1, prebuilt=0x7fef280182e8, match_mode=0, direction=0)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/row/row0sel.cc:4174
#9 0x0000000000b9aa7d in ha_innobase::index_read (this=0x7fef280342a0, buf=0x7fef28034568 "\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/handler/ha_innodb.cc:7549
#10 0x0000000000b9b788 in ha_innobase::index_first (this=0x7fef280342a0, buf=0x7fef28034568 "\377")
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/handler/ha_innodb.cc:7916
#11 0x0000000000b9b981 in ha_innobase::rnd_next (this=0x7fef280342a0, buf=0x7fef28034568 "\377")
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/handler/ha_innodb.cc:8013
#12 0x000000000068fc43 in handler::ha_rnd_next (this=0x7fef280342a0, buf=0x7fef28034568 "\377") at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/handler.cc:2687
#13 0x00000000008a5c7d in mysql_checksum_table (thd=0x28d8770, tables=0x7fef280050c8, check_opt=0x28db698) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_table.cc:9237
#14 0x000000000082f6a3 in mysql_execute_command (thd=0x28d8770) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:3277
#15 0x00000000008380e1 in mysql_parse (thd=0x28d8770, rawbuf=0x7fef28004fd0 "checksum table t1,t2,t3,t4 extended", length=35, parser_state=0x7fef57d4f680)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:6357
#16 0x000000000082aa63 in dispatch_command (command=COM_QUERY, thd=0x28d8770, packet=0x2a075b1 "", packet_length=35)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:1332
#17 0x0000000000829ac8 in do_command (thd=0x28d8770) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:1034
#18 0x00000000007f0f17 in do_handle_one_connection (thd_arg=0x28d8770) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_connect.cc:982
#19 0x00000000007f09e8 in handle_one_connection (arg=0x28d8770) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_connect.cc:898
#20 0x0000000000e64c25 in pfs_spawn_thread (arg=0x29cace0) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/perfschema/pfs.cc:1860
#21 0x0000003deb0079d1 in start_thread () from /lib64/libpthread.so.0
#22 0x0000003deace89dd in clone () from /lib64/libc.so.6
[8 Nov 2014 9:06]
MySQL Verification Team
// 5.7.6 builds doesn't seems to be affected
[3 Feb 2015 5:52]
Roel Van de Paar
Asserts 5.7.5-m15 DROP DATABASE transforms;CREATE DATABASE transforms;DROP DATABASE test;CREATE DATABASE test;USE test; SET @@global.innodb_trx_rseg_n_slots_debug = 1; CREATE TABLE t1(c1 INT); DROP TABLE t1; ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 2015-02-03T05:47:18.906970Z 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-03T05:47:35.653550Z 1 [Warning] InnoDB: Cannot find a free slot for an undo log. Do you have too many active transactions running concurrently? 2015-02-03T05:47:35.653594Z 1 [Warning] InnoDB: Unable to delete statistics for table test.t1: Too many concurrent transactions. They can be deleted later using DELETE FROM mysql.innodb_index_stats WHERE database_name = 'test' AND table_name = 't1'; DELETE FROM mysql.innodb_table_stats WHERE database_name = 'test' AND table_name = 't1'; 2015-02-03T05:47:35.654468Z 1 [Warning] InnoDB: Cannot find a free slot for an undo log. Do you have too many active transactions running concurrently? 2015-02-03T05:47:35.654508Z 1 [ERROR] InnoDB: Unknown error code 47 while dropping table: `test`.`t1`. 2015-02-03 16:47:36 0x7fbded4dc700 InnoDB: Assertion failure in thread 140453706843904 in file btr0cur.cc line 2208 InnoDB: Failing assertion: index->id == btr_page_get_index_id(page)
[5 Feb 2015 7:55]
Roel Van de Paar
Another testcase, tested to crash 5.7.5-m15 2015-02-05T07:51:40.515584Z 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-05T07:51:42.811781Z 1 [Warning] InnoDB: Cannot find a free slot for an undo log. Do you have too many active transactions running concurrently? 2015-02-05T07:51:42.811833Z 1 [Warning] InnoDB: Unable to delete statistics for table test.t1: Too many concurrent transactions. They can be deleted later using DELETE FROM mysql.innodb_index_stats WHERE database_name = 'test' AND table_name = 't1'; DELETE FROM mysql.innodb_table_stats WHERE database_name = 'test' AND table_name = 't1'; 2015-02-05T07:51:42.812642Z 1 [Warning] InnoDB: Cannot find a free slot for an undo log. Do you have too many active transactions running concurrently? 2015-02-05T07:51:42.812682Z 1 [ERROR] InnoDB: Unknown error code 47 while dropping table: `test`.`t1`. 2015-02-05 18:51:43 0x7f2b3d8d0700 InnoDB: Assertion failure in thread 139823692973824 in file btr0cur.cc line 1244 InnoDB: Failing assertion: index->id == btr_page_get_index_id(page) DROP DATABASE transforms;CREATE DATABASE transforms;DROP DATABASE test;CREATE DATABASE test;USE test; set global innodb_file_per_table=off; set global innodb_trx_rseg_n_slots_debug=1; CREATE TABLE m3(c1 DECIMAL,c2 BINARY (25),c3 INT(4),c4 VARBINARY(15) KEY,c5 DECIMAL UNIQUE KEY,c6 NUMERIC(0,0) DEFAULT 3.141592); CREATE TABLE t1(s1 CHAR (5)CHARACTER SET ucs2,s2 VARCHAR(5) CHARACTER SET utf16le); DROP TABLES t1,t3; CREATE TABLE t17(c1 CHAR (10)); INSERT INTO t1 VALUES(0,0);
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.059 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.