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.
一直提示这个错误,也不提示是哪个表的索引坏了,请问这个怎么查啊?
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。
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:[0x13
PG2_DOL_BTREE,BT_DELUPDCOMMIT)]
leaf status: 0x24 (0x20 (BT_COMMIT), 0x04 (BT_DELCOMMIT))
pagesize=16384 version=1 numundelrids=0 ncfs=8224 (Computed CFS=7600)
结果输入,您再帮忙看看,看不懂,呵呵
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:[0x13

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
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28