Any pointers as how to solved this intermittant probelm would be appreciated.

Setup:

Server: Windows XP SP3, 2Gb Ram, FB 2.5 Superserver.
Ws: Windows XP SP3, 256Mb Ram, FBClient supplied with 2.5
Server and WS connected via crossover network cable.
Software developed in use Deplhi 2010 using DBX.
Database size 1.5 Gb.

Problem: About once in every 2 months I get DB corruptions, the log look like this.


SERVER (Server) Fri Jan 14 07:43:48 2011
INET/inet_error: read errno = 10054
SERVER (Server) Fri Jan 14 07:43:48 2011
INET/inet_error: read errno = 10054
SERVER (Client) Fri Jan 14 08:23:31 2011
INET/inet_error: send errno = 10054
SERVER (Client) Fri Jan 14 08:23:31 2011
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost
SERVER (Client) Fri Jan 14 08:23:31 2011
INET/inet_error: send errno = 10054
SERVER (Client) Fri Jan 14 08:23:31 2011
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost
SERVER (Client) Fri Jan 14 08:27:09 2011
Guardian starting: "C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe"
SERVER (Server) Fri Jan 14 12:59:19 2011
INET/inet_error: read errno = 10054
SERVER (Server) Fri Jan 14 12:59:19 2011
INET/inet_error: read errno = 10054
SERVER (Client) Sat Jan 15 05:55:27 2011
Guardian starting: "C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe"
SERVER (Server) Sat Jan 15 07:00:05 2011
Database: C:\INFOSTAR\ACCOUNTING\DATA\TRAUMEREI_SPITSKOP.IS5
internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 224)

I know 10054 relates to a network error. I have changed the HDD on the server and the NIC on both pc's. The same software configuration runs 100% at 30 other sites. Most of then have more transactions and users. The problem only started after I switch the site over to FB 2.5.

Any help will be appreciated.

Regards




Cornie van Schoor
InfoStar Software