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:

[ERR-01067 : The allocated memory size of statement exceeds the maximum limit ( Name : Query_Execute, Wanted Memory Size : 1114112, Max size : 1048576 ).]

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)

iSQL> ALTER SYSTEM SET PREPARE_STMT_MEMORY_MAXIMUM = 419430400;

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.

Copyright ⓒ 2000~2016 Altibase Corporation. All Rights Reserved.

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.