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

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

Post by abdoel » Fri, 08 Oct 2004 15:34:13


urrent 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, XXXX@XXXXX.COM , 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, XXXX@XXXXX.COM , 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
 
 
 

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

Post by rkusene » Fri, 08 Oct 2004 17:33:29


Is there a deep nested level calling of stored procedures. Try increasing
STACKSIZE to 320 or more.

 
 
 

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

Post by Simmons, K » Fri, 08 Oct 2004 17:41:46


Abdul

As requested, call support

Keith

-> -----Original Message-----
-> From: XXXX@XXXXX.COM [mailto: XXXX@XXXXX.COM ]
-> Sent: Thursday, October 07, 2004 7:34 AM
-> To: XXXX@XXXXX.COM
-> Subject: Error -9791 when execute routine (procedure) - pls asap.....
->=20
->=20
-> Current Environment:
-> IDS9.40.FC4, O/S: AIX4.3
->=20
-> Dear folks
->=20
-> 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 =20
-> 10:15:10 Who: Session(40492, XXXX@XXXXX.COM , 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=20
-> /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 --=20
-> procname=3D<Lr01spl>
-> procid=3D430
-> reason: mem
-> 10:15:14 Assert Failed: No Exception Handler
-> 10:15:14 IBM Informix Dynamic Server Version 9.40.FC4 =20
-> 10:15:14 Who: Session(40492, XXXX@XXXXX.COM , 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=20
-> /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=20
-> Exception
-> Handler.
-> 10:15:16 Fatal error in ADM VP at mt.c:12298
-> 10:15:16 Unexpected virtual processor termination, pid =3D=20
-> 274566, exit
-> =3D 0x100
->=20
-> 10:15:16 PANIC: Attempting to bring system down
-> 10:29:52 IBM Informix Dynamic Server Started
-> #############################################################
<SNIP>
-> You're help in this case would be greatly appreciated...!!!!
-> Rgds
-> Abdul
->=20


***************************************************************************=
*******
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
***************************************************************************=
*******

sending to informix-list
 
 
 

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

Post by dryburgh » Fri, 08 Oct 2004 22:05:33

o 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


XXXX@XXXXX.COM (abdoell) wrote in message news:< XXXX@XXXXX.COM >...
 
 
 

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

Post by Claus Samu » Sat, 09 Oct 2004 02:01:18


Is this supported? I thought IDS 9.40.FC4 was only released for AIX 5.2
and 5.3
 
 
 

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

Post by abdoel » Sat, 09 Oct 2004 10:04:31

i All,
Deep appreaciated for your kind response,
I'll try to increase STACKSIZE as recommended on this post to me.
Beside that, you're right, this IDS running on AIX 5.3, instead of AIX 4.3

Will you know the result once i have change stacksize.

Kind regards..!

"Simmons, Keith" < XXXX@XXXXX.COM > wrote in message news:<ck3k0n$t01$ XXXX@XXXXX.COM >...