INET/inet_error: connect errno = 4

Hi,
I have multi-threaded application in C. When it starts, it tries to create simultanous connections to firebird running on the same machine. I am using firebird 1.5.1 on Redhat 9.

In some cases I get the following error:

2004-12-31 18:09:07: Error: -902(335544721) Unsuccessful execution caused by a system er
ror that precludes successful execution of subsequent statements.fbauth:connect_db, where 902 is the SQLCODE and 335544721 is the isc_status vector value.

Same error in the firebird log is shown as:
inventos.localdomain (Client) Fri Dec 31 18:09:07 2004
INET/inet_error: connect errno = 4

This happens only when multiple threads are trying to connect at the same time. When the number of simultaneous connections is high (around 15), I get these errors very frequently. But when I restricted the simultanous connections to 5 (using internla counters), I get only 1 or 2 errors only.

Any ideas what are these errors ? What is the root cause of the error?

I have written proper error trapping, which does the re-connections and recovers from the errors.

But when the server is running for a long time, it stops responding at all. Connection fails even when there is single connection request and I have to restart the firebird.

Any ideas??

JS

If you're running the classical server, you may want to modify your parameters in your firebird file of xinetd.d. Also note that performance is not as good.

If possible, use the SuperServer configuration. IBPhoenix.com has more information on this topic. See http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_ss_vs_classic .

Also, if you're using the C libraries with POSIX threads (I'm not sure if RedHat 9 has POSIX libraries), you may want to check what version of Firebird you're using. If so, install version 1.5.2.