- 论坛徽章:
- 0
|
数据库突然D掉,具体信息如下:
onstat -d
Informix Dynamic Server Version 7.31.UC7 -- On-Line -- Up 00:03:51 -- 172032
Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
1a05813c 1 1 1 1 N informix rootdbs
1a058e98 2 1 2 1 N informix plogdbs
1a058f54 3 1 3 1 N informix llogdbs
1a059010 4 2001 4 1 N T informix tempdbs
1a0590cc 5 5 5 9 ND informix datadbs01
5 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
1a0581f8 1 1 0 500000 498361 PO- /dev/rchunk20
1a058358 2 2 500000 175000 19947 PO- /dev/rchunk20
1a058448 3 3 700000 275000 18947 PO- /dev/rchunk20
1a058538 4 4 0 950000 949947 PO- /dev/rchunk21
1a058628 5 5 0 950000 0 PD- /dev/rchunk22
1a058718 6 5 0 990000 0 PD- /dev/rchunk23
1a058808 7 5 0 990000 0 PD- /dev/rchunk24
1a0588f8 8 5 0 990000 0 PD- /dev/rchunk25
1a0589e8 9 5 0 990000 0 PD- /dev/rchunk26
1a058ad8 10 5 0 995000 0 PD- /dev/rchunk30
1a058bc8 11 5 0 999500 0 PD- /dev/rchunk31
1a058cb8 12 5 0 999500 0 PD- /dev/rchunk32
1a058da8 13 5 0 999500 0 PD- /dev/rchunk33
13 active, 2047 maximum
另外,当天的日志显示如下:
Fri Nov 26 00:03:41 2004
00:03:41 Checkpoint Completed: duration was 0 seconds.
00:34:10 Checkpoint Completed: duration was 0 seconds.
00:39:15 Checkpoint Completed: duration was 0 seconds.
00:49:25 Checkpoint Completed: duration was 0 seconds.
00:54:30 Checkpoint Completed: duration was 0 seconds.
01:05:24 Checkpoint Completed: duration was 44 seconds.
01:11:18 Checkpoint Completed: duration was 49 seconds.
01:17:15 Checkpoint Completed: duration was 51 seconds.
01:21:39 Logical Log 1474 Complete.
01:21:41 Process exited with return code 142: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 1474 Complete." "Logical Log 1474 Complete."
01:22:32 Checkpoint Completed: duration was 13 seconds.
01:27:49 Checkpoint Completed: duration was 12 seconds.
01:33:03 Checkpoint Completed: duration was 8 seconds.
01:38:12 Checkpoint Completed: duration was 3 seconds.
01:45:17 Checkpoint Completed: duration was 120 seconds.
01:50:58 Checkpoint Completed: duration was 35 seconds.
01:58:28 Checkpoint Completed: duration was 144 seconds.
02:03:39 Checkpoint Completed: duration was 6 seconds.
02:08:45 Checkpoint Completed: duration was 1 seconds.
02:13:51 Checkpoint Completed: duration was 1 seconds.
02:15:29 Logical Log 1475 Complete.
02:15:32 Process exited with return code 142: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 1475 Complete." "Logical Log 1475 Complete."
02:18:29 Logical Log 1476 Complete.
02:18:31 Process exited with return code 142: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 1476 Complete." "Logical Log 1476 Complete."
02:19:20 Assert Failed: I/O error, Primary Chunk '/dev/rchunk33' -- Offline
02:19:20 Informix Dynamic Server Version 7.31.UC7
02:19:20 Who: Thread(10, flush_sub(0), 1a05a4fc, 1)
File: rsbuff.c Line: 4116
02:19:20 Results: Chunk is now unusable
02:19:20 Action: Repair and restore from mirror or archive
02:19:20 See Also: /usr/informix/tmp/af.3f22227
02:19:29 Assert Failed: Chunk 13 is being taken OFFLINE.
02:19:29 Informix Dynamic Server Version 7.31.UC7
02:19:29 Who: Thread(10, flush_sub(0), 1a05a4fc, 3)
File: rsmirror.c Line: 1784
02:19:29 Results: Dynamic Server will block at next checkpoint
02:19:29 Action: Shutdown (onmode -k) or override (onmode -O)
02:19:29 See Also: /usr/informix/tmp/af.3f22227
02:19:29 I/O write chunk 13, pagenum 218508, pagecnt 1 -->; errno = 2
02:19:29 Checkpoint blocked by down space, waiting for override or shutdown
03:34:46 WARNING: Checkpoint appears stalled and may not complete
before the database server shuts down.
03:34:47 Informix Dynamic Server Stopped.
03:35:10 Requested shared memory segment size rounded from 8000KB to 8192KB
Fri Nov 26 03:35:10 2004
03:35:10 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh'
03:35:15 DR: DRAUTO is 0 (Off)
03:35:15 Informix Dynamic Server Version 7.31.UC7 Software Serial Number AAC#J529250
03:35:19 Informix Dynamic Server Initialized -- Shared Memory Initialized.
03:35:19 Physical Recovery Started.
03:35:23 Physical Recovery Complete: 15212 Pages Restored.
03:35:23 Logical Recovery Started.
03:35:27 I/O read chunk 13, pagenum 218508, pagecnt 1 -->; errno = 5
03:35:27 Rollforward of log record failed. iserrno = 126
03:35:27 Log Record: log = 1476, pos = 37604c, type = OLDRSAM:HINSERT(40), trans = 64
03:35:35 Assert Failed: Chunk 5 is being taken OFFLINE.
03:35:35 Informix Dynamic Server Version 7.31.UC7
03:35:35 Who: Session(7, informix@rb0001, 0, 436741896)
Thread(43, xchg_1.3, 1a05d124, 3)
File: rsmirror.c Line: 1784
03:35:35 Results: Dynamic Server will block at next checkpoint
03:35:35 Action: Shutdown (onmode -k) or override (onmode -O)
03:35:36 See Also: /usr/informix/tmp/af.41333fe
03:35:36 Rollforward of log record failed. iserrno = 101
03:35:36 Log Record: log = 1476, pos = 3761b8, type = OLDRSAM:ADDITEM(2 , trans = 64
03:35:36 Rollforward of log record failed. iserrno = 101
请各位大侠看看,是什么原因早成的? |
|