dbTalk Databases Forums  

908: Attempt to connect to database server failed

comp.databases.informix comp.databases.informix


Discuss 908: Attempt to connect to database server failed in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
marcelo
 
Posts: n/a

Default 908: Attempt to connect to database server failed - 05-03-2011 , 07:51 AM






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.

Reply With Quote
  #2  
Old   
Jonathan Leffler
 
Posts: n/a

Default Re: 908: Attempt to connect to database server failed - 05-03-2011 , 09:22 AM






On Tue, May 3, 2011 at 05:51, marcelo <mcaluori (AT) gmail (DOT) com> wrote:

Quote:
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 <jonathan.leffler (AT) gmail (DOT) 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."

Reply With Quote
  #3  
Old   
Marco Greco
 
Posts: n/a

Default Re: 908: Attempt to connect to database server failed - 05-03-2011 , 09:35 AM



On 03/05/11 13:51, marcelo wrote:
Quote:
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
Informix-list (AT) iiug (DOT) 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.