论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2010-01-22 17:17 |只看该作者 |倒序浏览

数据库就重启日志报如下错误：
17:03:13  Maximum server connections 63
17:03:21  I/O read chunk 179, pagenum 254138, pagecnt 1 --> errno = 5
17:03:21  I/O read chunk 164, pagenum 504547, pagecnt 1 --> errno = 5
17:03:21  I/O read chunk 164, pagenum 504547, pagecnt 1 --> errno = 5
17:03:21  I/O read chunk 59, pagenum 44805, pagecnt 1 --> errno = 5
17:03:21  I/O read chunk 8, pagenum 779438, pagecnt 1 --> errno = 5
17:03:21  I/O read chunk 243, pagenum 381812, pagecnt 1 --> errno = 5
17:03:21  I/O read chunk 59, pagenum 44805, pagecnt 1 --> errno = 5
17:03:21  I/O read chunk 153, pagenum 18586, pagecnt 1 --> errno = 5
17:03:21  I/O read chunk 59, pagenum 44805, pagecnt 1 --> errno = 5
17:03:22  Assert Failed: Dynamic Server must abort
17:03:22  IBM Informix Dynamic Server Version 9.40.FC3W1
17:03:22 Who: Session(1451804, npmuser@HEBEOMS, 15212, 1b044c4f

            Thread(3729595, sqlexec, 1aaa222e8, 3)
            File: rslog.c Line: 3507
17:03:22 Results: Dynamic Server must abort
17:03:22 Action: Reinitialize shared memory
17:03:22  stack trace for pid 20198 written to /tmp/af.eca369d9
17:03:22 See Also: /tmp/af.eca369d9, shmem.eca369d9.0
17:03:22  I/O read chunk 4, pagenum 172300, pagecnt 1 --> errno = 5
17:03:22  I/O read chunk 59, pagenum 44805, pagecnt 1 --> errno = 5
17:03:22  I/O write chunk 153, pagenum 18707, pagecnt 4 --> errno = 5
17:03:22  Assert Failed: Dynamic Server must abort
17:03:22  IBM Informix Dynamic Server Version 9.40.FC3W1
17:03:22 Who: Session(1451729, npmuser@, 14402, 1aaa33cb0)
            Thread(3729276, sqlexec, 1aaa12610, 1)
            File: rslog.c Line: 3507
17:03:22 Results: Dynamic Server must abort
17:03:22 Action: Reinitialize shared memory
17:03:22  stack trace for pid 20196 written to /tmp/af.eb6469d8
17:03:22 See Also: /tmp/af.eb6469d8, shmem.eb6469d8.0
17:03:43  rslog.c, line 3507, thread 3729595, proc id 20198, Dynamic Server must abort.
17:03:43  rslog.c, line 3507, thread 3729276, proc id 20196, Dynamic Server must abort.
17:03:43  Fatal error in ADM VP at mt.c:12298
17:03:43  Unexpected virtual processor termination, pid = 20198, exit = 0x100

17:03:43  PANIC: Attempting to bring system down

[ 本帖最后由 liuxiaozhe 于 2010-1-22 17:28 编辑 ]

文库|博客

liaosnet

大富大贵

论坛徽章:: 11

2楼 [报告]

发表于 2010-01-22 17:27 |只看该作者

猜的: 另一个扫了一个阵列是什么意思?

也许是当前的数据库认为CHUNK出问题了~ 看下系统的 errno 5是什么意思...

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

liuxiaozhe

丰衣足食

论坛徽章:: 0

3楼 [报告]

发表于 2010-01-22 17:37 |只看该作者

这是系统日志，感觉可能是阵列读取的错误，数据库重启的时候，另外一套双机对这个阵列进行了扫描
Jan 22 17:03:21 HEBEOMS md_sp: [ID 641072 kern.warning] WARNING: md: d158: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:21 HEBEOMS md_sp: [ID 641072 kern.warning] WARNING: md: d392: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:21 HEBEOMS md_sp: [ID 641072 kern.warning] WARNING: md: d209: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:21 HEBEOMS md_sp: [ID 641072 kern.warning] WARNING: md: d297: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:21 HEBEOMS md_sp: [ID 641072 kern.warning] WARNING: md: d209: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:22 HEBEOMS md_sp: [ID 641072 kern.warning] WARNING: md: d154: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:22 HEBEOMS md_sp: [ID 641072 kern.warning] WARNING: md: d209: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:22 HEBEOMS md_sp: [ID 641072 kern.warning] WARNING: md: d297: write error on /dev/dsk/c3t600A0B8000477BC0000004A0
494326A9d0s0
Jan 22 17:03:22 HEBEOMS md_sp: [ID 641072 kern.warning] WARNING: md: d156: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:22 HEBEOMS md_sp: [ID 641072 kern.warning] WARNING: md: d180: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:32 HEBEOMS fctl: [ID 517869 kern.warning] WARNING: fp(0)::GPN_ID for D_ID=10600 failed
Jan 22 17:03:32 HEBEOMS fctl: [ID 517869 kern.warning] WARNING: fp(0)::N_x Port with D_ID=10600, PWWN=2100001b32945509 disappe
ared from fabric
Jan 22 17:03:32 HEBEOMS fctl: [ID 517869 kern.warning] WARNING: fp(1)::GPN_ID for D_ID=10600 failed
Jan 22 17:03:32 HEBEOMS fctl: [ID 517869 kern.warning] WARNING: fp(1)::N_x Port with D_ID=10600, PWWN=2100001b32942509 disappe
ared from fabric
Jan 22 17:04:18 HEBEOMS fctl: [ID 517869 kern.warning] WARNING: fp(0)::N_x Port with D_ID=10700, PWWN=2100001b32943809 reappea
red in fabric
Jan 22 17:04:19 HEBEOMS fctl: [ID 517869 kern.warning] WARNING: fp(1)::N_x Port with D_ID=10700, PWWN=2100001b3294f608 reappea
red in fabric
Jan 22 17:04:47 HEBEOMS fctl: [ID 517869 kern.warning] WARNING: fp(0)::N_x Port with D_ID=10600, PWWN=2100001b32945509 reappea
red in fabric
Jan 22 17:04:47 HEBEOMS fctl: [ID 517869 kern.warning] WARNING: fp(1)::N_x Port with D_ID=10600, PWWN=2100001b32942509 reappea
red in fabric

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

liaosnet

大富大贵

论坛徽章:: 11

4楼 [报告]

发表于 2010-01-22 23:57 |只看该作者

原帖由 liuxiaozhe 于 2010-1-22 17:37 发表
这是系统日志，感觉可能是阵列读取的错误，数据库重启的时候，另外一套双机对这个阵列进行了扫描
Jan 22 17:03:21 HEBEOMS md_sp: WARNING: md: d158: read error on /dev/dsk/c3t600A0B8000477BC0000004A04 ...

那就是了~~这个问题不是数据库的问题,是存储的问题~~

error 5应该就是读失败.....
应该扫描的时候动了数据库用到那些disk,影响到了数据库读取写入..

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

czw1413_cn czw1413_cn 当前离线禁止发言好友博客消息论坛徽章: 0	5楼 [报告] 发表于 2010-01-23 10:36 \|只看该作者提示: 作者被禁止或删除内容自动屏蔽
	实战分享：从技术角度谈机器学习入门\| 【大话IT】RadonDB低门槛向MySQL集群下战书 \| ChinaUnix打赏功能已上线！ \| 新一代分布式关系型数据库RadonDB知多少？

返回列表

Chinaunix › 论坛 › 数据库技术 › Informix › informix重启问题

informix重启问题 [复制链接]

浏览过的版块