Subject Re: [firebird-support] Firebird freezes on RedHat Linux
Author Helen Borrie
At 12:28 AM 20/09/2005 +0000, you wrote:
>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)..

Look in firebird.log to see whether you have any network problems being
reported there. It looks as if something is crashing the server and
Guardian can't get it to come up again. "Something" might be anything,
e.g. hyperthreading active, or the processor affinity (CPUAffinityMask in
firebird.conf) having been set to something other than 1; or long-running
transactions that simply exhaust system resources; or a rogue UDF that is
crashing the server; or more connections than the host machine has
resources to handle; or leaking connections from wrong cleanup by your
applications; or a cron job that is trying to do a file-level backup on an
active database file; or ...(how long is a piece of string?)

Make sure that the database file is located on a hard disk that is
physically attached to the host machine, i.e. not accessed on a different
box through Samba, NFS, NIS, etc.

If you don't get a solution from this list, try posting a question to the
firebird-java list. Make sure you provide all the ennvironment details,
including the exact version of Jaybird you are using for the client --
including OS platform -- and how your application code is handling
attachments and detachments.