Bug #39458 Wrong page type during recovery
Submitted: 15 Sep 2008 18:35 Modified: 7 Oct 2008 18:27
Reporter: Ann Harrison Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S2 (Serious)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: F_PAGE IO

[15 Sep 2008 18:35] Ann Harrison
Description:
Under some circumstances, a Falcon recovery fails with this
message:

bzr+ssh://aharrison@bk-internal.mysql.com/bzrroot/server/mysql-6.0-falcon-team

How to repeat:
I don't know
[15 Sep 2008 18:52] Ann Harrison
Message was Bugcheck: wrong page type, expected 5 found 9
[15 Sep 2008 19:12] Philip Stoev
Ann, would you say that all errors of the type

Bugcheck: page XXX/0 wrong page type, expected YYY got ZZZ

are the same bug, or it matters what numbers XXX , YYY and ZZZ are?
[16 Sep 2008 11:47] MySQL Verification Team
Maybe related to the bug: http://bugs.mysql.com/bug.php?id=36436?.
[16 Sep 2008 14:56] Kevin Lewis
Ann, There is a testcase in http://bugs.mysql.com/bug.php?id=36436 that caused this problem for Philip for a while on certain builds.  Is it similar to how you are getting this error?
[16 Sep 2008 18:27] Ann Harrison
It could be the same.  Both cases I have found a page of type 9, which
is a data overflow.  One expected a data page, one expected an index
page.  Until I know what's gone wrong, I won't know whether that's the
same as the bug Philip registered.  The behavior is consistently reproducible
with the log and data files, but producing it from a working database is
not consistent.
[16 Sep 2008 21:47] Kevin Lewis
Ann, Can you attach a link to the bug reproducing log and data files?
[18 Sep 2008 0:31] Kevin Lewis
Ann, Please set to Open or Verified once you have attached these files.
[6 Oct 2008 15:20] Kevin Lewis
Ann, is this wrong page type problem fixed now that the recent cache changes have been backed out?
[7 Oct 2008 18:27] Ann Harrison
After the changes to the Cache::flush method were reverted by 
Chris, this problem no longer occurs.