Can I deduce that approx 450 devices make approx 450 inserts each per day?
Can I deduce that 200,000 inserts per day, maybe thru a peak 4 hour period =
830 inserts per hour / 14 per sec?

I'm not about to offer a solution - just want to put some perspective on it.

This doesn't seem a lot of traffic. I wouldn't, at first, be jumping on that
as the cause.

Can you tell us more about the client? Perhaps something about triggers and
stored procedures under this traffic?

Alan
-----Original Message-----
From: erg_sg [mailto:erg_sg@...]
Sent: Wednesday, 23 October 2002 18:11
To: ib-support@yahoogroups.com
Subject: [ib-support] Database Crash


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



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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