Bug #41792 [Falcon] Error: page 9/1 wrong page type, expected 4 got 5
Submitted: 30 Dec 2008 8:12
Reporter: Shane Bester
Status: Analyzing
Category:Server: Falcon Severity:S3 (Non-critical)
Version:6.0.8-debug OS:Microsoft Windows
Assigned to: Shane Bester Target Version:

[30 Dec 2008 8:12] Shane Bester
Description:
after a few server crashes (thanks to bug #32124), falcon failed like this at one
startup:

081230  9:00:38  InnoDB: Started; log sequence number 0 103718238
Serial Log possible gap: 64709 - 61039
[Falcon] Error: page 9/1 wrong page type, expected 4 got 5

081230  9:00:39 - mysqld got exception 0x80000003 ;

mysqld-debug.exe!Error::debugBreak()[error.cpp:92]
mysqld-debug.exe!Error::error()[error.cpp:73]
mysqld-debug.exe!Cache::fetchPage()[cache.cpp:306]
mysqld-debug.exe!Dbb::fetchPage()[dbb.cpp:222]
mysqld-debug.exe!Section::deleteSectionLevel()[section.cpp:973]
mysqld-debug.exe!Section::deleteSection()[section.cpp:948]
mysqld-debug.exe!Dbb::deleteSection()[dbb.cpp:625]
mysqld-debug.exe!SRLDropTable::redo()[srldroptable.cpp:87]
mysqld-debug.exe!SerialLog::recover()[seriallog.cpp:363]
mysqld-debug.exe!Database::openDatabase()[database.cpp:733]
mysqld-debug.exe!Connection::getDatabase()[connection.cpp:1652]
mysqld-debug.exe!Connection::openDatabase()[connection.cpp:934]
mysqld-debug.exe!StorageDatabase::getOpenConnection()[storagedatabase.cpp:137]
mysqld-debug.exe!StorageHandler::initialize()[storagehandler.cpp:994]
mysqld-debug.exe!StorageInterface::falcon_init()[ha_falcon.cpp:237]
mysqld-debug.exe!ha_initialize_handlerton()[handler.cc:440]
mysqld-debug.exe!plugin_initialize()[sql_plugin.cc:1006]
mysqld-debug.exe!plugin_init()[sql_plugin.cc:1213]
mysqld-debug.exe!init_server_components()[mysqld.cc:4103]
mysqld-debug.exe!win_main()[mysqld.cc:4583]
mysqld-debug.exe!mysql_service()[mysqld.cc:4749]
mysqld-debug.exe!main()[mysqld.cc:4922]
mysqld-debug.exe!mainCRTStartup()[crt0.c:259]
kernel32.dll!BaseProcessInitPostImport()
age at http://dev.mysql.com/doc/mysql/en/crashing.html contains
that should help you find out what is causing the crash.

page	0x08f1a000 {pageType=5 checksum=0 pageNumber=9 ...}	Page *
 pageType	5	short
 checksum	0	unsigned short
pageNumber	9	int
pageType	PAGE_record_locator	PageType
lockType	Exclusive	LockType

pageNumber	9	int
pageUnused	0	int

How to repeat:
not deterministic. run some queries that crash server, restart server, run some falcon
queries.  I had always used a single thread to run the queries.