IDS Forum

Re: System Or Internal Error InterruptedIOExceptio

Posted By: Martin Fuerderer
Date: Wednesday, 17 September 2014, at 6:31 a.m.

In Response To: Re: System Or Internal Error InterruptedIOExceptio (NATYURAL HORACIO)

Hi,

in your Informix Server environment you can do:

% finderr 25582
-25582 Network connection is broken.

The connection terminated because the network is down, the database server
is offline, or the client is offline. If you receive this error on a
client,
check the network connection, and the database server. If you receive this
error on the database server, check the network connection, and the
client.

% finderr 27001
-27001 Read error occurred during connection attempt.

This error can occur on either the client or database server side.

When you encounter this error on the client side, it indicates that a
network I/O error occurred when the client tried to connect to a
database server. Probably the connection attempt timed out because the
database server or the network was very busy, too many clients were
attempting to connect to the database server simultaneously, or the
database server was taken off-line during the connection attempt.

If you are using IBM Informix Dynamic Server, IBM Informix Universal
Server,
or IBM Informix OnLine Dynamic Server, verify that the database server is
still online. If you are using IBM Informix SE, verify that the sqlexecd
daemon
for the database server is still running. Use either or both of the
environment
variables INFORMIXCONTIME and INFORMIXCONRETRY on the client side to
increase
the connection time and number of retry attempts.

When you encounter this error on the database server side, it is a
warning that a network I/O error is detected while the database server
is accepting a connection request from a client. This error usually
occurs when the database server or the network is very busy or when too
many clients are trying to connect to the database server at once. The
database server might be taking so long to respond to a client that the
client's connection request timed out before the connection is
complete. Or possibly a client terminated its connection attempt before
the connection is completely established.

If this error is seen only occasionally in the server message log, it
is just a warning. No corrective action is required on the server
side.

If this error occurs frequently on a database server that runs on a
host with multiple processors, you might want to tune the database
server by increasing the number of poll threads and/or listener
threads.

%

The output from the "finderr" command should give you some ideas
where to start looking.

Regards, Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

Read about the Informix Warehouse Accelerator:
http://tinyurl.com/the-iwa-blog

IBM Deutschland Research & Development GmbH
Chairman of the Supervisory Board: Martina Koederitz
Board of Management: Dirk Wittkopp
Corporate Seat: Boeblingen, Germany
Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294

From: "NATYURAL HORACIO" <horacio.natyural@gmail.com>
To: ids@iiug.org,
Date: 09/17/2014 12:08
Subject: Re: System Or Internal Error InterruptedIOExceptio [33797]
Sent by: ids-bounces@iiug.org

Hi,

In the informix online logs we are seeing the following errors:

Informix

Listener err - 25582
Listener err - 27001

What can I do to check these errors ?

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• System Or Internal Error InterruptedIOException
  NATYURAL HORACIO -- Tuesday, 16 September 2014, at 6:48 a.m.
  • Re: System Or Internal Error InterruptedIOExceptio
    Art Kagel -- Tuesday, 16 September 2014, at 7:16 a.m.
    • Re: System Or Internal Error InterruptedIOExceptio
      NATYURAL HORACIO -- Tuesday, 16 September 2014, at 10:35 a.m.
      • Re: System Or Internal Error InterruptedIOExceptio
        Marcus Haarmann -- Tuesday, 16 September 2014, at 11:03 a.m.
        • Re: System Or Internal Error InterruptedIOExceptio
          NATYURAL HORACIO -- Wednesday, 17 September 2014, at 6:04 a.m.
          • Re: System Or Internal Error InterruptedIOExceptio
            Martin Fuerderer -- Wednesday, 17 September 2014, at 6:31 a.m.
          • Re: System Or Internal Error InterruptedIOExceptio
            Fernando Nunes -- Wednesday, 17 September 2014, at 8:41 a.m.
            • Re: System Or Internal Error InterruptedIOExceptio
              NATYURAL HORACIO -- Wednesday, 17 September 2014, at 12:26 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.