coocool骑士请进....遇到了你以前碰到的问题

tonysong

骑士,最近我们sybase11.9 for win2000的数据库errorlog报了以下错
pc: 0x7800ffe7 MSVCRT.dll (0x3561a088, 0x3561a07e, 0xffffffe7, 0x21a72bb
00:00000:00013:2005/04/03 15:56:08.84 kernel  pc: 0x7800ffe7 MSVCRT.dll (0x3714ad30, 0x1a2e7f0, 0x2, 0x0)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x7ff0b5 bt__addrid_to_nonleafrow+ 0xf5 (0x20282ae0, 0x3714ad30, 0x1a2e7f0, 0x2)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x7fe683 bt__putrow+ 0x6a3 (0x1a2e70c, 0x3714ad30, 0x47, 0x0)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x7fdde4 bt__logandinsdel+ 0x1c4 (0x1a2e70c, 0x1a2e70c, 0x3714abd4, 0x4)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x804d02 bt__propagatesplit+ 0x1a2 (0x1a2e70c, 0x3714abd4, 0x1a2e69c, 0x1a2e670)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x7ffee9 bt__splitleaf+ 0x159 (0x1a2e70c, 0x3714abd4, 0x1a2e888, 0x0)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x7f81cb bt__insert_into_leaf+ 0x15b (0x1a2e70c, 0x0, 0x1, 0x20282ae0)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x7f78ac bt__traverseandinsert+ 0x5c (0x20282ae0, 0x1a2eb14, 0x1a2e888, 0x16)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x7f710c bt_insert+ 0x10c (0x20282ae0, 0x3c, 0x1a2f2c0, 0x21b388b0)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x570448 dol__ncinsert+ 0xd8 (0x20282ae0, 0x21b388b0, 0x6f, 0x21b388b0)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x56ef83 dol_insert+ 0x343 (0x20282ae0, 0x21b388b0, 0x6f, 0x20639aa0)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x53e08d insert+ 0x36d (0x0, 0x21c3b418, 0x20282ae0, 0x21b388b0)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x53dc91 insert_all+ 0x71 (0x21c3b418, 0x21c3b594, 0x21c3b418, 0x21c3b594)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x6f8c94 run+ 0x13174 (0x21c3b418, 0x21c3b594, 0x1a2fd34, 0x20639aa0)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x6d697b exec_eop+ 0x50b (0x21c3b3a0, 0x21c3b418, 0xc3, 0x1a2fd34)
00:00000:00013:2005/04/03 15:56:08.85 kernel  [Handler pc: 0x6da130 execerr  installed by the following function:-]
00:00000:00013:2005/04/03 15:56:08.85 kernel  [Handler pc: 0x68fb50 sortmerr  installed by the following function:-]
00:00000:00013:2005/04/03 15:56:08.85 kernel  [Handler pc: 0x6da130 execerr  installed by the following function:-]
00:00000:00013:2005/04/03 15:56:08.85 kernel  [Handler pc: 0x6da130 execerr  installed by the following function:-]
00:00000:00013:2005/04/03 15:56:08.85 kernel  [Handler pc: 0x635bb0 aritherr  installed by the following function:-]
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x6d573e execute+ 0x26e (0x21, 0x20639aa0, 0x20639aa0, 0x205cd790)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x654d4c s_execute+ 0x280c (0x21c3a800, 0x21, 0x20640cdd, 0x20639aa0)
00:00000:00013:2005/04/03 15:56:08.85 kernel  [Handler pc: 0x6398a0 s_handle  installed by the following function:-]
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x63678f sequencer+ 0x15f (0x0, 0x200152b4, 0x260026, 0x2001391c)
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x436d31 tdsrecv_language+ 0xc1 (0x7, 0x4000, 0x200152b4, 0x260026)
00:00000:00013:2005/04/03 15:56:08.85 kernel  [Handler pc: 0x452660 hdl_backout  installed by the following function:-]
00:00000:00013:2005/04/03 15:56:08.85 kernel  [Handler pc: 0x5c0c40 ut_handle  installed by the following function:-]
00:00000:00013:2005/04/03 15:56:08.85 kernel  [Handler pc: 0x5c0c40 ut_handle  installed by the following function:-]
00:00000:00013:2005/04/03 15:56:08.85 kernel  pc: 0x40dc1c conn_hdlr+ 0xb5c (0x200152b4, 0x2001391c, 0x260026, 0x200152b4)
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x89c1c6 kpntwrapper+ 0x96 (0x89c130, 0x200152b4, 0x0, 0x0)
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x77e6438b KERNEL32.dll (0xc3, 0x1, 0x53ae5d, 0x21c3b41
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x77e61608 KERNEL32.dll (0x1a2fd8c, 0x63c9b2, 0x21b38884, 0x1)
00:00000:00013:2005/04/03 15:56:08.89 kernel  end of stack trace, spid 13, kpid 2555943, suid 6
00:00000:00013:2005/04/03 15:56:08.89 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x40664d terminate_process+ 0xbcd (0x270027, 0xffffffff, 0x1998, 0x0)
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x40664d terminate_process+ 0xbcd (0xc0000005, 0x7800bdb5, 0x1a2de68, 0x0)
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x85b56e kiexception+ 0x1ee (0x200152b4, 0x2001391c, 0x260026, 0x200152b4)
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x89c23d kpntwrapper+ 0x10d (0x89c130, 0x200152b4, 0x0, 0x0)
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x77e6438b KERNEL32.dll (0xc3, 0x1, 0x53ae5d, 0x21c3b41
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x77e61608 KERNEL32.dll (0x1a2fd8c, 0x63c9b2, 0x21b38884, 0x1)
00:00000:00013:2005/04/03 15:56:08.89 kernel  end of stack trace, spid 13, kpid 2555943, suid 6
00:00000:00013:2005/04/03 15:56:08.89 kernel  ************************************
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x1a2cfd4, 0x270027, 0x1a2cfd4, 0x0)
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x1a2cfd4, 0x1a2d528, 0x270f, 0x2)
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x883514 pcstkwalk+ 0x224 (0x270027, 0x2, 0x270f, 0x0)
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x8830ae ucstkgentrace+ 0x1ce (0x270027, 0x1, 0xc0000005, 0x20639aa0)
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x862864 ucbacktrace+ 0x84 (0x270027, 0xffffffff, 0x1998, 0x0)
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x406810 terminate_process+ 0xd90 (0xc0000005, 0x7800bdb5, 0x1a2d91c, 0x0)
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x85b56e kiexception+ 0x1ee (0x200152b4, 0x2001391c, 0x260026, 0x200152b4)
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x89c23d kpntwrapper+ 0x10d (0x89c130, 0x200152b4, 0x0, 0x0)
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x77e6438b KERNEL32.dll (0xc3, 0x1, 0x53ae5d, 0x21c3b41
00:00000:00013:2005/04/03 15:56:08.89 kernel  pc: 0x77e61608 KERNEL32.dll (0x1a2fd8c, 0x63c9b2, 0x21b38884, 0x1)
00:00000:00013:2005/04/03 15:56:08.89 kernel  end of stack trace, spid 13, kpid 2555943, suid 6
00:00000:00009:2005/04/03 15:56:08.89 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00009:2005/04/03 15:56:08.90 kernel  pc: 0x496371 buf_cachesearch+ 0x71 (0x20dc4370, 0xc80, 0x6, 0x2061d69
00:00000:00009:2005/04/03 15:56:08.90 kernel  pc: 0x496371 buf_cachesearch+ 0x71 (0x2061d698, 0x2, 0x20, 0x196fd10)
00:00000:00009:2005/04/03 15:56:08.90 kernel  pc: 0x48f5b0 bufsearch+ 0xf0 (0x2061d698, 0x2, 0x20, 0x196fd10)
00:00000:00009:2005/04/03 15:56:08.90 kernel  pc: 0x540339 getpage_with_validation+ 0xe9 (0x201d69e0, 0x20bddfe0, 0x0, 0x2000a334)
00:00000:00009:2005/04/03 15:56:08.90 kernel  pc: 0x4c25fd systs_desorides_flush+ 0x16d (0x7, 0x4, 0x200328d0, 0x7)
00:00000:00009:2005/04/03 15:56:08.90 kernel  [Handler pc: 0x4c39c0 hk_gcstats_handler  installed by the following function:-]
00:00000:00009:2005/04/03 15:56:08.90 kernel  pc: 0x4c33f9 hk_flushstats+ 0x459 (0x7, 0x2000f940, 0x0, 0x0)
00:00000:00009:2005/04/03 15:56:08.90 kernel  [Handler pc: 0x452660 hdl_backout  installed by the following function:-]
00:00000:00009:2005/04/03 15:56:08.90 kernel  pc: 0x49ab8b hk__run_other_chores+ 0x16b (0x0, 0x1e, 0x7, 0x0)
00:00000:00009:2005/04/03 15:56:08.90 kernel  pc: 0x499a47 hk__cycle_chores+ 0x177 (0x2001463c, 0x196ffb4, 0x196ffb4, 0x89c1c6)
00:00000:00009:2005/04/03 15:56:08.90 kernel  pc: 0x49971f hk__chores+ 0x4bf (0x0, 0x4000, 0x2001463c, 0x520050)
00:00000:00009:2005/04/03 15:56:08.90 kernel  pc: 0x499237 housekeeper+ 0xa7 (0x2001463c, 0x520045, 0x520050, 0x2001463c)
00:00000:00009:2005/04/03 15:56:08.90 kernel  pc: 0x89c1c6 kpntwrapper+ 0x96 (0x0, 0x0, 0x0, 0x0)
00:00000:00009:2005/04/03 15:56:08.90 kernel  pc: 0x77e6438b KERNEL32.dll (0xaef2c033, 0xd8f7c18b, 0x8302e883, 0x3f771ef
00:00000:00009:2005/04/03 15:56:08.90 kernel  pc: 0x77e61608 KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00009:2005/04/03 15:56:08.90 kernel  end of stack trace, spid 9, kpid 1310740, suid 0
00:00000:00009:2005/04/03 15:56:08.90 kernel  ************************************
00:00000:00009:2005/04/03 15:56:08.90 kernel  curdb = 1 pstat = 0x0 lasterror = 0
00:00000:00009:2005/04/03 15:56:08.90 kernel  preverror = 0 transtate = 1
00:00000:00009:2005/04/03 15:56:08.90 kernel  curcmd = 0 program =                              
00:00000:00000:2005/04/03 15:57:48.89 kernel  timeslice -500, current process infected
00:00000:00009:2005/04/03 15:57:48.89 kernel  SQL Server system exception (0xe0000001) generated by a process exceeding its time slice allotment.
00:00000:00009:2005/04/03 15:57:48.89 kernel  pc: 0x77e6e592 KERNEL32.dll (0xe0000001, 0x1, 0x0, 0x0)
00:00000:00009:2005/04/03 15:57:48.89 kernel  pc: 0x77e6e592 KERNEL32.dll (0x49a6e7, 0x2061cdd0, 0x0, 0x4)
00:00000:00009:2005/04/03 15:57:48.89 kernel  pc: 0x89c276 kpntraise+ 0x26 (0xc0000005, 0x2061cdd0, 0xa5d230, 0x0)
00:00000:00009:2005/04/03 15:57:48.89 kernel  pc: 0x8725d9 spinobtain+ 0x19 (0x140014, 0xffffffff, 0xd20, 0x0)
00:00000:00009:2005/04/03 15:57:48.89 kernel  pc: 0x4062d6 terminate_process+ 0x856 (0xc0000005, 0x7800bdb5, 0x196f7d0, 0x0)
00:00000:00009:2005/04/03 15:57:48.89 kernel  pc: 0x85b56e kiexception+ 0x1ee (0x2001463c, 0x520045, 0x520050, 0x2001463c)
00:00000:00009:2005/04/03 15:57:48.89 kernel  pc: 0x89c23d kpntwrapper+ 0x10d (0x0, 0x0, 0x0, 0x0)
00:00000:00009:2005/04/03 15:57:48.89 kernel  pc: 0x77e6438b KERNEL32.dll (0xaef2c033, 0xd8f7c18b, 0x8302e883, 0x3f771ef
00:00000:00009:2005/04/03 15:57:48.89 kernel  pc: 0x77e61608 KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00009:2005/04/03 15:57:48.89 kernel  end of stack trace, spid 9, kpid 1310740, suid 0
00:00000:00009:2005/04/03 15:57:48.89 kernel  ************************************
00:00000:00009:2005/04/03 15:57:48.89 kernel  pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x196e8a0, 0x140014, 0x196e8a0, 0x0)
00:00000:00009:2005/04/03 15:5

好象跟你以前发的贴子一样,你是如何解决的?

chuxu

打一下补丁吧

coocool

好是是表的索引坏了，我是把表删了又重建的，就好了
但是过一段时间又出现同样的问题
不知道如何杜绝该问题再次发生也不知道如何彻底解决该问题

lovebaobao

楼主 我也遇到了你说的问题
非常恐慌 请楼主赐教 你是怎么解决的 该问题啊
弟弟 急~
请回 或者 QQ通知我好吗 99939756
谢谢 ！