Subject Re: [firebird-support] Database corruption
Author Benno
Hi,

----- Original Message -----
From: "Bob Murdoch" <ram5@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, September 06, 2004 4:21 PM
Subject: RE: [firebird-support] Database corruption


>
>
> > -----Original Message-----
> > From: Helen Borrie [mailto:helebor@...]
> > Sent: Monday, September 06, 2004 2:44 AM
> > >
> > >We did a backup/restore on the db when moving to the latest
> > version of FB.
> > >It has remained a dialect 1 db.
> >
> > Was this recent? Could you run a gstat -h just to make sure
> > about the ODS version?
>
>
> Database "fds_corrupt.gdb"
>
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 1102173
> Page size 8192
> ODS version 10.1
> Oldest transaction 20517
> Oldest active 1102144
> Oldest snapshot 1102131
> Next transaction 1102163
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 0
> Implementation ID 16
> Shadow count 0
> Page buffers 2048
> Next header page 0
> Database dialect 1
> Creation date Feb 6, 2004 23:38:29
> Attributes force write, no reserve
>
> Variable header data:
> Sweep interval: 0
> *END*

Seems like you have a transaction problem in your application I guess.
Normally oldest transaction and Next transaction should have somewhere the
same number.