this looks like good idea
But i have sweep set to default 20k and none of databases exceed that
interval.

Anyway this idea looks promising and i'll try to set sweeping on all
databases to 0

pavol

> 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]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>