Today the database EMPRESAP got corrupted for the 5th time.

I will update the version of FireBird as Gabros suggested.

Any other ideas of what may be causing this repeated database corruption?

I post what firebird.log says.

Gustavo

**************************
Extracts form firebird.log
**************************

5th time the database EMPRESAP.FDB got corrupted
------------------------------------------------

TBASNT02 (Server) Fri May 29 07:43:25 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
internal gds software consistency check (decompression overran buffer (179), file: sqz.cpp line: 223)

When I repaired it using gfix -mend
-----------------------------------

TBASNT02 (Server) Fri May 29 09:00:20 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
Data page 81528 (sequence 51), line 0 is bad in table PRODCOST (171)



TBASNT02 (Server) Fri May 29 09:00:48 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
internal gds software consistency check (page in use during flush (210), file: cch.cpp line: 3805)


TBASNT02 (Server) Fri May 29 09:00:48 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
internal gds software consistency check (page in use during flush (210), file: cch.cpp line: 3805)


TBASNT02 (Server) Fri May 29 09:00:59 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
Page 81528 is an orphan

----- Original Message -----
From: "Gabor Boros" <gaborboros@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, May 28, 2009 12:44 PM
Subject: Re: [firebird-support] Repeated database corruption


Hi,

I don't know the answer for the whole question but...

I found this things for you:
http://tracker.firebirdsql.org/browse/CORE-973
http://tracker.firebirdsql.org/browse/CORE-1961

If you use 2.0.x why not the latest 2.0.5?

Gabor

Gustavo írta:
> Hello:
>
> I have a problem with an application in Delphi that uses many FireBird databases. I use FB 2.0.1.12810 and the OS is Windows.
>
> Everything has been working fine during more than a year, but a month ago there begun to be problems with database corruption. Since that moment, there is one database (EMPRESAP.FDB) which got corrupted 4 times and another one (GENERAL.FDB) which got corrupted 1 time.
>
> The first event occured when a user was making a backup and EMPRESAP.FDB got corrupted. I can´t be sure if the backup was the cause because at the same time there were other users working with the same database.
>
> A few days later the database EMPRESAP.FDB got corrupted again. No user was making a backup this time.
>
> A few days later the database EMPRESAP.FDB got corrupted again. No user was making a backup this time.
>
> A few days later the database GENERAL.FDB got corrupted.
>
> A few days later the database EMPRESAP.FDB got corrupted again. A user was making a backup this time.
>
> Every time this happened, I repaired the database using gfix -mend and doing backup and restore.
>
> At the end of this message I post what firebird.log says.
>
> My question is:
>
> ¿What may be causing these problems?
>
> ¿What can I do to solve this?
>
> Thanks in advance.
>
> Gustavo



------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links





[Non-text portions of this message have been removed]