Hi all:

our production db occasionally would encounter this error:

March 14

15:31:37 Assert Failed: No Exception Handler
15:31:37 Informix Dynamic Server 2000 Version 9.21.UC4
15:31:37 Who: Session(589965, a@b.c, 2484, 338115788)
Thread(743458, sqlexec, 1475c608, 1)
File: mtex.c Line: 405
15:31:37 Results: Exception Caught. Type: MT_EX_OS, Context: ill
15:31:37 Action: Action: %s
15:31:37 stack trace for pid 8877 written to /tmp/af.5c0a51d8
15:31:37 See Also: /tmp/af.5c0a51d8, shmem.5c0a51d8.0
15:33:14 mtex.c, line 405, thread 743458, proc id 8877, No Exception Handler.
15:33:15 The Master Daemon Died
15:33:23 PANIC: Attempting to bring system down

Oct 23

22:45:37 Assert Failed: No Exception Handler
22:45:37 Informix Dynamic Server 2000 Version 9.21.UC4
22:45:37 Who: Session(1330272, a@b.c, 1396, 345225848)
Thread(1365453, sqlexec, 180faf38, 1)
File: mtex.c Line: 405
22:45:37 Results: Exception Caught. Type: MT_EX_OS, Context: mem
22:45:37 Action: Please notify Informix Technical Support.
22:45:37 stack trace for pid 16531 written to /tmp/af.d9b5b610
22:45:37 See Also: /tmp/af.d9b5b610, shmem.d9b5b610.0
22:46:56 Error writing '/tmp/shmem.d9b5b610.0' errno = 28
22:46:56 mtex.c, line 405, thread 1365453, proc id 16531, No Exception Handler.
22:47:07 The Master Daemon Died
22:47:07 PANIC: Attempting to bring system down

Nov 13

15:43:37 Assert Failed: No Exception Handler
15:43:37 Informix Dynamic Server 2000 Version 9.21.UC4
15:43:37 Who: Session(142604, a@b.c, 1220, 377587412)
Thread(155548, sqlexec, 1679a4f8, 1)
File: mtex.c Line: 405
15:43:37 Results: Exception Caught. Type: MT_EX_OS, Context: mem
15:43:37 Action: Action: %s
15:43:37 stack trace for pid 9897 written to /tmp/af.638402a8
15:43:37 See Also: /tmp/af.638402a8, shmem.638402a8.0
15:45:09 mtex.c, line 405, thread 155548, proc id 9897, No Exception Handler.
15:45:17 The Master Daemon Died
15:45:17 The Master Daemon Died
15:45:17 Fatal error in ADM VP at mt.c:11462
15:45:17 Unexpected virtual processor termination, pid = 9901, exit = 0x100

15:45:17 PANIC: Attempting to bring system down

After the crash, we bring up the db again and it would work fine. It was suggested that the db might need to be patched. I am just wondering if anyone here can offer a second opinion.

Regards,

Mark

Please let me know another information such as sql , stack thread ...

When an Assert Failure occurs, it's best to call your local Tech Support Center.

15:43:37 See Also: /tmp/af.638402a8, shmem.638402a8.0


Provide them these files.

We used to have lots of those errors in windows NT.
It was due to the SHMBASE address in the onconfig.
It should be a function of the memory you have.
The rule for the NT was:
Physycal Memory x 1024 x 1024 = Phys. Mem. in bytes.
(Phys. Mem. in bytes / 2 ) * 4 = SHMBASE ( in decimal system ) , just change to hexadecimal system.

Example:
Phys Mem = 512 Mb
512*1024*1024 = 536870912
(536870912 /2 ) *4 =1073741824 to hex 0x40000000

thanks, i will give it a try if our server goes down again....
i checked the Informix admin guide, but it doesn't have a specific formula for this parameter.

since ours is run on redhat, does anyone have any suggestion on what formula it might have?