互联网服务数据库

WARNING: IBM Informix Dynamic Server is no longer running

informix-/opt/informix> onstat -*** WARNING: IBM Informix Dynamic Server is no longer running. ****** WARNING: IBM Informix Dynamic Server is no longer running. ***IBM Informix Dynamic Server Version 9.40.FC3W1   -- On-Line (CKPT REQ) -- Up...显示全部
informix-/opt/informix> onstat -
*** WARNING: IBM Informix Dynamic Server is no longer running. ***

*** WARNING: IBM Informix Dynamic Server is no longer running. ***


IBM Informix Dynamic Server Version 9.40.FC3W1   -- On-Line (CKPT REQ) -- Up 141 days 23:20:10 -- 3867648 Kbytes
Blocked:CKPT

*** WARNING: IBM Informix Dynamic Server is no longer running. ***

这种从15点半就开始是这样了,一直持续到了16点半。
我执行操作是:onmode –ky ,把数据库停了。而后oninit –v ,数据库起了20分钟,起来了。

从online日志里看到在15点半左右有如下报错:
15:26:12   Results: Possible inconsistencies in a Chunk Freelist page
15:26:12   Action: Run 'oncheck -ce' and/or restore affected DBSpace
15:26:12  stack trace for pid 3820 written to /tmp/af.d555e28f
15:26:12   See Also: /tmp/af.d555e28f
15:26:12  Page Check Error in chfree:bad chunk free list page2
15:26:12  Assert Failed: Page Check Error in chfree:bad chunk free list page2
15:26:12  IBM Informix Dynamic Server Version 9.40.FC3W1  
15:26:12   Who: Session(7518674, informix@HEBMD1, 207, 1c0e00408)
                Thread(53924205, sqlexec, 1c4ed0668, 7)
                File: rsdebug.c Line: 1047
15:26:12   Results: Possible inconsistencies in a Chunk Freelist page
15:26:12   Action: Run 'oncheck -ce' and/or restore affected DBSpace
15:26:12  stack trace for pid 3820 written to /tmp/af.d555e28f
15:26:12   See Also: /tmp/af.d555e28f
15:26:12  Page Check Error in chfree:bad chunk free list page2
15:26:12  Assert Failed: Page Check Error in chfree:bad chunk free list page2
15:26:12  IBM Informix Dynamic Server Version 9.40.FC3W1  
…………………..
15:33:04  IBM Informix Dynamic Server Started.
15:33:04  shmget: [EEXIST][17]: key 52884801: shared memory already exists
15:33:04  mt_shm_init: can't create resident segment

15:33:05  IBM Informix Dynamic Server Started.
15:33:05  shmget: [EEXIST][17]: key 52884801: shared memory already exists
15:33:05  mt_shm_init: can't create resident segment

15:33:51  IBM Informix Dynamic Server Started.
15:33:51  shmget: [EEXIST][17]: key 52884801: shared memory already exists
15:33:51  mt_shm_init: can't create resident segment

从日志看,系统应该是自动启动了,但是由于共享内存未释放,一直启动不起来?
还是咋回事儿?收起
参与21

查看其它 20 个回答孔令俊的回答

孔令俊孔令俊软件开发工程师建行
你是不是使用了文件系统文件作为数据文件?
如果使用文件,又没有使用direct/IO,则可能因为文件系统异常导致数据库异常。
互联网服务 · 2011-11-14
浏览2602

回答者

孔令俊
软件开发工程师建行
擅长领域: 分布式架构

孔令俊 最近回答过的问题

回答状态

  • 发布时间:2011-11-14
  • 关注会员:0 人
  • 回答浏览:2602
  • X社区推广