Subject | Re: Database page error after migrating to 1.5 |
---|---|
Author | tdtappe |
Post date | 2004-10-13T06:35:25Z |
Hmm. And again! The same database is corrupted.
We use several other databases (about 50 on that server from which at
about 10 are used throughout the day) and they are all OK.
And I am still thinking about InterClient as a possible problem maker.
Why? The affected database is the ONLY database which is accessed
via "standard" client interface AND InterClient.
There is some other database which is only accessed via InterClient
and it showed no problems so far.
This makes me a bit nervous, to be honest.
Some more information:
FB host:
Debian Linux System (stable apart from libc, libstdc++ and samba for
testing purposes), RAID-5, ext3 file system.
client access: native (port 3050) and JDBC (Interclient 2.01, port
3051), all clients are Firebird 1.0 or 1.5
The error always occurs when trying to backup the database at night.
(gbak as a local cronjob on db host).
A simple gfix -m ..., gbak -b -g ..., gbak -c cures the database.
Validation said:
Summary of validation errors
Number of record level errors : 2
Number of data page errors : 1
Number of index page errors : 3
Here is some excerpt from the log file:
diego Tue Oct 12 20:21:52 2004
Database: /database/intern/transdata.fdb
internal gds software consistency check (decompression
overran buffer (179))
...
diego Wed Oct 13 07:52:08 2004
Database: /database/intern/transdata.fdb
Record 213428 is wrong length in table TBLCFGVALUES (405)
diego Wed Oct 13 07:52:08 2004
Database: /database/intern/transdata.fdb
Index 1 is corrupt (missing entries) in table TBLCFGVALUES
(405)
diego Wed Oct 13 07:52:08 2004
Database: /database/intern/transdata.fdb
Index 2 is corrupt (missing entries) in table TBLCFGVALUES
(405)
diego Wed Oct 13 07:52:08 2004
Database: /database/intern/transdata.fdb
Index 3 is corrupt (missing entries) in table TBLCFGVALUES
(405)
diego Wed Oct 13 07:52:08 2004
Database: /database/intern/transdata.fdb
Relation has 4 orphan backversions (23 in use) in table
TBLCFGVALUES (405)
diego Wed Oct 13 07:52:08 2004
Database: /database/intern/transdata.fdb
Data page 95007 (sequence 253) is confused in table
TBLDESKVERSAND (432)
Any idea what to do?
I really need some advice here.
A few more crashes and my boss is going to kill me :-(
--Heiko
We use several other databases (about 50 on that server from which at
about 10 are used throughout the day) and they are all OK.
And I am still thinking about InterClient as a possible problem maker.
Why? The affected database is the ONLY database which is accessed
via "standard" client interface AND InterClient.
There is some other database which is only accessed via InterClient
and it showed no problems so far.
This makes me a bit nervous, to be honest.
Some more information:
FB host:
Debian Linux System (stable apart from libc, libstdc++ and samba for
testing purposes), RAID-5, ext3 file system.
client access: native (port 3050) and JDBC (Interclient 2.01, port
3051), all clients are Firebird 1.0 or 1.5
The error always occurs when trying to backup the database at night.
(gbak as a local cronjob on db host).
A simple gfix -m ..., gbak -b -g ..., gbak -c cures the database.
Validation said:
Summary of validation errors
Number of record level errors : 2
Number of data page errors : 1
Number of index page errors : 3
Here is some excerpt from the log file:
diego Tue Oct 12 20:21:52 2004
Database: /database/intern/transdata.fdb
internal gds software consistency check (decompression
overran buffer (179))
...
diego Wed Oct 13 07:52:08 2004
Database: /database/intern/transdata.fdb
Record 213428 is wrong length in table TBLCFGVALUES (405)
diego Wed Oct 13 07:52:08 2004
Database: /database/intern/transdata.fdb
Index 1 is corrupt (missing entries) in table TBLCFGVALUES
(405)
diego Wed Oct 13 07:52:08 2004
Database: /database/intern/transdata.fdb
Index 2 is corrupt (missing entries) in table TBLCFGVALUES
(405)
diego Wed Oct 13 07:52:08 2004
Database: /database/intern/transdata.fdb
Index 3 is corrupt (missing entries) in table TBLCFGVALUES
(405)
diego Wed Oct 13 07:52:08 2004
Database: /database/intern/transdata.fdb
Relation has 4 orphan backversions (23 in use) in table
TBLCFGVALUES (405)
diego Wed Oct 13 07:52:08 2004
Database: /database/intern/transdata.fdb
Data page 95007 (sequence 253) is confused in table
TBLDESKVERSAND (432)
Any idea what to do?
I really need some advice here.
A few more crashes and my boss is going to kill me :-(
--Heiko