ERROR 2628

nikii

SYBASE 数据库报这个错误，是什么意思啊？
怎么解决？

nikii

00:00000:00014:2005/06/25 19:01:45.10 server  Error: 2628, Severity: 21, State: 1
00:00000:00014:2005/06/25 19:01:45.10 server  In database 'MBFEWKDB', page 206881 is linked forward to page 207748, but that page is linked backward to page 206883. Please report this internal error to Sybase Technical Support.
00:00000:00014:2005/06/25 19:01:45.10 kernel  ************************************
00:00000:00014:2005/06/25 19:01:45.10 kernel  SQL causing error : EXEC sp_UpdateSystemState '20050624', '40', '20050627', '00', '0', '20050628', '20050629', '20050624180026', '3310ISC0544700000620', 'ccpcuser', '{3::
00:00000:00014:2005/06/25 19:01:45.10 kernel  ************************************
00:00000:00014:2005/06/25 19:01:45.10 server  SQL Text: EXEC sp_UpdateSystemState '20050624', '40', '20050627', '00', '0', '20050628', '20050629', '20050624180026', '3310ISC0544700000620', 'ccpcuser', '{3::CJ6:20050624:CI4:40:CJ2:20050627:CI5:00:CE4:0:72A::CJ4:20050628:CJ5:20050629:CK4:20050624180026}'
00:00000:00014:2005/06/25 19:01:45.10 kernel  curdb = 6 pstat = 0x10100 lasterror = 2628
00:00000:00014:2005/06/25 19:01:45.10 kernel  preverror = 0 transtate = 0
00:00000:00014:2005/06/25 19:01:45.10 kernel  curcmd = 195 program =                              
00:00000:00014:2005/06/25 19:01:45.10 kernel  pc 0x83e1828 ucbacktrace+0x58(0x0,0x1,0x906adcc,0x0,0x90640ec)
00:00000:00014:2005/06/25 19:01:45.10 kernel  pc 0x8187a55 terminate_process.low.usage+0x505(0x0,0xffffffff,0x8b51930,0x8251ffc,0x8b51994)
00:00000:00014:2005/06/25 19:01:45.10 kernel  pc 0x825201c close_network+0xc(0x8b51994,0x81a5e08,0x1a,0x1c,0x15)
00:00000:00014:2005/06/25 19:01:45.10 kernel  pc 0x8251ffc hdl_default+0x4c(0x1a,0x1c,0x15,0x1,0x8b519c0)
00:00000:00014:2005/06/25 19:01:45.10 kernel  pc 0x81a5e08 s_handle.low.usage+0x868(0x1a,0x1c,0x15,0x1,0x8b519c0)
00:00000:00014:2005/06/25 19:01:45.10 kernel  pc 0x80b425b ex_raise+0x17b(0x1a,0x1c,0x15,0x1,0x
00:00000:00014:2005/06/25 19:01:45.10 kernel  pc 0x8137681 linksplit.low.usage+0x321(0x8b52034,0x8b520b0,0x8b52d34,0x8dfc120,0x8b51dc
00:00000:00014:2005/06/25 19:01:45.10 kernel  pc 0x80ab527 indexsplit+0xc7(0x8b520b0,0x3,0x8b525d0,0x30,0x8b520cc)
00:00000:00014:2005/06/25 19:01:45.11 kernel  pc 0x8108c06 srchindex.low.usage+0x166(0x8b525d0,0x8b52d34,0x8b52618,0x8b52d34,0x9fe0800)
00:00000:00014:2005/06/25 19:01:45.11 kernel  pc 0x80a7119 insert_index_row+0x119(0x8dfc120,0x1b,0x8b53008,0x8b52d34,0x9fe0800)
00:00000:00014:2005/06/25 19:01:45.11 kernel  pc 0x812e92b ncupdate.low.usage+0x4b(0x8dfc120,0x2e5193f4,0x8b53008,0x9fe0800,0x8c)
00:00000:00014:2005/06/25 19:01:45.11 kernel  pc 0x811838a insert.low.usage+0x6a(0x8dfc120,0x9fe0800,0x8c,0x9fe0100,0x8b53544)
00:00000:00014:2005/06/25 19:01:45.11 kernel  pc 0x8058a5f insert_all+0x6f(0x0,0x9fe3d7c,0x8dfc120,0x9fe0800,0x8c)
00:00000:00014:2005/06/25 19:01:45.11 kernel  pc 0x80ee0ad run.low.usage+0x38d(0x9fe3d7c,0x9fe3efc,0x9fe3efc,0x9fe3d7c,0x0)
00:00000:00014:2005/06/25 19:01:45.11 kernel  pc 0x804d456 exec_eop+0x146(0x9fe3d7c,0x9fe3efc,0x8b53940,0x9fe3d7c,0x0)
00:00000:00014:2005/06/25 19:01:45.11 kernel  pc 0x804e969 execute+0x1a9(0x9fe3d04,0x9fe3d7c,0xc3,0x8b53940,0xa02b000)
00:00000:00014:2005/06/25 19:01:45.11 kernel  Handler execerr (0x821ee20)

nikii

急啊，我的支付系统不能周期切换了

chuxu

Error 2628 is due to corruption of page pointers for the object. Use the
following steps to resolve the error:
1 Identify the object using one of the pages identified in the message. Refer to “How to Find an Object Name from a Page Number” in the Encyclopedia of Tasks chapter for information.
2 If the page is a data page (index ID = 0), drop and recreate the clustered index on the table.
3 If this is an index page (index ID is greater than 0), drop and recreate the index.
4 Run dbcc pglinkage on the table to verify that the problem is corrected. Besure to check both next page and previous page pointers.

nikii

把所有索引重建了一下，搞定。
谢谢斑竹了。

ysbw511

呵呵，也是大额支付系统啊。

nikii

就是啊。现在觉得sybase好差啊。

jys1059

怎么重建的索引呀，有什么工具吗？我的sybase版本是11.0.3，可以有什么命令重建索引？

chuxu

删了索引再重建

nikii

支付系统不是有建索引的sql吗？
mbfe_Index