Hello,

I am using Interbase 6 as a persistent storage to store event
information from devices in a real time system. There are about 20
tables in the database out of which only one table has an high
traffic of inserts (from the devices concurrently). The number of
devices vary from 300-600 and the number of records inserted into the
table for one day is approx 200,000 rows. The records are backed up
and records deleted every night.

The database crashes under peak load. The database cannot be fixed
using gfix. The crash is not confiend the to table having the
inserts. The crash occurs in various tables, sometimes affecting the
system tables like RDB$INDEX too. Given below is the environment
under which the Interbase runs

Environment :
Interbase Server Version : WI-V6.0.1.0
Platform : WIN NT4, SP6
Client : IBPP C++ Classes Ver. 0.9
Network Connectivity : TCP/IP. Server running under localhost as
clients.

Given below are the dump from Interbase.log file during the time the
database experienced the crash :

SBSERVER (Client) <Time>
INET/inet_error: send errno = 10053

SBSERVER (Client) <Time>
INET/inet_error: read errno = 10054

SBSERVER (Server) <Time>
Database: C:\CSC\DATABASE\CSC.GDB
internal gds software consistency check (attempt to release free
block (154))

SBSERVER (Server) <Time>
Database: C:\CSC\DATABASE\CSC.GDB
I/O error for file "C:\CSC\DATABASE\CSC.GDB"
Error while trying to read from file
Reached end of file.

SBSERVER (Server) <Time>
Database: C:\CSC\DATABASE\CSC.GDB
lock conflict on no wait transaction
internal gds software consistency check (cannot find record back
version (291))

I have some questions regarding this issue :

1. Are there any tools available to help find out the cause of the
crash?
2. What are the possible causes for errors based on the Interbase log
dump provided?

Any help is appreciated.
Thanks