sybase崩溃，Stack overflow detected，请问该如何解决？

guobeifen

操作系统为aix5.2,sybase版本为12.5



00:00000:00615:2005/08/31 09:07:00.41 kernel  Stack overflow detected: limit: 0x0000000165644610, sp: 0x0000000165644a38
00:00000:00615:2005/08/31 09:07:00.41 kernel  *** Stack guardword corrupted.
00:00000:00615:2005/08/31 09:07:00.43 kernel  pc: 0x00000001001e3a28 pcstkwalk[2]+0x80()
00:00000:00615:2005/08/31 09:07:00.43 kernel  pc: 0x00000001001e38a4 ucstkgentrace+0xe4()
00:00000:00615:2005/08/31 09:07:00.43 kernel  pc: 0x00000001001e35fc ucbacktrace+0xa0()
00:00000:00615:2005/08/31 09:07:00.44 kernel  pc: 0x00000001001fec68 ucstackcrash+0xa4()
00:00000:00615:2005/08/31 09:07:00.44 kernel  pc: 0x000000010021ca38 upsleepgeneric[10]+0x160()
00:00000:00615:2005/08/31 09:07:00.45 kernel  pc: 0x000000010002b034 cm_writedes[7]+0x4c()
00:00000:00615:2005/08/31 09:07:00.45 kernel  pc: 0x000000010001fbb0 bufwritedes_log[1]+0x18()
00:00000:00615:2005/08/31 09:07:00.45 kernel  pc: 0x00000001000299a0 xls_flush+0xc4()
00:00000:00615:2005/08/31 09:07:00.45 kernel  pc: 0x0000000100029794 finishlog+0x1c4()
00:00000:00615:2005/08/31 09:07:00.46 kernel  pc: 0x00000001000dafec abort__all[1]+0x20()
00:00000:00615:2005/08/31 09:07:00.46 kernel  pc: 0x00000001000db9e8 xact__rollbackxact[1]+0x158()
00:00000:00615:2005/08/31 09:07:00.46 kernel  pc: 0x00000001000dbb18 xact__rollback_local[1]+0x8()
00:00000:00615:2005/08/31 09:07:00.46 kernel  pc: 0x00000001001eccbc s_handle+0x384()
00:00000:00615:2005/08/31 09:07:00.46 kernel  pc: 0x0000000100159124 ex_raise+0x21c()
00:00000:00615:2005/08/31 09:07:00.46 kernel  pc: 0x0000000100218dd0 stack_oflow+0x2c()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010094e59c norm1[11]+0x48()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  end of stack trace, spid 615, kpid 48628454, suid 9
00:00000:00615:2005/08/31 09:07:00.47 kernel  *** Stack corrupted, server aborting.
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x00000001001e3a28 pcstkwalk[2]+0x80()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x00000001001e38a4 ucstkgentrace+0xe4()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x00000001001e35fc ucbacktrace+0xa0()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x00000001001ff17c keipanic+0x84()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x00000001001fec70 ucstackcrash+0xac()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010021ca38 upsleepgeneric[10]+0x160()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002b034 cm_writedes[7]+0x4c()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010001fbb0 bufwritedes_log[1]+0x18()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x00000001000299a0 xls_flush+0xc4()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x0000000100029794 finishlog+0x1c4()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x00000001000dafec abort__all[1]+0x20()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x00000001000db9e8 xact__rollbackxact[1]+0x158()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x00000001000dbb18 xact__rollback_local[1]+0x8()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x00000001001eccbc s_handle+0x384()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x0000000100159124 ex_raise+0x21c()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x0000000100218dd0 stack_oflow+0x2c()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010094e59c norm1[11]+0x48()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  pc: 0x000000010002d7dc nmskclr[1]+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernel  end of stack trace, spid 615, kpid 48628454, suid 9
00:00000:00615:2005/08/31 09:07:00.47 kernel  ueshutdown: exiting
00:00000:00615:2005/08/31 09:07:00.48 kernel  Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.

sun&ibm

你把stack size的值改为原值的2倍试试！！应该是stack溢出错误！

guobeifen

这个错误也不是经常出，可能一个月出个一两回吧。是不是stack size 太小了就会造成溢出的情况？

li_lsl

后来情况怎么样？我这里也碰到了同样的问题。操作系统为aix5.3,sybase版本为15.0

wfcjz

回复 4# li_lsl


    说说你的具体情况

Eisen

应该是某user在执行某个procedure的时候，侵入了stack guard area。
如果改stack size没有用处的话，试试调大stack guard area。
————当然，最最根本解决问题的还是找到那个引发故障的procedure，分析一下怎么会占用那么大的stack size才是。

wfcjz

Eisen说的好，最好看看存储编的有什么问题，不然在系统里折腾半天，到头来是应用上的问题，让人很郁闷的。