InnoDB: Failing assertion: i < srv_buf_pool_instances in file buf0buf.ic line 88 | abort in buf_pool_from_bpage

Bug #1227578 reported by Roel Van de Paar
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Critical
Laurynas Biveinis

Bug Description

Version: '5.6.13-rc60.5-debug-log' socket: '/ssd//228188/current1_10/tmp/master.sock' port: 13180 Percona Server with XtraDB (GPL), Release rc60.5, Revision 440-debug
row_undo_ins_remove_sec_low returning DB_FAIL
row_undo_ins_remove_sec_low returning DB_FAIL
row_undo_ins_remove_sec_low returning DB_FAIL
[...]
row_undo_ins_remove_sec_low returning DB_FAIL
2013-09-18 20:39:26 7fbd99651700 InnoDB: Assertion failure in thread 140452299085568 in file buf0buf.ic line 88
InnoDB: Failing assertion: i < srv_buf_pool_instances
[...]
Query (7fbcf0004d70): SELECT `c12` FROM `table100_innodb_compressed_int_autoinc`
Connection ID (thread ID): 19
Status: NOT_KILLED

Thread 1 (LWP 1343):
+bt
#0 0x000000363720c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006874ae in handle_fatal_signal (sig=6) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/signal_handler.cc:251
#2 <signal handler called>
#3 0x0000003636e328a5 in raise () from /lib64/libc.so.6
#4 0x0000003636e34085 in abort () from /lib64/libc.so.6
#5 0x0000000000b805e6 in buf_pool_from_bpage (bpage=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/include/buf0buf.ic:88
#6 buf_page_get_mutex (bpage=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/include/buf0buf.ic:348
#7 buf_enter_zip_mutex_for_page (bpage=0x7fbd30009130) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/include/buf0buf.ic:1416
#8 0x0000000000b825dd in buf_page_get_gen (space=13, zip_size=8192, offset=1664, rw_latch=1, guess=<optimized out>, mode=10, file=0xe0ddf8 "/bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/btr/btr0pcur.cc", line=438, mtr=0x7fbd9964e470) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/buf/buf0buf.cc:2744
#9 0x0000000000b6ba86 in btr_block_get_func (mtr=0x7fbd9964e470, index=0x7fbd6ecddcc8, line=438, file=0xe0ddf8 "/bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/btr/btr0pcur.cc", mode=1, page_no=<optimized out>, zip_size=<optimized out>, space=13) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/include/btr0btr.ic:60
#10 btr_pcur_move_to_next_page (cursor=0x7fbcf0034730, mtr=0x7fbd9964e470) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/btr/btr0pcur.cc:438
#11 0x0000000000aeb9bf in btr_pcur_move_to_next (cursor=0x7fbcf0034730, mtr=0x7fbd9964e470) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/include/btr0pcur.ic:360
#12 0x0000000000aecb5c in row_search_for_mysql (buf=0x7fbcf0007e50 "", mode=1, prebuilt=<optimized out>, match_mode=0, direction=1) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0sel.cc:4970
#13 0x0000000000a022f3 in ha_innobase::general_fetch (this=0x7fbcf0009360, buf=0x7fbcf0007e50 "", direction=1, match_mode=0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/handler/ha_innodb.cc:8143
#14 0x0000000000a026c2 in ha_innobase::rnd_next (this=0x7fbcf0009360, buf=0x7fbcf0007e50 "") at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/handler/ha_innodb.cc:8369
#15 0x00000000005b4eca in handler::ha_rnd_next (this=0x7fbcf0009360, buf=0x7fbcf0007e50 "") at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/handler.cc:2693
#16 0x0000000000888edc in rr_sequential (info=0x7fbcf0006418) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/records.cc:478
#17 0x00000000006fc639 in sub_select (join=0x7fbcf00056c0, join_tab=0x7fbcf0006388, end_of_records=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_executor.cc:1256
#18 0x00000000006fd9ab in do_select (join=0x7fbcf00056c0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_executor.cc:930
#19 JOIN::exec (this=0x7fbcf00056c0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_executor.cc:191
#20 0x000000000074a5c0 in mysql_execute_select (free_join=true, select_lex=0x2e04e30, thd=0x2e02360) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_select.cc:1101
#21 mysql_select (thd=0x2e02360, tables=0x7fbcf0005080, wild_num=0, fields=..., conds=0x0, order=<optimized out>, group=0x2e04f30, having=0x0, select_options=2147748608, result=0x7fbcf0005698, unit=0x2e047e8, select_lex=0x2e04e30) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_select.cc:1222
#22 0x000000000074b0bb in handle_select (thd=0x2e02360, result=0x7fbcf0005698, setup_tables_done_option=0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_select.cc:111
#23 0x000000000071faed in execute_sqlcom_select (thd=0x2e02360, all_tables=0x7fbcf0005080) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:5307
#24 0x00000000007225c7 in mysql_execute_command (thd=0x2e02360) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:2764
#25 0x0000000000728628 in mysql_parse (thd=0x2e02360, rawbuf=0x2e04720 "P\303\070\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:6479
#26 0x000000000072978c in dispatch_command (command=COM_QUERY, thd=0x2e02360, packet=0x7fbd99650910 "`#\340\002", packet_length=61) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:1355
#27 0x000000000072a987 in do_command (thd=0x2e02360) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:1049
#28 0x00000000007d7f57 in threadpool_process_request (thd=0x2e02360) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/threadpool_common.cc:312
#29 0x00000000007dac38 in handle_event (connection=0x2dbe370) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/threadpool_unix.cc:1466
#30 worker_main (param=0x151d600 <all_groups+1536>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/threadpool_unix.cc:1519
#31 0x00000000009e033a in pfs_spawn_thread (arg=0x2cf5c20) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/perfschema/pfs.cc:1858
#32 0x0000003637207851 in start_thread () from /lib64/libpthread.so.0
#33 0x0000003636ee890d in clone () from /lib64/libc.so.6

Tags: qa qablock 56qual
Revision history for this message
Roel Van de Paar (roel11) wrote :
summary: InnoDB: Failing assertion: i < srv_buf_pool_instances in file buf0buf.ic
- line 88
+ line 88 | abort in buf_pool_from_bpage
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :

RQG @ 911 <email address hidden>
PS @ Percona-Server-5.6.13-rc60.5-440-debug.Linux.x86_64 (5.6-QA)

Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :

Upgrade to qablock: seen in many runs.

tags: added: qablock
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Fixed in the latest bp-split branch. The bug is not present in any released version nor trunk.

no longer affects: percona-server/5.1
no longer affects: percona-server/5.5
no longer affects: percona-server/5.6
Changed in percona-server:
status: Confirmed → Fix Released
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-374

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.