Subject Re: [firebird-support] Re: Processes under Classic server?
Author Sándor Tamás
Well, the server is Windows, where we can see processes. Under Linux, we always can see multiple processes, even with Super Server.
The FB server is 1.5 classic. We connect to it through BDE, not ODBC. Can be the problem that BDE not always closes its connection?

----- Original Message -----
From: lysander_fb
Sent: Friday, August 05, 2005 9:43 AM
Subject: [firebird-support] Re: Processes under Classic server?

--- In, Sándor Tamás <san_ta@v...> wrote:

> Is there any possibility to work these problems around?

Which server system, windows?

I also have "problems" with multiple zombie-processes which do not
seem to get terminated correctly. However, I do not have a problem as
such, because the same users/clients will use the same connection
again next time they connect, even if it is 4 days later.
I do not have any lock-conflicts because of this.

Our server has sufficient RAM for all clients (40) to connect to all
databases on the server (5). So this thing just makes me nervous, but
it is not a real problem.

In _my_ case, the reason could be some connections to the databases
with old software while other - more modern - software is connecting
to the same database, from the same client, using the same ODBC-DSN.

If you installed on windows, check that in the firebird.conf on the
serverroot\bin directory there is an explicit "WITHGUARDIANOPTION =
0". The installation package is installing the guardian, although it
is not needed for classic server. And this prevents processes from
being terminated.

In our case the situation became much better after this change.



Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Yahoo! Groups Links

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