informix重启问题
数据库就重启日志报如下错误：17:03:13Maximum server connections 63
17:03:21I/O read chunk 179, pagenum 254138, pagecnt 1 --> errno = 5
17:03:21I/O read chunk 164, pagenum 504547, pagecnt 1 --> errno = 5
17:03:21I/O read chunk 164, pagenum 504547, pagecnt 1 --> errno = 5
17:03:21I/O read chunk 59, pagenum 44805, pagecnt 1 --> errno = 5
17:03:21I/O read chunk 8, pagenum 779438, pagecnt 1 --> errno = 5
17:03:21I/O read chunk 243, pagenum 381812, pagecnt 1 --> errno = 5
17:03:21I/O read chunk 59, pagenum 44805, pagecnt 1 --> errno = 5
17:03:21I/O read chunk 153, pagenum 18586, pagecnt 1 --> errno = 5
17:03:21I/O read chunk 59, pagenum 44805, pagecnt 1 --> errno = 5
17:03:22Assert Failed: Dynamic Server must abort
17:03:22IBM Informix Dynamic Server Version 9.40.FC3W1
17:03:22 Who: Session(1451804, npmuser@HEBEOMS, 15212, 1b044c4f8)
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:22stack trace for pid 20198 written to /tmp/af.eca369d9
17:03:22 See Also: /tmp/af.eca369d9, shmem.eca369d9.0
17:03:22I/O read chunk 4, pagenum 172300, pagecnt 1 --> errno = 5
17:03:22I/O read chunk 59, pagenum 44805, pagecnt 1 --> errno = 5
17:03:22I/O write chunk 153, pagenum 18707, pagecnt 4 --> errno = 5
17:03:22Assert Failed: Dynamic Server must abort
17:03:22IBM 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:22stack trace for pid 20196 written to /tmp/af.eb6469d8
17:03:22 See Also: /tmp/af.eb6469d8, shmem.eb6469d8.0
17:03:43rslog.c, line 3507, thread 3729595, proc id 20198, Dynamic Server must abort.
17:03:43rslog.c, line 3507, thread 3729276, proc id 20196, Dynamic Server must abort.
17:03:43Fatal error in ADM VP at mt.c:12298
17:03:43Unexpected virtual processor termination, pid = 20198, exit = 0x100
17:03:43PANIC: Attempting to bring system down
[ 本帖最后由 liuxiaozhe 于 2010-1-22 17:28 编辑 ] 猜的: 另一个扫了一个阵列是什么意思?:em17: :em17:
也许是当前的数据库认为CHUNK出问题了~ 看下系统的 errno 5是什么意思... 这是系统日志，感觉可能是阵列读取的错误，数据库重启的时候，另外一套双机对这个阵列进行了扫描
Jan 22 17:03:21 HEBEOMS md_sp: WARNING: md: d158: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:21 HEBEOMS md_sp: WARNING: md: d392: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:21 HEBEOMS md_sp: WARNING: md: d209: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:21 HEBEOMS md_sp: WARNING: md: d297: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:21 HEBEOMS md_sp: WARNING: md: d209: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:22 HEBEOMS md_sp: WARNING: md: d154: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:22 HEBEOMS md_sp: WARNING: md: d209: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:22 HEBEOMS md_sp: WARNING: md: d297: write error on /dev/dsk/c3t600A0B8000477BC0000004A0
494326A9d0s0
Jan 22 17:03:22 HEBEOMS md_sp: WARNING: md: d156: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:22 HEBEOMS md_sp: WARNING: md: d180: read error on /dev/dsk/c3t600A0B8000477BC0000004A04
94326A9d0s0
Jan 22 17:03:32 HEBEOMS fctl: WARNING: fp(0)::GPN_ID for D_ID=10600 failed
Jan 22 17:03:32 HEBEOMS fctl: WARNING: fp(0)::N_x Port with D_ID=10600, PWWN=2100001b32945509 disappe
ared from fabric
Jan 22 17:03:32 HEBEOMS fctl: WARNING: fp(1)::GPN_ID for D_ID=10600 failed
Jan 22 17:03:32 HEBEOMS fctl: WARNING: fp(1)::N_x Port with D_ID=10600, PWWN=2100001b32942509 disappe
ared from fabric
Jan 22 17:04:18 HEBEOMS fctl: WARNING: fp(0)::N_x Port with D_ID=10700, PWWN=2100001b32943809 reappea
red in fabric
Jan 22 17:04:19 HEBEOMS fctl: WARNING: fp(1)::N_x Port with D_ID=10700, PWWN=2100001b3294f608 reappea
red in fabric
Jan 22 17:04:47 HEBEOMS fctl: WARNING: fp(0)::N_x Port with D_ID=10600, PWWN=2100001b32945509 reappea
red in fabric
Jan 22 17:04:47 HEBEOMS fctl: WARNING: fp(1)::N_x Port with D_ID=10600, PWWN=2100001b32942509 reappea
red in fabric 原帖由 liuxiaozhe 于 2010-1-22 17:37 发表 http://bbs3.chinaunix.net/images/common/back.gif
这是系统日志，感觉可能是阵列读取的错误，数据库重启的时候，另外一套双机对这个阵列进行了扫描
Jan 22 17:03:21 HEBEOMS md_sp:WARNING: md: d158: read error on /dev/dsk/c3t600A0B8000477BC0000004A04 ...
那就是了~~这个问题不是数据库的问题,是存储的问题~~:em17: :em17:error 5应该就是读失败.....
应该扫描的时候动了数据库用到那些disk,影响到了数据库读取写入..
页:
[1]