Bug #77164 | Assertion : mtr_memo_contains(mtr, block, 2) == rw_lock_own(&block->lock, 351) | ||
---|---|---|---|
Submitted: | 27 May 2015 5:10 | Modified: | 27 May 2015 13:21 |
Reporter: | Ramesh Sivaraman | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.6.21, 5.6.26, 5.6.24 | OS: | Linux (CentOS 7) |
Assigned to: | CPU Architecture: | Any | |
Tags: | debug |
[27 May 2015 5:10]
Ramesh Sivaraman
[27 May 2015 5:10]
Ramesh Sivaraman
Testcase bundle
Attachment: 1432553395_bug_bundle.tar.gz (application/gzip, text), 1014.63 KiB.
[27 May 2015 13:21]
MySQL Verification Team
Hello Ramesh, Thank you for the report and test case. Observed that only debug build is affected(checked 5.6.26). Thanks, Umesh
[27 May 2015 13:22]
MySQL Verification Team
// 5.6.26 scripts/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-5.6.26 --datadir=/export/umesh/server/binaries/mysql-5.6.26/77164 bin/mysqld-debug --basedir=/export/umesh/server/binaries/mysql-5.6.26 --datadir=/export/umesh/server/binaries/mysql-5.6.26/77164 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.6.26/77164/log.err 2>&1 & // [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.26: bin/mysql -uroot -S/tmp/mysql_ushastry.sock --force < tests/1432553395.sql .. ERROR 177 (HY000) at line 34: Too many active concurrent transactions ERROR 1146 (42S02) at line 35: Table 'test.t' doesn't exist ERROR 2013 (HY000) at line 36: Lost connection to MySQL server during query (gdb) bt #0 0x00007f10a40ed771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000ae21cf in my_write_core (sig=6) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/mysys/stacktrace.c:422 #2 0x000000000074643a in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007f10a2cf35c9 in raise () from /lib64/libc.so.6 #5 0x00007f10a2cf4cd8 in abort () from /lib64/libc.so.6 #6 0x0000000000d2bac0 in fseg_inode_get (header=0x7f1081434054 "", space=0, zip_size=0, mtr=0x7f1079984500) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/storage/innobase/fsp/fsp0fsp.cc:1849 #7 0x0000000000d2cf65 in fseg_n_reserved_pages (header=0x7f1081434054 "", used=0x7f1079984430, mtr=0x7f1079984500) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/storage/innobase/fsp/fsp0fsp.cc:2178 #8 0x0000000000c9033b in btr_get_size (index=0x7f104001cdc8, flag=2, mtr=0x7f1079984500) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/storage/innobase/btr/btr0btr.cc:1219 #9 0x0000000000d0ff48 in dict_stats_analyze_index (index=0x7f104001cdc8) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/storage/innobase/dict/dict0stats.cc:1910 #10 0x0000000000d109da in dict_stats_update_persistent (table=0x7f104005e508) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/storage/innobase/dict/dict0stats.cc:2209 #11 0x0000000000d12bcf in dict_stats_update (table=0x7f104005e508, stats_upd_option=DICT_STATS_RECALC_PERSISTENT) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/storage/innobase/dict/dict0stats.cc:3127 #12 0x0000000000d12ea8 in dict_stats_update (table=0x7f104005e508, stats_upd_option=DICT_STATS_FETCH_ONLY_IF_NOT_IN_MEMORY) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/storage/innobase/dict/dict0stats.cc:3248 #13 0x0000000000afdd87 in dict_stats_init (table=0x7f104005e508) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/storage/innobase/include/dict0stats.ic:174 #14 0x0000000000b0cff8 in ha_innobase::open (this=0x7f104002c7a0, name=0x7f104001cbd8 "./test/t1", mode=2, test_if_locked=2) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/storage/innobase/handler/ha_innodb.cc:4859 #15 0x0000000000652d37 in handler::ha_open (this=0x7f104002c7a0, table_arg=0x7f1040029460, name=0x7f104001cbd8 "./test/t1", mode=2, test_if_locked=2) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/sql/handler.cc:2505 #16 0x00000000008c19ef in open_table_from_share (thd=0x3a15850, share=0x7f104001c8b0, alias=0x7f1040017540 "t1", db_stat=39, prgflag=44, ha_open_flags=0, outparam=0x7f1040029460, is_create_table=false) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/sql/table.cc:2355 #17 0x0000000000794367 in open_table (thd=0x3a15850, table_list=0x7f1040017548, ot_ctx=0x7f1079985c30) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/sql/sql_base.cc:3167 #18 0x00000000007951d6 in open_and_process_table (thd=0x3a15850, lex=0x3a17618, tables=0x7f1040017548, counter=0x7f1079985dc8, flags=0, prelocking_strategy=0x7f1079985d30, has_prelocking_list=false, ot_ctx=0x7f1079985c30) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/sql/sql_base.cc:4706 #19 0x00000000007959a4 in open_tables (thd=0x3a15850, start=0x3a17628, counter=0x7f1079985dc8, flags=0, prelocking_strategy=0x7f1079985d30) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/sql/sql_base.cc:5139 #20 0x00000000007d4d74 in open_tables (thd=0x3a15850, tables=0x3a17628, counter=0x7f1079985dc8, flags=0) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/sql/sql_base.h:451 #21 0x000000000086fa2d in mysql_create_table (thd=0x3a15850, create_table=0x7f1040017548, create_info=0x7f1079986610, alter_info=0x7f1079986060) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/sql/sql_table.cc:5068 #22 0x00000000007fc395 in mysql_execute_command (thd=0x3a15850) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/sql/sql_parse.cc:3068 #23 0x0000000000802a66 in mysql_parse (thd=0x3a15850, rawbuf=0x7f10400173f0 "create TABLE t1(a int,primary key (a),t timestamp,c char(10) default \"hello\",i int)", length=83, parser_state=0x7f1079987700) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/sql/sql_parse.cc:6386 #24 0x000000000080468a in dispatch_command (command=COM_QUERY, thd=0x3a15850, packet=0x3b46281 "create TABLE t1(a int,primary key (a),t timestamp,c char(10) default \"hello\",i int)", packet_length=83) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/sql/sql_parse.cc:1340 #25 0x0000000000805f16 in do_command (thd=0x3a15850) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/sql/sql_parse.cc:1037 #26 0x00000000007bb949 in do_handle_one_connection (thd_arg=0x3a15850) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/sql/sql_connect.cc:982 #27 0x00000000007bba0f in handle_one_connection (arg=0x3a15850) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/sql/sql_connect.cc:898 #28 0x0000000000daf210 in pfs_spawn_thread (arg=0x3abeb80) at /export/home/pb2/build/sb_0-15307164-1431760457.15/mysqlcom-pro-5.6.26/storage/perfschema/pfs.cc:1860 #29 0x00007f10a40e8df3 in start_thread () from /lib64/libpthread.so.0 #30 0x00007f10a2db447d in clone () from /lib64/libc.so.6 (gdb)
[27 May 2015 13:28]
MySQL Verification Team
// with 5.6.24 debug build, each time getting diff asserts( every time cleaning datadir) (gdb) bt #0 0x00007fd5eecfa771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000ae0f7f in my_write_core (sig=6) at /export/home/pb2/build/sb_0-14808650-1427301633.73/mysqlcom-pro-5.6.24/mysys/stacktrace.c:422 #2 0x0000000000745f8a in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-14808650-1427301633.73/mysqlcom-pro-5.6.24/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007fd5ed9005c9 in raise () from /lib64/libc.so.6 #5 0x00007fd5ed901cd8 in abort () from /lib64/libc.so.6 #6 0x00007fd5ed8f9536 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007fd5ed8f95e2 in __assert_fail () from /lib64/libc.so.6 #8 0x0000000000b2fead in commit_try_norebuild (ha_alter_info=0x7fd5c45aefa0, ctx=0x7fd58c02cbb0, old_table=0x7fd58c007190, trx=0x7fd58c059f18, table_name=0x7fd58c018b55 "t1") at /export/home/pb2/build/sb_0-14808650-1427301633.73/mysqlcom-pro-5.6.24/storage/innobase/handler/handler0alter.cc:5074 #9 0x0000000000b241a9 in ha_innobase::commit_inplace_alter_table (this=0x7fd58c023650, altered_table=0x7fd58c05aea0, ha_alter_info=0x7fd5c45aefa0, commit=true) at /export/home/pb2/build/sb_0-14808650-1427301633.73/mysqlcom-pro-5.6.24/storage/innobase/handler/handler0alter.cc:5517 #10 0x000000000065107a in handler::ha_commit_inplace_alter_table (this=0x7fd58c023650, altered_table=0x7fd58c05aea0, ha_alter_info=0x7fd5c45aefa0, commit=true) at /export/home/pb2/build/sb_0-14808650-1427301633.73/mysqlcom-pro-5.6.24/sql/handler.cc:4386 #11 0x00000000008696cc in mysql_inplace_alter_table (thd=0x3af5570, table_list=0x7fd58c02be58, table=0x7fd58c007190, altered_table=0x7fd58c05aea0, ha_alter_info=0x7fd5c45aefa0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7fd5c45af900, alter_ctx=0x7fd5c45ae4f0) at /export/home/pb2/build/sb_0-14808650-1427301633.73/mysqlcom-pro-5.6.24/sql/sql_table.cc:6623 #12 0x000000000086b169 in mysql_alter_table (thd=0x3af5570, new_db=0x7fd58c02c3b8 "test", new_name=0x7fd58c02be20 "t1", create_info=0x7fd5c45b0610, table_list=0x7fd58c02be58, alter_info=0x7fd5c45b0060, order_num=0, order=0x0, ignore=false) at /export/home/pb2/build/sb_0-14808650-1427301633.73/mysqlcom-pro-5.6.24/sql/sql_table.cc:8447 #13 0x00000000007fbd41 in mysql_execute_command (thd=0x3af5570) at /export/home/pb2/build/sb_0-14808650-1427301633.73/mysqlcom-pro-5.6.24/sql/sql_parse.cc:3118 #14 0x0000000000802212 in mysql_parse (thd=0x3af5570, rawbuf=0x7fd58c02bd70 "CREATE INDEX i ON t1(a)", length=23, parser_state=0x7fd5c45b1700) at /export/home/pb2/build/sb_0-14808650-1427301633.73/mysqlcom-pro-5.6.24/sql/sql_parse.cc:6391 #15 0x0000000000803e36 in dispatch_command (command=COM_QUERY, thd=0x3af5570, packet=0x3c25fe1 "CREATE INDEX i ON t1(a)", packet_length=23) at /export/home/pb2/build/sb_0-14808650-1427301633.73/mysqlcom-pro-5.6.24/sql/sql_parse.cc:1340 #16 0x00000000008056c0 in do_command (thd=0x3af5570) at /export/home/pb2/build/sb_0-14808650-1427301633.73/mysqlcom-pro-5.6.24/sql/sql_parse.cc:1037 #17 0x00000000007bb221 in do_handle_one_connection (thd_arg=0x3af5570) at /export/home/pb2/build/sb_0-14808650-1427301633.73/mysqlcom-pro-5.6.24/sql/sql_connect.cc:982 #18 0x00000000007bb2e7 in handle_one_connection (arg=0x3af5570) at /export/home/pb2/build/sb_0-14808650-1427301633.73/mysqlcom-pro-5.6.24/sql/sql_connect.cc:898 #19 0x0000000000dd43e0 in pfs_spawn_thread (arg=0x3b9e700) at /export/home/pb2/build/sb_0-14808650-1427301633.73/mysqlcom-pro-5.6.24/storage/perfschema/pfs.cc:1860 #20 0x00007fd5eecf5df3 in start_thread () from /lib64/libpthread.so.0 #21 0x00007fd5ed9c147d in clone () from /lib64/libc.so.6
[27 May 2015 13:29]
MySQL Verification Team
/ 5.5.45, 5.7.8 debug/release build not affected