informix高手请进(急急急急急急)

圣诞老人

informix的版本是online7.10
操作系统是:sco5.0.6
服务器:hpserver
online.log文件的内容是:
18:25:54  Quiescent Mode
18:25:58  Checkpoint Completed:  duration was 4 seconds.
18:26:14  On-Line Mode
18:31:00  Checkpoint Completed:  duration was 0 seconds.
18:46:09  Checkpoint Completed:  duration was 0 seconds.
19:01:18  Checkpoint Completed:  duration was 0 seconds.
19:16:26  Checkpoint Completed:  duration was 0 seconds.
19:31:35  Checkpoint Completed:  duration was 0 seconds.
19:46:42  Checkpoint Completed:  duration was 0 seconds.
20:01:51  Checkpoint Completed:  duration was 0 seconds.
20:17:00  Checkpoint Completed:  duration was 0 seconds.
20:32:09  Checkpoint Completed:  duration was 0 seconds.
20:47:17  Checkpoint Completed:  duration was 0 seconds.
21:02:25  Checkpoint Completed:  duration was 0 seconds.
21:17:34  Checkpoint Completed:  duration was 0 seconds.
21:30:34  Logical Log 701 Complete.
21:32:43  Checkpoint Completed:  duration was 0 seconds.
21:37:45  Checkpoint Completed:  duration was 0 seconds.
21:47:52  Checkpoint Completed:  duration was 0 seconds.
22:03:01  Checkpoint Completed:  duration was 0 seconds.
22:18:10  Checkpoint Completed:  duration was 0 seconds.
22:33:19  Checkpoint Completed:  duration was 0 seconds.
22:48:28  Checkpoint Completed:  duration was 0 seconds.
23:03:37  Checkpoint Completed:  duration was 0 seconds.
23:18:44  Checkpoint Completed:  duration was 0 seconds.
23:33:53  Checkpoint Completed:  duration was 0 seconds.
23:49:02  Checkpoint Completed:  duration was 0 seconds.
23:59:07  Checkpoint Completed:  duration was 0 seconds.

Mon Feb 21 00:04:11 2005

00:04:11  Checkpoint Completed:  duration was 0 seconds.
00:09:13  Checkpoint Completed:  duration was 0 seconds.
00:19:19  Checkpoint Completed:  duration was 0 seconds.
00:24:22  Checkpoint Completed:  duration was 0 seconds.
00:34:28  Checkpoint Completed:  duration was 0 seconds.
00:47:11  Logical Log 702 Complete.
00:49:36  Checkpoint Completed:  duration was 0 seconds.
00:54:39  Checkpoint Completed:  duration was 0 seconds.
01:04:46  Checkpoint Completed:  duration was 0 seconds.
01:19:54  Checkpoint Completed:  duration was 0 seconds.
01:35:03  Checkpoint Completed:  duration was 0 seconds.
01:50:11  Checkpoint Completed:  duration was 0 seconds.
02:05:19  Checkpoint Completed:  duration was 0 seconds.
02:20:28  Checkpoint Completed:  duration was 0 seconds.
02:35:37  Checkpoint Completed:  duration was 0 seconds.
02:50:46  Checkpoint Completed:  duration was 0 seconds.
03:05:55  Checkpoint Completed:  duration was 0 seconds.
03:21:04  Checkpoint Completed:  duration was 0 seconds.
03:36:13  Checkpoint Completed:  duration was 0 seconds.
03:48:41  Logical Log 703 Complete.
03:51:22  Checkpoint Completed:  duration was 0 seconds.
03:56:24  Checkpoint Completed:  duration was 0 seconds.
04:06:31  Checkpoint Completed:  duration was 0 seconds.
04:21:39  Checkpoint Completed:  duration was 0 seconds.
04:36:47  Checkpoint Completed:  duration was 0 seconds.
04:51:56  Checkpoint Completed:  duration was 0 seconds.
05:07:05  Checkpoint Completed:  duration was 0 seconds.
05:22:14  Checkpoint Completed:  duration was 0 seconds.
05:37:23  Checkpoint Completed:  duration was 0 seconds.
05:52:31  Checkpoint Completed:  duration was 0 seconds.
06:07:40  Checkpoint Completed:  duration was 0 seconds.
06:22:49  Checkpoint Completed:  duration was 0 seconds.
06:37:58  Checkpoint Completed:  duration was 0 seconds.
06:53:05  Checkpoint Completed:  duration was 0 seconds.
07:05:16  Logical Log 704 Complete.
07:08:14  Checkpoint Completed:  duration was 0 seconds.
07:13:17  Checkpoint Completed:  duration was 0 seconds.
07:18:20  Checkpoint Completed:  duration was 0 seconds.
07:23:21  Checkpoint Completed:  duration was 0 seconds.
07:33:25  Checkpoint Completed:  duration was 0 seconds.
07:38:28  Checkpoint Completed:  duration was 0 seconds.
07:48:34  Checkpoint Completed:  duration was 0 seconds.
07:53:37  Checkpoint Completed:  duration was 0 seconds.
08:03:44  Checkpoint Completed:  duration was 0 seconds.
08:03:49  Logical Log 705 Complete.
08:03:51  Assert Failed: Internal Error - Segmentation Violation
08:03:51   Who: Session(13, informix@, 0, 2)
                Thread(20, btclean, 800112c4, 1)
08:03:51   Results: OnLine must abort
08:03:51   Action: Reinitialize shared memory
08:03:51   See Also: /tmp/af.b5826f, shmem.b5826f.0
08:04:22  rsdebug.c, line 3563, thread 20, proc id 28172, Segmentation Violati
.
08:04:23    PANIC: Attempting to bring system down

圣诞老人

重新启动了,可是用不了一天的时间他还是会自动地offline
着急呀,请大家帮帮忙吧 !
informix我都重新初始化了还是不行

圣诞老人

这个问题没有人能解决吗
        

zmdzxd

用onstat -g seg 看一下共享内存段是否太小，导致增加到一定数量后出现上述错误。

sososky

08:03:51 See Also: /tmp/af.b5826f,
日志已经提示你了，你看看吧

圣诞老人

首先先谢谢zmdzxd和sososky

hanyu

把SHMADD 加大试试吧。

onlywxw

不要忘了考虑一下你的硬件是否有问题啊，我这里原来就出现过类似的情况，数据库启动后每多久就自动offline了，最后才确定是机器的主板出问题了，主板更换之后，现象消失，所以别忘了诊断一下你的硬件