Pavol STAREK wrote:

> 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.

I presume you are running Superserver version?
What processor are you running on?

I have a problem with my own set-up where after time I 'loose the database',
but I'm running classic and fb_inet_server is not closing down some processes
so it gets to a point where I have to killall fb_inet_server and the sites are
working again!

Only difference to people who report that their systems are fine is that I'm
running AMD64 copies of Linux.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Firebird - http://www.firebirdsql.org/index.php