topic Re: informix crashed in Operating System - HP-UX

informix crashed

Animesh Chakraborty — Tue, 17 Jul 2001 08:27:47 GMT

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

Re: informix crashed

Rainer von Bongartz — Tue, 17 Jul 2001 08:51:06 GMT

Looks like you've got a semaphores problem

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

Re: informix crashed

Ravi_8 — Tue, 17 Jul 2001 09:00:52 GMT

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

Re: informix crashed

Zafar A. Mohammed — Tue, 17 Jul 2001 19:53:47 GMT

Is this the complete AF?

Re: informix crashed

Animesh Chakraborty — Wed, 18 Jul 2001 00:21:25 GMT

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

Thanks
Animesh

Re: informix crashed

Rainer von Bongartz — Wed, 18 Jul 2001 06:06:07 GMT

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

Re: informix crashed

Animesh Chakraborty — Wed, 18 Jul 2001 08:34:10 GMT

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

Thanks
Animesh

Re: informix crashed

Rainer von Bongartz — Wed, 18 Jul 2001 09:04:33 GMT

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