RE: IDS 7.3UC2 on SCO Unixware Version 7.01 Hangs everyday

Hello Al: I had problem very similar to yours with a site on DEC-UX and IDS 7.30. I solved it with 7.31. Pablo F. Herrero Gijon (SPAIN) -----Mensaje original----- De: Al Wilson [mailto:allan.wilson@versaterm.com] Enviado el: mi'rcoles 26 de enero de 2000 18:45 Para: comp.databases.informix@list.deja.com Asunto: Re: IDS 7.3UC2 on SCO Unixware Version 7.01 Hangs everyday We have several sites on UXW 7.0.1 and IDS 7.30.UC2. I would be very interested in knowing more information on both of your ONCONFIG settings and Unixware 7.0.1 patch levels. Specifically, NETTYPE, NUMCPUVPS and typical number of users connected to the database. We had 2 sites running with no problems (150 and 200 users), a third site went live in September and gets an Assert Failure every 5 to 21 days. It has more users and volume, but runs the same application. No luck from Informix Tech Support. We have tuned a lot of parameters, but with no success. Most suggestions have come from us and not Informix. We have just experience the same assert failure at one of the first sites (once in 9 months), so this helps rule out some of the OS and Hardware questions we had in the back of our minds. A fourth site went live late November and is experiencing sporatic system hangs. UXW is up and running, but performance on existing IDS connections degrades and no new connections are allowed. Onstat commands are available, but cannot execute onmode, etc. My next course of action is to apply 7.30.UC10 (recently available on UXW 7.0.1), keep pushing Informix Tech Support and continue to try to isolate the cause myself. Any other suggestions??? Thanks, Allan Wilson allan.wilson@versaterm.com online.log 10:45:00 Who: Session(32804, someone@whatever, 11205, 0) Thread(36117, sqlexec, 0, 3) File: mtex.c Line: 314 10:45:00 Results: Exception Caught. Type: MT_EX_OS, Context: mem stack #Stack Trace for p1, Program rpt_view.er #*[0] _syscall(0x2, 0x636, 0xbff4170c, 0x1, 0xbff42e08) [0xbffc92df] # [1] _semop(0x636, 0xbff4170c, 0x1) [0xbffe2c21] # [2] buf_wait(0x81b4be8, 0, 0) [0xbff34483] # [3] recvshm(0x81bb718, 0x81bb568, 0x81b59ec) [0xbff33a63] # [4] tlRecv(0x81b59ec, 0x81bb568) [0xbff2d649] # [5] slSQIrecv(presumed: 0x81b59ec, 0x8036f38, 0x8036fa4) [0xbff2b38c] # [6] pfRecv(0x81b59ec, 0x8036fc4) [0xbff25e26] # [7] asfRecv(0x81b59ec, 0x81b581c, 0x8036fc0) [0xbff1533d] # [8] ASF_Call(0x81b5660, 0x8036fc0) [0xbff17368] # [9] asf_recv(0x81b5640) [0xbfeb683d] # [10] _iread(presumed: 0x803706e, 0x2, 0x81b5640) [0xbfeb6904] # [11] _igetint(presumed: 0x81b5640, 0x819a658, 0xbff84054) [0xbfeb54cb] # [12] _sqr_messages(0x81d749c, 0, 0x819a658) [0xbff64ac3] # [13] _sqexecute(presumed: 0x81d749c, 0x81b9490, 0) [0xbff58c1b] # [14] sqli_exec(presumed: 0x1, 0x81d749c, 0x81b9490) [0xbff587e7] # [15] ?(0x80c9436, 0x81b9490, 0) [0x80a5c50] # [16] ?() [0x80a33c3] Note: Looking at the stack, we have focused our search primarily on Informix BUFFERS (and other related settings) and Unixware semaphore/ shared memory settings (and UXW patches). #************************************************************************** # # Informix Dynamic Server Configuration Parameters # # # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace nameROOTPATH /IFX_DEVICES/raw01 ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 50000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS logspace # Location (dbspace) of physical log PHYSFILE 10000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 56 # Number of logical log files LOGSIZE 4000 # Logical log size (Kbytes) # Diagnostics MSGPATH /usr2/informix/online.log # System message log file path CONSOLE /dev/null # System console message path ALARMPROGRAM /usr2/informix/etc/log_full.sh # Alarm program pathSYSALARMPROGRAM /usr2/informix/etc/evidence.sh # System Alarm program path TBLSPACE_STATS 1 # System Archive Tape Device TAPEDEV /dev/rmt/ntape3 TAPEBLK 16 # Tape block size (Kbytes) TAPESIZE 15000000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/rmt/ntape2 LTAPEBLK 16 # Log tape block size (Kbytes) LTAPESIZE 15000000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server/Optical staging area # System Configuration SERVERNUM 3 # Unique id corresponding to a DynamicServer in stance DBSERVERNAME ifx # Name of default database server DBSERVERALIASES ifxtcp # List of alternate dbservernames DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) NETTYPE ipcshm,1,500,CPU NETTYPE tlitcp,1,200,NET MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor NUMCPUVPS 3 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps toone NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 50000 # Maximum number of locks BUFFERS 150000 # Maximum number of shared buffers NUMAIOVPS 14 # Number of IO vps PHYSBUFF 256 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 100 # Maximum number of logical log files CLEANERS 16 # Number of buffer cleaner processes SHMBASE 0xa000000L # Shared memory base address SHMVIRTSIZE 262144 SHMADD 65536 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 600 # Check point interval (in sec) LRUS 64 # Number of LRU queues LRU_MAX_DIRTY 2 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit LTXHWM 40 # Long transaction high water markpercentage LTXEHWM 50 # Long transaction high water mark (exclusive) TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 32 # Stack