informix老宕,求助各位大侠

seanliu

Wed Jun 29 15:09:44 2005

15:09:44  Event alarms enabled.  ALARMPROG = '/usr/users/informix/etc/log_full.sh'
15:09:44  rsinit: Can not open /dev/sysdev0, not reading time from kernel memory.
15:09:44  Timer_vp: Can not open /dev/sysdev0, not reading time from kernel memory
15:09:49  DR: DRAUTO is 0 (Off)
15:09:49  Warning: Number of poll threads for nettype soctcp has already reached the maximum (50).  Poll threads which exceed the maximum number will not be started.

15:09:54  Informix Dynamic Server Version 7.31.FC5    Software Serial Number AAC#J456981
15:09:55  dynamically allocated new shared memory segment (size 838860

15:09:56  Informix Dynamic Server Initialized -- Shared Memory Initialized.
15:09:56  Physical Recovery Started.
15:09:56  Physical Recovery Complete: 64 Pages Restored.
15:09:56  Logical Recovery Started.
15:09:59  Logical Recovery Complete.
        18 Committed, 2 Rolled Back, 0 Open, 0 Bad Locks

15:10:00  Dataskip is now OFF for all dbspaces
15:10:00  On-Line Mode
15:10:00  Checkpoint Completed:  duration was 0 seconds.
15:15:29  Checkpoint Completed:  duration was 0 seconds.
15:17:24  Assert Failed: No Exception Handler
15:17:24  Informix Dynamic Server Version 7.31.FC5   
15:17:24   Who: Session(101, informix@wf, 1720, 587794264)
                Thread(136, sqlexec, 22305f1d8, 1)
                File: mtex.c Line: 446
15:17:24   Results: Exception Caught. Type: MT_EX_OS, Context: mem
15:17:24   Action: Please notify Informix Technical Support.
15:17:31   See Also: /tmp/af.4704b04, shmem.4704b04.0
15:18:17  mtex.c, line 446, thread 136, proc id 11896, No Exception Handler.
15:18:19  PANIC: Attempting to bring system down
15:18:19  semctl: errno = 22

15:20:03  Requested shared memory segment size rounded from 8000KB to 8192KB

这是online.log 中的,请各位大侠看看,为什么数据库老宕呀.

zzjijun

断言失败没什么好看的了，买了IBM的服务的就打电话吧。
没买的话，查查线程136这个时候有没有在执行什么操作，有的话改写相关的SQL或者oncheck检查相关的表。