Subject Re: [firebird-support] How can I increase the number of concurrent connections on FB Classic?
Author Helen Borrie
At 03:52 PM 30/10/2005 -0800, you wrote:
>Hi,
>
> I am using Firebird Classic 1.5.2 on RedHat Linux in
>a distributed environment, with multiple machines
>accessing a Firebird database via JDBC.
>
> As the number of machines on the network increase,
>so do the number of active connections to the database
>(each machine ends up with about 3-6 connections to
>the database). When the total connection count (as
>indicated by the fb_inet_server process) reaches
>around 60, I start seeing failures making additional
>connections. The error I get is:
>
>SQL state [HY000]; error code [335544421]; Resource
>Exception. connection rejected by remote interface,
>error code: HY000
>
> The firebird.log file contains entries that look
>like:
>
>localhost.localdomain Sun Oct 30 23:49:21 2005
> INET/inet_error: read errno = 104
>
> I cannot see any configuration parameters in
>firebird.conf that would address this. How can I
>increase the limit of concurrent connections?

If it's a configuration issue, it's not a matter of Firebird configuration,
but of configuring xinetd, the daemon that supervises the server's
interface with the outside world. This may help:

http://linux.about.com/od/commands/l/blcmdl5_xinetd.htm

There is also a parameter in xinetd's firebird script that you can
configure to extend the maximum number of instances connected. This sets
the maximum specifically for the Firebird instances, regardless of the
settings in xinetd.conf. I think it's called "MaxInstances" or something
along those lines and I think its default setting is 30 (unless it's
commented out; in which case, the max will be the Instances setting in
xinetd.conf, probably "UNLIMITED".

It's possibly not a configuration issue but that the host machine simply
has insufficient resources to allow any further connections. How come you
are allowing such a large number of connections per client machine? This
is a very uneconomical way to use server resources with Classic....RAM is
not a bottomless bucket.

./heLen