Re: listener-thread err
In article <6d4go9$3rs$1@news.xmission.com>, Scott Black
<sblack@elsouth.com> writes
>
>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
>
since this is on a NET VP try
onstat -g glo
to get the process id of the VP.
Then do
truss -aef -v all -o /tmp/1 -p <process-id>
until the problem occurs.
Then do
grep Err /tmp/1
and you should see which system call is failing...
>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 root>dbspace
>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 mirrored>root
>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 path>ALARMPROGRAM /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 OnLine>instance
>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 in>distributed env.
>RESIDENT 1 # Forced residency flag (Yes = 1, No =
>0)
>
>MULTIPROCESSOR 0 # 0 for single-processor, 1 for>multi-processor
>NUMCPUVPS 1 # Number of user (cpu) vps
>SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vps>to 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 segment>size
>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 mark>percentage
>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 worker>threads
>ON_RECVRY_THREADS 1 # Default number of online worker>threads
>
># 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>BA