908: Attempt to connect to database server failed

[marcelo]

When I work with INFORMIXSERVER configured via onipcshm DBSERVERNAME
everything works OK. When setting via onsoctcp after a period of time
the database locked and does not allow more connections giving the
error
908: Attempt to connect to database server (ifxdatabase_tcp) failed.
ISAM error: record is locked.

[Jonathan Leffler]

It doesn't for me...

If we're going to be able to help you, we're going to need to know the version of IDS and the platform on which it is running.

The error is not a common one, which has me somewhat puzzled.

*  Have you looked at the sessions running ('onstat -u') when you start getting those errors?
*  Which API are you connecting with (ESQL/C, ODBC, JDBC, something else)?
*  Are you connecting from the local machine or a remote machine?

--
Jonathan Leffler <jonathan...@gmail.com>  #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be amused."

[Marco Greco]

> _______________________________________________
> Informix-list mailing list
> Inform...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>

There was a time when operating system errors where well below 100, which is
the number at which Informix errors start.
Sadly these days most POSIX OS have error numbers well into the several
hundreds - What I think is happening is that the OS is returning error 107 to
the client trying to connect and this is picking up, in error, the message for
an Informix message as opposed to the OS.

Depending on the OS inspect /usr/include/errno.h or /usr/include/sys/errno.h
or even /usr/include/asm/errno.h, and look for the meaning of the 107 returned
by the Operating System: once we know that, we might be able to help. I had a
quick look at Solaris 9 and AIX 5.3 and 107 is undefined - hence OS
information would be appreciated too.
--
Ciao,
Marco
______________________________________________________________________________
Marco Greco /UK /IBM Standard disclaimers apply!

Structured Query Scripting Language http://www.4glworks.com/sqsl.htm
4glworks http://www.4glworks.com
Informix on Linux http://www.4glworks.com/ifmxlinux.htm

[ceo....@gmail.com]

Hi,

I'm curious did you ever figure this error out? I am running into the same error trying to test the db connectivity.

Thanks,