Sybase ASE中Uninitialized logical page错误的解决方法

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

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

请高手们给点指点,新手,比较白。
每次来了都是光看,不发贴,潜水。现在出了问题才知道注册,这样确实有点无耻||||我错了。求指点。。
昨天突然发生了不能正常查询的错误,查的时候提示: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 serverMass: 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 serverPage: 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 serverError: 692, Severity: 20, State: 1
00:00000:00014:2008/11/20 06:40:19.70 serverUninitialized 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 serverError: 692, Severity: 20, State: 1
00:00000:00014:2008/11/20 06:40:34.04 serverUninitialized 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 serverError: 692, Severity: 20, State: 1
00:00000:00014:2008/11/20 06:40:38.60 serverUninitialized 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 serverError: 692, Severity: 20, State: 1
00:00000:00014:2008/11/20 06:40:40.84 serverUninitialized 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 serverBufunhash: 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

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




  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值