各位老大，看看我的informix咋的了！

cjt

Message Log File: /home/informix/ontjtest.log
09:23:55  Informix Dynamic Server Initialized -- Shared Memory Initialized.
09:23:55  Physical Recovery Started.
09:23:56  Physical Recovery Complete: 96 Pages Restored.
09:23:56  Logical Recovery Started.
09:24:00  Logical Recovery Complete.
        56 Committed, 3 Rolled Back, 0 Open, 0 Bad Locks

09:24:01  Dataskip is now OFF for all dbspaces
09:24:02  On-Line Mode
09:24:06  Checkpoint Completed:  duration was 5 seconds.
09:29:08  Checkpoint Completed:  duration was 0 seconds.
09:34:11  Checkpoint Completed:  duration was 0 seconds.
09:39:14  Checkpoint Completed:  duration was 0 seconds.
09:41:29  Assert Failed: No Exception Handler
09:41:30  Informix Dynamic Server Version 7.31.UC7
09:41:30   Who: Session(19, informix@948e02c0, -1, 558394520)
                Thread(67, sqlexec, 21460754, 1)
                File: mtex.c Line: 446
09:41:30   Results: Exception Caught. Type: MT_EX_OS, Context: mem
09:41:30   Action: Please notify Informix Technical Support.

shenwu

你看看你的Buffers是否过大？可以改小一点再启试试！

cjt

谢谢版主指教！

我这是台测试服务器，正常使用时掉过电！

xjfirst

一般情况下是应用出现了问题，上次出现这个问题是因为查询的条件中有一个month(inputdate) = month(today - 1)。用这个条件对一个拥有30万数据的表做求和操作时，出现了这个问题。