Skip to content

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#

  1. Tune the query to reduce memory usage.
  2. 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#

  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.