InnoDB: Failing assertion: flags & BUF_PAGE_PRINT_NO_CRASH in buf0buf.cc line 941 | sig 6 in buf_page_print

Bug #1384627 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-19 00:03:44 7f0f14e27700 InnoDB: Assertion failure in thread 139702751622912 in file buf0buf.cc line 941
InnoDB: Failing assertion: flags & BUF_PAGE_PRINT_NO_CRASH

** Asserting query

select * from information_schema.partitions where table_name= 't1'

** GDB info

#0 0x00007f0f345fc771 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 0x00007f0f332005c9 in raise () from /lib64/libc.so.6
#5 0x00007f0f33201cd8 in abort () from /lib64/libc.so.6
#6 0x0000000000cb7775 in buf_page_print (read_buf=0x7f0f0fa08000 "", zip_size=0, flags=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/labe
l_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/buf/buf0buf.cc:941
#7 0x0000000000c8294e in btr_corruption_report (block=0x7f0f07fbd990, index=0x7f0ed82bbe18) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/la
bel_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0btr.cc:81
#8 0x0000000000c82b8d in btr_root_block_get (index=0x7f0ed82bbe18, mode=2, mtr=0x7f0f14e217b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl
/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0btr.cc:745
#9 0x0000000000c82d02 in btr_root_get (index=0x7f0ed82bbe18, mtr=0x7f0f14e217b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/cen
tos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0btr.cc:782
#10 0x0000000000c83a09 in btr_get_size (index=0x7f0ed82bbe18, flag=2, mtr=0x7f0f14e217b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label
_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/btr0btr.cc:1229
#11 0x0000000000d1483f in dict_stats_analyze_index (index=0x7f0ed82bbe18) 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:1910
#12 0x0000000000d152d6 in dict_stats_update_persistent (table=0x7f0ed82bc648) 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:2209
#13 0x0000000000d16e8d in dict_stats_update (table=0x7f0ed82bc648, stats_upd_option=DICT_STATS_RECALC_PERSISTENT) at /mnt/workspace/percona-server-5.6-bi
naries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/dict/dict0stats.cc:3127
#14 0x0000000000d17173 in dict_stats_update (table=0x7f0ed82bc648, stats_upd_option=DICT_STATS_FETCH_ONLY_IF_NOT_IN_MEMORY) at /mnt/workspace/percona-ser
ver-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/dict/dict0stats.cc:3248
#15 0x0000000000acd349 in dict_stats_init (table=0x7f0ed82bc648) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-s
erver-5.6.21-69.0/storage/innobase/include/dict0stats.ic:174
#16 0x0000000000ad3868 in ha_innobase::open (this=0x7f0ed8c3fe00, name=0x7f0ed8c393d8 "./test/t1", mode=2, test_if_locked=2) at /mnt/workspace/percona-se
rver-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/handler/ha_innodb.cc:5518
#17 0x0000000000641e45 in handler::ha_open (this=0x7f0ed8c3fe00, table_arg=0x7f0ed8c3f510, name=0x7f0ed8c393d8 "./test/t1", 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
#18 0x00000000008ab54b in open_table_from_share (thd=0x19e2da0, share=0x7f0ed8c390a0, alias=0x7f0ed8c3ba90 "t1", db_stat=39, prgflag=44, ha_open_flags=0,
 outparam=0x7f0ed8c3f510, 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
#19 0x00000000007710e9 in open_table (thd=0x19e2da0, table_list=0x7f0ed8c3d480, ot_ctx=0x7f0f14e22ff0) at /mnt/workspace/percona-server-5.6-binaries-debu
g-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:3205
#20 0x000000000077389e in open_and_process_table (thd=0x19e2da0, lex=0x7f0f14e231b0, tables=0x7f0ed8c3d480, counter=0x7f0f14e23270, flags=1282, prelockin
g_strategy=0x7f0f14e230f0, has_prelocking_list=false, ot_ctx=0x7f0f14e22ff0) 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
#21 0x00000000007747a3 in open_tables (thd=0x19e2da0, start=0x7f0f14e230b0, counter=0x7f0f14e23270, flags=1282, prelocking_strategy=0x7f0f14e230f0) at /m
nt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:5213
#22 0x0000000000775932 in open_normal_and_derived_tables (thd=0x19e2da0, tables=0x7f0ed8c3d480, flags=1282) 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
#23 0x0000000000830e92 in fill_schema_table_by_open (thd=0x19e2da0, is_show_fields_or_keys=false, table=0x7f0ed8c31390, schema_table=0x15912a0 <schema_tables+1088>, orig_db_name=0x7f0ed8c372e0, orig_table_name=0x7f0f14e24550, open_tables_state_backup=0x7f0f14e24570, can_deadlock=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_show.cc:3837
#24 0x0000000000833397 in get_all_tables (thd=0x19e2da0, tables=0x7f0ed8299308, cond=0x7f0ed8299a40) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_show.cc:4769
#25 0x0000000000840c9b in do_fill_table (thd=0x19e2da0, table_list=0x7f0ed8299308, join_table=0x7f0ed8c36bb0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_show.cc:7902
#26 0x000000000084106a in get_schema_tables_result (join=0x7f0ed829bb98, executed_place=PROCESSED_BY_JOIN_EXEC) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_show.cc:8003
#27 0x0000000000813522 in JOIN::prepare_result (this=0x7f0ed829bb98, columns_list=0x7f0f14e249c0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_select.cc:823
#28 0x00000000007b050b in JOIN::exec (this=0x7f0ed829bb98) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_executor.cc:116
#29 0x000000000081401b in mysql_execute_select (thd=0x19e2da0, select_lex=0x19e5a00, free_join=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_select.cc:1100
#30 0x0000000000814317 in mysql_select (thd=0x19e2da0, tables=0x7f0ed8299308, wild_num=1, fields=..., conds=0x7f0ed8299a40, order=0x19e5bc8, group=0x19e5b00, having=0x0, select_options=2820754688, result=0x7f0ed829bb70, unit=0x19e53b8, select_lex=0x19e5a00) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_select.cc:1221
#31 0x00000000008123a6 in handle_select (thd=0x19e2da0, result=0x7f0ed829bb70, setup_tables_done_option=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_select.cc:110
#32 0x00000000007ea892 in execute_sqlcom_select (thd=0x19e2da0, all_tables=0x7f0ed8299308) 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:5597
#33 0x00000000007e2de9 in mysql_execute_command (thd=0x19e2da0) 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:2958
#34 0x00000000007ed193 in mysql_parse (thd=0x19e2da0, rawbuf=0x7f0ed8299090 "select * from information_schema.partitions where table_name= 't1'", length=66, parser_state=0x7f0f14e25e30) 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
#35 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x19e2da0, packet=0x21dfad1 "select * from information_schema.partitions where table_name= 't1';", packet_length=67) 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
#36 0x00000000007de528 in do_command (thd=0x19e2da0) 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
#37 0x00000000007a64e5 in do_handle_one_connection (thd_arg=0x19e2da0) 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
#38 0x00000000007a5fed in handle_one_connection (arg=0x19e2da0) 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
#39 0x0000000000dc5bac in pfs_spawn_thread (arg=0x20e4790) 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
#40 0x00007f0f345f7df3 in start_thread () from /lib64/libpthread.so.0
#41 0x00007f0f332c101d 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-3212

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.