[求助]error 696

tking 发表于 2007-3-12 13:23:15

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  00:00000:00087:2007/03/12 09:36:56.88 kernel  00:00000:00087:2007/03/12 09:36:56.88 kernel  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 发表于 2007-3-13 16:43:42

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

tking 发表于 2007-3-13 16:46:59

disk是raid5，raid卡带的软件检查没问题。这个问题出现频率平均在5%以下，只是有时候在一段时间内很频繁。我看了sybase的一些资料，没有提出什么办法，只是叫报告sybase。

tking 发表于 2007-3-16 14:57:32

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

tking 发表于 2007-3-20 08:52:30

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

tking 发表于 2007-3-20 16:29:41

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

tking 发表于 2007-3-31 10:13:48

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

tking 发表于 2007-5-10 11:49:27

再请高手帮忙下。

tking 发表于 2007-7-25 08:21:25

顶一下。

页: [1]

PowerBuilder(PB)BBS社区's Archiver

[求助]error 696