Subject Firebird freezes on RedHat Linux
Author aiylam_s
I am having severe problems with Firebird on RedHat Linux. Here are
the steps I followed:

I first installed "FirebirdSS-". Using this, my
application (which runs on multiple boxes and uses the JDBC driver)
runs for about 18-24 hours, after which Firebird hangs. Everything
hangs, including isql, which times out after a long time during the
connect with the error:

Statement failed, SQLCODE = -902
Unable to complete network request to host "localhost".
-Failed to establish a connection.

I then tried the NPTL version "FirebirdSS-",
since I read posts that indicated this would fix the problem.
However, this made the problem even worse - my application hangs in
the first 15 minutes with the same symptoms.

I am using RedHat with the 2.6 Kernel (I believe this uses NPTL).
The output of cat/proc on my system yields:

Linux version (root@linux745) (gcc version 3.2.3 20030502
(Red Hat Linux 3.2.3-24)) #16 SMP Fri Sep 10 12:57:04 EDT 2004

Are there any logs that I can look at which will help locate the
problem? I am wondering if building Firebird from the sources on the
same hardware that it runs on will help - how can I build a new RPM
from scratch? (I am a Linux newbie)..