Subject Re: [firebird-support] Re: Database page error after migrating to 1.5
Author Helen Borrie
At 06:35 AM 13/10/2004 +0000, you wrote:


>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).

Is it possible that cron is using the wrong version of gbak?


>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)

Ann's the one who can usually come up with clues based on these msgs.

Some questions of interest....

What is the character set of the database? Is it the same in the java client?

When you backed up the "old" and restored the "new", what ODS, dialect,
character set were you coming from?

./heLen