it could be an index degeneration problem, after records are deleted,
try running a script to drop and recreate index.
[i had this kind of problem with pseudo-real time system (nearly 50
insert/s), table had only 1 index
based on 1 integer field ordered descending)]


erg_sg a écrit:

>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
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
>