Error -9791 when execute routine (procedure) - pls asap.....

Current Environment: IDS9.40.FC4, O/S: AIX4.3 Dear folks I got a problem, When SPL(Stored Procedure Language) program is performed from 4gl or PowerBuilder program, an error occured, In this case, Informix system is going to DOWN. here is the log: #################################################################### 10:15:10 Assert Failed: Exception Caught. Type: MT_EX_OS, Context:mem 10:15:10 IBM Informix Dynamic Server Version 9.40.FC4 10:15:10 Who: Session(40492, larry@152.202.30.10, 3852,700000070400068) Thread(53579, sqlexec, 7000000703c6488, 3) File: mtex.c Line: 377 10:15:10 Action: Please notify IBM Informix Technical Support. 10:15:10 stack trace for pid 274566 written to /IDS0/dumb/af.d533c85c 10:15:10 See Also: /IDS0/dumb/af.d533c85c 10:15:12 Exception Caught. Type: MT_EX_OS, Context: mem 10:15:12 (-9791): ERROR: Routine execution trap -- procname=<Lr01spl> procid=430 reason: mem 10:15:14 Assert Failed: No Exception Handler 10:15:14 IBM Informix Dynamic Server Version 9.40.FC4 10:15:14 Who: Session(40492, larry@152.202.30.10, 3852,700000070400068) Thread(53579, sqlexec, 7000000703c6488, 3) File: mtex.c Line: 431 10:15:14 Results: Exception Caught. Type: MT_EX_OS, Context: mem 10:15:14 Action: Please notify IBM Informix Technical Support. 10:15:14 stack trace for pid 274566 written to /IDS0/dumb/af.d533c85c 10:15:14 See Also: /IDS0/dumb/af.d533c85c 10:15:16 mtex.c, line 431, thread 53579, proc id 274566, No Exception Handler. 10:15:16 Fatal error in ADM VP at mt.c:12298 10:15:16 Unexpected virtual processor termination, pid = 274566, exit = 0x100 10:15:16 PANIC: Attempting to bring system down 10:29:52 IBM Informix Dynamic Server Started ############################################################# HERE is the onconfig file: ############################################################################# ROOTNAME rootdbs # Root dbspace nameROOTPATH /IDS0/dev/rootdbsm # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 500000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirroredroot MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS rootdbs # Location (dbspace) of physical log PHYSFILE 30000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 40 # Number of logical log files LOGSIZE 40000 # Logical log size (Kbytes) # Diagnostics MSGPATH /IDS0/logs/online.log # System message log file path CONSOLE /dev/console # System console message path # To automatically backup logical logs, edit alarmprogram.sh and set # BACKUPLOGS=Y ALARMPROGRAM /IDS0/etc/no_log.sh # Alarm program path TBLSPACE_STATS 1 # Maintain tblspace statistics # System Archive Tape Device TAPEDEV /dev/rmt0 # Tape device path TAPEBLK 16 # Tape block size (Kbytes) TAPESIZE 40000000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/rmt0 # Log tape device path LTAPEBLK 16 # Log tape block size (Kbytes) LTAPESIZE 40000000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server staging area # System Configuration SERVERNUM 1 # Unique id corresponding to a OnLineinstance DBSERVERNAME post_shm # Name of default database server DBSERVERALIASES # List of alternate dbservernames NETTYPE soctcp,2,150,CPU # Configure poll thread(s) fornettype NETTYPE ipcshm,1,50,NET # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor NUMCPUVPS 2 # Number of user (cpu) vps SINGLE_CPU_VP 0 # 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 800000 # Maximum number of locks BUFFERS 300000 # Maximum number of shared buffers NUMAIOVPS 3 # Number of IO vps PHYSBUFF 64 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes) CLEANERS 22 # Number of buffer cleaner processes SHMBASE 0x700000010000000 # Shared memory base address SHMVIRTSIZE 81920 # initial virtual shared memorysegment size SHMADD 8192 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 300 # Check point interval (in sec) LRUS 32 # Number of LRU queues LRU_MAX_DIRTY 20.000000 # LRU percent dirty begin cleaninglimit LRU_MIN_DIRTY 10.000000 # LRU percent dirty end cleaning limit TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 64 # Dynamic Logging # DYNAMIC_LOGS: # 2 : server automatically add a new logical log when necessary. (ON) # 1 : notify DBA to add new logical logs when necessary. (ON) # 0 : cannot add logical log on the fly. (OFF) # # When dynamic logging is on, we can have higher values for LTXHWM/LTXEHWM, # because the server can add new logical logs during long transaction rollback. # However, to limit the number of new logical logs being added, LTXHWM/LTXEHWM # can be set to smaller values. # # If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values # to avoid long transaction rollback hanging the server due to lack of logical # log space, i.e. 50/60 or lower. DYNAMIC_LOGS 0 LTXHWM 40 LTXEHWM 50 # 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 10 # Default number of offline workerthreads ON_RECVRY_THREADS 1 # Default number of online workerthreads @@

