Subject | Firebird Hanging - Need suggestions ??? |
---|---|
Author | John B. Moore |
Post date | 2006-01-21T20:15:31Z |
I've had Firebird running non-stop on this machine for months..
Suddenly it is hanging, twice in the last several days.. (I define
hanging as the inablility to complete any connection)
Some basic background info..
===================
Firebird Version installed FirebirdSS-1.5.0.4290-0.i686.rpm
(Note: It is the ONLY application running on this machine.)
Redhat 9 (with last updates available)
Kernel: kernel-2.4.20-30.9.i686.rpm
Hardware
Processor: Intel P4 2.8 GHz
Memory: 1 Gig
Free Disk Space on Data Partition: 99 Gigs
Database Usage:
Databases: 14
Max users (based on max connections allowed to DB Pools): 70
Average Users (Based on Connections reported in DatabaseWorkbench): 55
=================
Obviously, I'm very concerned..<sigh>
Can anyone help me diagnose this problem.. What to check for..etc..
Have I hit some limit of databases or users..???
John..
===============
Log from last several days..
===================
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:09 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:09 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 10:26:44 2006
INET/inet_error: connect errno = 111
microps-185 (Client) Fri Jan 20 10:26:44 2006
/opt/firebird/bin/fbguard: guardian starting bin/fbserver
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:09 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:09 2006
INET/inet_error: receive in try_connect errno = 2
Suddenly it is hanging, twice in the last several days.. (I define
hanging as the inablility to complete any connection)
Some basic background info..
===================
Firebird Version installed FirebirdSS-1.5.0.4290-0.i686.rpm
(Note: It is the ONLY application running on this machine.)
Redhat 9 (with last updates available)
Kernel: kernel-2.4.20-30.9.i686.rpm
Hardware
Processor: Intel P4 2.8 GHz
Memory: 1 Gig
Free Disk Space on Data Partition: 99 Gigs
Database Usage:
Databases: 14
Max users (based on max connections allowed to DB Pools): 70
Average Users (Based on Connections reported in DatabaseWorkbench): 55
=================
Obviously, I'm very concerned..<sigh>
Can anyone help me diagnose this problem.. What to check for..etc..
Have I hit some limit of databases or users..???
John..
===============
Log from last several days..
===================
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:09 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 00:03:09 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Fri Jan 20 10:26:44 2006
INET/inet_error: connect errno = 111
microps-185 (Client) Fri Jan 20 10:26:44 2006
/opt/firebird/bin/fbguard: guardian starting bin/fbserver
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:00 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:09 2006
INET/inet_error: receive in try_connect errno = 2
microps-185 (Client) Sat Jan 21 00:03:09 2006
INET/inet_error: receive in try_connect errno = 2