Subject Database-Errors
Author Richard
Most of our Customers use FB 1.0. And until now we have had about 5
demaged databases that we have to backup und restore to repair the
erros.
Some problems are that some entries are not deleted but without any
error-message prompted for the user (we are checking if our Zeos-
Components dont work properly). But there are also no entries in the
interbase.log that show me a problem within the database until i make
a validation of the DB.
It's strange: After the Validation the interbase-log show me errors
in a table that is not the table i have the delete-problem.

e.g. a interbase.log:
SERVER (Server) Fri Jul 18 10:18:59 2003
Database: C:\DATEN_IB\ELITE.GDB
Relation has 33925 orphan backversions (13 in use) in table
RUNINFO (306)


SERVER (Server) Fri Jul 18 10:20:37 2003
Database: C:\DATEN_IB\ELITE.GDB
Relation has 33925 orphan backversions (13 in use) in table
RUNINFO (306)


SERVER (Server) Fri Jul 18 10:20:56 2003
Database: C:\DATEN_IB\ELITE.GDB
Relation has 33925 orphan backversions (13 in use) in table
RUNINFO (306)


SERVER (Server) Fri Jul 18 10:21:16 2003
Database: C:\DATEN_IB\ELITE.GDB
Relation has 33925 orphan backversions (13 in use) in table
RUNINFO (306)


But the table where Records are not deleted are RSVBUCH, RSVZEIT,
RSVZIM.

A additional question:
What does this mean:
SERVER (Server) Mon Nov 11 15:15:22 2002
INET/inet_error: read errno = 10054

I've many such entries in the log.


How can a Firebird-Datebase be demaged?
We have WIN NT 4.0, WIN 2000 SERVERS and WIN-XP (Single-User).
Have Force-Write enabled. But i dont know what can cause a database
Error. We thought that firebird is stable und we have done everything
to make it stable on a windows-System.
e.g.
Database header page information:
Flags 0
Checksum 12345
Generation 1039309
Page size 1024
ODS version 10.0
Oldest transaction 1039295
Oldest active 1039296
Oldest snapshot 1039296
Next transaction 1039297
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jun 3, 2003 11:09:57
Attributes force write

Variable header data:
Sweep interval: 20000



any help for me, thanks

Richard