Subject Firebird process takes 100% of one CPU core
Author rizekj@crs-net.cz
Hi to all, we have a problem with the application running on Apache 2 +
PHP + Firebird 2.0.0.12748.
Sometimes, it happens that one of the Firebird process takes 100% of one
CPU core and after that Firebird doesn’t accept any other connection and
we must kill the FB process manually. We have tested it with FB 1.5, CS,
SS and there occurs this problem too. The interval between these events is
shorter when the database goes bigger (at this time is about 600MB). Our
web site has about 200 hit/sec in its peak and this generates about 2000
simple db queries per sec.
Does anybody know what can cause this situation?

Jiri