June 28. 1 customer got a corrupt database, (FB 1.5.1 SS on Win2000 SP 4)
after some gfix -mend we were able to do a backup and restore.
Some of the records were missing after restore, but we managed to pull
them out from an earlier backup.
Then we installed FB 1.5.2 SS on the same machine. 3 weeks later the same
thing happened again.
We managed to get it working, but today it got corrupted again.
The same Database and application is deployed at approximately 35 other
customers, and there has never been any problems.
I suspect some HW problems. Can someone get an Idea from the information
below ?

Sorry for the long mail......

Regards

Trond Dammen

#######

Server Version Info
---------------------------------------------------------------------------
Server Version: WI-V1.5.2.4731 Firebird 1.5
Server Implementation: Firebird/x86/Windows NT
Service Version: 2


Configuration Info
---------------------------------------------------------------------------
Base File: C:\Program Files\Firebird\Firebird_1_5\
Lock File: C:\Program Files\Firebird\Firebird_1_5\
Message File: C:\Program Files\Firebird\Firebird_1_5\
Security Database: C:\Program Files\Firebird\Firebird_1_5\security.fdb



Database Info
---------------------------------------------------------------------------
Number of connections: 2
Number of databases: 1
Databases: D:\FLEXI\DATA\INKASSO.FB

----------------------------------------------------------------------------
Summary of validation errors


Number of record level errors : 4
Number of database page errors : 1


------------------------------------------------------------------------------

Database "D:\Flexi\Data\INKASSO.FB"

Database header page information:
Flags 0
Checksum 12345
Generation 100049
Page size 4096
ODS version 10.1
Oldest transaction 100019
Oldest active 100020
Oldest snapshot 100020
Next transaction 100031
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 4096
Next header page 0
Database dialect 3
Creation date Jun 24, 2005 14:45:58
Attributes force write, database shutdown

Variable header data:
Sweep interval: 20000
*END*




----Snip from Firebird Log.

SERVER (Server) Tue Jul 19 23:29:11 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Server) Tue Jul 19 23:29:11 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Server) Wed Jul 20 09:59:37 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Server) Wed Jul 20 09:59:38 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Client) Wed Jul 20 10:25:15 2005
C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: normal
shutdown


SERVER (Client) Wed Jul 20 10:25:20 2005
Guardian starting: C:\Program
Files\Firebird\Firebird_1_5\bin\fbserver.exe


SERVER (Client) Wed Jul 20 10:25:27 2005
INET/inet_error: send errno = 10054

SERVER (Server) Wed Jul 20 10:25:33 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Server) Wed Jul 20 10:25:33 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Server) Wed Jul 20 10:39:46 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Server) Wed Jul 20 10:39:46 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Server) Wed Jul 20 10:48:50 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Server) Wed Jul 20 10:48:50 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Client) Wed Jul 20 21:06:44 2005
Guardian starting: C:\Program
Files\Firebird\Firebird_1_5\bin\fbserver.exe


SERVER (Server) Wed Jul 20 21:06:57 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Server) Wed Jul 20 21:06:57 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Server) Wed Jul 20 21:07:41 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Server) Wed Jul 20 21:07:41 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Client) Wed Jul 20 21:15:09 2005
Guardian starting: C:\Program
Files\Firebird\Firebird_1_5\bin\fbserver.exe


SERVER (Server) Wed Jul 20 21:15:39 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Server) Wed Jul 20 21:15:39 2005
Database: D:\FLEXI\DATA\INKASSO.FB
internal gds software consistency check (cannot find record back
version (291))

SERVER (Server) Fri Jul 22 09:29:32 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Data page 143540 (sequence 0) is confused in table JOBBER (144)


SERVER (Server) Fri Jul 22 09:29:34 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Chain for record 24857 is broken in table SAK (159)


SERVER (Server) Fri Jul 22 09:29:34 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Chain for record 24863 is broken in table SAK (159)


SERVER (Server) Fri Jul 22 09:29:34 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Relation has -1 orphan backversions (2 in use) in table SAK (159)


SERVER (Server) Fri Jul 22 09:29:35 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Data page 143625 (sequence 0) is confused in table SPOOLER (166)


SERVER (Server) Fri Jul 22 09:29:35 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Relation has 1 orphan backversions (16 in use) in table SPOOLER
(166)


SERVER (Server) Fri Jul 22 09:29:38 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Page 143540 is use but marked free

SERVER (Server) Fri Jul 22 09:29:38 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Page 143625 is use but marked free

SERVER (Server) Fri Jul 22 09:29:38 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Page 143854 is use but marked free

SERVER (Server) Fri Jul 22 09:29:38 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Page 143855 is use but marked free

SERVER (Server) Fri Jul 22 09:31:08 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Data page 143540 (sequence 0) is confused in table JOBBER (144)


SERVER (Server) Fri Jul 22 09:31:10 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Chain for record 24857 is broken in table SAK (159)


SERVER (Server) Fri Jul 22 09:31:10 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Chain for record 24863 is broken in table SAK (159)


SERVER (Server) Fri Jul 22 09:31:11 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Relation has -1 orphan backversions (2 in use) in table SAK (159)


SERVER (Server) Fri Jul 22 09:31:11 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Data page 143625 (sequence 0) is confused in table SPOOLER (166)


SERVER (Server) Fri Jul 22 09:31:11 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Relation has 1 orphan backversions (16 in use) in table SPOOLER
(166)


SERVER (Server) Fri Jul 22 09:31:15 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Page 143540 is use but marked free

SERVER (Server) Fri Jul 22 09:31:15 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Page 143625 is use but marked free

SERVER (Server) Fri Jul 22 09:31:15 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Page 143854 is use but marked free

SERVER (Server) Fri Jul 22 09:31:15 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Page 143855 is use but marked free

SERVER (Server) Fri Jul 22 09:32:55 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Record 24857 is marked as damaged in table SAK (159)


SERVER (Server) Fri Jul 22 09:32:56 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Record 24863 is marked as damaged in table SAK (159)


SERVER (Server) Fri Jul 22 09:32:56 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Relation has 1 orphan backversions (0 in use) in table SAK (159)


SERVER (Server) Fri Jul 22 09:32:56 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Relation has 1 orphan backversions (0 in use) in table SPOOLER
(166)


SERVER (Server) Fri Jul 22 09:33:00 2005
Database: D:\FLEXI\DATA\INKASSO.FB
Page 143855 is use but marked free