求助，频繁出现605错误

superskyer

硬件：RS3000/1u/2g
操作系统：AIX5.2
SYBASE版本：12.5.3/EBF12871
总是出现605错误，不知道是什么原因。
起初怀疑是未打补丁的问题，后来打了12871补丁，问题依然存在。
部分日志：
00:00000:00025:2006/12/04 10:31:18.20 server  Starting diagnostics for read failure:
00:00000:00025:2006/12/04 10:31:18.20 server  Device Information:
                                 Device number = 3
                                 Phyname = /sybdata/data02.dat
00:00000:00025:2006/12/04 10:31:18.20 server  Buffer Information:
                                 Buf addr = 0x16942c8e0, Mass addr = 0x16942c8e0
                                 Buf pageno = 3954054, Mass pageno = 3954054, dbid = 4
00:00000:00025:2006/12/04 10:31:18.20 server  
                                 Buf virtpg = 51725704, Mass virtpg = 51725704
                                 Buf stat = 0x1, Mass stat = 0x1008
                                 Mass keep = 1, Mass awaited = 0
00:00000:00025:2006/12/04 10:31:18.20 server  Page Information from first read attempt: Page read from disk ppageno = 3954054, pobjid = 1865054298, pindid = 0 pnextpg = 439822, pprevpg = 3954053 plevel = 0, pstat = 0x801 pts_hi = 0, pts_lo = 4881079
00:00000:00025:2006/12/04 10:31:18.20 server  Page Information from second read attempt: Page read from disk ppageno = 3954054, pobjid = 1865054298, pindid = 0 pnextpg = 439822, pprevpg = 3954053 plevel = 0, pstat = 0x801 pts_hi = 0, pts_lo = 4881079
00:00000:00025:2006/12/04 10:31:18.20 server  SDES Information:
                                 dbid = 4, objid = 1865054649, scur.pageid = 3954054
                                 sstat = 0x0, sstat2 = 0x800
                                 suid = 1, cacheid = 0
00:00000:00025:2006/12/04 10:31:18.20 server  PSS Information:
                                 pstat = 0x10000, pcurdb = 4, pspid = 25
                                 p2stat = 0x1000, p3stat = 0x800
                                 plasterror = 605, preverror = 0, pattention = 0
00:00000:00025:2006/12/04 10:31:18.20 server  End diagnostics for read failure:
00:00000:00025:2006/12/04 10:31:18.20 server  Run the DBCC command 'dbcc tablealloc' for both the objects 1865054649, 1865054298

请诸位指教，可能是什么原因造成的？

hobbylu

这个不是补丁的问题，首先先检查一下你这个设备是否有硬件损坏，看看系统日志
其次检查两个表1865054298，1865054649，在没法修复的情况下，drop掉重新建表

superskyer

嗯。errpt -a 没有硬件错误。
这段日志只是一个例子，还有好多类似的。
每次发现都是修复或重建表、导入数据。
但问题很快再次出现。

hobbylu

对你的数据库做一个完整的检查

superskyer

