Percona Server moved to https://jira.percona.com/projects/PS

InnoDB: Failing assertion: buf_page_get_io_fix(bpage) == BUF_IO_NONE in file buf0lru.cc line 2272 | abort (sig=6) in buf_LRU_block_remove_hashed

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

Bug Description

Thread 1 (LWP 19633):
+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 0x0000000000b93f84 in buf_LRU_block_remove_hashed (bpage=0x7f8075f7ab98, zip=true) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/buf/buf0lru.cc:2272
#6 0x0000000000b948f9 in buf_LRU_remove_all_pages (id=<optimized out>, buf_pool=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/buf/buf0lru.cc:852
#7 buf_LRU_remove_pages (trx=<optimized out>, buf_remove=<optimized out>, id=<optimized out>, buf_pool=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/buf/buf0lru.cc:900
#8 buf_LRU_flush_or_remove_pages (id=38, buf_remove=<optimized out>, trx=0x0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/buf/buf0lru.cc:961
#9 0x0000000000bd24ab in fil_delete_tablespace (id=38, buf_remove=BUF_REMOVE_ALL_NO_WRITE) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/fil/fil0fil.cc:2753
#10 0x0000000000bd29ea in fil_discard_tablespace (id=38) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/fil/fil0fil.cc:2866
#11 0x0000000000acfdd0 in row_truncate_table_for_mysql (table=0x7f8018053068, trx=0x7f7fe8034988) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0mysql.cc:3356
#12 0x0000000000a0f0f5 in ha_innobase::truncate (this=0x7f7fe8008570) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/handler/ha_innodb.cc:10314
#13 0x00000000008dd389 in Sql_cmd_truncate_table::handler_truncate (this=<optimized out>, thd=0x35eb0e0, table_ref=0x7f7fe8004dd0, is_tmp_table=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_truncate.cc:235
#14 0x00000000008dd907 in Sql_cmd_truncate_table::truncate_table (this=0x7f7fe8005338, thd=0x35eb0e0, table_ref=0x7f7fe8004dd0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_truncate.cc:467
#15 0x00000000008ddd5a in Sql_cmd_truncate_table::execute (this=0x7f7fe8005338, thd=0x35eb0e0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_truncate.cc:519
#16 0x0000000000721e3b in mysql_execute_command (thd=0x35eb0e0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:5159
#17 0x0000000000728628 in mysql_parse (thd=0x35eb0e0, rawbuf=0x35ed4a0 "p\264\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
#18 0x000000000072978c in dispatch_command (command=COM_QUERY, thd=0x35eb0e0, packet=0x7f806f4f9a90 "\340\260^\003", packet_length=39) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:1355
#19 0x000000000072a987 in do_command (thd=0x35eb0e0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:1049
#20 0x00000000006ee1ef in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_connect.cc:1615
#21 0x00000000006ee2d7 in handle_one_connection (arg=0x35eb0e0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_connect.cc:1526
#22 0x00000000009e033a in pfs_spawn_thread (arg=0x2e48df0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/perfschema/pfs.cc:1858
#23 0x0000003637207851 in start_thread () from /lib64/libpthread.so.0
#24 0x0000003636ee890d in clone () from /lib64/libc.so.6

2013-09-12 06:00:04 7f806f4fa700 InnoDB: Assertion failure in thread 140189600032512 in file buf0lru.cc line 2272
InnoDB: Failing assertion: buf_page_get_io_fix(bpage) == BUF_IO_NONE
[...]
Query (7f7fe8004c50): TRUNCATE `table500_innodb_compressed`
Connection ID (thread ID): 21
Status: NOT_KILLED

Tags: qa qablock
Revision history for this message
Roel Van de Paar (roel11) wrote :
Laurynas Biveinis (laurynas-biveinis)
Changed in percona-server:
status: Confirmed → In Progress
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

This has been caused by incorrect port of buf_LRU_remove_all_pages() from 5.5 to 5.6. The final page state re-check of I/O fix and space id has been dropped, incorrectly.

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

No need to target this bug to series, it is not visible in any released version or even trunk checkout.

no longer affects: percona-server/5.1
no longer affects: percona-server/5.5
no longer affects: percona-server/5.6
Revision history for this message
Roel Van de Paar (roel11) wrote :

Ack

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

Should be fixed in the latest push.

Changed in percona-server:
assignee: Laurynas Biveinis (laurynas-biveinis) → Roel Van de Paar (roel11)
status: In Progress → Incomplete
Revision history for this message
Roel Van de Paar (roel11) wrote :

Setting to fix released based on #5, if seen again will re-open.

Changed in percona-server:
status: Incomplete → Fix Released
assignee: Roel Van de Paar (roel11) → nobody
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-372

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

Other bug subscribers

Remote bug watches

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