out of memory and 4GL hags
Posted in 1999
Hi Informixers
My situation looks like a mystery.
Maybe somebody crossed with the situation.
HP-UX 10.20, IDS 7.30 UC6, 4GL 7.20.UD4
In general the situation is very simple. When start a 4GL client
Informix server is going out of virtual shared memory and after that
client hags.
It's all except:
1. It has happened about once per two weeks and increasing
SHMVIRTSIZE doesn't increase a period between errors.
2. HP-UX has about 1.3 GB free shared memory. When Informix try to
add the segment in next times an engine doesn't have any error.
3. 4GL client doesn't consist any user input and hags forever without
any
error from an engine or 4GL side.
4. Changing type if connection (tcp/shm) doesn't help.
5. It isn't bug #84947.
How can I avoid the situation ?
Any idea any input will be very appreciated.
Eugene Nechayev
online.log
07:35:15 Checkpoint Completed: duration was 2 seconds.
07:38:48 dynamically allocated new shared memory segment (size 8388608)
07:38:48 out of virtual shared memory
07:42:42 Logical Log 10406 Complete.
onstat -g ses 351643
Informix Dynamic Server Version 7.30.UC6 -- On-Line -- Up 10 days
23:06:09 '
session #RSAM total used
id user tty pid hostname threads memory memory
351643 brokrage - 2506 yyzcohp 1 24576 21704
tid name rstcb flags curstk status
361143 sqlexec c2b1f784 Y--P--- 67560 c2b1f784 cond wait(sm_read)
Memory pools count 1
name class addr totalsize freesize #allocfrag #freefrag
351643 V c34d6018 24576 2872 241 1
name free used name free used
overhead 0 128 scb 0 96
opentable 0 280 filetable 0 280
log 0 2152 gentcb 0 8512
ostcb 0 2160 sqscb 0 6040
hashfiletab 0 280 osenv 0 1080
sqtcb 0 648 fragman 0 48
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
351643 - - - Not Wait 0 0 7.20
onstat -g sql 351643
Informix Dynamic Server Version 7.30.UC6 -- On-Line -- Up 10 days
23:06:09 --
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
351643 - - - Not Wait 0 0 7.20
onstat -g mem 351643
Informix Dynamic Server Version 7.30.UC6 -- On-Line -- Up 10 days
23:06:09 --
Pool Summary:
name class addr totalsize freesize #allocfrag #freefrag
351643 V c34d6018 24576 2872 241 1
Blkpool Summary:
name class addr size #blks
onstat -g stk 361143
Informix Dynamic Server Version 7.30.UC6 -- On-Line -- Up 10 days
23:06:10 --
Stack for thread: 361143 sqlexec
base: 0xc392e018
len: 69632
pc: 0x00000000
tos: 0xc392e830
state: cond wait
vp: 1
( 0 ) 0x364310 resume
( 1 ) 0x340d2b yield_processor_svp + 0x1f3 (0x576210 , 0x576160,
0xc383a1a0, 0x575fc8)
( 2 ) 0x344cd3 mt_wait + 0x15b (0x0 , 0xc32b24d0, 0x0, 0x20)
( 3 ) 0x381c03 recvshm+0x2dc + 0xf7 (0xc392e7d9 , 0xc392e7d9,
0xc392e7ee, 0xc392e7ee)
onconfig
# Shared Memory Parameters
LOCKS 120000 # Maximum number of locks
BUFFERS 8192 # Maximum number of shared buffers
NUMAIOVPS 2 # Number of IO vps
PHYSBUFF 64 # Physical log buffer size (Kbytes)
LOGBUFF 64 # Logical log buffer size (Kbytes)
LOGSMAX 230 # Maximum number of logical log files
CLEANERS 4 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 32000 # initial virtual shared memory segmentsize
SHMADD 8192 # Size of new shared memory segments
(Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes).
0=>unlimited
CKPTINTVL 600 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 20 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 10 # LRU percent dirty end cleaning limit
LTXHWM 45 # Long transaction high water markpercentage
LTXEHWM 50 # Long transaction high water mark
(exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 64 # Stack size (Kbytes)
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.