| Table of Contents |
|---|
Version
6.3.1
Explanation
Unable to execute query.
Cause
The query requires a stack size that exceeds the size of the stack used by Altibase to run queries (This is to prevent the waste of memory resources of the Altibase server due to maintaining a large stack.).
Action
Check whether query tuning has been performed; otherwise choose one of the two following methods.
1. Change the maximum stack size for a specific session only.
Change the maximum time of query execution. (MAX: 65536)
| Code Block | ||
|---|---|---|
| ||
ALTER SESSION SET STACK SIZE = 2048; |
2. Change the maximum stack size of all the sessions.
1) Run the statement in iSQL to change server settings.
| Code Block | ||
|---|---|---|
| ||
iSQL> ALTER SYSTEM SET QUERY_STACK_SIZE = 2048; |
2) Change QUERY_STACK_SIZE from $ALTIBASE_HOME/conf/altibase.properties.
3. Re-connect all the clients.
Reference
If the stack size is set to a value greater than needed, it may become a waste of unnecessary memory space.