Posted by: Colin Smith
Database, DBA, Sybase
I am currently working on upgrading one of our applications from ASE12.5 to ASE15 and the developers are in the middle of testing. This morning I got a call saying that the developer working on this could no longer connect to the server. I looked into it and found that the server was shutdown. I started it back up and started working on something else. I get a call in about 5 minutes saying that again, she can not connect. I look and the server is shutdown. I open up the log file this time to find out what she is doing that is making the server crash and I see that I have a “Stack Overflow” error. I started looking into this, since I am still pretty new to Sybase, and I see that I essentially have two options to resolve this problem. I can have the developers break the job into smaller SQL statements or I can change the Stack Size. So I started doing that by using ‘sp_configure “stack size”, new_value’. This is a static option and the server must be restarted after making the change. I added 50% more to the Stack Size and now the job is running as expected. Hope this can help someone that is having the same problem.