ERR-21013

Calculation stack overflow

Version
Explanation
Cause
Action
Reference

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)

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.

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.

These documents are for informational purposes only. These information contained herein is not warranted to be error-free and is subject to change without notice. Decisions pertaining to Altibase’s product characteristics, features and development roadmap are at the sole discretion of Altibase. Altibase may own related patents, trademarks, copyright or other intellectual property rights of products and/or features discussed in this document.