At 09:44 AM 28/07/2005 +0200, you wrote:

>Hi,
>in one of our apps Firebird 1.03 (SS) crashes in a regularly but
>unpredictable manner (on some systems once a month, on some other
>systems almost each day). The interbase.log file only contains the
>message "/opt/interbase/bin/ibguard: bin/ibserver terminated abnormally
>(-1)".
>
>Also several customers (each of it abroad) have the problem, we couldn't
>reproduce it, yet. Almost after each crash, the guardian process
>restarts the server.
>
>The databases have between 2GB and 3GB. About 500000 records will be
>inserted each day. The data insertion is done from a JBoss-Server via
>JDBC (Jaybird 1.5.4) on a RedHat 7.2 system (Double XEON)

I would be interested to know what filesystem the database file is located
on. If it is ext2 which, as I recall, is the default for a new RH 7.2
installation, then it's possibly encounteriing the 2 Gb file size limit
during periods when there is a lot of uncollected garbage.

./heLen