论坛徽章:: 0

电梯直达

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

发表于 2010-03-22 10:09 |只看该作者 |倒序浏览

本帖最后由 silamuwang 于 2010-03-23 11:03 编辑

业务程序对一张表进行查询时报错，用PB连上执行语句也报错，日志错误代码：
00:00000:00221:2010/03/22 08:34:27.16 server  Starting diagnostics for read failure:
00:00000:00221:2010/03/22 08:34:27.16 server  Device Information:
   Device number = 22
   Phyname = /sybdata/erp_logdevice
00:00000:00221:2010/03/22 08:34:27.16 server  Buffer Information:
   Buf addr = 0x29e183fd8, Mass addr = 0x29e183fd8
   Buf pageno = 6265144, Mass pageno = 6265144, dbid = 5
00:00000:00221:2010/03/22 08:34:27.16 server
   Buf virtpg = 371267896, Mass virtpg = 371267896
   Buf stat = 0x1, Mass stat = 0x46001008
   Mass keep = 1, Mass awaited = 0
00:00000:00221:2010/03/22 08:34:27.16 server  Page Information from first read attempt: Page read from cache ppageno = 6265144, pobjid = 2121771585, pindid = 1 pnextpg = 6046387, pprevpg = 3318759 plevel = 0, pstat = 0x80 pts_hi = 0, pts_lo = 1114648987
00:00000:00221:2010/03/22 08:34:27.16 server  Page Information from second read attempt: Page read from disk ppageno = 6265144, pobjid = 2121771585, pindid = 1 pnextpg = 6046387, pprevpg = 3318759 plevel = 0, pstat = 0x80 pts_hi = 0, pts_lo = 1114648987
00:00000:00221:2010/03/22 08:34:27.16 server  SDES Information:
   dbid = 5, objid = 1492197335, scur.pageid = 6265144
   sstat = 0x2000040, sstat2 = 0x20
   suid = 1, cacheid = 0
00:00000:00221:2010/03/22 08:34:27.16 server  PSS Information:
   pstat = 0x10100, pcurdb = 5, pspid = 221
   p2stat = 0x1000, p3stat = 0x81a
   plasterror = 0, preverror = 0, pattention = 0
00:00000:00221:2010/03/22 08:34:27.16 server  End diagnostics for read failure:
00:00000:00221:2010/03/22 08:34:27.16 server  Run the DBCC command 'dbcc tablealloc' for both the objects 1492197335, 2121771585
00:00000:00221:2010/03/22 08:34:27.17 server  Error: 605, Severity: 21, State: 1
00:00000:00221:2010/03/22 08:34:27.17 server  An attempt was made to fetch logical page '6265144' in database 'hjerp' from cache 'default data cache'. Page belongs to object with id '2121771585', not to object 'invt06_c'.

如何解决？

文库|博客

silamuwang

稍有积蓄

论坛徽章:: 0

2楼 [报告]

发表于 2010-03-22 10:25 |只看该作者

后执行
1> dbcc checktable (1492197335)
2> go
Checking invt06_c: Logical pagesize is 2048 bytes
The total number of data pages in this table is 76660.
The total number of empty pages (with all deleted rows) in this table is 23.
The total number of pages which could be garbage collected to free up some space
is 23396.
Table has 378289 data rows.
Msg 605, Level 16, State 1:
Line 1:
An attempt was made to fetch logical page '6265160' in database 'hjerp' from
cache 'default data cache'. Page belongs to object with id '956527410', not to
object 'invt06_c'.
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
1> dbcc checktable (2121771585)
2> go
Checking prdm33: Logical pagesize is 2048 bytes
The total number of data pages in this table is 71752.
The total number of TEXT/IMAGE pages in this table is 740.
Table has 262639 data rows.
Msg 7931, Level 16, State 1:
Line 1:
Table Corrupt: keys in right child precede the parent key; check right child
page 3993338.
Msg 7931, Level 16, State 1:
Line 1:
Table Corrupt: keys in right child precede the parent key; check right child
page 3993339.
Msg 7931, Level 16, State 1:
Line 1:
Table Corrupt: keys in right child precede the parent key; check right child
page 3993340.
Msg 605, Level 16, State 1:
Line 1:
An attempt was made to fetch logical page '3700304' in database 'hjerp' from
cache 'default data cache'. Page belongs to object with id '1227200441', not to
object 'prdm33'.
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
1>

怎么解决这个问题？多谢各位了