Subject Re: Update: CPU Pegged on Firebird v2
Author josef_gschwendtner
--- In, "Gary Benade" <gary@...>
> >Yes, I've considered it, but I know this is not the case.
> >threads running the same query post their data just fine. Even
> >it is slow, because a previous thread has caused the deadlock
> Sorry to keep hammering on about this, but that sounds like garbage
collection. The thread that triggers the GC process is kept busy and
will not return results until the process is done, any subsequent
threads will run just fine, although obviously slower due to the
server workload of the GC thread.
> Could you let us know what your sweep interval is set to and post
your header page stats.
> Regards
> Gary

Do you have an entry "Deadlock" in Firebird.log?

We also face sometimes such a freezed server and we get
this "Deadlock"-Entry in the logfile.

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