- 论坛徽章:
- 0
|
上星期一直在用dbaccess中的load语句导数据，到星期六晚，数据库突然死了，察看日志如下：
20:55:02 Assert Failed: I/O error, Primary Chunk '/home/dbchunk/rootchk' -- Offline
20:55:02 Informix Dynamic Server Version 7.30.UC10
20:55:02 Who: Session(741, xxx@xxx.xxx, 4562, 0)
Thread(765, sqlexec, 0, 1)
File: rsbuff.c Line: 3609
20:55:02 Results: Chunk is now unusable
20:55:02 Action: Repair and restore from mirror or archive
20:55:03 See Also: /tmp/af.2fd28a5
20:55:03 Assert Failed: INFORMIX-OnLine Must ABORT
Critical media failure.
20:55:03 Informix Dynamic Server Version 7.30.UC10
20:55:03 Who: Session(741, xxx@xxx.xxx, 4562, 0)
Thread(765, sqlexec, 0, 1)
File: rsmirror.c Line: 1703
20:55:05 See Also: /tmp/af.2fd28a5, shmem.2fd28a5.1
20:55:22 rsmirror.c, line 1703, thread 765, proc id 2665, INFORMIX-OnLine Must
ABORT
Critical media failure..
20:55:22 PANIC: Attempting to bring system down
发现后，重新启动oninit,很快又报错：
oninit: Fatal error in shared memory initialization
发现日志中，写道：
21:05:55 Informix Dynamic Server Initialized -- Shared Memory Initialized.
21:05:55 Physical Recovery Started.
21:06:08 I/O read chunk 1, pagenum 92, pagecnt 4 -->; errno = 5
21:06:08 Assert Failed: Physical log recovery error
21:06:08 Informix Dynamic Server Version 7.30.UC10
21:06:08 Who: Session(11, informix@xxx.xxx, 0, 0)
Thread(38, fast_rec, 0, 1)
File: rsrecvr.c Line: 361
21:06:08 Results: Physical Recovery Aborted.
21:06:08 Action: Retry and/or restore
21:06:09 See Also: /tmp/af.267cc0, shmem.267cc0.0
21:06:09 Cannot Restore to Checkpoint.
21:06:09 Informix Dynamic Server Stopped.
21:06:09 mt_shm_remove: WARNING: may not have removed all/correct segments
好像是rootchk出了问题，但是在oninit刚启还能用的那几分钟内看onstat 或 onmonitor ，rootchk的状态为PO，如果真的offline的话状态不是应该为PD吗？
请教各位，我该怎么才能修复呢？ |
|
免费注册
发表于 2004-12-20 13:40
