Bug #56359 | Assertion failure in LRU handler | ||
---|---|---|---|
Submitted: | 30 Aug 2010 10:29 | Modified: | 22 Aug 2015 11:31 |
Reporter: | Jonathon Coombes | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S1 (Critical) |
Version: | 5.0.72sp1 | OS: | Linux |
Assigned to: | Marko Mäkelä | CPU Architecture: | Any |
Tags: | assertion, innodb, LRU |
[30 Aug 2010 10:29]
Jonathon Coombes
[7 Sep 2010 6:04]
Marko Mäkelä
It looks like there could be two errors in the error log. One would be the buf_pool->LRU list corruption, and another would be an (incomplete) page dump from some other thread. Can you please attach the full error log since the server was started? There have been many changes to the buf_pool->LRU list management in InnoDB Plugin 1.0 (available in MySQL 5.1). At least one had something to do with the LRU_old boundary. It is possible that this bug has been fixed in newer 5.0 releases. I can try to check that, once I have the full error log.
[8 Sep 2010 7:57]
Marko Mäkelä
I cannot see any relevant changes to the LRU bug in the 5.0 or 5.1 code bases. The only relevant changes I see are in InnoDB Plugin 1.0 (which is distributed with recent 5.1 releases): Debug code: ------------------------------------------------------------ revno: 0.3.1190 revision-id: svn-v4:16c675df-0fcb-4bc9-8058-dcc011a37293:branches/zip:2596 parent: svn-v4:16c675df-0fcb-4bc9-8058-dcc011a37293:branches/zip:2595 committer: marko timestamp: Mon 2008-08-18 18:06:33 +0000 message: branches/zip: buf_page_set_old(): Add the assertion ut_ad(bpage->in_LRU_list). Adjust the callers where necessary: buf_LRU_add_block_to_end_low() and buf_LRU_add_block_low(). ------------------------------------------------------------ revno: 0.3.1191 revision-id: svn-v4:16c675df-0fcb-4bc9-8058-dcc011a37293:branches/zip:2597 parent: svn-v4:16c675df-0fcb-4bc9-8058-dcc011a37293:branches/zip:2596 committer: marko timestamp: Mon 2008-08-18 18:28:20 +0000 message: branches/zip: Introduce UNIV_LRU_DEBUG for debugging the LRU buffer pool cache, especially buf_pool->LRU_old and bpage->old. (plus many other changes to the LRU code) Bug fix: ------------------------------------------------------------ revno: 0.3.1908 revision-id: svn-v4:16c675df-0fcb-4bc9-8058-dcc011a37293:branches/zip:6111 parent: svn-v4:16c675df-0fcb-4bc9-8058-dcc011a37293:branches/zip:6110 committer: marko timestamp: Thu 2009-10-29 11:04:11 +0000 message: branches/zip: Fix corruption of buf_pool->LRU_old and improve debug assertions. This was reported as Issue #381. It would be hard to port all these changes to the built-in InnoDB in 5.1, let alone to 5.0. The LRU_old assertion failure is likely fixed in the InnoDB Plugin of MySQL 5.1 and in MySQL 5.5+.
[7 Oct 2010 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".