This is a discussion on STACKSIZE. within the Informix forums, part of the Database Server Software category; --> Hello, I recently resolved an issue with STACKSIZE on one of our test databases by using the following thread: ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello, I recently resolved an issue with STACKSIZE on one of our test databases by using the following thread: http://groups.google.com/groups?q=yi...eja.com&rnum=2 Thanks to those that contributed to this and helped me resolve the issue. The error seemed to indicate small STACKSIZE. I was, however, surprised to see that this error caused the engine to crash. From what I can gather, there were new 'improved' Stored Procs running against the database, and it was the low stack size (32K) which caused the crash. This has been raised to 128k (still crashed at 64k) and now the process during which the crash occured completes successfully. Is a crash in this scenario acceptable or expected? I didn't think so...Can any one tell why such drastic action on the engines part took place? Thanks, Simon |