ERR-01067 The memory size allocated for the statement has exceeded the maximum limit#
Version#
7.1.0 or later
Explanation#
This error occurs if query execution has stopped due to query preparation or execution failure.
Cause#
The amount of memory used for the statement exceeded the maximum limit. The Name in the error message shows which limit was exceeded.
- Name: Query_Prepare - The amount of memory used for query preparation exceeded PREPARE_STMT_MEMORY_MAXIMUM.
- Name: Query_Execute - The amount of memory used for query execution exceeded EXECUTE_STMT_MEMORY_MAXIMUM.
Action#
- Tune the query to reduce memory usage.
-
Increase the property that matches the Name in the error message with the ALTER SYSTEM command or altibase.properties file.
1)iSQL> ALTER SYSTEM SET PREPARE_STMT_MEMORY_MAXIMUM = 419430400; iSQL> ALTER SYSTEM SET EXECUTE_STMT_MEMORY_MAXIMUM = 2147483648;2) Change the value of PREPARE_STMT_MEMORY_MAXIMUM or EXECUTE_STMT_MEMORY_MAXIMUM from $ALTIBASE_HOME/conf/altibase.properties.
Reference#
-
PREPARE_STMT_MEMORY_MAXIMUM:
Check this property when query preparation has insufficient memory. -
EXECUTE_STMT_MEMORY_MAXIMUM:
Check this property to modify the size used by group functions.