InnoDB: Failing assertion: bpage->in_flush_list in file buf0lru.c line 605 | abort in buf_flush_or_remove_pages
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Expired
|
Undecided
|
Unassigned | ||
5.1 |
Invalid
|
Undecided
|
Unassigned | ||
5.5 |
Expired
|
High
|
Unassigned | ||
5.6 |
Expired
|
Undecided
|
Unassigned |
Bug Description
=======
130211 7:54:50 InnoDB: Assertion failure in thread 139821419931392 in file buf0lru.c line 605
InnoDB: Failing assertion: bpage->
=======
Thread 1 (LWP 24779):
+bt
#0 0x0000003da180c60c in pthread_kill () from /lib64/
#1 0x00000000007de9a8 in my_write_core (sig=6) at /ssd/QA-
#2 0x00000000006b3114 in handle_fatal_signal (sig=6) at /ssd/QA-
#3 <signal handler called>
#4 0x0000003da1435935 in raise () from /lib64/libc.so.6
#5 0x0000003da14370e8 in abort () from /lib64/libc.so.6
#6 0x00000000008fdc21 in buf_flush_
#7 buf_flush_
#8 buf_LRU_
#9 0x0000000000935050 in fil_delete_
#10 0x0000000000846cbf in row_drop_
#11 0x000000000081cdb5 in ha_innobase:
#12 0x00000000006b9a22 in handler:
#13 0x00000000006b9b1b in ha_delete_table (thd=0x39141a0, table_type=
#14 0x000000000060141b in quick_rm_table (base=base@
#15 0x000000000060ba7a in mysql_alter_table (thd=<optimized out>, new_db=<optimized out>, new_name=
#16 0x00000000007bd089 in Alter_table_
#17 0x00000000005a0b95 in mysql_execute_
#18 0x00000000005a1f2d in mysql_parse (thd=thd@
#19 0x00000000005a2a08 in dispatch_command (command=
#20 0x00000000005a3fc3 in do_command (thd=0x39141a0) at /ssd/QA-
#21 0x000000000064e11c in do_handle_
#22 0x000000000064e212 in handle_
#23 0x0000003da1807d14 in start_thread () from /lib64/
#24 0x0000003da14f168d in clone () from /lib64/libc.so.6
=======
From Laurynas: Analyzed, it's an easy fix. Looks like one missed case of bug 934377 and friends.
Related branches
- Laurynas Biveinis (community): Needs Fixing
- George Ormond Lorch III (community): Approve (g2)
-
Diff: 107 lines (+20/-13)1 file modifiedPercona-Server/storage/innobase/buf/buf0lru.c (+20/-13)
tags: |
added: xtradb removed: bitmap |
summary: |
InnoDB: Failing assertion: bpage->in_flush_list in file buf0lru.c line - 605 + 605 | abort in buf_flush_or_remove_pages |
Changed in percona-server: | |
status: | New → Incomplete |
Related: bug 934377, bug 1110102, bug 1111211, bug 1116447.
The fix needs bug 1086680 fix as well (another instance where the new mutex has to be acquired).