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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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: