Assertion failure in file buf0buf.cc line 3687, buf_page_init_for_read() w/ multiple purge threads and compressed tables
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
I'm experiencing constant crashes of percona server; Assertion failure in file buf0buf.cc line 3687
/usr/local/
Tried downgrading a couple of versions, but that didn't help.
Unable to provide a testcase, because the crashes seem random
2013-11-01 09:59:27 7fb231e20700 InnoDB: Assertion failure in thread 140403317802752 in file buf0buf.cc line 3687
InnoDB: Failing assertion: buf_fix_count > 0
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://
InnoDB: about forcing recovery.
08:59:27 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
Please help us make Percona Server better by reporting any
bugs at http://
key_buffer_
read_buffer_
max_used_
max_threads=1502
thread_count=9
connection_count=8
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x40000
/usr/local/
/usr/local/
/lib64/
/lib64/
/lib64/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/lib64/
/lib64/
Related branches
- George Ormond Lorch III (community): Approve (g2)
-
Diff: 59 lines (+11/-16)1 file modifiedPercona-Server/storage/innobase/buf/buf0buf.cc (+11/-16)
summary: |
- Assertion failure in file buf0buf.cc line 3687 + Assertion failure in file buf0buf.cc line 3687, buf_page_init_for_read() + w/ multiple purge threads and compressed tables |
After reinstalling (compiled from latest source) and restoring the DB from a dump the bug was still there (it took some time, only after the server had been online for a day)
Turning off binlog seems to fix it. Changing innodb_ purge_threads to 1 (with active binlog) also seems to work.
Resolved stacktrace;
0x8db7c5 my_print_stacktrace + 53 init_for_ read(dberr_ t*, unsigned long, unsigned long, unsigned long, unsigned long, long, unsigned long) + 2714 page_low( dberr_t* , bool, unsigned long, unsigned long, unsigned long, unsigned long, long, unsigned long, trx_t*) + 162 page(unsigned long, unsigned long, unsigned long, trx_t*) + 83 get_gen( unsigned long, unsigned long, unsigned long, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*) + 830 search_ to_nth_ level(dict_ index_t* , unsigned long, dtuple_t const*, unsigned long, unsigned long, btr_cur_t*, unsigned long, char const*, unsigned long, mtr_t*) + 803 index_entry( dict_index_ t*, dtuple_t const*, unsigned long, btr_pcur_t*, mtr_t*) + 141 remove_ sec_if_ poss_leaf( purge_node_ t*, dict_index_t*, dtuple_t const*) + 204 step(que_ thr_t*) + 1900 threads( que_thr_ t*) + 1919
0x663114 handle_fatal_signal + 1220
0x3f9420f500 _end + -1830327664
0x3f93e328e5 _end + -1834377611
0x3f93e340c5 _end + -1834371499
0xa5cbaa buf_page_
0xa6e5e2 buf_read_
0xa6f303 buf_read_
0xa591fe buf_page_
0xa47093 btr_cur_
0x9e31ad row_search_
0x9e188c row_purge_
0x9e29bc row_purge_
0x9b20ef que_run_
0x9fb2fd srv_worker_thread + 781
0x3f94207851 _end + -1830359583
0x3f93ee894d _end + -1833632035