求助Fatal Error 605

hongliny

见附件

wfcjz

执行过程失败，你尝试退出来重新isql进去的看一下，看这好像是你的过程本身有问题吧！

hongliny

这个存储过程运行好几年了，每天执行一次，今天报的错

andkylee

贴errorlog的日志信息吧！

hongliny

00:00000:00013:2010/01/15 09:51:06.85 server  Starting diagnostics for read failure:
00:00000:00013:2010/01/15 09:51:06.89 server  Device Information:
                                 Device number = 2
                                 Phyname = c:\sybase\data\jmjcdb_data
00:00000:00013:2010/01/15 09:51:06.89 server  Buffer Information:
                                 Buf addr = 0x21BE6B90, Mass addr = 0x21BE6B90
                                 Buf pageno = 1905200, Mass pageno = 1905200, dbid = 4
00:00000:00013:2010/01/15 09:51:06.89 server  
                                 Buf virtpg = 35459632, Mass virtpg = 35459632
                                 Buf stat = 0x1, Mass stat = 0x1008
                                 Mass keep = 1, Mass awaited = 0
00:00000:00013:2010/01/15 09:51:06.89 server  Page Information from first read attempt: Page read from disk ppageno = 1905200, pobjid = 89048322, pindid = 2 pnextpg = 1905201, pprevpg = 1905159 plevel = 0, pstat = 0x82 pts_hi = 0, pts_lo = 277445452
00:00000:00013:2010/01/15 09:51:06.89 server  Page Information from second read attempt: Page read from disk ppageno = 1905200, pobjid = 89048322, pindid = 2 pnextpg = 1905201, pprevpg = 1905159 plevel = 0, pstat = 0x82 pts_hi = 0, pts_lo = 277445452
00:00000:00013:2010/01/15 09:51:06.89 server  SDES Information:
                                 dbid = 4, objid = 121048436, scur.pageid = 1905200
                                 sstat = 0x20010c0, sstat2 = 0x200020
                                 suid = 1, cacheid = 0
00:00000:00013:2010/01/15 09:51:06.89 server  PSS Information:
                                 pstat = 0x10100, pcurdb = 4, pspid = 13
                                 p2stat = 0x1001000, p3stat = 0x81a
                                 plasterror = 0, preverror = 0, pattention = 0
00:00000:00013:2010/01/15 09:51:06.89 server  End diagnostics for read failure:
00:00000:00013:2010/01/15 09:51:06.89 server  Run the DBCC command 'dbcc tablealloc' for both the objects 121048436, 89048322
00:00000:00013:2010/01/15 09:51:06.90 server  Error: 605, Severity: 21, State: 1
00:00000:00013:2010/01/15 09:51:06.90 server  An attempt was made to fetch logical page '1905200' in database 'jmjcdb' from cache 'default data cache'. Page belongs to object with id '89048322', not to object 'tab_tjrbb'.
00:00000:00013:2010/01/15 09:51:07.01 server  Starting diagnostics for read failure:
00:00000:00013:2010/01/15 09:51:07.01 server  Device Information:
                                 Device number = 2
                                 Phyname = c:\sybase\data\jmjcdb_data
00:00000:00013:2010/01/15 09:51:07.01 server  Buffer Information:
                                 Buf addr = 0x21C292C4, Mass addr = 0x21C292C4
                                 Buf pageno = 1905208, Mass pageno = 1905208, dbid = 4
00:00000:00013:2010/01/15 09:51:07.01 server  
                                 Buf virtpg = 35459640, Mass virtpg = 35459640
                                 Buf stat = 0x1, Mass stat = 0x44001008
                                 Mass keep = 1, Mass awaited = 0
00:00000:00013:2010/01/15 09:51:07.01 server  Page Information from first read attempt: Page read from cache ppageno = 1905208, pobjid = 89048322, pindid = 0 pnextpg = 1905209, pprevpg = 1905167 plevel = 0, pstat = 0x101 pts_hi = 0, pts_lo = 277699066
00:00000:00013:2010/01/15 09:51:07.01 server  Page Information from second read attempt: Page read from disk ppageno = 1905208, pobjid = 89048322, pindid = 0 pnextpg = 1905209, pprevpg = 1905167 plevel = 0, pstat = 0x101 pts_hi = 0, pts_lo = 277699066
00:00000:00013:2010/01/15 09:51:07.01 server  SDES Information:
                                 dbid = 4, objid = 121048436, scur.pageid = 1905208
                                 sstat = 0x2004042, sstat2 = 0x800020
                                 suid = 1, cacheid = 0
00:00000:00013:2010/01/15 09:51:07.01 server  PSS Information:
                                 pstat = 0x10010000, pcurdb = 4, pspid = 13
                                 p2stat = 0x1001000, p3stat = 0x81a
                                 plasterror = 0, preverror = 0, pattention = 0
00:00000:00013:2010/01/15 09:51:07.01 server  End diagnostics for read failure:
00:00000:00013:2010/01/15 09:51:07.01 server  Run the DBCC command 'dbcc tablealloc' for both the objects 121048436, 89048322
00:00000:00013:2010/01/15 09:51:07.01 server  Error: 605, Severity: 21, State: 1
00:00000:00013:2010/01/15 09:51:07.01 server  An attempt was made to fetch logical page '1905208' in database 'jmjcdb' from cache 'default data cache'. Page belongs to object with id '89048322', not to object 'tab_tjrbb'.
00:00000:00013:2010/01/15 09:51:21.04 server  WARNING: ***************************
00:00000:00013:2010/01/15 09:51:21.04 server  Attempt by user 4 to dump xact on db jmjcdb with NO_LOG
00:00000:00013:2010/01/15 09:51:21.42 server  Attempt by user 4 to dump xact on db jmjcdb with NO_LOG was successful
00:00000:00013:2010/01/15 09:51:21.42 server  WARNING: ***************************

wfcjz

An attempt was made to fetch logical page '1905208' in database 'jmjcdb' from cache 'default data cache'. Page belongs to object with id '89048322', not to object 'tab_tjrbb'

看这个吧！tab_tjrbb有题了，对tab_tjrbb做dbcc看一下！

jmabis

error-7939

wfcjz

Run the DBCC command 'dbcc tablealloc' for both the objects 121048436, 89048322

wfcjz

dbcc checktable（121048436）
dbcc checktable（89048322）

结果贴出来！

andkylee

原帖由 jmabis 于 2010-1-17 12:58 发表
error-7939

请问从哪里看出来是error7939？

从error messge guide 上面我找到的7939为：
Error 7939
severity:16
message text:table corrupt:the entry is missing from the OAM for the object id %ld indid %d for allocation page %ld.