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


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


1st time the database EMPRESAP.FDB got corrupted
------------------------------------------------

TBASNT02 (Server) Thu Apr 23 08:30:14 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1090)


2nd time the database EMPRESAP.FDB got corrupted
------------------------------------------------

TBASNT02 (Server) Fri May 08 17:14:21 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1090)

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

TBASNT02 (Server) Fri May 08 17:30:03 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
Index 8 is corrupt on page 118596 level 1. File: \fb2\dev\fb2R2_0_1\firebird2\src\jrd\validation.cpp, line: 1650
in table VALSTLIN (262)

TBASNT02 (Server) Fri May 08 17:30:03 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
Record 85808 is wrong length in table ASIMOVIM (264)


1st time the database GENERAL.FDB got corrupted
-----------------------------------------------

TBASNT02 (Client) Thu May 21 10:40:05 2009
INET/inet_error: read errno = 10054

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

TBASNT02 (Server) Thu May 21 12:05:25 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\GENERAL\GENERAL1.FDB
Relation has 13 orphan backversions (0 in use) in table RDB$RELATIONS (6)

TBASNT02 (Server) Thu May 21 12:05:25 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\GENERAL\GENERAL1.FDB
Index 1 is corrupt on page 2335 level 1. File: \fb2\dev\fb2R2_0_1\firebird2\src\jrd\validation.cpp, line: 1650
in table FORMOBJ (173)


3rd time the database EMPRESAP.FDB got corrupted
------------------------------------------------

TBASNT02 (Server) Wed May 27 08:01:00 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1090)

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

TBASNT02 (Server) Wed May 27 09:16:01 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
Data page 84417 (sequence 1752), line 0 is bad in table CCOMPROB (167)



TBASNT02 (Server) Wed May 27 09:16:03 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
Data page 21504 (sequence 1287), line 0 is bad in table MOVSTOCK (271)



TBASNT02 (Server) Wed May 27 09:16:04 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) Wed May 27 09:16:04 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) Wed May 27 09:16:31 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
Page 21504 is an orphan


TBASNT02 (Server) Wed May 27 09:16:31 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
Page 84417 is an orphan


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

TBASNT02 (Server) Thu May 28 08:32:28 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1090)

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

TBASNT02 (Server) Thu May 28 09:27:22 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
Data page 110565 (sequence 2624), line 0 is bad in table ASIENTOS (152)



TBASNT02 (Server) Thu May 28 09:27:24 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
Data page 47527 (sequence 757), line 0 is bad in table VREMLIN (260)



TBASNT02 (Server) Thu May 28 09:27:25 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) Thu May 28 09:27:25 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) Thu May 28 09:27:33 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
Page 47527 is an orphan


TBASNT02 (Server) Thu May 28 09:27:33 2009
Database: C:\ARCHIVOS DE PROGRAMA\EGMM-FB\GESTIÓN COMERCIAL\EMPRESAP\EMPRESAP.FDB
Page 110565 is an orphan



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