Discussion:
908: Attempt to connect to database server failed
(too old to reply)
marcelo
2011-05-03 12:51:15 UTC
Permalink
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
2011-05-03 14:22:07 UTC
Permalink
Post by 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.
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 <***@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
2011-05-03 14:35:53 UTC
Permalink
Post by 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.
_______________________________________________
Informix-list mailing list
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
c***@gmail.com
2015-08-28 21:34:15 UTC
Permalink
Post by 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.
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,

Loading...