informix crashed

[Animesh Chakraborty]

Hi,
Our informix dynamic server crashed with folling error in log file:
16:19:31 Checkpoint Completed:duration was 6 seconds.
16:19:39 Logical Log 316223 Complete.
16:20:08 Logical Log 316224 Complete.
16:20:41 Logical Log 316225 Complete.
16:21:42 Logical Log 316226 Complete.
16:23:20 Logical Log 316227 Complete.
16:24:41 Checkpoint Completed: duration was 7 seconds.
16:25:02 Logical Log 316228 Complete.
16:26:20 Logical Log 316229 Complete.
16:27:04 Assert Failed: semop: errno = 34

16:27:04 Assert Failed: semop: errno = 34

16:27:04 Informix Dynamic Server Version 7.31.FC6X7
16:27:04 Informix Dynamic Server Version 7.31.FC6X7
16:27:04 Who: Session(2, informix@, 0, 0)
Thread(8, sm_poll, 0, 1)
File: mt.c Line: 1158
16:27:04 Who: Session(463, sapr3@ctxap4, 1061, 778472240)
Thread(1287, sqlexec, c00000002e650aa0, 4)
File: mt.c Line: 1158
16:27:04 stack trace for pid 2740 written to /informix/dump/af.3f0f6d7
16:27:04 stack trace for pid 2744 written to /informix/dump/af.8eff6d7
16:27:04 See Also: /informix/dump/af.8eff6d7, shmem.8eff6d7.0
16:27:04 Exception Recursion while handling: MT_EX_OS, Context: ill
16:27:04 PANIC: Attempting to bring system down
16:40:33 Segment locked: addr=0x239000, size=775356416
16:40:42 Segment locked: addr=0x2e5a9000, size=1073741824

Any help
Thanks
Animesh

[Rainer von Bongartz]

Looks like you've got a semaphores problem

Please post first 100 lines of file
/informix/dump/af.8eff6d7

[Ravi_8]

Hi,
I havn't worked on Informix but from my experience on Orcale and DB2 i can say this.
Since the transactions are recorded in log files(check point completed as shown in your log file)if you have the backup of control and datafiles still you can recover.

later
ravi

[Zafar A. Mohammed]

Is this the complete AF?

[Animesh Chakraborty]

hi,
I have attached /informix/dump/af.8eff6d7
for your reference.

Thanks
Animesh

[Rainer von Bongartz]

Animesh,

Ok, this looks like the documented Defect 109257 from INFORMIX and was reported in several 7.3x releases
(7.31.UC5 , 7.30.UC10 7.31.UD1N88)

check with INFORMIX for a release with a fix to 109257

[Animesh Chakraborty]

Hi all ,
Thanks for the responses.
But on my browser "assign points" is not highlighted..so unable to assign points.


Thanks
Animesh

[Rainer von Bongartz · Accepted solution]

you have to log-in into ITRC to assign..