The Multifunctioning DBA

Oct 23 2008   8:30PM GMT

ASE15 Stack Size

Colin Smith Colin Smith Profile: Colin Smith

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.

1  Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.
  • Princehancey
    Its is informative and helpul. Appreciate your good attitude... Thanks for sharing -Prince
    0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: