Re: help with assert failures
Floyd Wellershaus wrote:
> Hi,
> A client has an Informix instance version 9.40 UC4 running on
> sunfire -V440 running Solaris 9.
> Last week it crashed due to a bad external power supply. Ever since
> then they are periodically getting assert fails of what looks like 2
> types below:
>
> My problem is that they have no informix maintenance contract and
> don't want to use time and materials. So I'm asking if there are any
> ideas as to how I may figure out the cause and or try some things that
> may be a workaround.
> They say nothing has changed in the code or the OS, there is nothing
> showing in the OS messages.log. Onstats appear normal to me, nothing
> glaring. There doesn't appear to be any specific sql running at the
> different times of failures etc...
>
> Thanks for any advice.
> Floyd
>
>
> 1)
> ============================
> 16:25:01 Assert Failed: No Exception Handler
> 16:25:01 Who: Session(489, informix@vceb0a, 10471, 4c333f50)
> Thread(563, sqlexec, 4c30ddc0, 3)
> File: mtex.c Line: 431
> 16:25:01 Results: Exception Caught. Type: MT_EX_OS, Context: mem
> 16:25:01 Action: Please notify IBM Informix Technical Support.
> 16:25:01 Stack for thread: 563 sqlexec>
> base: 0x4e1a7000
> len: 69632
> pc: 0x0072073c
> tos: 0x4e1b6cc0
> state: running
> vp: 3
>
> 0x0071fb20 (oninit)afhandler(0xb90800, 0x9fd800, 0x4c00af60, 0x1,
> 0x601, 0x601)
> 0x0071f314 (oninit)afcrash_interface(0xafbae8, 0x4e1b7450, 0x4c00af60,
> 0xafbb00,
>
> 0x1af, 0x0)
> 0x00723c84 (oninit)mt_ex_throw_sig(0x9fc548, 0xaf8c78, 0xb91bb8,
> 0xafbabc, 0x4d7
>
> 4eea8, 0x0)
> 0x006f0770 (oninit)afsig_handler(0xa, 0x4e1b7a28, 0x4e1b7770, 0x0,
> 0x4e1b773b, 0
>
> x0)
> 0x007043cc (on init)free_pools(0x9fdc00, 0xac, 0xb90670, 0xb90670,
> 0x9fc51c, 0xff
>
> ffe0b8)
> 0x007029b0 (oninit)destroy_session(0x9fb400, 0xb82400, 0x9ff4b4,
> 0xb82528, 0x4db
>
> cb888, 0x4dbcb888)
> 0x003d86c0 (oninit)sq_exit (0xb92800, 0x0, 0x1c7, 0x1f, 0x1000, 0xb929d8)
> 0x003d3e5c (oninit)sqmain (0x38, 0xb92400, 0x9fb400, 0x1020,
> 0xb91a34, 0x1000)
> 0x00741ff8 (oninit)listen_verify(0xa2f288, 0xa, 0x9fb468, 0x0,
> 0x4caac4a8, 0xafe
>
> d04)
> 0x006fded8 (oninit)startup (0xb90bfc, 0x7, 0x4d74eea8, 0x4c00c8e0,
> 0xffffffff, 0
>
> x4c00c8a0)
> 0x00748824 (oninit)net_wait_for_io(0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
> 0x00000000 (*nosymtab*)0x0
>
>
> 16:25:01 See Also: /informix/logs/tmp/af.61b592c, shmem.61b592c.0>
> ===========================
>
> 2)
> ==================================
> 06:58:55 Assert Failed: No Exception Handler
> 06:58:55 Who: Session(61, informix@mailhost, -1, 4c3378f4)
> &nb sp; Thread(100, sqlexec, 4c30f620, 3)
> File: mtex.c Line: 431
> 06:58:55 Results: Exception Caught. Type: MT_EX_OS, Context: mem
> 06:58:55 Action: Please notify IBM Informix Technical Support.
> 06:58:55 Stack for thread: 100 sqlexec>
> base: 0x4cf84000
> len: 69632
> pc: 0x0072073c
> tos: 0x4cf93b80
> state: running
> vp: 3
>
> 0x0071fb20 (oninit)afhandler(0xb90800, 0x9fd800, 0x4c00af60, 0x1,
> 0x601, 0x601)
> 0x0071f314 (oninit)afcrash_interface(0xafbae8, 0x4cf94310, 0x4c00af60,
> 0xafbb00,
>
> 0x1af, 0x0)
> 0x00723c84 (oninit)mt_ex_throw_sig(0x9fc548, 0xaf8c78, 0xb91bb8,
> 0xafbabc, 0x4ce
>
> 8dd78, 0x0)
> 0x006f0770 (oninit)afsig_handler(0xa, 0x4cf948e8, 0x4cf94630, 0x0,
> 0x4d2ecfc8, 0
>
> x0)
> 0x0029ddfc (onini t)dup_ref_cmpseqs(0xa2dc00, 0x4cecb3a0, 0x0,
> 0x3467c, 0x4cecb3a
>
> 0, 0x4cffc668)
> 0x002958e4 (oninit)bldrefs (0x4cfbd030, 0x4d155540, 0xaba24c, 0x1,
> 0xa2eee0, 0xa
>
> 2dd14)
> 0x00357204 (oninit)maybe_bldrefs(0x4d1553a0, 0x0, 0x4d2e2020, 0x0,
> 0x4cecb2c0, 0
>
> x4cecb2e0)
> 0x00357024 (oninit)bldstructs(0xb92400, 0x20000, 0x1000, 0x10ca, 0x0,
> 0x4cf94b64
>
> )
> 0x00356d24 (oninit)sqcmd (0xb92400, 0xb927ec, 0x1, 0x4cf97018,
> 0x4d1553a0, 0x0
>
> )
> 0x00356930 (oninit)sq_cmnd (0xb92400, 0x0, 0x4d01a538, 0x6, 0x1000,
> 0xb929d8)
> 0x003d3e5c (oninit)sqmain (0x2, 0xb92400, 0x9fb400, 0x1020, 0xb91a34,
> 0x1000)
> 0x00741ff8 (oninit)listen_verify(0xa2f288, 0xa, 0x9fb468, 0x0,
> 0x4ce210c0, 0xafe
>
> d04)
> 0x006fded8 (oninit)startup (0xb90bfc, 0x7, 0x0, 0x4c00c8e0, 0x22,
> 0x4c00c8a0)
> 0x006f6974 (oninit)mt_poll_yield(0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
> 0x00000000 (*nosymtab*)0x0
> =================================
You ran onchecks after the crash right?
You have the install media right?
dbexport
re-install
dbimport