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

基本上都能解決此類問題。