cancel
Showing results for 
Search instead for 
Did you mean: 

informix crashed

SOLVED
Go to solution
Animesh Chakraborty
Honored Contributor

informix crashed

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

Did you take a backup?
7 REPLIES
Rainer von Bongartz
Honored Contributor

Re: informix crashed

Looks like you've got a semaphores problem

Please post first 100 lines of file
/informix/dump/af.8eff6d7
He's a real UNIX Man, sitting in his UNIX LAN making all his UNIX plans for nobody ...
Ravi_8
Honored Contributor

Re: informix crashed

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
never give up

Re: informix crashed

Is this the complete AF?
Win/Win
Animesh Chakraborty
Honored Contributor

Re: informix crashed

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

Thanks
Animesh
Did you take a backup?
Rainer von Bongartz
Honored Contributor

Re: informix crashed

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


He's a real UNIX Man, sitting in his UNIX LAN making all his UNIX plans for nobody ...
Animesh Chakraborty
Honored Contributor

Re: informix crashed

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


Thanks
Animesh
Did you take a backup?
Rainer von Bongartz
Honored Contributor
Solution

Re: informix crashed

you have to log-in into ITRC to assign..
He's a real UNIX Man, sitting in his UNIX LAN making all his UNIX plans for nobody ...