errpt报以下错误
IDENTIFIER TIMESTAMP  T C RESOURCE_NAME  DESCRIPTION
A6DF45AA   1205134406 I O RMCdaemon      The daemon is started.
2BFA76F6   1205133806 T S SYSPROC        SYSTEM SHUTDOWN BY USER
9DBCFDEE   1205134306 T O errdemon       ERROR LOGGING TURNED ON
192AC071   1205133606 T O errdemon       ERROR LOGGING TURNED OFF
F89FB899   1204150006 P O dumpcheck      The copy directory is too small.
F89FB899   1203150006 P O dumpcheck      The copy directory is too small.
F89FB899   1202150006 P O dumpcheck      The copy directory is too small.
F89FB899   1201150006 P O dumpcheck      The copy directory is too small.
F89FB899   1130150006 P O dumpcheck      The copy directory is too small.
F89FB899   1129150006 P O dumpcheck      The copy directory is too small.
A6DF45AA   1128220406 I O RMCdaemon      The daemon is started.
2BFA76F6   1128215706 T S SYSPROC        SYSTEM SHUTDOWN BY USER
9DBCFDEE   1128220306 T O errdemon       ERROR LOGGING TURNED ON
192AC071   1128215606 T O errdemon       ERROR LOGGING TURNED OFF
A6DF45AA   1128215306 I O RMCdaemon      The daemon is started.
2BFA76F6   1128214606 T S SYSPROC        SYSTEM SHUTDOWN BY USER
9DBCFDEE   1128215206 T O errdemon       ERROR LOGGING TURNED ON
192AC071   1128214506 T O errdemon       ERROR LOGGING TURNED OFF
A6DF45AA   1128192706 I O RMCdaemon      The daemon is started.
2BFA76F6   1128192106 T S SYSPROC        SYSTEM SHUTDOWN BY USER
9DBCFDEE   1128192606 T O errdemon       ERROR LOGGING TURNED ON
192AC071   1128191906 T O errdemon       ERROR LOGGING TURNED OFF
A6DF45AA   1128175706 I O RMCdaemon      The daemon is started.
2BFA76F6   1128175106 T S SYSPROC        SYSTEM SHUTDOWN BY USER
9DBCFDEE   1128175606 T O errdemon       ERROR LOGGING TURNED ON
192AC071   1128174906 T O errdemon       ERROR LOGGING TURNED OFF
F89FB899   1128150006 P O dumpcheck      The copy directory is too small.
A6DF45AA   1127171706 I O RMCdaemon      The daemon is started.
2BFA76F6   1127171006 T S SYSPROC        SYSTEM SHUTDOWN BY USER
9DBCFDEE   1127171606 T O errdemon       ERROR LOGGING TURNED ON
192AC071   1127170906 T O errdemon       ERROR LOGGING TURNED OFF
F89FB899   1127150006 P O dumpcheck      The copy directory is too small.
F89FB899   1126150006 P O dumpcheck      The copy directory is too small.
F89FB899   1125150006 P O dumpcheck      The copy directory is too small.
F89FB899   1124150006 P O dumpcheck      The copy directory is too small.
F89FB899   1123150006 P O dumpcheck      The copy directory is too small.
F89FB899   1122150006 P O dumpcheck      The copy directory is too small.
F89FB899   1121150006 P O dumpcheck      The copy directory is too small.
F89FB899   1120150006 P O dumpcheck      The copy directory is too small.
F89FB899   1119150006 P O dumpcheck      The copy directory is too small.
A6DF45AA   1118171506 I O RMCdaemon      The daemon is started.
2BFA76F6   1118170806 T S SYSPROC        SYSTEM SHUTDOWN BY USER
9DBCFDEE   1118171406 T O errdemon       ERROR LOGGING TURNED ON
192AC071   1118170706 T O errdemon       ERROR LOGGING TURNED OFF
F89FB899   1118150006 P O dumpcheck      The copy directory is too small.
F89FB899   1117150006 P O dumpcheck      The copy directory is too small.
F89FB899   1116150006 P O dumpcheck      The copy directory is too small.
5DFED6F1   1116105706 I O SYSPFS         UNABLE TO ALLOCATE SPACE IN FILE SYSTEM
5DFED6F1   1116103006 I O SYSPFS         UNABLE TO ALLOCATE SPACE IN FILE SYSTEM
A6DF45AA   1116094906 I O RMCdaemon      The daemon is started.
2BFA76F6   1116094206 T S SYSPROC        SYSTEM SHUTDOWN BY USER
9DBCFDEE   1116094806 T O errdemon       ERROR LOGGING TURNED ON
192AC071   1116094106 T O errdemon       ERROR LOGGING TURNED OFF
A6DF45AA   1115180606 I O RMCdaemon      The daemon is started.
2BFA76F6   1115180006 T S SYSPROC        SYSTEM SHUTDOWN BY USER
9DBCFDEE   1115180506 T O errdemon       ERROR LOGGING TURNED ON
192AC071   1115175806 T O errdemon       ERROR LOGGING TURNED OFF
369D049B   1115155906 I O SYSPFS         UNABLE TO ALLOCATE SPACE IN FILE SYSTEM
A6DF45AA   1115151006 I O RMCdaemon      The daemon is started.
2BFA76F6   1115150406 T S SYSPROC        SYSTEM SHUTDOWN BY USER
9DBCFDEE   1115150906 T O errdemon       ERROR LOGGING TURNED ON
192AC071   1115150206 T O errdemon       ERROR LOGGING TURNED OFF
F89FB899   1115150006 P O dumpcheck      The copy directory is too small.
A6DF45AA   1115145806 I O RMCdaemon      The daemon is started.
1BA7DF4E   1115145806 P S SRC            SOFTWARE PROGRAM ERROR
B6048838   1115145806 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
BA431EB7   1115145806 P S SRC            SOFTWARE PROGRAM ERROR
B6048838   1115145806 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
BA431EB7   1115145806 P S SRC            SOFTWARE PROGRAM ERROR
B6048838   1115145806 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
1BA7DF4E   1115145806 P S SRC            SOFTWARE PROGRAM ERROR
B6048838   1115145806 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
BA431EB7   1115145806 P S SRC            SOFTWARE PROGRAM ERROR
B6048838   1115145806 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
BA431EB7   1115145806 P S SRC            SOFTWARE PROGRAM ERROR
B6048838   1115145806 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
A2D4EDC6   1115145806 I O RMCdaemon      The daemon is stopped.
613E5F38   1115145806 P H LVDD           I/O ERROR DETECTED BY LVM
425BDD47   1115145806 P H hdisk0         DISK OPERATION ERROR
613E5F38   1115145806 P H LVDD           I/O ERROR DETECTED BY LVM
425BDD47   1115145806 P H hdisk0         DISK OPERATION ERROR
A6DF45AA   1115131906 I O RMCdaemon      The daemon is started.
2BFA76F6   1115131306 T S SYSPROC        SYSTEM SHUTDOWN BY USER
9DBCFDEE   1115131806 T O errdemon       ERROR LOGGING TURNED ON
192AC071   1115131206 T O errdemon       ERROR LOGGING TURNED OFF
A6DF45AA   1115115606 I O RMCdaemon      The daemon is started.
2BFA76F6   1115113606 T S SYSPROC        SYSTEM SHUTDOWN BY USER
9DBCFDEE   1115114106 T O errdemon       ERROR LOGGING TURNED ON
i/o错误只有11月15号有，那时候还没装ASE，而且最近几天605错误也频繁出现啊。
会是硬件问题么？

superskyer

dbcc checkdb(...)？
每天查一次，发现错误就drop、create、bcp in。。。。
绝大多数都是605错误，偶尔还有692。

hobbylu

如果频繁发生这个故障，那么需要对你的运行条件检查，是否经常非正常关机等

superskyer

没有啊。非正常关机只在安装aix5.2之前有过。
原来是4.3的，11月16号全新安装的5.2。之后就没有非正常关机了。。。
会不会异步i/o的问题？我把aix的异步i/o最大值改成2，问题不出现的那么频繁了，但没有什么数据来证明。。。

action929

有没有注意过，出错的 总是那几个表还是随即的什么表都出错
感觉还是业务问题

Blackrose

1. 使用dbcc checkdb、dbcc checkalloc对数据库进行全面的检查，一次性的将所有坏表处理
2. 关注系统中存储设备的健康状况