we don't use UDF's nor Events
Backup is done each day
there is no antivirus program runing
there should be enough space for temp-file (2GB)
we don't know what the server is doing during the crash, because its
kind of a 24/7 system.

The database is around 2GB (at the moment). 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 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-machine:
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.


--- In firebird-support@yahoogroups.com, Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:

> In general, Firebird shouldn't crash. I think the most common

causes

> when it happens will be hardware fault or faulty UDFs (of which
> Firebird does not have control).
>
> I have no experience with Firebird crashing, and - excepting Ann
> Harrison who fixed InterBase databases for a living - I think very

few

> have much experience with it (some will have experienced it, but

it's

> the first time I've heard anyone say 'crashes regularly').
>
> So, a few questions:
>
> Does the Firebird server use UDFs?
> Does the Firebird server use events?
> How is backup done?
> Does any antivirus program run on databases (I doubt this should

make

> the server crash)?
> Are there enough free space available for Firebirds temporary files?
> What's the Firebird server doing when it crashes (is it during

night

> when only gbak is doing it's stuff or does it happen when doing

some

> particular SQL statements)?
>
> Many of these questions may be irrelevant, but the people with

enough

> knowledge to pinpoint your problem is better at ignoring excessive
> information than to guess required information.
>
> HTH,
> Set
>
> --- In firebird-support@yahoogroups.com, "Josef Gschwendtner" wrote:
> > Hi,
> >
> > one of our firebird servers (Firebird 1.03 on a Redhat 7.2 system

at

> > a customer site) crashes regularly, and the coredump shows the
> > following lines:
> >
> > Core was generated by '/opt/interbase/bin/ibserver'.
> > Program terminated with signal 11, Segmentation fault.
> > #0 0x08083d9a in local_fini () at eval.c:41
> >
> > Output to /opt/interbase/interbase.log:
> > /opt/interbase/bin/ibguard: bin/ibserver terminated abnormally (-

1)

> >
> > What could we do to chase down this problem?
> > Does anybody have any experiance with that?
> > Is it a Firebird 1.03 problem?
> >
> > Thank you for your help,
> > Josef Gschwendtner