Subject RE: [firebird-support] Firebird database corrupt with wrong page type error on table
Author Paul Beach
 
Regards
Paul
 
-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 21 December 2017 13:14
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Firebird database corrupt with wrong page type error on table

 

Hello everyone,

During inserting data to a table I received an error on my application log “database file appears corrupt (DB Path) wrong page type page 232333 is of wrong type (expected 5, found 7)”.

On looking in FB log I got following  :

DEVMACHINE (Server)  Thu Dec 21 16:45:23 2017

                Database: DB

                Data page 232331 (sequence 168514) is confuse d in table TABLENAME (159)

DEVMACHINE (Server)  Thu Dec 21 16:45:23 2017

                Database: DB

                Page 232333 wrong type (expected 5 encountered 7)

DEVMACHINE (Server)  Thu Dec 21 16:45:23 2017

                Database: DB < /p>

                Data page 232333 (sequence 168515) is confused in table TABLENAME (159)

DEVMACHINE (Server)  Thu Dec 21 16:45:24 2017

                Database: DB

                Page 232317 is an orphan

This is the first time I am seeing this error and don’t know what has caused it. Is there any precaution to avoid such kind of errors….?

This database is around 3 years old and database maintenance activity is not done on it.  Also, the said table has 5.4 million records in it.

Thank you in advance J