Hi,

yesterday, I asked for help with a problem we have with random server
crashes (Firebird 1.03 (SS) on Redhad 7.2) we couldn't reproduce, yet.
Thank you for your replys so far, but we are still searching for a
solution.

Is there a possibility (with Firebird 1.03) to get more information
about the situation leading to the problem (debug build, core dump, log
information)?

Is it possible to compile a statically linked Firebird 1.52 and let it
run on RedHat 7.2? (because we think there is a chance, that Firebird
1.5.2 could solve the problem)


Any help is much appreciated,
Josef Gschwendtner



More infos about the problem:
=============================
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)".

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)

The system is kind of a 24/7 system. The data of one special table is
needed only 30 days, so we delete older data periodically (400000
records --> GC is very busy); otherwise the database is getting to
large.

Infos about the server:
=======================
Linux version 2.4.20-28.7smp
Filesystem: EXT3 FS 2.4-0.9.19
Mount: EXT3-fs: mounted filesystem with ordered data mode.
The 64-bit file I/O version of Firebird is installed.
we don't use external function libraries.

We tried to compile a statically linked Firebird 1.52 on a Suse 9.2
machine and to run it on RedHat 7.2. The statically linked Firebird
1.5.2-4731 actually refuses to link "libfbintl.so" due to a missing
"main" needed in /usr/lib/crt1.o on our Suse 9.2 machine.