Subject Database appears corrupt
Author Bogdan Mugerli
Hi

Every few months the following type of error occurs on cca 2GB heavily
loaded database (Firebird 6.2.796)
===========================================================================
Interbase.log:

Fri Feb 27 06:45:10 2004
Database: D:\APLJBAZA\APLJ.GDB
database file appears corrupt ()
wrong page type
page 474703 is of wrong type (expected 7
found 5)
P1800 (Server)
Fri Feb 27 06:45:10 2004
Database: D:\APLJBAZA\APLJ.GDB
database file appears corrupt ()
wrong page type
page 474703 is of wrong type (expected 7
found 5)
P1800 (Server)
Fri Feb 27 06:45:10 2004
Database: D:\APLJBAZA\APLJ.GDB
database file appears corrupt ()
wrong page type
page 474703 is of wrong type (expected 7
found 5)
P1800 (Server)
Fri Feb 27 06:45:10 2004
Database: D:\APLJBAZA\APLJ.GDB
database file appears corrupt ()
wrong page type
page 474703 is of wrong type (expected 7
found 5)
P1800 (Server)
Fri Feb 27 06:45:10 2004
Database: D:\APLJBAZA\APLJ.GDB
database file appears corrupt ()
wrong page type
page 474703 is of wrong type (expected 7
found 5)
P1800 (Server)
Fri Feb 27 06:45:12 2004
Database: D:\APLJBAZA\APLJ.GDB
database file appears corrupt ()
wrong page type
page 474703 is of wrong type (expected 7
found 5)
P1800 (Server)
Fri Feb 27 06:45:12 2004
Database: D:\APLJBAZA\APLJ.GDB
database file appears corrupt ()
wrong page type
page 474703 is of wrong type (expected 7
found 5)
P1800 (Server)
Fri Feb 27 06:45:12 2004
Database: D:\APLJBAZA\APLJ.GDB
database file appears corrupt ()
wrong page type
page 474703 is of wrong type (expected 7
found 5)
P1800 (Server)
Fri Feb 27 06:45:18 2004
Database: D:\APLJBAZA\APLJ.GDB
database file appears corrupt ()
wrong page type
page 474703 is of wrong type (expected 7
found 5)
internal gds software consistency check (error during savepoint backout
(290))
P1800 (Server)
Fri Feb 27 06:46:08 2004
INET/inet_error: read errno = 10054
P1800 (Server)
Fri Feb 27 06:46:13 2004
INET/inet_error: read errno = 10054
P1800 (Client)
Fri Feb 27 06:53:57 2004
Guardian starting: C:\Program Files\Firebird\bin\ibserver.exe
P1800 (Server)
Fri Feb 27 06:54:05 2004
INET/inet_error: read errno = 10054
P1800 (Server)
Fri Feb 27 06:54:06 2004
INET/inet_error: send errno = 10054
P1800 (Server)
==================================================
Then we do backup and restore and thing go on without (noticed) problems.

Server is running on win2000 server.

We are planning to upgrade to Firebird-1.0.3.972 soon
still i would like to know why such things continue to happen

Regards, Bogdan