RE: [firebird-support] Firebird database corrupt with wrong page type error on table

2017-12-21 Thread 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support] 
http://www.ibphoenix.com/resources/documents/how_to/doc_5

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

[firebird-support] Firebird database corrupt with wrong page type error on table

2017-12-21 Thread 'Joje' j...@codework-solutions.com [firebird-support] 
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 confused 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

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 :)