幫忙出錯了?dbcc tablealloc?

hejiajun

00:00000:00035:2005/12/26 08:51:11.76 server  Run the DBCC command 'dbcc tablealloc' for both the objects 22291139, 1975678086
00:00000:00035:2005/12/26 08:51:11.76 server  Error: 605, Severity: 21, State: 1
00:00000:00035:2005/12/26 08:51:11.76 server  An attempt was made to fetch logical page '304288' in database 'precico2' from cache 'default data cache'. Page belongs to object with id '1975678086', not to object 'inv_dnmx'.
00:00000:00095:2005/12/26 08:51:19.00 server  Starting diagnostics for read failure:
00:00000:00095:2005/12/26 08:51:19.00 server  Device Information:
                                 Device number = 8
                                 Phyname = C:\erpdata\precoco2
00:00000:00095:2005/12/26 08:51:19.00 server  Buffer Information:
                                 Buf addr = 0x2F9CACF0, Mass addr = 0x2F9CACF0
                                 Buf pageno = 304288, Mass pageno = 304288, dbid = 6
00:00000:00095:2005/12/26 08:51:19.00 server  
                                 Buf virtpg = 134522016, Mass virtpg = 134522016
                                 Buf stat = 0x1, Mass stat = 0x44001008
                                 Mass keep = 1, Mass awaited = 0
00:00000:00095:2005/12/26 08:51:19.00 server  Page Information from first read attempt:
                                 Page read from cache
                                 ppageno = 304288, pobjid = 1975678086, pindid = 255
                                 pnextpg = 0, pprevpg = 0
                                 plevel = 251, pstat = 0x4030﹐
                                 pts_hi = 1, pts_lo = 37324767
00:00000:00095:2005/12/26 08:51:19.00 server  Page Information from second read attempt:
                                 Page read from disk
                                 ppageno = 304288, pobjid = 1975678086, pindid = 255
                                 pnextpg = 0, pprevpg = 0
                                 plevel = 251, pstat = 0x4030
                                 pts_hi = 1, pts_lo = 37324767
00:00000:00095:2005/12/26 08:51:19.00 server  SDES Information:
                                 dbid = 6, objid = 22291139, scur.pageid = 304288
                                 sstat = 0x2000441, sstat2 = 0x20
                                 suid = 3, cacheid = 0
00:00000:00095:2005/12/26 08:51:19.00 server  PSS Information:
                                 pstat = 0x10100, pcurdb = 6, pspid = 95
                                 p2stat = 0x1000, p3stat = 0x81a
                                 plasterror = 0, preverror = 0, pattention = 0
00:00000:00095:2005/12/26 08:51:19.00 server  End diagnostics for read failure:
00:00000:00095:2005/12/26 08:51:19.00 server  Run the DBCC command 'dbcc tablealloc' for both the objects 22291139, 1975678086

1017of

the fastest way is recreation

hejiajun

以前我是這樣干的﹐現在我找到了錯誤頁面包含的記錄﹐我想先刪除記錄再插入新的記錄﹐但是刪除不了﹐還有更好的方法不﹐另外造成這個錯誤的原因現在還不太清楚﹐是不是硬 盤有問題﹖

1017of

It looks like system pages encounter some error,maybe the AP page or OAM page.I am not clear how you can delete the data,if ASE don't return you right page.except you have other powerful tools to get it on your way.
the reason for error 605 can not be sure without specific circumstance.system accidental halt、sudden pweroff、storage fault etc,will be the direct factor you look for.good luck.

hobbylu

首先要确定这个表重要不重要

hejiajun

多謝1017﹐數據只能讀出一半﹐就是刪不掉郁悶。