Hi



We never use automatic sweep, from time to time (month to year) we do backup
and restore.

There were always problems with Sweep interval > 0

so our our default setting is 0.



Database sizes are from 3 to 15 GB, 100 � 300 tables, >1500 stored
procedures ...



users from 5 to 200. 1000 to 100000 transactions per day.





Regards Bogdan





From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Pavol STAREK
Sent: Wednesday, March 05, 2008 9:51 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Server is freezing every 15 hours



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*




No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.21.5/1314 - Release Date: 5.3.2008
18:38



[Non-text portions of this message have been removed]