Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Angry Unanswered: listener-thread: err = -27001

    Hi,

    I have a problem with an application that runs for a very long time and makes serveral connections to the DB server during the execution. After more or less 24h of execution, and a lot of connections and queries performed, I obtain the error listener-thread: err = -27001 in the DB server and the application stops with identical error message.
    Any ideias of what could be wrong ?

    Informix IDS 2000 9.21 running on a W2K server with SP4. The server has 2 CPUs and 1GB RAM. The application is running on the same server.

    Thanks

    Fernando

    # IFMX Server LOG
    ....
    11:29:14 Fuzzy Checkpoint Completed: duration was 0 seconds, 6 buffers not flushed.
    11:29:14 Checkpoint loguniq 15056, logpos 0x9706c

    11:31:59 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt.

    11:54:14 Fuzzy Checkpoint Completed: duration was 0 seconds, 6 buffers not flushed.
    11:54:14 Checkpoint loguniq 15056, logpos 0x9a06c
    .....


    # Client application error log
    ERROR: System.Data.OleDb.OleDbException: XIX000:53oftware caused connection abort
    XIX000:-27001:Read error occurred during connection attempt.



    # Informix configurations


    NETTYPE soctcp,4,,NET # Override sqlhosts nettype parameters
    DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
    RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)
    MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
    NUMCPUVPS 2 # Number of user (cpu) vps
    SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one

    NOAGE 0 # Process aging
    AFF_SPROC 1 # Affinity start processor
    AFF_NPROCS 2 # Affinity number of processors

    # Shared Memory Parameters

    LOCKS 20000 # Maximum number of locks
    BUFFERS 100000 # Maximum number of shared buffers
    NUMAIOVPS # Number of IO vps
    PHYSBUFF 128 # Physical log buffer size (Kbytes)
    LOGBUFF 128 # Logical log buffer size (Kbytes)
    LOGSMAX 200 # Maximum number of logical log files
    CLEANERS 1 # Number of buffer cleaner processes
    SHMBASE 0xc000000 # Shared memory base address
    SHMVIRTSIZE 524288 # initial virtual shared memory segment size
    SHMADD 51200 # Size of new shared memory segments (Kbytes)
    SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    How many connections are established against the informix instance ? Also, what is the main method for connecting to the server (tcp/ip,shm...) ? Do you have only 1 NETTYPE line in your onconfig file ?

  3. #3
    Join Date
    Nov 2003
    Posts
    3
    Originally posted by rnealejr
    How many connections are established against the informix instance ? Also, what is the main method for connecting to the server (tcp/ip,shm...) ? Do you have only 1 NETTYPE line in your onconfig file ?
    The main method for connecting tcp/ip, and there is only one NETTYPE in onconfig. There may be a big number of connections to this instance, because there are other applications connecting to it (including a WEB based application).

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Monitor the connections being used and adjust your nettype settings. Also, change your vp class in your nettype from net to cpu.

Posting Permissions

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