Subject | Database-Errors |
---|---|
Author | Richard |
Post date | 2003-07-18T09:13:44Z |
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
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