SQLERR -25580, ISAM -54
Kurt Van Gompel reported users disconnected with error -25580, ISAM -54 and asked the session timeout. Alexandre Marini said there is no default timeout and such errors point to the network. Art Kagel said errno 54 usually means connection reset, from an engine bounce, idle-session task or onmode -z. The ISP had added a connection timeout. Solved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello, Since a few days now, we regularly hear from users that their are disconnected from the database with error -25580, isam -54. Does anyone now what is the timeout after which Informix disconnects a session? Thanks in advance!!
Hi, there is no default timeout for sessions, unless you specify a method of disconnecting idle sessions intenally in IBM Informix. You did not mention what version you are, so we cannot tell you if this feature is available for your box. Errors 25580, 27001 are best related to external network services interrupted, than to Informix engine directly. Hope it helps. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Certified Developer - Informix Genero BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: kvangompel@caami-hziv.fgov.be > Subject: SQLERR -25580, ISAM -54 [36438] > Date: Fri, 22 Jan 2016 08:17:24 -0500 > > Hello, > > Since a few days now, we regularly hear from users that their are disconnected > from the database with error -25580, isam -54. > Does anyone now what is the timeout after which Informix disconnects a > session? > Thanks in advance!! > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Kurt:
Version and platform are always helpful.
On most platforms (but not all) errno 54 is "Connection reset by peer"
which would indicate that Informix disconnected the user's session. That
could be for several reasons, some obvious:
1. The engine bounced.
2. You have an idle session task running that disconnected it.
3. Someone ran an onmode -z for that session.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Fri, Jan 22, 2016 at 8:17 AM, KURT VAN GOMPEL <
kvangompel@caami-hziv.fgov.be> wrote:
> Hello,
>
> Since a few days now, we regularly hear from users that their are
> disconnected
> from the database with error -25580, isam -54.
> Does anyone now what is the timeout after which Informix disconnects a
> session?
> Thanks in advance!!
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1141c1e027cc5f0529ec2eef
Hi, We found out that our internet service provider had configured a connection timeout recently without telling us. That's why our users were disconnected after some idle time. Thanks for your responses!!!