Assert Failed
Posted in 1999
Topics: Stored Procedures & SPL, Error Codes & Troubleshooting, Logging & Checkpoints
This is a multi-part message in MIME format.
------=_NextPart_000_0038_01BE5F58.F57B93B0
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0039_01BE5F58.F57D1A50"
------=_NextPart_001_0039_01BE5F58.F57D1A50
Content-Type: text/plain;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
We used Informix Workgroup Server v. 7.23 on Windows NT.
After execution of a stored procedure an Assert Failed occures and the =
Informix stopped .
Can someone help me to find the reason for this error?
I send the part of the online.log file and the af file.
15:28:51 Checkpoint Completed: duration was 0 seconds.
15:58:11 Assert Failed: Memory block header corruption detected in =
mt_shm_free 1
15:58:11 Who: Session(92, nikolai@hera, 2902, 0)
Thread(113, sqlexec, 0, 1)
15:58:11 Results: Unable to repair pool
15:58:11 Action: Please notify Informix Technical Support.
15:58:11 See Also: \\\\tmp/af.71b3f3, shmem.71b3f3.0
15:58:12 Assert Failed: Internal Error - Segmentation Violation
15:58:12 Who: Session(92, nikolai@hera, 2902, 0)
Thread(113, sqlexec, e1a4214, 1)
15:58:12 Results: OnLine must abort
15:58:12 Action: Reinitialize shared memory
15:58:12 See Also: \\\\tmp/af.71b3f3, shmem.71b3f3.1
15:59:28 Internal Error - Segmentation Violation
15:59:29 r:\\\\rsam\\\\rsinit.c, line 10151, thread 113, proc id 76, =
Segmentation Violation.
15:59:29 PANIC: Attempting to bring system down
Thanks in advance,
Carolina Yalamova
------=_NextPart_001_0039_01BE5F58.F57D1A50
Content-Type: text/html;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Dkoi8-r http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.71.1712.3"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>We used Informix Workgroup Server v. =
7.23 on=20
Windows NT.</FONT></DIV>
<DIV><FONT size=3D2>After execution of a stored procedure an Assert =
Failed occures=20
and the Informix stopped .</FONT></DIV>
<DIV><FONT size=3D2>Can someone help me to find the reason for this=20
error?</FONT></DIV>
<DIV><FONT size=3D2>I send the part of the online.log file and the af=20
file.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>15:28:51 Checkpoint =
Completed: =20
duration was 0 seconds.<BR>15:58:11 Assert Failed: Memory block =
header=20
corruption detected in mt_shm_free 1<BR>15:58:11 Who: =
Session(92,=20
nikolai@hera, 2902, 0)<BR> Thread(113, sqlexec, 0,=20
1)<BR>15:58:11 Results: Unable to repair=20
pool<BR>15:58:11 Action: Please notify Informix Technical=20
Support.<BR>15:58:11 See Also: \\\\tmp/af.71b3f3,=20
shmem.71b3f3.0<BR>15:58:12 Assert Failed: Internal Error - =
Segmentation=20
Violation<BR>15:58:12 Who: Session(92, nikolai@hera, 2902,=20
0)<BR> Thread(113, sqlexec, e1a4214, 1)<BR>15:58:12 =
Results:=20
OnLine must abort<BR>15:58:12 Action: Reinitialize shared=20
memory<BR>15:58:12 See Also: \\\\tmp/af.71b3f3,=20
shmem.71b3f3.1<BR>15:59:28 Internal Error - Segmentation=20
Violation<BR>15:59:29 r:\\\\rsam\\\\rsinit.c, line 10151, thread 113, =
proc id=20
76, Segmentation Violation.<BR>15:59:29 PANIC: Attempting to bring =
system=20
down</FONT> </DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Thanks in advance,</FONT></DIV>
<DIV><FONT size=3D2>Carolina Yalamova</FONT></DIV></BODY></HTML>
------=_NextPart_001_0039_01BE5F58.F57D1A50--
------=_NextPart_000_0038_01BE5F58.F57B93B0
Content-Type: application/octet-stream;
name="af.71b3f3"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="af.71b3f3"
15:58:11 Found during mt_shm_free 1
15:58:11 Pool '92' (0xe450014)
15:58:11 Bad block header 0xe5ed38c
blk-64
0e5ed34c: 00000000 00000000 09000000 00800000 ........ ........
0e5ed35c: 00000080 00000080 00000080 01000000 ........ ........
0e5ed36c: 00000000 45000000 00000000 00000000 ....E... ........
0e5ed37c: 00000000 00000000 00000000 00000000 ........ ........
blk+64
0e5ed38c: 00000000 00000000 8ccf5e0e 00040000 ........ ..^.....
0e5ed39c: 18abbd1c a0c75e0e 00000000 f4356a0e ......^. .....5j.
0e5ed3ac: 08366a0e 30366a0e 1c366a0e ffffffff .6j.06j. .6j.....
0e5ed3bc: 00000000 00000000 00000000 00000000 ........ ........
15:58:11 Found during recover_pool_bad_block 1
15:58:11 Pool '92' (0xe450014)
15:58:11 Bad block header 0xe5a0800
blk-64
0e5a07c0: 00000000 00000000 09000000 00800000 ........ ........
0e5a07d0: 00000080 00000080 00000080 01000000 ........ ........
0e5a07e0: 00000000 45000000 00000000 00000000 ....E... ........
0e5a07f0: 00000000 00000000 00000000 00000000 ........ ........
blk+64
0e5a0800: 00000000 00000000 00045a0e 00040000 ........ ..Z.....
0e5a0810: 0014b41c 14505a0e 00000000 f409660e .....PZ. ......f.
0e5a0820: 080a660e 300a660e 1c0a660e ffffffff ..f.0.f. ..f.....
0e5a0830: 00000000 00000000 00000000 00000000 ........ ........
15:58:11 Multiple block errors found
15:58:11
15:58:11 Assert Failed: Memory block header corruption detected in mt_shm_free 1
15:58:11 Who: Session(92, nikolai@hera, 2902, 0)
Thread(113, sqlexec, 0, 1)
15:58:11 Results: Unable to repair pool
15:58:11 Action: Please notify Informix Technical Support.
15:58:11 See Also: \\tmp/af.71b3f3, shmem.71b3f3.0
15:58:11 Stack for thread: 113 sqlexec
base: 0x0e51c014
len: 33280
pc: 0x00657655
tos: 0x0e523960
0x00657096 _mt_affail (0xe26afb0, 0xffffffff, 0xe450060, 0x779394)
0x0064ebec _recover_pool_bad_block(0xe523d98, 0x779394, 0xe2ebd18, 0x0)
0x0064d76f _mt_shm_free (0xe450014, 0xe5ed38c, 0x7790b4, 0xe5ec7a0)
0x0063139f _do_rhpfree (0xe450014, 0xe5ed3a0, 0x1, 0xe5e2710)
0x00631373 _rhpfree (0xe5ebba8, 0xe450014, 0xe524088, 0x4e4516)
0x004e4516 _releasesdb (0xe5ebba8, 0xe5e77e0, 0xe5e7800, 0x140ff8)
0x0046d527 _drpcurlist (0xe5e2710, 0xe5e7800, 0xe5e7540, 0xe54b05c)
0x0046f6e4 _clean_proc (0xe5e7800, 0x0, 0xe5e78a0, 0xe5dc9a0)
0x0046f5c1 _rmstproc (0xe5e7540, 0x1, 0x0, 0x4925e2)
0x0041a1dc _aud_sqdbclose (0x1, 0xe54b19c,