Strange error during concurrence of users
Posted in 2003
Hi to all
I have the next error in 4gl app: Error number -25588 The appl process
cannot connect to database server server-name.
$ finderr -25588-25588 The appl process cannot connect to the database server server-name.
An error in the application can produce this message. Check your
CONNECT statement and the sqlhosts file. A system failure can also
produce this message. If you can find no immediate cause for the
failure, note the circumstances and contact your database server
administrator for assistance.
The shared memory communication subsystem is down or not functioning.
Contact the database server administrator to report the problem.
This occurs at the 5th and next runs of the app... this app was running ok
at the old server since last saturday but it's not running ok at the new
server (10 or 15 times powerful!!!!)
Here I post some onconfig parameters that help us to help me.
# Shared Memory Parameters
LOCKS 100000 # Maximum number of locks
BUFFERS 192000 # Maximum number of shared buffers
NUMAIOVPS 2 # Number of IO vps
PHYSBUFF 96 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 100 # Maximum number of logical log files
CLEANERS 4 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 196608 # initial virtual shared memory segment size
SHMADD 65536 # Size of new shared memory segments
(Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 48 # 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 45 # Long transaction high water markpercentage
LTXEHWM 50 # Long transaction high water mark
(exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
NEW SERVER: SQLHOSTS
ids_dc onipcshm districn ids_dc_shm
ids_dc_net onsoctcp districn s_ids_dc
OLD SERVER: SQLHOSTS
workgroup onsoctcp distri sqlturbo
workgroup_shm onipcshm distri workgroup_shm
NEW SERVER: ANOTHER PIECE OF ONCONFIG FILE
DBSERVERNAME ids_dc # Name of default database server
DBSERVERALIASES ids_dc_net # List of alternate dbservernames
NETTYPE ipcshm,1,50,NET # Configure poll thread(s) for nettype
NETTYPE soctcp,1,60,CPU # Configure poll thread(s) for nettype
OLD SERVER: ANOTHER PIECE OF ONCONFIG FILE
DBSERVERNAME workgroup # Name of default database server
DBSERVERALIASES workgroup_shm # List of alternate dbservernames
NETTYPE soctcp,1,50,NET # Configure poll thread(s) for nettype
NETTYPE ipcshm,1,50,CPU # Configure poll thread(s) for netty
What's the difference between NET and CPU at NETTYPE configuration???
TIA.
DJMoralesM
dmorales@districenter.es
dmorales@condeminas.com
Telf. 93 264 3940
sending to informix-list