listener-thread err
Posted in 1998
HP-UX 10.20, OnLine 7.22.UC1X2
Throughout the day the engine will temporarily hang up, there will be
zero ISAM calls. No one can do anything with Informix. This condition
will last anywhere from a few seconds to several minutes. Afterwards
when the engine begins to respond again the log file contains several
lines like the following:
13:36:41 listener-thread: err = -25587: Network receive failed.
finderr 25587:
A system call has failed. Perform a DISCONNECT, and then check the
status of the server. See your UNIX system administrator for
assistance.
Tech support said that there must be a problem with our network. I have
confirmed with HP tech support that there are absolutely no problems
with the network or the OS. The tech from Informix suggested the
following change to the onconfig file:
from -- NETTYPE soctcp,1,100,CPU
to -- NETTYPE soctcp,2,100,CPU
this made the problem infinitely worse.
Has anyone else seen this? What does it indicate? The error message
points to the UNIX box, but that is not the problem...
TIA;
Scott
onconfig file:
#***********************************************************************
***
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.std
# Description: INFORMIX-OnLine Configuration Parameters
#
#***********************************************************************
***
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /dev/rootspace # Path for device containing rootdbspace
ROOTOFFSET 0 # Offset of root dbspace into device
(Kbytes)
ROOTSIZE 565248 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 1 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirroredroot
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS plogspace # Location (dbspace) of physical log
PHYSFILE 360342 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 76 # Number of logical log files
LOGSIZE 500 # Logical log size (Kbytes)
# Diagnostics
MSGPATH /ard/logfiles/online.log # System message log file path
CONSOLE /dev/console # System console message pathALARMPROGRAM /ard/informix/log_full.sh # Alarm program path
# System Archive Tape Device
TAPEDEV /dev/tape # Tape device path
TAPEBLK 64 # Tape block size (Kbytes)
TAPESIZE 16777216 # Maximum amount of data to put on tape
(Kbytes)
# Log Archive Tape Device
LTAPEDEV /dev/tape # Log tape device path
LTAPEBLK 64 # Log tape block size (Kbytes)
LTAPESIZE 16777216 # Max amount of data to put on log tape
(Kbytes)
# Optical
STAGEBLOB # INFORMIX-OnLine/Optical staging area
# System Configuration
SERVERNUM 1 # Unique id corresponding to a OnLineinstance
DBSERVERNAME elsouth # Name of default database server
DBSERVERALIASES online1 # List of alternate dbservernames
NETTYPE ipcshm,2,100,NET # Configure poll thread(s) for nettype
NETTYPE soctcp,1,100,CPU # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed env.
RESIDENT 1 # Forced residency flag (Yes = 1, No =
0)
MULTIPROCESSOR 0 # 0 for single-processor, 1 formulti-processor
NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vpsto one
NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 80000 # Maximum number of locks
BUFFERS 40000 # Maximum number of shared buffers
NUMAIOVPS 1 # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 96 # Maximum number of logical log files
CLEANERS 8 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 64000 # initial virtual shared memory segmentsize
SHMADD 32000 # Size of new shared memory segments
(Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes).
0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 30 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 20 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water markpercentage
LTXEHWM 60 # Long transaction high water mark
(exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
# System Page Size
# BUFFSIZE - OnLine no longer supports this configuration parameter.
# To determine the page size used by OnLine on your platform
# see the last line of output from the command, 'onstat -b'.
# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline
restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.
OFF_RECVRY_THREADS 20 # Default number of offline workerthreads
ON_RECVRY_THREADS 1 # Default number of online workerthreads
# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO 0 # DR automatic switchover
DRINTERVAL 30 # DR max time between DR buffer flushes
(in sec)
DRTIMEOUT 30 # DR network timeout (in sec)DRLOSTFOUND /ard/informix/etc/dr.lostfound # DR lost+found file path
# Backup/Restore variables
BAR_ACT_LOG /tmp/bar_act.log
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
# Read Ahead Variables
RA_PAGES 4 # Number of pages to attempt to readahead
RA_THRESHOLD 2 # Number of pages left before next group
# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine system is brought online. If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.
DBSPACETEMP