Failing assertion: fil_page_get_type(page) == 17855 in btr0cur.cc line 981 | sig 6 in btr_cur_open_at_index_side_func

Bug #1384596 reported by Ramesh Sivaraman
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Invalid
Undecided
Unassigned
5.5
Invalid
Undecided
Unassigned
5.6
Triaged
High
Unassigned
5.7
Invalid
Undecided
Unassigned

Bug Description

2014-10-19 06:48:02 7fbbc50ab700 InnoDB: Assertion failure in thread 140444441425664 in file btr0cur.cc line 981
InnoDB: Failing assertion: fil_page_get_type(page) == 17855

** Asserting query

SELECT * FROM t1 WHERE c2 <=> '2010-10-00 00:00:00' ORDER BY c2

*** GDB info

#0 0x00007fbbe3271644 in __io_getevents_0_4 () from /lib64/libaio.so.1
#1 0x0000000000b61310 in os_aio_linux_collect (array=0x2187760, segment=2, seg_size=256) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label
_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/os/os0file.cc:5113
#2 0x0000000000b616f7 in os_aio_linux_handle (global_seg=4, message1=0x7fbbb2a6aeb0, message2=0x7fbbb2a6aea8, type=0x7fbbb2a6aea0, space_id=0x7fbbb2a6ae
98) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/os/os0file.cc:5259
#3 0x0000000000d2d399 in fil_aio_wait (segment=4) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-6
9.0/storage/innobase/fil/fil0fil.cc:5822
#4 0x0000000000c2eb79 in io_handler_thread (arg=0x18bce40 <n+32>) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona
-server-5.6.21-69.0/storage/innobase/srv/srv0start.cc:498
#5 0x00007fbbe347adf3 in start_thread () from /lib64/libpthread.so.0
#6 0x00007fbbe214401d in clone () from /lib64/libc.so.6

Thread 1 (Thread 0x7fbbc50ab700 (LWP 23859)):
+bt
#0 0x00007fbbe347f771 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 0x00007fbbe20835c9 in raise () from /lib64/libc.so.6
#5 0x00007fbbe2084cd8 in abort () from /lib64/libc.so.6
#6 0x0000000000c97cd4 in btr_cur_open_at_index_side_func (from_left=true, index=0x7fbb88117e48, latch_mode=1, cursor=0x7fbb886a2810, level=0, file=0x107
75e8 "/mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/include/btr0pcur.ic", line=
518, mtr=0x7fbbc50a7890) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/btr/b
tr0cur.cc:981
#7 0x0000000000c01fa6 in btr_pcur_open_at_index_side (from_left=true, index=0x7fbb88117e48, latch_mode=1, pcur=0x7fbb886a2810, init_pcur=false, level=0,
 mtr=0x7fbbc50a7890) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/include/b
tr0pcur.ic:518
#8 0x0000000000c09fb5 in row_search_for_mysql (buf=0x7fbb8819b4a0 "", mode=1, prebuilt=0x7fbb886a2798, match_mode=0, direction=0) at /mnt/workspace/perc
ona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/row/row0sel.cc:4161
#9 0x0000000000ad8684 in ha_innobase::index_read (this=0x7fbb886dc880, buf=0x7fbb8819b4a0 "", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /m
nt/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:8224
#10 0x0000000000ad9654 in ha_innobase::index_first (this=0x7fbb886dc880, buf=0x7fbb8819b4a0 "") 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:8621
#11 0x0000000000ad984c in ha_innobase::rnd_next (this=0x7fbb886dc880, buf=0x7fbb8819b4a0 "") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/la
bel_exp/centos6-64/percona-server-5.6.21-69.0/storage/innobase/handler/ha_innodb.cc:8718
#12 0x0000000000642820 in handler::ha_rnd_next (this=0x7fbb886dc880, buf=0x7fbb8819b4a0 "") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/lab
el_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.cc:2872
#13 0x00000000009384c0 in find_all_keys (param=0x7fbbc50a82f0, select=0x7fbb88521880, fs_info=0x7fbbc50a8280, buffpek_pointers=0x7fbbc50a8490, tempfile=0
x7fbbc50a8370, pq=0x0, found_rows=0x7fbbc50a8710) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/filesort.cc:774
#14 0x0000000000936ef1 in filesort (thd=0x215fdd0, table=0x7fbb886dd580, filesort=0x7fbb885219f0, sort_positions=false, examined_rows=0x7fbbc50a8718, found_rows=0x7fbbc50a8710) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/filesort.cc:339
#15 0x00000000007b8257 in create_sort_index (thd=0x215fdd0, join=0x7fbb88005e48, tab=0x7fbb88521280) 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:3346
#16 0x00000000007b5d09 in st_join_table::sort_table (this=0x7fbb88521280) 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:2511
#17 0x00000000007b57d9 in join_init_read_record (tab=0x7fbb88521280) 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:2385
#18 0x00000000007b3083 in sub_select (join=0x7fbb88005e48, join_tab=0x7fbb88521280, end_of_records=false) 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:1256
#19 0x00000000007b2a6d in do_select (join=0x7fbb88005e48) 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:933
#20 0x00000000007b09c9 in JOIN::exec (this=0x7fbb88005e48) 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:194
#21 0x000000000081401b in mysql_execute_select (thd=0x215fdd0, select_lex=0x2162a30, 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
#22 0x0000000000814317 in mysql_select (thd=0x215fdd0, tables=0x7fbb880052f8, wild_num=1, fields=..., conds=0x7fbb88005a88, order=0x2162bf8, group=0x2162b30, having=0x0, select_options=2281712384, result=0x7fbb88005e20, unit=0x21623e8, select_lex=0x2162a30) 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
#23 0x00000000008123a6 in handle_select (thd=0x215fdd0, result=0x7fbb88005e20, 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
#24 0x00000000007ea892 in execute_sqlcom_select (thd=0x215fdd0, all_tables=0x7fbb880052f8) 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
#25 0x00000000007e2de9 in mysql_execute_command (thd=0x215fdd0) 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
#26 0x00000000007ed193 in mysql_parse (thd=0x215fdd0, rawbuf=0x7fbb880050a0 "SELECT * FROM t1 WHERE c2 <=> '2010-10-00 00:00:00' ORDER BY c2", length=63, parser_state=0x7fbbc50a9e30) 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
#27 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x215fdd0, packet=0x2967a01 "t\002t1\002t1\004c773\004c773\f?", packet_length=64) 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
#28 0x00000000007de528 in do_command (thd=0x215fdd0) 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
#29 0x00000000007a64e5 in do_handle_one_connection (thd_arg=0x215fdd0) 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
#30 0x00000000007a5fed in handle_one_connection (arg=0x215fdd0) 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
#31 0x0000000000dc5bac in pfs_spawn_thread (arg=0x28ebf50) 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
#32 0x00007fbbe347adf3 in start_thread () from /lib64/libpthread.so.0
#33 0x00007fbbe214401d in clone () from /lib64/libc.so.6

Tags: qa upstream
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
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
tags: added: upstream
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Please confirm 5.7 status on the upstream bug?

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

Could not reproduce the issue with upstream 5.7.11 version

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-3208

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.