+ -
当前位置:首页 → 问答吧 → Error: 2628, Severity: 21, State: 3错误解决,请大侠们帮帮忙

Error: 2628, Severity: 21, State: 3错误解决,请大侠们帮帮忙

时间:2010-12-09

来源:互联网

日记记录如下:
112:00000:00009:2010/12/09 09:10:28.58 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:28.58 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:10:32.22 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:32.22 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:10:36.44 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:36.44 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:10:40.39 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:40.39 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:10:44.48 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:44.48 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:10:48.44 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:48.44 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:10:53.08 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:53.08 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:10:57.41 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:57.41 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:01.44 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:01.44 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:05.74 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:05.74 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:09.76 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:09.76 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:13.82 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:13.82 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:17.61 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:17.61 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:21.59 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:21.59 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:33.65 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:33.65 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:38.76 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:38.76 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.

一直提示这个错误,也不提示是哪个表的索引坏了,请问这个怎么查啊?

作者: zdz000   发布时间: 2010-12-09

dbcc traceon(3604)
go
dbcc page("rnosdb",60042467,2)
go
会知道此页60042467 是数据还是索引,以及索引的indid。

作者: andkylee   发布时间: 2010-12-09

回复 andkylee


    Page found in Cache: default data cache. Cachelet: 53

BUFFER:
Buffer header for buffer 0x1034ba34000
    page=0x1034ba30000 bdnew=0x105850d4548 bdold=0x10170c2f7a0 bhash=0x0
    bmass_next=0x105850be060 bmass_prev=0x1058527e440 bdbid=4
    bvirtpg= [ 0x1034ba340b8 vpgdevno=22 vpvpn=4179736 vdisk=0x101cf1bb368 ]
    bmass_head=0x10585159610 bmass_tail=0x10585159610
    bcache_desc=0x1034bab6548 (cache name='default data cache')
    bpool_desc=0x1034bb32828 bdbtable=0x10173995b40
    Mass bkeep=0 Mass bpawaited=0 Mass btripsleft=0 Mass btripsleft_orig=0
    bmass_size=16384 (16K pool) bunref_cnt=0
    bmass_stat=0x44011000 (0x40000000 (MASS_CLOCK_SEEN), 0x04000000
(MASS_DONT_DISCARD), 0x00010000 (MASS_DIRTY), 0x00001000 (MASS_HASHED))
    bbuf_stat=0x1 (0x00000001 (BUF_PG_REF))
    Buffer blpageno=60042467 bpg_size=16k Mass blpageno=60042467 (Buffer slot #:
0)
    bxls_pin=0x0 bxls_next=0x0 bspid=0
    bxls_flushseq=1083588113 bxls_pinseq=0 bcurrxdes=0x0
Latch and the wait queue:
Latch (address: 0x1034ba34030)
        latchmode: 0x0 (FREE_LATCH)
        latchowner: -1
        latchnoofowners: 0
        latchwaitq: 0x0 latchwaitqt: 0x0

Latch wait queue:

PAGE HEADER:
Page header for leaf page 0x1034ba30000
pageno=60042467 nextpg=60309379 prevpg=40397961 ptnid=1723029978 timestamp=001b
51292863
numentries=257 level=0 indid=2 freeoff=8268 fixedlen=25
page status bits: 0x802 (0x0800 (PG_XHEADER), 0x0002 (PG_LEAF))
page stat2 bits: pstat2:[0x13PG2_DOL_BTREE,BT_DELUPDCOMMIT)]
leaf status: 0x24 (0x20 (BT_COMMIT), 0x04 (BT_DELCOMMIT))
pagesize=16384 version=1 numundelrids=0 ncfs=8224 (Computed CFS=7600)

结果输入,您再帮忙看看,看不懂,呵呵

作者: zdz000   发布时间: 2010-12-09

页:60042467  是indid=2的非聚簇索引的叶子级别的页面。
可以重建该非聚簇索引。

作者: andkylee   发布时间: 2010-12-09