[求助]error 696

tking

免费乐捐，感谢支持

sybase 11.9.2，经常出现696错误，导致客户端不能建立与服务的连接。重启后还会出现。

errorlog提示：

00:00000:00087:2007/03/12 09:36:56.88 server  Error: 696, Severity: 21, State: 1
00:00000:00087:2007/03/12 09:36:56.88 server  An attempt was made to fetch logical page '887824' in tempdb from cache
 'dbtemp'. Page belongs to object '8' and not to object '-5701649'. Restart of SQL Server will clear the error.
Please contact your System Administrator for help.
00:00000:00087:2007/03/12 09:36:56.88 kernel  ************************************
00:00000:00087:2007/03/12 09:36:56.88 kernel  SQL causing error : SELECT convert ( char ( 1 ) , datepart ( dw , getdate ( ) )
 ) , convert ( char ( 2 ) , datepart ( hh , getdate ( ) ) ) from XTMC
00:00000:00087:2007/03/12 09:36:56.88 kernel  ************************************
00:00000:00087:2007/03/12 09:36:56.88 server  SQL Text: SELECT convert ( char ( 1 ) , datepart ( dw , getdate ( ) ) ) ,
convert ( char ( 2 ) , datepart ( hh , getdate ( ) ) ) from XTMC
00:00000:00087:2007/03/12 09:36:56.88 kernel  curdb = 6 pstat = 0x10000 lasterror = 696
00:00000:00087:2007/03/12 09:36:56.88 kernel  preverror = 0 transtate = 0
00:00000:00087:2007/03/12 09:36:56.88 kernel  curcmd = 0 program = grft_TM                      
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x439f224, 0xd10007c, 0x439f224, 0x0)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x439f224, 0x439f778, 0x270f, 0x2)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x883514 pcstkwalk+ 0x224 (0xd10007c, 0x2, 0x270f, 0x0)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x8830ae ucstkgentrace+ 0x1ce (0x0, 0x1, 0x20ce5970, 0x0)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x862864 ucbacktrace+ 0x84 (0x0, 0xffffffff, 0x439fb3c, 0x4527a8)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x405fe6 terminate_process+ 0x566 (0x439fbb4, 0x4523bc, 0x6, 0x60)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x4527ea close_network+ 0x1a (0x6, 0x60, 0x15, 0x1)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x4527a8 hdl_default+ 0x48 (0x6, 0x60, 0x15, 0x1)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x4523bc ex_raise+ 0x13c (0x706d6e44, 0x20645c2c, 0x1, 0x0)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x542d6e wrongpage+ 0x31e (0x20645c2c, 0x4, 0x0, 0x0)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x540482 getpage_with_validation+ 0x232 (0x20645c2c, 0x439fd54, 0x4, 0x0)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x5419eb getpage_noscan_with_validation+ 0x8b (0x20645c2c, 0x23fab758, 0x1, 0x0)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x4f8577 pg_objdeall+ 0x137 (0x20645c2c, 0x20ce0498, 0x0, 0x20016390)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x52f60f closetable+ 0x23f (0x6, 0x10, 0xc, 0x0)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x6511d1 close_range+ 0x2a1 (0x20ce0498, 0x0, 0x0, 0x20ce0498)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x63a6ce s_cleanframe+ 0x4e (0x20ce0498, 0x0, 0x20ce0498, 0xd0f0015)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x4106d0 clean_process+ 0x80 (0x20ce0498, 0x2001b4f0, 0xd0f0015, 0x20016390)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x40cc63 conn_hdlr_err_cleanup+ 0x83 (0x36, 0x4000, 0x2001b4f0, 0xd0f0015)
00:00000:00087:2007/03/12 09:36:56.88 kernel  [Handler pc: 0x452660 hdl_backout  installed by the following function:-]
00:00000:00087:2007/03/12 09:36:56.88 kernel  [Handler pc: 0x5c0c40 ut_handle  installed by the following function:-]
00:00000:00087:2007/03/12 09:36:56.88 kernel  [Handler pc: 0x5c0c40 ut_handle  installed by the following function:-]
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x40f0e4 conn_hdlr+ 0x2024 (0x2001b4f0, 0x20016390, 0xd0f0015, 0x2001b4f0)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x89c1c6 kpntwrapper+ 0x96 (0x89c130, 0x2001b4f0, 0x0, 0x0)
00:00000:00087:2007/03/12 09:36:56.88 kernel  pc: 0x77e6b396 KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00087:2007/03/12 09:36:56.88 kernel  end of stack trace, spid 87, kpid 219152508, suid 5
00:00000:00087:2007/03/12 09:36:56.88 server  Starting diagnostics for read failure:
00:00000:00087:2007/03/12 09:36:56.88 server  Device Information:
     Device number = 14
     Phyname = d:\data\tempdbd02.dat
00:00000:00087:2007/03/12 09:36:56.88 server  Buffer Information:
     Buf addr = 0x706d6e44, Mass addr = 0x706d6e44
     Buf pageno = 887824, Mass pageno = 887824, dbid = 2
00:00000:00087:2007/03/12 09:36:56.88 server 
     Buf virtpg = 235717648, Mass virtpg = 235717648
     Buf stat = 0x1, Mass stat = 0x40201008
     Mass keep = 1, Mass awaited = 0
00:00000:00087:2007/03/12 09:36:56.88 server  Page Information from first read attempt:
     Page read from cache
     ppageno = 887824, pobjid = 8, pindid = 0
     pnextpg = 887825, pprevpg = 887823
     plevel = 0, pstat = 0x105
     pts_hi = 1, pts_lo = 126645810
00:00000:00087:2007/03/12 09:36:56.88 server  Page Information from second read attempt:
     Page read from disk
     ppageno = 887824, pobjid = 8, pindid = 0
     pnextpg = 887825, pprevpg = 887823
     plevel = 0, pstat = 0x105
     pts_hi = 1, pts_lo = 126645810
00:00000:00087:2007/03/12 09:36:56.88 server  SDES Information:
     dbid = 2, objid = -5701649, scur.pageid = 887824
     sstat = 0x10, sstat2 = 0x0
     suid = 3, cacheid = 1
00:00000:00087:2007/03/12 09:36:56.88 server  PSS Information:
     pstat = 0x10000, pcurdb = 6, pspid = 87
     p2stat = 0x101000, p3stat = 0x81a
     plasterror = 696, preverror = 0, pattention = 0

flybean

检查一下DISK,有可能DISK有问题

tking

disk是raid5，raid卡带的软件检查没问题。

这个问题出现频率平均在5%以下，只是有时候在一段时间内很频繁。

我看了sybase的一些资料，没有提出什么办法，只是叫报告sybase。

tking

非常郁闷，有高手指点一下吗？

tking

曾经重起过系统，不久问题有出现了！

tking

可能错误出现在tempdb上，怎么样删除tempdb的device，然后再重建呢？

tking

tempdb有3个devices，有两个出现这样的问题，可否修改sysusages相关记录，然后删除问题devices，再重建？

重建服务很麻烦。

tking

免费乐捐，感谢支持

再请高手帮忙下。

tking

顶一下。