Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Posts
    98

    Unanswered: Informix Server error

    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

  2. #2
    Join Date
    Mar 2002
    Posts
    112

    re

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

  3. #3
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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.
    rws

  4. #4
    Join Date
    Oct 2002
    Posts
    52

    Re: Informix Server error

    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

  5. #5
    Join Date
    Nov 2002
    Posts
    98
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •