免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2251 | 回复: 3
打印 上一主题 下一主题

数据库突然D掉,具体信息如文! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2004-11-26 12:40 |只看该作者 |倒序浏览
数据库突然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
请各位大侠看看,是什么原因早成的?

论坛徽章:
0
2 [报告]
发表于 2004-11-26 15:43 |只看该作者

数据库突然D掉,具体信息如文!

查查你的CHUNK,/dev/rchunk33,读写是否正常

论坛徽章:
0
3 [报告]
发表于 2004-11-27 14:05 |只看该作者

数据库突然D掉,具体信息如文!

不能读写,database库的chunk完全不能读写,状态为PD

论坛徽章:
0
4 [报告]
发表于 2004-11-29 09:56 |只看该作者
提示: 作者被禁止或删除 内容自动屏蔽
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP