Hello,

my problem with freezing server is still actual. I done some mor
investigations and databases maintenance.

SYMPTOMS:
We use firebird 2.0.3 from gentoo repository as public database on small
hosting server. There is aprox. 150 web applications in php connecting to
firebird. We do not allow pconnect.
Sprox. every 15 hours server stops responding. It is not responding even
to TERM signal. It is in Sl state by ps (sleep multithreaded).
Before that event there is 60s 100% cpu utilization.

What was done:
gfix -v -full on all databases
gbak without -g on all databases
nbackup -B 0 on all databases

Please help me debug this problem. I really don't know what to do.
Is there way how to increase verbosity of logging?
Will coredump help anyone?

I cannot investigate all client code and i cannot modify it of course.

thx
pavol

gstat -h for most active database
Database header page information:
Flags 0
Checksum 12345
Generation 11194
Page size 1024
ODS version 11.0
Oldest transaction 1806
Oldest active 11174
Oldest snapshot 11174
Next transaction 11182
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Feb 24, 2008 17:40:09

Variable header data:
Database backup GUID: {1F510140-0830-E4BE-BFC5-8CE648CFEF45}
Sweep interval: 20000
*END*

firebird.log (previous message is 15h before there is no next message even
after 5 hours)

secundus (Client) Wed Mar 5 17:25:16 2008
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost
secundus (Client) Wed Mar 5 17:25:16 2008
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost
secundus (Client) Wed Mar 5 17:25:16 2008
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost
secundus (Client) Wed Mar 5 17:25:16 2008
INET/inet_error: read errno = 104
secundus (Client) Wed Mar 5 17:25:16 2008
INET/inet_error: send errno = 32
secundus (Client) Wed Mar 5 17:25:16 2008
INET/inet_error: send errno = 32
secundus (Client) Wed Mar 5 17:25:16 2008
INET/inet_error: send errno = 32
secundus (Client) Wed Mar 5 17:25:16 2008
INET/inet_error: send errno = 32
secundus (Client) Wed Mar 5 17:25:16 2008
INET/inet_error: send errno = 32
secundus (Client) Wed Mar 5 17:25:17 2008
INET/inet_error: read errno = 104
secundus (Client) Wed Mar 5 17:25:24 2008
INET/inet_error: connect errno = 111
secundus (Client) Wed Mar 5 17:25:24 2008
INET/inet_error: read errno = 104
secundus (Client) Wed Mar 5 17:25:30 2008
INET/inet_error: connect errno = 111
secundus (Client) Wed Mar 5 17:25:30 2008
INET/inet_error: connect errno = 111
secundus (Client) Wed Mar 5 17:25:30 2008
/usr/lib/firebird/../../../usr/bin/fbguard: guardian starting
../../../usr/bin/fbserver

SERVER KILLED AND RESTARTED

secundus (Client) Wed Mar 5 17:25:33 2008
INET/inet_error: read errno = 104
secundus (Client) Wed Mar 5 17:25:40 2008
INET/inet_error: read errno = 104
secundus (Client) Wed Mar 5 17:25:59 2008
INET/inet_error: read errno = 104