Hi
I have a DB running at a customer site.
The DB started today with errors.
The DB stops all the time.
The customer restarts the DB, but within 5-10 minutes it stops again.

Firebird is version: 1.5.2.4731 SS

First entry I see is:

SERVER (Server) Tue Mar 23 10:12:18 2010
Database: E:\EASYPOS DATA\OCCEASYPOS.FDB
internal gds software consistency check (applied differences will not fit in record (177))

When trying to backup DB I get this also:

SERVER (Server) Tue Mar 23 12:52:55 2010
Database: E:\MICROCOM\OCCEASYPOS.FEJL
internal gds software consistency check (cannot find record back version (291))


I then shutdown firebird, makes a copy of DB and starts working on the copy.

First i do a Gfix -mend.
It tells me of 149 errors.

In the LOG these entry are present (and a lot of them).


SERVER (Server) Tue Mar 23 13:20:42 2010
Database: E:\MICROCOM\OCCEASYPOS.FEJL
Chain for record 41400 is broken in table TILGLAAS (281)

ending with these

SERVER (Server) Tue Mar 23 13:20:42 2010
Database: E:\MICROCOM\OCCEASYPOS.FEJL
Chain for record 41598 is broken in table TILGLAAS (281)


SERVER (Server) Tue Mar 23 13:20:43 2010
Database: E:\MICROCOM\OCCEASYPOS.FEJL
Relation has 559 orphan backversions (5604 in use) in table TILGLAAS (281)


SERVER (Server) Tue Mar 23 13:21:01 2010
Database: E:\MICROCOM\OCCEASYPOS.FEJL
internal gds software consistency check (applied differences will not fit in record (177))


So eventhough I have made a mend I cant backup the DB.

I know its a problem regarding table TILGLAAS.
This is just a temporary table, so I tried connecting to the DB and doing this:

- Delete from TILGLAAS
- select count(*) from tilglaas

All above resulted in Firebird crashing.

In the end I dropped the table TILGLAAS. This I could.
After that I did a backlup/restore, recreated the table and all seems ok.


Anyone knowing what happend here?