ERR-01067 The memory size allocated for the statement has exceeded the maximum limit

Version

5.5.1 or above

# For 5.3.3, the following error message is output:

Explanation

This error occurs if query execution has stopped due to query preparation failure.

Cause

The amount of memory used for query preparation exceeded PREPARE_STMT_MEMORY_MAXIMUM.

Action

1. Tune the query to reduce memory usage.
2. Increase the memory usage for query execution with the ALTER SYSTEM command or altibase.properties file.
 1)

 2) Change the value of PREPARE_STMT_MEMORY_MAXIMUM from $ALTIBASE_HOME/conf/altibase.properties.

Reference

1. PREPARE_STMT_MEMORY_MAXIMUM: 

Check this property when query preparation has insufficient memory.

2. EXECUTE_STMT_MEMORY_MAXIMUM: 

Check this property to modify the size used by group functions.