sybase报的堆栈错大家帮忙看看

coco_andy

今天早上发现的

01:00000:00072:2008/08/16 18:53:19.76 kernel  current process (0x5650232) infected with 11
01:00000:00072:2008/08/16 18:53:19.76 kernel  Error at address 0x4000000000ca066b (run_crtable+0x17b)
01:00000:00072:2008/08/16 18:53:19.76 kernel  ir=0000000008726800.0000000000000004
01:00000:00072:2008/08/16 18:53:19.76 kernel  pc=0000000002b92800.4000000000ca066f  psw=00000000000952e4
01:00000:00072:2008/08/16 18:53:19.76 kernel  gr0-3   0000000000000000 c00000018dc142d0 4000000000ca0703 c00000021a4ab900
01:00000:00072:2008/08/16 18:53:19.76 kernel  gr4-7   c00000018dc072d0 c0000002015e3000 0000000000000032 0000000000000000
01:00000:00072:2008/08/16 18:53:19.76 kernel  gr8-11  c00000018dc1db60 c00000021a4abcd8 000000000000c000 0000000000000000
01:00000:00072:2008/08/16 18:53:19.76 kernel  gr12-15 400000000043c640 0000000000000024 0000000000000000 0000000000000032
01:00000:00072:2008/08/16 18:53:19.76 kernel  gr16-19 00000000003a76a4 c0000001a692c970 000000000000015e 0000000000480000
01:00000:00072:2008/08/16 18:53:19.76 kernel  gr20-23 00000000004801c1 fffffffffffffcb0 0000000000000038 0000000000007fff
01:00000:00072:2008/08/16 18:53:19.77 kernel  gr24-27 c0000001a692cb88 c00000018dc072d0 00000000ffb7fe3f 8000000000600da0
01:00000:00072:2008/08/16 18:53:19.77 kernel  gr28-31 ffffffffffb7fe3f 0000000000000000 c0000000f2d831c0 0000000000000000
01:00000:00072:2008/08/16 18:53:19.77 kernel  ************************************
01:00000:00072:2008/08/16 18:53:19.77 kernel  SQL causing error : execute arith..DJ50_left_query;1 @train_date = '20080816', @train_
code='2655',@train_no = '410000265500', @station = 'XYY',  @start_coach_no = '00' ,@
01:00000:00072:2008/08/16 18:53:19.77 kernel  ************************************
01:00000:00072:2008/08/16 18:53:19.77 server  SQL Text: execute arith..DJ50_left_query;1 @train_date = '20080816', @train_code='2655
',@train_no = '410000265500', @station = 'XYY',  @start_coach_no = '00' ,@end_coach_no= 'A9' ,@left_only='0'
01:00000:00072:2008/08/16 18:53:19.77 kernel  curdb = 5 tempdb = 2 pstat = 0x18010000
01:00000:00072:2008/08/16 18:53:19.77 kernel  lasterror = 0 preverror = 0 transtate = 1
01:00000:00072:2008/08/16 18:53:19.77 kernel  curcmd = 265 program = CTMS2D
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x4000000000e9d708 pcstkwalk+0x50()
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x4000000000e9dfa8 ucstkgentrace+0x2c8()
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x4000000000e595e8 ucbacktrace+0x80()
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x40000000008e75c8 terminate_process+0xf10()
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x4000000000e761a8 kisignal+0x230()
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x400000000084d3d8 _sigreturn()
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x4000000000ca0668 run_crtable+0x178()
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x40000000007e3da8 run+0x12100()
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x40000000007ec728 exec_eop+0x5f0()
01:00000:00072:2008/08/16 18:53:19.77 kernel  [Handler pc: 0x4000000000c76a68 execerr installed by the following function:-]
01:00000:00072:2008/08/16 18:53:19.77 kernel  [Handler pc: 0x4000000000d932c0 jcsExHandler installed by the following function:-]
01:00000:00072:2008/08/16 18:53:19.77 kernel  [Handler pc: 0x4000000000c1f448 sortmerr installed by the following function:-]
01:00000:00072:2008/08/16 18:53:19.77 kernel  [Handler pc: 0x4000000000c76a68 execerr installed by the following function:-]
01:00000:00072:2008/08/16 18:53:19.77 kernel  [Handler pc: 0x4000000000c76a68 execerr installed by the following function:-]
01:00000:00072:2008/08/16 18:53:19.77 kernel  [Handler pc: 0x4000000000963870 aritherr installed by the following function:-]
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x40000000007eeaa4 execute+0x47c()
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x4000000000784b90 curs_open+0x198()
01:00000:00072:2008/08/16 18:53:19.77 kernel  [Handler pc: 0x40000000009622c0 hdl_backout installed by the following function:-]
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x40000000007f4088 s_execute+0x1de8()
01:00000:00072:2008/08/16 18:53:19.77 kernel  [Handler pc: 0x400000000066fd90 s_handle installed by the following function:-]
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x4000000000791638 sequencer+0x268()
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x40000000007932cc execproc+0x4bc()
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x40000000007f4324 s_execute+0x2084()
01:00000:00072:2008/08/16 18:53:19.77 kernel  [Handler pc: 0x400000000066fd90 s_handle installed by the following function:-]
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x4000000000791638 sequencer+0x268()
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x40000000006de518 tdsrecv_language+0xb0()
01:00000:00072:2008/08/16 18:53:19.77 kernel  [Handler pc: 0x40000000009622c0 hdl_backout installed by the following function:-]
01:00000:00072:2008/08/16 18:53:19.77 kernel  [Handler pc: 0x4000000000b85830 ut_handle installed by the following function:-]
01:00000:00072:2008/08/16 18:53:19.77 kernel  [Handler pc: 0x4000000000b85830 ut_handle installed by the following function:-]
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x4000000000768b2c conn_hdlr+0x79c()
01:00000:00072:2008/08/16 18:53:19.77 kernel  pc: 0x40000000007ee620 proc_stack_switch+0x60()
01:00000:00072:2008/08/16 18:53:19.77 kernel  end of stack trace, spid 72, kpid 90505778, suid 8

好像是在执行存储时报的 帮忙看看谢谢了

mzd73

看看存储过程调的是那些表，然后bcp out数据，删除表重建，bcp in来数据，再运行看看如何！

coco_andy

谢谢 这位大哥，但是这个存储过程是hiden，看不到。我最开始和你的想法一样。

aliking

Try the following commands:

use arith
go
sp_depends DJ50_left_query
go

chenfeng825

Error at address 0x4000000000ca066b (run_crtable+0x17b)
这个错误首先看起来像bug，确定一下版本号，如果有服务，建议作个shared memory dump给sybase
还有一些可以参考的是这个procedure是每次都错还是某些特定参数出错，如果又没有source code就比较麻烦了
相关对象是否损坏可以做dbcc看看，猜测可能性不大！