Buffer pool watch sentinel page buf_fix_count race condition | InnoDB: Failing assertion: buf_fix_count > 0 in file buf0buf.cc line 3690 | abort (sig=6) in buf_page_init_for_read
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
| Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Laurynas Biveinis | |
| 5.1 |
Invalid
|
Undecided
|
Unassigned | |
| 5.5 |
Invalid
|
Undecided
|
Unassigned | |
| 5.6 |
Fix Released
|
High
|
Laurynas Biveinis |
Bug Description
An one-off occurrence on bp-split branch, testcase innodb_bug56680:
...
2013-09-12 12:15:38 7ff450082700 InnoDB: Assertion failure in thread 140687291459328 in file buf0buf.cc line 3694
InnoDB: Failing assertion: buf_fix_count > 0
...
Which appears to be a race condition on buf_fix_count on a page that is a sentinel for buffer pool watch. How exactly this can happen is not clear to me currently. All the watch sentinel buf_fix_count changes happen under zip_mutex and a corresponding page_hash X lock. Further, buf_page_
Stacktrace:
Thread 1 (Thread 0x7ff450082700 (LWP 29289)):
#0 __pthread_kill (threadid=
#1 0x0000000000adaa61 in my_write_core (sig=6) at /home/jenkins/
#2 0x00000000007367a1 in handle_fatal_signal (sig=6) at /home/jenkins/
#3 <signal handler called>
#4 0x00007ff453577425 in __GI_raise (sig=<optimized out>) at ../nptl/
#5 0x00007ff45357ab8b in __GI_abort () at abort.c:91
#6 0x0000000000cddfe0 in buf_page_
#7 0x0000000000cfa619 in buf_read_page_low (err=0x7ff45007
#8 0x0000000000cfaef8 in buf_read_page (space=525, zip_size=1024, offset=37, trx=0x7ff4280f2c08) at /home/jenkins/
#9 0x0000000000cdb2e5 in buf_page_get_gen (space=525, zip_size=1024, offset=37, rw_latch=3, guess=0x0, mode=10, file=0x10bc558 "/home/
#10 0x0000000000cb7f23 in btr_cur_
#11 0x0000000000c238a9 in btr_pcur_
#12 0x0000000000c2bc1b in row_search_
#13 0x0000000000afd5cf in ha_innobase:
#14 0x0000000000afe5da in ha_innobase:
#15 0x0000000000645e8a in handler:
#16 0x00000000007c0e20 in join_read_first (tab=0x7ff42800
#17 0x00000000007bdfd7 in sub_select (join=0x7ff4280
#18 0x00000000007bd9c1 in do_select (join=0x7ff4280
#19 0x00000000007bb89a in JOIN::exec (this=0x7ff4280
#20 0x0000000000820426 in mysql_execute_
#21 0x0000000000820728 in mysql_select (thd=0x34e8b90, tables=
#22 0x000000000081e596 in handle_select (thd=0x34e8b90, result=
#23 0x00000000007f601c in execute_
#24 0x00000000007ee562 in mysql_execute_
#25 0x00000000007f88da in mysql_parse (thd=0x34e8b90, rawbuf=
#26 0x00000000007eb18b in dispatch_command (command=COM_QUERY, thd=0x34e8b90, packet=0x35c2fd1 "", packet_length=37) at /home/jenkins/
#27 0x00000000007ea1b8 in do_command (thd=0x34e8b90) at /home/jenkins/
#28 0x00000000007b0f1a in do_handle_
#29 0x00000000007b09e8 in handle_
#30 0x0000000000de7205 in pfs_spawn_thread (arg=0x340df50) at /home/jenkins/
#31 0x00007ff45411ce9a in start_thread (arg=0x7ff45008
#32 0x00007ff453634ccd in clone () at ../sysdeps/
#33 0x0000000000000000 in ?? ()
Related branches
- Sergei Glushchenko (community): Approve (g2) on 2013-10-04
-
Diff: 11 lines (+1/-0)1 file modifiedPercona-Server/storage/innobase/buf/buf0buf.cc (+1/-0)
Changed in percona-server: | |
assignee: | nobody → Laurynas Biveinis (laurynas-biveinis) |
status: | New → Incomplete |
Roel Van de Paar (roel11) wrote : | #1 |
summary: |
- Buffer pool watch sentinel page buf_fix_count race condition + Buffer pool watch sentinel page buf_fix_count race condition | InnoDB: + Failing assertion: buf_fix_count > 0 in file buf0buf.cc line 3690 | + abort (sig=6) in buf_page_init_for_read |
Roel Van de Paar (roel11) wrote : | #2 |
Bug seen in 5.6.13-
Roel Van de Paar (roel11) wrote : | #3 |
Roel Van de Paar (roel11) wrote : | #4 |
Roel Van de Paar (roel11) wrote : | #5 |
Roel Van de Paar (roel11) wrote : | #6 |
No relation to bug 1217158.
The issue is missing watch_page recheck in buf_page_
The bug is not present in 5.1 or 5.5.
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/
Not 56qual because of bug 1217158 which looks like the 5.5 version of this bug?