Comment 2 for bug 1247021

Revision history for this message
Ivor B. (ivor.b) wrote : Re: Assertion failure in file buf0buf.cc line 3687

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
0x663114 handle_fatal_signal + 1220
0x3f9420f500 _end + -1830327664
0x3f93e328e5 _end + -1834377611
0x3f93e340c5 _end + -1834371499
0xa5cbaa buf_page_init_for_read(dberr_t*, unsigned long, unsigned long, unsigned long, unsigned long, long, unsigned long) + 2714
0xa6e5e2 buf_read_page_low(dberr_t*, bool, unsigned long, unsigned long, unsigned long, unsigned long, long, unsigned long, trx_t*) + 162
0xa6f303 buf_read_page(unsigned long, unsigned long, unsigned long, trx_t*) + 83
0xa591fe buf_page_get_gen(unsigned long, unsigned long, unsigned long, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*) + 830
0xa47093 btr_cur_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
0x9e31ad row_search_index_entry(dict_index_t*, dtuple_t const*, unsigned long, btr_pcur_t*, mtr_t*) + 141
0x9e188c row_purge_remove_sec_if_poss_leaf(purge_node_t*, dict_index_t*, dtuple_t const*) + 204
0x9e29bc row_purge_step(que_thr_t*) + 1900
0x9b20ef que_run_threads(que_thr_t*) + 1919
0x9fb2fd srv_worker_thread + 781
0x3f94207851 _end + -1830359583
0x3f93ee894d _end + -1833632035