I've had several of these same crashes. The crash occurs every time I
reboot the OS. It happened on my new production box every time, never on my
development box. Same OS and IDS version, AIX 5.2 and IDS 9.40.FC1.
Upgraded to 9.40.FC2 and no more crashes.

The stack trace(see below) is always the same and it certainly wouldn't give
anyone a clue as to what is happening.

From the online log:

09:08:44 Physical Recovery Started at Page (2:7188).
09:08:45 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
09:08:45 Logical Recovery Started.
09:08:45 10 recovery worker threads will be started.
09:08:49 Logical Recovery has reached the transaction cleanup phase.
09:08:49 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

09:08:51 Dataskip is now OFF for all dbspaces
09:08:51 Checkpoint Completed: duration was 0 seconds.
09:08:51 Checkpoint loguniq 8, logpos 0xcc2018, timestamp: 14346806

09:08:51 Maximum server connections 0
09:08:51 On-Line Mode
09:08:51 Assert Failed: No Exception Handler
09:08:51 Informix Dynamic Server Version 9.40.FC1
09:08:51 Who: Session(1, informix@proddb, 0, 70000004037b028)
Thread(7, main_loop(), 700000040339028, 1)
File: mtex.c Line: 431
09:08:51 Results: Exception Caught. Type: MT_EX_OS, Context: mem
09:08:51 Action: Please notify Informix Technical Support.
09:08:51 stack trace for pid 426026 written to /var/crash/af.3ef2063
09:08:51 See Also: /var/crash/af.3ef2063, shmem.3ef2063.0,
/usr/informix/core
09:14:44 Error writing '/var/crash/shmem.3ef2063.0' errno = 28
09:14:46 The Master Daemon Died
09:14:47 PANIC: Attempting to bring system down
09:17:50 Informix Dynamic Server Started.


From the af file:

Stack for thread: 7 main_loop()
base: 0x0700000040dab000
len: 69632
pc: 0x000000010003bbe0
tos: 0x0000000110218140
state: running
vp: 3

0x0000000000000000 ***unknown***

Regards,
Bill Dare

> -----Original Message-----
> From: Michael Mueller [SMTP:michael.mueller01@kay-mueller.de]
> Sent: Thursday, July 31, 2003 11:13 AM
> To: dusong; informix-list@iiug.org
> Subject: Re: Informix 9.4 crash
>
> I really am interested in where you crash and therefor I am asking
> again: Can you send me the stack trace? You should find it at the
> beginning of file /tmp/af.3ef06ff. It looks something like this:
>
>
sending to informix-list