Bug #74682 Assertion: index->id == btr_page_get_index_id(page) in btr0cur.cc line 899
| Submitted: | 4 Nov 2014 13:32 | Modified: | 4 Nov 2014 14:21 |
|---|---|---|---|
| Reporter: | Ramesh Sivaraman | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: DDL | Severity: | S3 (Non-critical) |
| Version: | 5.6.20-debug, 5.6.22, 5.7.6 | OS: | Linux (CentOS 7) |
| Assigned to: | CPU Architecture: | Any |
[4 Nov 2014 13:32]
Ramesh Sivaraman
[4 Nov 2014 13:43]
MySQL Verification Team
Hello Ramesh Sivaraman, Thank you for the bug report and test case. Confirmed the issue with debug build of 5.6.22 Thanks, Umesh
[4 Nov 2014 13:44]
MySQL Verification Team
//
/data/ushastry/server/mysql-advanced-5.6.22/scripts/mysql_install_db --basedir=/data/ushastry/server/mysql-advanced-5.6.22 --datadir=/tmp/bug --user=root
/data/ushastry/server/mysql-advanced-5.6.22/bin/mysqld-debug --basedir=/data/ushastry/server/mysql-advanced-5.6.22 --tmpdir=/tmp/bug --datadir=/tmp/bug --core --socket=/tmp/mysql.sock --port=3306 --log-error=/tmp/bug/log.err --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY --user=root 2>&1 &
mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------------+
| Variable_name | Value |
+-------------------------+---------------------------------------------------------------+
| innodb_version | 5.6.22 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.22-enterprise-commercial-advanced-debug |
| version_comment | MySQL Enterprise Server - Advanced Edition Debug (Commercial) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+---------------------------------------------------------------+
7 rows in set (0.00 sec)
mysql> DROP DATABASE test;CREATE DATABASE test;USE test;
Query OK, 0 rows affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Database changed
mysql> set global innodb_undo_logs=1;
Query OK, 0 rows affected (0.00 sec)
mysql> set global innodb_trx_rseg_n_slots_debug=1;
Query OK, 0 rows affected (0.00 sec)
mysql> create table t1(a INT,b INT);
Query OK, 0 rows affected (0.03 sec)
mysql> DROP TABLE t1;
ERROR 177 (HY000): Too many active concurrent transactions
mysql> alter table t1 add unique(a,b),add key (b);
ERROR 2013 (HY000): Lost connection to MySQL server during query
(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=0x7fde6401c7f8, latch_mode=1, cursor=0x7fde8ee3c990, level=0,
file=0x113dc88 "/pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/include/btr0pcur.ic", line=518, mtr=0x7fde8ee3c4c0)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/btr/btr0cur.cc:899
#7 0x0000000000c7bb24 in btr_pcur_open_at_index_side (from_left=true, index=0x7fde6401c7f8, latch_mode=1, pcur=0x7fde8ee3c990, init_pcur=true, level=0, mtr=0x7fde8ee3c4c0)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/include/btr0pcur.ic:518
#8 0x0000000000c7f30d in row_merge_read_clustered_index (trx=0x7fde64032b08, table=0x7fde6401cf40, old_table=0x7fde6401a298, new_table=0x7fde6401a298, online=true, index=0x7fde6401e218,
fts_sort_idx=0x0, psort_info=0x0, files=0x7fde6401f108, key_numbers=0x7fde6401e228, n_index=2, add_cols=0x0, col_map=0x0, add_autoinc=18446744073709551615, sequence=...,
block=0x7fde5fd00000 <Address 0x7fde5fd00000 out of bounds>) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/row/row0merge.cc:1267
#9 0x0000000000c84455 in row_merge_build_indexes (trx=0x7fde64032b08, old_table=0x7fde6401a298, new_table=0x7fde6401a298, online=true, indexes=0x7fde6401e218, key_numbers=0x7fde6401e228,
n_indexes=2, table=0x7fde6401cf40, add_cols=0x0, col_map=0x0, add_autoinc=18446744073709551615, sequence=...)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/row/row0merge.cc:3539
#10 0x0000000000bb8ba3 in ha_innobase::inplace_alter_table (this=0x7fde640113a0, altered_table=0x7fde6401cf40, ha_alter_info=0x7fde8ee3dac0)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/innobase/handler/handler0alter.cc:3928
#11 0x00000000008a65f7 in handler::ha_inplace_alter_table (this=0x7fde640113a0, altered_table=0x7fde6401cf40, ha_alter_info=0x7fde8ee3dac0)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/handler.h:2870
#12 0x000000000089efc0 in mysql_inplace_alter_table (thd=0x350abf0, table_list=0x7fde640050d8, table=0x7fde64022920, altered_table=0x7fde6401cf40, ha_alter_info=0x7fde8ee3dac0,
inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7fde8ee3e420, alter_ctx=0x7fde8ee3d010)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_table.cc:6586
#13 0x00000000008a3520 in mysql_alter_table (thd=0x350abf0, new_db=0x7fde64005638 "test", new_name=0x0, create_info=0x7fde8ee3ee90, table_list=0x7fde640050d8, alter_info=0x7fde8ee3ef70,
order_num=0, order=0x0, ignore=false) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_table.cc:8419
#14 0x00000000009ea722 in Sql_cmd_alter_table::execute (this=0x7fde640057e0, thd=0x350abf0) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_alter.cc:313
#15 0x0000000000834a46 in mysql_execute_command (thd=0x350abf0) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:4945
#16 0x00000000008380e1 in mysql_parse (thd=0x350abf0, rawbuf=0x7fde64004fd0 "alter table t1 add unique(a,b),add key (b)", length=42, parser_state=0x7fde8ee40680)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:6357
#17 0x000000000082aa63 in dispatch_command (command=COM_QUERY, thd=0x350abf0, packet=0x363a541 "alter table t1 add unique(a,b),add key (b)", packet_length=42)
at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:1332
#18 0x0000000000829ac8 in do_command (thd=0x350abf0) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:1034
#19 0x00000000007f0f17 in do_handle_one_connection (thd_arg=0x350abf0) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_connect.cc:982
#20 0x00000000007f09e8 in handle_one_connection (arg=0x350abf0) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_connect.cc:898
#21 0x0000000000e64c25 in pfs_spawn_thread (arg=0x35fdc70) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/perfschema/pfs.cc:1860
#22 0x0000003deb0079d1 in start_thread () from /lib64/libpthread.so.0
#23 0x0000003deace89dd in clone () from /lib64/libc.so.6
[4 Nov 2014 13:46]
MySQL Verification Team
// 5.7.6 debug build
(gdb) bt
#0 0x0000003deb00c8ac in pthread_kill () from /lib64/libpthread.so.0
#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 () from /lib64/libc.so.6
#5 0x0000003deac33e05 in abort () from /lib64/libc.so.6
#6 0x000000000121b81b in ut_dbg_assertion_failed (expr=0x175ace8 "index->id == btr_page_get_index_id(page)",
file=0x175a248 "/pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc", line=2231)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/ut/ut0dbg.cc:67
#7 0x000000000124a9f8 in btr_cur_open_at_index_side_func (from_left=true, index=0x7f10fc0269a8, latch_mode=1, cursor=0x7f112a1720f0, level=0,
file=0x171d1c0 "/pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/include/btr0pcur.ic", line=551, mtr=0x7f112a171be0)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc:2231
#8 0x0000000001145726 in btr_pcur_open_at_index_side (from_left=true, index=0x7f10fc0269a8, latch_mode=1, pcur=0x7f112a1720f0, init_pcur=true, level=0, mtr=0x7f112a171be0)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/include/btr0pcur.ic:551
#9 0x0000000001149ab5 in row_merge_read_clustered_index (trx=0x7f11333dc8f8, table=0x7f10fc02ae60, old_table=0x7f10fc022478, new_table=0x7f10fc022478, online=true, index=0x7f10fc02be98,
fts_sort_idx=0x0, psort_info=0x0, files=0x7f10fc02a8b0, key_numbers=0x7f10fc02bea8, n_index=2, add_cols=0x0, col_map=0x0, add_autoinc=18446744073709551615, sequence=...,
block=0x7f1129e37000 <Address 0x7f1129e37000 out of bounds>, skip_pk_sort=false, tmpfd=0x7f112a1727ec)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0merge.cc:1557
#10 0x000000000114fba8 in row_merge_build_indexes (trx=0x7f11333dc8f8, old_table=0x7f10fc022478, new_table=0x7f10fc022478, online=true, indexes=0x7f10fc02be98, key_numbers=0x7f10fc02bea8,
n_indexes=2, table=0x7f10fc02ae60, add_cols=0x0, col_map=0x0, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=false)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0merge.cc:4020
#11 0x00000000010665d4 in ha_innobase::inplace_alter_table (this=0x7f10fc02a480, altered_table=0x7f10fc02ae60, ha_alter_info=0x7f112a173870)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/handler0alter.cc:4601
#12 0x0000000000d39be7 in handler::ha_inplace_alter_table (this=0x7f10fc02a480, altered_table=0x7f10fc02ae60, ha_alter_info=0x7f112a173870)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/handler.h:3248
#13 0x0000000000d320c1 in mysql_inplace_alter_table (thd=0x7f10fc000cf0, table_list=0x7f10fc005da8, table=0x7f10fc0318f0, altered_table=0x7f10fc02ae60, ha_alter_info=0x7f112a173870,
inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f112a1741f0, alter_ctx=0x7f112a172dd0)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_table.cc:6767
#14 0x0000000000d367ec in mysql_alter_table (thd=0x7f10fc000cf0, new_db=0x7f10fc006320 "test", new_name=0x0, create_info=0x7f112a174c80, table_list=0x7f10fc005da8, alter_info=0x7f112a174d60)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_table.cc:8629
#15 0x0000000000e7d727 in Sql_cmd_alter_table::execute (this=0x7f10fc0064c8, thd=0x7f10fc000cf0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_alter.cc:315
#16 0x0000000000cbb4f7 in mysql_execute_command (thd=0x7f10fc000cf0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:4785
#17 0x0000000000cbce6a in mysql_parse (thd=0x7f10fc000cf0, parser_state=0x7f112a176660) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:5397
#18 0x0000000000cb0f2c in dispatch_command (command=COM_QUERY, thd=0x7f10fc000cf0, packet=0x7f10fc009a21 "alter table t1 add unique(a,b),add key (b)", packet_length=42)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:1249
#19 0x0000000000cafbd4 in do_command (thd=0x7f10fc000cf0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:833
#20 0x0000000000dbe89c in handle_connection (arg=0x450e0f0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298
#21 0x000000000138347f in pfs_spawn_thread (arg=0x4364760) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs.cc:2137
#22 0x0000003deb0079d1 in start_thread () from /lib64/libpthread.so.0
#23 0x0000003deace89dd in clone () from /lib64/libc.so.6
[4 Nov 2014 14:21]
Marko Mäkelä
This looks like a duplicate of Bug#74663, which is a crash in CHECK TABLE after a failed DROP TABLE. In both test cases, we have the following: mysql> DROP TABLE t1; ERROR 177 (HY000): Too many active concurrent transactions Apparently, InnoDB will somehow corrupt the table in this case, and any subsequent operation on the table will fail.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.057 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.