Chinaunix

标题: 数据库单个表出现页连接错误，不能读取数据；请问什么原因造成的；求助 [打印本页]

作者: hzc761207 时间: 2006-03-17 08:06
标题: 数据库单个表出现页连接错误，不能读取数据；请问什么原因造成的；求助
00:00000:00111:2006/03/16 10:49:19.57 server  Error: 2628, Severity: 21, State: 2
00:00000:00111:2006/03/16 10:49:19.57 server  In database 'court', page 2456623 is linked forward to page 2560056, but that page is linked backward to page 2378525. Please report this internal error to Sybase Technical Support.
00:00000:00111:2006/03/16 10:49:19.57 kernel  ************************************
00:00000:00111:2006/03/16 10:49:19.57 kernel  SQL causing error : Select Count ( *) From CASES Where STATE_NO in ( '070' , '080' ) AND DRAFTSDEPT ='执二庭'
00:00000:00111:2006/03/16 10:49:19.57 kernel  ************************************
00:00000:00111:2006/03/16 10:49:19.57 server  SQL Text: Select Count ( *) From CASES Where STATE_NO in ( '070' , '080' ) AND DRAFTSDEPT ='执二庭'
00:00000:00111:2006/03/16 10:49:19.57 kernel  curdb = 4 pstat = 0x10000 lasterror = 2628
00:00000:00111:2006/03/16 10:49:19.57 kernel  preverror = 0 transtate = 0
00:00000:00111:2006/03/16 10:49:19.57 kernel  curcmd = 193 program =

作者: 小无赖 时间: 2006-03-17 09:16
把聚簇索引删除后重建再用dbcc checktable检查一下CASES

作者: hzc761207 时间: 2006-03-17 13:16
多谢

作者: zhaopingzi 时间: 2006-03-17 21:42
LZ,现在怎么样了,如果修好了,贴出来共享一下啊

作者: hzc761207 时间: 2006-03-20 11:43
标题: 已处理完毕
通过sql语句检索出数据，坏页的数据不能读出，大部分数据读出；删除数据表，重建表后导入数据

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)