Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1332851
  • 博文数量: 185
  • 博客积分: 50
  • 博客等级: 民兵
  • 技术积分: 3934
  • 用 户 组: 普通用户
  • 注册时间: 2007-09-11 13:11
个人简介

iihero@ChinaUnix, ehero.[iihero] 数据库技术的痴迷爱好者. 您可以通过iihero AT qq.com联系到我 以下是我的三本图书: Sybase ASE in Action, Oracle Spatial及OCI高级编程, Java2网络协议内幕

文章分类

全部博文(185)

文章存档

2014年(4)

2013年(181)

分类: 数据库开发技术

2013-07-24 11:16:00

如下是原帖的内容:
<<<<<<:

数据库突然发生了不能查询的情况

请高手们给点指点,新手,比较白。
每次来了都是光看,不发贴,潜水。现在出了问题才知道注册,这样确实有点无耻||||我错了。求指点。。
昨天突然发生了不能正常查询的错误,查的时候提示: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

基本上都能解决此类问题。

阅读(2261) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~