Bug #39458 Wrong page type during recovery
Submitted: 15 Sep 2008 20:35 Modified: 7 Oct 2008 20:27
Reporter: Ann Harrison
Status: Can't repeat
Category:Server: Falcon Severity:S2 (Serious)
Version: OS:Any
Assigned to: Target Version:6.0-beta
Tags: F_PAGE IO
Triage: Triaged: D1 (Critical)

[15 Sep 2008 20: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 20:52] Ann Harrison 
Message was Bugcheck: wrong page type, expected 5 found 9
[15 Sep 2008 21: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 13:47] Miguel Solorzano 
Maybe related to the bug: http://bugs.mysql.com/bug.php?id=36436?.
[16 Sep 2008 16: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 20: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 23:47] Kevin Lewis 
Ann, Can you attach a link to the bug reproducing log and data files?
[18 Sep 2008 2:31] Kevin Lewis 
Ann, Please set to Open or Verified once you have attached these files.
[6 Oct 2008 17:20] Kevin Lewis 
Ann, is this wrong page type problem fixed now that the recent cache changes have been
backed out?
[7 Oct 2008 20:27] Ann Harrison 
After the changes to the Cache::flush method were reverted by 
Chris, this problem no longer occurs.