"abdoell" <abdoell@yahoo.com> wrote in message news:e05e140c.0410062234.5e3d27b5@posting.google.com... > Current Environment: > IDS9.40.FC4, O/S: AIX4.3 > > Dear folks > > I got a problem, When SPL(Stored Procedure Language) program is > performed from 4gl or PowerBuilder program, an error occured, In this > case, Informix system is going to DOWN. > here is the log: > STACKSIZE 64 Is there a deep nested level calling of stored procedures. Try increasing STACKSIZE to 320 or more.

do you have "nested" stored procedures? If so , I reckon this is a known problem. Contact your support provider If its what I think it is it should be fixed in FC5 abdoell@yahoo.com (abdoell) wrote in message news:<e05e140c.0410062234.5e3d27b5@posting.google.com>... > Current Environment: > IDS9.40.FC4, O/S: AIX4.3 > > Dear folks > > I got a problem, When SPL(Stored Procedure Language) program is > performed from 4gl or PowerBuilder program, an error occured, In this > case, Informix system is going to DOWN. > here is the log: > #################################################################### > 10:15:10 Assert Failed: Exception Caught. Type: MT_EX_OS, Context:> mem > 10:15:10 IBM Informix Dynamic Server Version 9.40.FC4 > 10:15:10 Who: Session(40492, larry@152.202.30.10, 3852,> 700000070400068) > Thread(53579, sqlexec, 7000000703c6488, 3) > File: mtex.c Line: 377 > 10:15:10 Action: Please notify IBM Informix Technical Support. > 10:15:10 stack trace for pid 274566 written to /IDS0/dumb/af.d533c85c > 10:15:10 See Also: /IDS0/dumb/af.d533c85c > 10:15:12 Exception Caught. Type: MT_EX_OS, Context: mem > 10:15:12 (-9791): ERROR: Routine execution trap -- procname=<Lr01spl> > procid=430 > reason: mem > 10:15:14 Assert Failed: No Exception Handler > 10:15:14 IBM Informix Dynamic Server Version 9.40.FC4 > 10:15:14 Who: Session(40492, larry@152.202.30.10, 3852,> 700000070400068) > Thread(53579, sqlexec, 7000000703c6488, 3) > File: mtex.c Line: 431 > 10:15:14 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 10:15:14 Action: Please notify IBM Informix Technical Support. > 10:15:14 stack trace for pid 274566 written to /IDS0/dumb/af.d533c85c > 10:15:14 See Also: /IDS0/dumb/af.d533c85c > 10:15:16 mtex.c, line 431, thread 53579, proc id 274566, No Exception > Handler. > 10:15:16 Fatal error in ADM VP at mt.c:12298 > 10:15:16 Unexpected virtual processor termination, pid = 274566, exit > = 0x100 > > 10:15:16 PANIC: Attempting to bring system down > 10:29:52 IBM Informix Dynamic Server Started > #############################################################> > HERE is the onconfig file: > ############################################################################# > ROOTNAME rootdbs # Root dbspace name> ROOTPATH /IDS0/dev/rootdbsm # Path for device containing root > dbspace > ROOTOFFSET 0 # Offset of root dbspace into device > (Kbytes) > ROOTSIZE 500000 # 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 rootdbs # Location (dbspace) of physical log > PHYSFILE 30000 # Physical log file size (Kbytes)> > # Logical Log Configuration > > LOGFILES 40 # Number of logical log files > LOGSIZE 40000 # Logical log size (Kbytes)> > # Diagnostics > > MSGPATH /IDS0/logs/online.log > # System message log file path > CONSOLE /dev/console # System console message path> > # To automatically backup logical logs, edit alarmprogram.sh and set > # BACKUPLOGS=Y > ALARMPROGRAM /IDS0/etc/no_log.sh # Alarm program path > TBLSPACE_STATS 1 # Maintain tblspace statistics> > # System Archive Tape Device > > TAPEDEV /dev/rmt0 # Tape device path > TAPEBLK 16 # Tape block size (Kbytes) > TAPESIZE 40000000 # Maximum amount of data to put on > tape (Kbytes)> > # Log Archive Tape Device > > LTAPEDEV /dev/rmt0 # Log tape device path > LTAPEBLK 16 # Log tape block size (Kbytes) > LTAPESIZE 40000000 # Max amount of data to put on log > tape (Kbytes)> > # Optical > > STAGEBLOB # Informix Dynamic Server staging area > > # System Configuration > > SERVERNUM 1 # Unique id corresponding to a OnLine> instance > DBSERVERNAME post_shm # Name of default database server > DBSERVERALIASES # List of alternate dbservernames > NETTYPE soctcp,2,150,CPU # Configure poll thread(s) for> nettype > NETTYPE ipcshm,1,50,NET # Configure poll thread(s) for nettype > DEADLOCK_TIMEOUT 60 # Max time to wait of lock in> distributed env. > RESIDENT 0 # Forced residency flag (Yes = 1, No = > 0) > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for> multi-processor > NUMCPUVPS 2 # Number of user (cpu) vps > SINGLE_CPU_VP 0 # 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 800000 # Maximum number of locks > BUFFERS 300000 # Maximum number of shared buffers > NUMAIOVPS 3 # Number of IO vps > PHYSBUFF 64 # Physical log buffer size (Kbytes) > LOGBUFF 32 # Logical log buffer size (Kbytes) > CLEANERS 22 # Number of buffer cleaner processes > SHMBASE 0x700000010000000 # Shared memory base address > SHMVIRTSIZE 81920 # initial virtual shared memory> segment size > SHMADD 8192 # Size of new shared memory segments > (Kbytes) > SHMTOTAL 0 # Total shared memory (Kbytes). > 0=>unlimited > CKPTINTVL 300 # Check point interval (in sec) > LRUS 32 # Number of LRU queues > LRU_MAX_DIRTY 20.000000 # LRU percent dirty begin cleaning> limit > LRU_MIN_DIRTY 10.000000 # LRU percent dirty end cleaning limit > TXTIMEOUT 0x12c # Transaction timeout (in sec) > STACKSIZE 64> > # Dynamic Logging > # DYNAMIC_LOGS: > # 2 : server automatically add a new logical log when necessary. > (ON) > # 1 : notify DBA to add new logical logs when necessary. (ON) > # 0 : cannot add logical log on the fly. (OFF) > # > # When dynamic logging is on, we can have higher values for > LTXHWM/LTXEHWM, > # because the server can add new logical logs during long transaction > rollback. > # However, to limit the number of new logical logs being added, > LTXHWM/LTXEHWM > # can be set to smaller values. > # > # If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller > values > # to avoid long transaction rollback hanging the server due to lack of > logical > # log space, i.e. 50/60 or lower. > > DYNAMIC_LOGS 0 > LTXHWM 40 > LTXEHWM 50> > # System Page Size > # BUFFSIZE -

abdoell wrote: > Current Environment: > IDS9.40.FC4, O/S: AIX4.3 > Is this supported? I thought IDS 9.40.FC4 was only released for AIX 5.2 and 5.3