如下是原帖的内容:
<<<<<<:
数据库突然发生了不能查询的情况
请高手们给点指点,新手,比较白。
每次来了都是光看,不发贴,潜水。现在出了问题才知道注册,这样确实有点无耻||||我错了。求指点。。
昨天突然发生了不能正常查询的错误,查的时候提示:The connection has been marked dead.
被标识为DEAD?
错误日志是这样
in the page header and page number 665362 in the buffer header. Buffer will be unhashed,
no action is necessary. Printing headers for diagnostics:
00:00000:00014:2008/11/20 06:40:00.12 server Mass: 0x21c46a74 Buffer: 0x21c46a74 Mass pageno: 665362
-Mass virtpg: 50997010 dbid: 4 Mass stat: 0x4001010
-Buffer pageno: 665362 Buffer virtpg: 50997010 Buf stat: 0x1 keep: 0 awaited: 0 tripsleft: 0
-bpage: 0x21abd800 flushseq: 0 dirty seq: 0 filthyseq: 0 linked: ( hash lru)
00:00000:00014:2008/11/20 06:40:00.12 server Page: 0x21abd800 pageno: 0 objid: 0 indid: 0
- nextpg: 0 prevpg: 0 pstat: 0x0 ts: (0, 0) nextrno: 0
- freeoff: 0 minlen: 0 level: 0
00:00000:00014:2008/11/20 06:40:19.70 server Error: 692, Severity: 20, State: 1
00:00000:00014:2008/11/20 06:40:19.70 server Uninitialized logical page '665362' was read while accessing object '1166624168' in database '4'. Please contact Sybase Technical Support.
00:00000:00014:2008/11/20 06:40:34.04 server Error: 692, Severity: 20, State: 1
00:00000:00014:2008/11/20 06:40:34.04 server Uninitialized logical page '665279' was read while accessing object '1166624168' in database '4'. Please contact Sybase Technical Support.
00:00000:00014:2008/11/20 06:40:38.60 server Error: 692, Severity: 20, State: 1
00:00000:00014:2008/11/20 06:40:38.60 server Uninitialized logical page '665362' was read while accessing object '1166624168' in database '4'. Please contact Sybase Technical Support.
00:00000:00014:2008/11/20 06:40:40.84 server Error: 692, Severity: 20, State: 1
00:00000:00014:2008/11/20 06:40:40.84 server Uninitialized logical page '665362' was read while accessing object '1166624168' in database '4'. Please contact Sybase Technical Support.
00:00000:00014:2008/11/20 06:41:11.34 server Bufunhash: Buffer 0x21c1a174 from database id 4 has page number 0
in the page header and page number 665279 in the buffer header. Buffer will be unhashed,
no action is necessary. Printing headers for diagnostics:
这是什么意思,初始化的时候发生了什么错误,那几页怎么了。database'4'是自己建立的一个库。。。
很着急。。。求指点...谢谢了
>>>>>>>>>>>>>>>>>>>>>>>>>>>>:
解决方法:
1. 首先找出问题的sysobjects的名,大部分是表或者索引
select name from sysobjects where id=1166624168
2. 如果是一个表的话,对这个表进行
dbcc checktable
dbcc tablealloc
3.在这之后,可以尝试将表bcp out,再bcp in
基本上都能解决此类问题。
阅读(2219) | 评论(0) | 转发(0) |