sybase12.5報(bào)錯(cuò)，還請(qǐng)大俠幫診斷診斷

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列的頁(yè)鏈有問(wèn)題。
修復(fù)一下這張表。

fj8172@126.com

回復(fù) 2# andkylee

我這報(bào)錯(cuò)的表每天都不一樣,但是page那個(gè)是一樣的,如何修復(fù)?


   

andkylee

回復(fù) 3# fj8172@126.com


    不是的。
如果報(bào)錯(cuò)的頁(yè)號(hào)是一樣的，則損壞對(duì)象也應(yīng)該一樣。你使用dbcc page查看該頁(yè)所屬對(duì)象。