sybase12.5报错，还请大侠帮诊断诊断

fj8172@126.com

01:00000:00057:2015/05/18 15:47:47.84 kernel  Cannot read, host process disconnected:  2276 spid: 57
01:00000:00061:2015/05/18 23:30:01.52 server  Error: 2628, Severity: 21, State: 1
01:00000:00061:2015/05/18 23:30:01.53 server  In database 'zcdynadb', page 42255874 is linked forward to page 42255873, but that page is linked backward to page 42255873. Please report this internal error to Sybase Technical Support.
01:00000:00061:2015/05/18 23:30:01.54 kernel  ************************************
01:00000:00061:2015/05/18 23:30:01.56 kernel  SQL causing error : create table uptransferstat150518(stime datetime null,prov_id tinyint null,city_id tinyint null,s_optid tinyint null,d_optid tinyint null,islocal tiny
01:00000:00061:2015/05/18 23:30:01.56 kernel  ************************************
01:00000:00061:2015/05/18 23:30:01.56 server  SQL Text: create table uptransferstat150518(stime datetime null,prov_id tinyint null,city_id tinyint null,s_optid tinyint null,d_optid tinyint null,islocal tinyint null,cf tinyint null,cfcount int null,iamduration float null)
01:00000:00061:2015/05/18 23:30:01.56 kernel  curdb = 5 tempdb = 2 pstat = 0x10000
01:00000:00061:2015/05/18 23:30:01.57 kernel  lasterror = 2628 preverror = 0 transtate = 0
01:00000:00061:2015/05/18 23:30:01.57 kernel  curcmd = 0 program = isql                          
01:00000:00061:2015/05/18 23:30:01.62 kernel  pc: 0x00000000808f6818 pcstkwalk+0x28(0x0000010004682b38, 0x00000100046822b0, 0x000000000000270f, 0x0000000000000002, 0x0000000000000000)
01:00000:00061:2015/05/18 23:30:01.62 kernel  pc: 0x00000000808f65f0 ucstkgentrace+0xbc(0x000000006980006d, 0x0000000000000000, 0x00000100104b6968, 0x0000000000000000, 0x00000100151ed430)
01:00000:00061:2015/05/18 23:30:01.62 kernel  pc: 0x000000008089f8c8 ucbacktrace+0x84(0x0000000000000000, 0x0000000000000001, 0x000000000000001e, 0x00000100104caadc, 0x0000010000000000)
01:00000:00061:2015/05/18 23:30:01.63 kernel  pc: 0x000000008025131c terminate_process+0x860(0x00000100104b6968, 0x000000000000a400, 0x00000100104be710, 0x00000000802ace94, 0x00000100104be2c0)
01:00000:00061:2015/05/18 23:30:01.63 kernel  pc: 0x00000000802acea8 hdl_default+0x58(0x000000000000001a, 0x000000000000001c, 0x0000000000000015, 0x0000000000000001, 0x0000010004683060)
01:00000:00061:2015/05/18 23:30:01.63 kernel  pc: 0x00000000802ac820 ex_raise+0x1d8(0x0000000000000015, 0x0000000000000001, 0x0000000000000000, 0x00000100104be5a8, 0x00000100104be2c0)
01:00000:00061:2015/05/18 23:30:01.63 kernel  pc: 0x00000000803e5e00 linksplit+0x574(0x00000100046838b0, 0x00000100c44a2878, 0x000000000000002c, 0x0000000000000001, 0x0000000000000000)
01:00000:00061:2015/05/18 23:30:01.63 kernel  pc: 0x00000000803e64bc datasplit+0x3d8(0x00000100046838b0, 0x00000100c44a2878, 0x000000000000002c, 0x0001000000000000, 0x00000100104b696
01:00000:00061:2015/05/18 23:30:01.64 kernel  pc: 0x00000000802005d0 cinsert+0x2ec(0x000000008113f636, 0x000000008113f630, 0x000000000000002c, 0x0000000000000000, 0x0000000000001000)
01:00000:00061:2015/05/18 23:30:01.64 kernel  pc: 0x000000008020ba28 ins_insert+0x13c(0x00000100104b7ac8, 0x0000010004683b40, 0x000000000000002c, 0x0000010004683b40, 0x0000000000000000)
01:00000:00061:2015/05/18 23:30:01.64 kernel  [Handler pc: 0x00000000804fad28 ut_handle installed by the following function:-]
01:00000:00061:2015/05/18 23:30:01.64 kernel  [Handler pc: 0x00000000804fad28 ut_handle installed by the following function:-]
01:00000:00061:2015/05/18 23:30:01.64 kernel  [Handler pc: 0x00000000804fad28 ut_handle installed by the following function:-]
01:00000:00061:2015/05/18 23:30:01.64 kernel  pc: 0x0000000080472da8 crt_cols+0x14bc(0x00000100104b7ac8, 0x00000100155c8f00, 0x0000000000000000, 0x00000100104b7580, 0x0000000000004000)
01:00000:00061:2015/05/18 23:30:01.64 kernel  [Handler pc: 0x00000000804fad28 ut_handle installed by the following function:-]
01:00000:00061:2015/05/18 23:30:01.64 kernel  pc: 0x0000000080470090 crt_main+0x1ac8(0x0000000000000001, 0x0000000000000000, 0x0000000000000001, 0x0000000000000001, 0x000000000000785
01:00000:00061:2015/05/18 23:30:01.64 kernel  [Handler pc: 0x0000000080589a14 tmp_hdl installed by the following function:-]
01:00000:00061:2015/05/18 23:30:01.64 kernel  pc: 0x0000000080589718 tmp_definition+0xe4(0x0000010017670ee0, 0x00000100177b1ea8, 0x0000010017654800, 0x0000000000000001, 0x00000100104b696
01:00000:00061:2015/05/18 23:30:01.67 kernel  [Handler pc: 0x0000000000000000  installed by the following function:-]
01:00000:00061:2015/05/18 23:30:01.67 kernel  pc: 0x00000000805892a8 tmp_create+0x5f0(0x0000010017654b78, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
01:00000:00061:2015/05/18 23:30:01.67 kernel  end of stack trace, spid 61, kpid 1769996397, suid 3

andkylee

某张表上的text列的页链有问题。
修复一下这张表。

fj8172@126.com

回复 2# andkylee

我这报错的表每天都不一样,但是page那个是一样的,如何修复?


   

andkylee

回复 3# fj8172@126.com


    不是的。
如果报错的页号是一样的，则损坏对象也应该一样。你使用dbcc page查看该页所属对象。