Hello:

I have an application with the following technical data:

Delphi 5 with IBX
FireBird 2.1.2.18118
Server: Windows 2003 Server
Clients: Windows XP

This has been working well for a couple of years but during the last couple of months it happened some times that suddenly no user can access one of the databases. My application accesses many databases and each user, when he opens the application, choses a database. The database with problems (apparently) is one of the databases that almost every user acceses everyday.

I copy some examples of lines of firebird.log of moments when this happened:

SERVERNAME (Server) Fri Jul 31 12:11:26 2009
Database: EMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)


SERVERNAME (Server) Thu Aug 06 16:46:31 2009
Database: EMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)


SERVERNAME (Server) Tue Aug 11 08:35:53 2009
Database: EMPRESA
internal gds software consistency check (decompression overran buffer (179), file: sqz.cpp line: 222)


If at that moment I try to open the database using IB_SQL, I get a message saying that it is not possible to connect to the database because there is another user accesing it.

The first times this happened I tried repairing the database with gfix, but I discovered that if do nothing with the database and I reset the server then everything works perfect again.

Another strange thing is that when this happens, if (before reseting the server) I open Services Manager and try to stop FireBird Service, it cannot stop. I see the little window saying "stopping" with the scroll bar but it never ends. The only solution is to reset the server and then everything works fine again.

Any idea of what may be causing this?

Thanks in advance

Gustavo

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