论坛 › Sybase › sybase崩溃，Stack overflow detected，请问该如何解决？

guobeifen 发表于 2005-08-31 09:35

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

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



00:00000:00615:2005/08/31 09:07:00.41 kernelStack 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 kernelpc: 0x00000001001e3a28 pcstkwalk+0x80()
00:00000:00615:2005/08/31 09:07:00.43 kernelpc: 0x00000001001e38a4 ucstkgentrace+0xe4()
00:00000:00615:2005/08/31 09:07:00.43 kernelpc: 0x00000001001e35fc ucbacktrace+0xa0()
00:00000:00615:2005/08/31 09:07:00.44 kernelpc: 0x00000001001fec68 ucstackcrash+0xa4()
00:00000:00615:2005/08/31 09:07:00.44 kernelpc: 0x000000010021ca38 upsleepgeneric+0x160()
00:00000:00615:2005/08/31 09:07:00.45 kernelpc: 0x000000010002b034 cm_writedes+0x4c()
00:00000:00615:2005/08/31 09:07:00.45 kernelpc: 0x000000010001fbb0 bufwritedes_log+0x18()
00:00000:00615:2005/08/31 09:07:00.45 kernelpc: 0x00000001000299a0 xls_flush+0xc4()
00:00000:00615:2005/08/31 09:07:00.45 kernelpc: 0x0000000100029794 finishlog+0x1c4()
00:00000:00615:2005/08/31 09:07:00.46 kernelpc: 0x00000001000dafec abort__all+0x20()
00:00000:00615:2005/08/31 09:07:00.46 kernelpc: 0x00000001000db9e8 xact__rollbackxact+0x158()
00:00000:00615:2005/08/31 09:07:00.46 kernelpc: 0x00000001000dbb18 xact__rollback_local+0x8()
00:00000:00615:2005/08/31 09:07:00.46 kernelpc: 0x00000001001eccbc s_handle+0x384()
00:00000:00615:2005/08/31 09:07:00.46 kernelpc: 0x0000000100159124 ex_raise+0x21c()
00:00000:00615:2005/08/31 09:07:00.46 kernelpc: 0x0000000100218dd0 stack_oflow+0x2c()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010094e59c norm1+0x48()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelend 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 kernelpc: 0x00000001001e3a28 pcstkwalk+0x80()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x00000001001e38a4 ucstkgentrace+0xe4()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x00000001001e35fc ucbacktrace+0xa0()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x00000001001ff17c keipanic+0x84()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x00000001001fec70 ucstackcrash+0xac()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010021ca38 upsleepgeneric+0x160()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002b034 cm_writedes+0x4c()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010001fbb0 bufwritedes_log+0x18()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x00000001000299a0 xls_flush+0xc4()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x0000000100029794 finishlog+0x1c4()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x00000001000dafec abort__all+0x20()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x00000001000db9e8 xact__rollbackxact+0x158()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x00000001000dbb18 xact__rollback_local+0x8()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x00000001001eccbc s_handle+0x384()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x0000000100159124 ex_raise+0x21c()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x0000000100218dd0 stack_oflow+0x2c()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010094e59c norm1+0x48()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelpc: 0x000000010002d7dc nmskclr+0x68()
00:00000:00615:2005/08/31 09:07:00.47 kernelend of stack trace, spid 615, kpid 48628454, suid 9
00:00000:00615:2005/08/31 09:07:00.47 kernelueshutdown: exiting
00:00000:00615:2005/08/31 09:07:00.48 kernelAbnormal exit detected - SQL Server process level execution bindings will be cleared on startup.

sun&ibm 发表于 2005-08-31 09:50

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

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

guobeifen 发表于 2005-08-31 11:00

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

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

li_lsl 发表于 2010-10-18 15:08

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

wfcjz 发表于 2010-10-18 16:24

回复 4# li_lsl


    说说你的具体情况

Eisen 发表于 2010-10-19 12:33

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

wfcjz 发表于 2010-10-20 08:07

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

查看完整版本: sybase崩溃，Stack overflow detected，请问该如何解决？