Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Location
    Madrid
    Posts
    14

    Angry Unanswered: Informix error code -27001

    Hello,

    I receive en my message log un error such 2 minutes,listed as below :

    -----------------------------------------------------------------------
    16:51:18 listener-thread: err = -27001: oserr = 0: errstr = : Read
    error occurred during connection attempt.
    16:49:18 listener-thread: err = -25582: oserr = 9: errstr = :
    Network connection is broken. System error = 9.

    16:47:18 listener-thread: err = -27001: oserr = 0: errstr = : Read
    error occurred during connection attempt.

    --------------------------------------------------------------
    En my sqlhosts file i have this information :

    mydbserver ontlitcp myhost 1525
    mydbalias onipcshm myhost 1526
    -------------------------------------------------------------
    En my onconfig file i have :

    DBSERVERNAME mydbserver
    DBSERVERALIASES mydbalias
    NETTYPE tlitcp,2,400,NET
    NETTYPE ipcshm,1,20,cpu
    -------------------------------------------------------------------
    and my number of connections is <= 100 connections
    ===> it is not a problem of POLLTHREAD and LISNERTHREAD.

    WHERE IS THE PROBLEM ?

    Thanks.

  2. #2
    Join Date
    May 2004
    Location
    Barcelona, Spain
    Posts
    54

    Output from finderr

    Output from "finderr 25582"

    -25582 Network connection is broken.

    This error might indicate that the database server has terminated, or a
    problem might exist on the network itself. Check that the network is
    functioning and that the server is still running.



    Output from "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.

  3. #3
    Join Date
    Jun 2004
    Location
    Madrid
    Posts
    14

    Smile

    Thanks for the detail of the error -27001.I know it.
    But we haven't I/O network error.

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    Please change the following and test.
    In SQLHOSTS file:
    mydbserver ontlitcp myhost 1525
    mydbalias onipcshm myhost 1526
    For
    mydbalias ontlitcp myhost 1525
    mydbserver onipcshm myhost mydbserver ########

    In ONCONFIG file
    DBSERVERNAME mydbserver
    DBSERVERALIASES mydbalias

    The connection by ipc does not need I number on services file.
    I suggest it to him connection of "ipc" is by CPU.

    Gustavo.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •