欢迎来到Doc100.Net免费学习资源知识分享平台!
您的位置:首页 > 程序异常 >

sybase ase中uninitialized logical page异常的解决办法

更新时间: 2014-01-05 02:21:01 责任编辑: Author_N1

 

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 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

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




上一篇:上一篇
下一篇:下一篇

 

随机推荐程序问答结果

 

 

如对文章有任何疑问请提交到问题反馈,或者您对内容不满意,请您反馈给我们DOC100.NET论坛发贴求解。
DOC100.NET资源网,机器学习分类整理更新日期::2014-01-05 02:21:01
如需转载,请注明文章出处和来源网址:http://www.doc100.net/bugs/t/8716/
本文WWW.DOC100.NET DOC100.NET版权所有。