Failing assertion: index->id == btr_page_get_index_id(page) in file btr0cur.cc line 1132 | in btr_cur_open_at_rnd_pos_func

Bug #1384581 reported by Ramesh Sivaraman
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Won't Fix
Undecided
Unassigned
5.5
New
Undecided
Unassigned
5.6
New
Undecided
Unassigned
5.7
New
Undecided
Unassigned

Bug Description

2014-10-18 17:11:37 7f94de197700 InnoDB: Assertion failure in thread 140277358098176 in file btr0cur.cc line 1132
InnoDB: Failing assertion: index->id == btr_page_get_index_id(page)

** Asserting query

INSERT INTO t2 VALUES (356,098015,58,'unlocks','assessor','births','')

** GDB info

#0 0x00007f9515387771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab7586 in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0
/mysys/stacktrace.c:422
#2 0x000000000072f9ff in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.2
1-69.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007f9513f8b5c9 in raise () from /lib64/libc.so.6
#5 0x00007f9513f8ccd8 in abort () from /lib64/libc.so.6
#6 0x0000000000c98250 in btr_cur_open_at_rnd_pos_func (index=0x7f94bc2f3ba8, latch_mode=1, cursor=0x7f94de192a00, file=0x109e898 "/mnt/workspace/percona
-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0cur.cc", line=4101, mtr=0x7f94de192a80) at /mnt
/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0cur.cc:1132
#7 0x0000000000c9e507 in btr_estimate_number_of_different_key_vals (index=0x7f94bc2f3ba8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/labe
l_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0cur.cc:4101
#8 0x0000000000d12e44 in dict_stats_update_transient_for_index (index=0x7f94bc2f3ba8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_ex
p/centos6-64/percona-server-5.6.21-69.0/storage/innobase/dict/dict0stats.cc:862
#9 0x0000000000d12f9a in dict_stats_update_transient (table=0x7f94bc2bc888) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-
64/percona-server-5.6.21-69.0/storage/innobase/dict/dict0stats.cc:916
#10 0x0000000000d172ae in dict_stats_update (table=0x7f94bc2bc888, stats_upd_option=DICT_STATS_FETCH_ONLY_IF_NOT_IN_MEMORY) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/dict/dict0stats.cc:3292
#11 0x0000000000acd349 in dict_stats_init (table=0x7f94bc2bc888) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/include/dict0stats.ic:174
#12 0x0000000000ad3868 in ha_innobase::open (this=0x7f94bc296da0, name=0x7f94bca310e0 "./mysql/t2", mode=2, test_if_locked=2) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/handler/ha_innodb.cc:5518
#13 0x0000000000641e45 in handler::ha_open (this=0x7f94bc296da0, table_arg=0x7f94bca2beb0, name=0x7f94bca310e0 "./mysql/t2", mode=2, test_if_locked=2) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.cc:2683
#14 0x00000000008ab54b in open_table_from_share (thd=0x2101670, share=0x7f94bca30da0, alias=0x7f94bc0051d8 "t2", db_stat=39, prgflag=44, ha_open_flags=0, outparam=0x7f94bca2beb0, is_create_table=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/table.cc:2364
#15 0x00000000007710e9 in open_table (thd=0x2101670, table_list=0x7f94bc0051e0, ot_ctx=0x7f94de194780) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:3205
#16 0x000000000077389e in open_and_process_table (thd=0x2101670, lex=0x2103bb8, tables=0x7f94bc0051e0, counter=0x2103c78, flags=0, prelocking_strategy=0x7f94de194880, has_prelocking_list=false, ot_ctx=0x7f94de194780) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:4699
#17 0x00000000007747a3 in open_tables (thd=0x2101670, start=0x7f94de194840, counter=0x2103c78, flags=0, prelocking_strategy=0x7f94de194880) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:5213
#18 0x0000000000775932 in open_normal_and_derived_tables (thd=0x2101670, tables=0x7f94bc0051e0, flags=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:5913
#19 0x00000000007c1296 in mysql_insert (thd=0x2101670, table_list=0x7f94bc0051e0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_insert.cc:750
#20 0x00000000007e5262 in mysql_execute_command (thd=0x2101670) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:3851
#21 0x00000000007ed193 in mysql_parse (thd=0x2101670, rawbuf=0x7f94bc0050a0 "INSERT INTO t2 VALUES (356,098015,58,'unlocks','assessor','births','')", length=70, parser_state=0x7f94de195e30) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
#22 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x2101670, packet=0x2909681 "INSERT INTO t2 VALUES (356,098015,58,'unlocks','assessor','births','');", packet_length=71) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
#23 0x00000000007de528 in do_command (thd=0x2101670) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
#24 0x00000000007a64e5 in do_handle_one_connection (thd_arg=0x2101670) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1532
#25 0x00000000007a5fed in handle_one_connection (arg=0x2101670) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1443
#26 0x0000000000dc5bac in pfs_spawn_thread (arg=0x28ba390) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/perfschema/pfs.cc:1860
#27 0x00007f9515382df3 in start_thread () from /lib64/libpthread.so.0
#28 0x00007f951404c01d in clone () from /lib64/libc.so.6

Tags: qa
tags: added: qa
Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

Core, GDB, error log etc

There was no master (single threaded, single mysqld run)

Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

s/There was no master (single threaded, single mysqld run)/Single threaded run, single mysqld involved/

description: updated
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3205

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.