Skip to end of metadata
Go to start of metadata

Version

All versions

Explanation

Unable to execute query.

This error occurs when the execution of a certain query fails due to insufficient temporary memory.

# Example

# 5.5.1 or above

Icon

ERR-0109D : Insufficient memory

# 5.3.3

Icon

ERR-01067 : The allocated memory size of statement exceeds the maximum limit ( Name : Query_Execute, Wanted Memory Size : 1114112, Max size : 1048576 ).|"linktype="raw" wikidestination="" originalalias="ERR-01067 : The allocated memory size of statement exceeds the maximum limit ( Name : Query_Execute, Wanted Memory Size : 1114112, Max size : 1048576 ).|" class="linkerror" >ERR-01067 : The allocated memory size of statement exceeds the maximum limit ( Name : Query_Execute, Wanted Memory Size : 1114112, Max size : 1048576 ).|||||||||\

Cause

The following error description can be viewed with the AltiErr utility:

$ altierr 0x0109D
0x0109D ( 4253) idERR_ABORT_InsufficientMemory Insufficient memory

# *Cause: Insufficient memory

# *Action: Please make sure that the system has enough available memory.

The temporary area is used when executing a query including a GROUP BY or ORDER BY clause for memory. However, this temporary area also uses memory.

This error occurs due to EXECUTE_STMT_MEMORY_MAXIMUM while allocating memory to execute a query.

Action

Altibase uses memory space for temporary memory tables, instead of disk space.

Consequently, the necessary memory space must be secured at query execution with the following property:

The unit is bytes and an error occurs if more memory than the value specified for this property is used during the execution stage of query execution.

This property is set as the maximum value to prevent unnecessary memory increase.

<How to Fix the Error>

1. Check the increase in Query_Execute.

2. Check the current value of EXECUTE_STMT_MEMORY_MAXIMUM

3. Using the ALTER statement, set a value (in bytes) larger than ALLOC_SIZE for EXECUTE_STMT_MEMORY_MAXIMUM.

    Set an appropriate value by estimating how much the execution space will extend for the query.

4. To apply the change permanently, the value has to be changed in the altibase.properties file as well($ALTIBASE_HOME/conf/altibase.properties).

Reference

The EXECUTE_STMT_MEMORY_MAXIMUM property specifies the maximum memory that a single statement can use for execution, not the pre-allocation memory that a single statement can use.

Memory usage can increase as much as specified by the property. Therefore, the user is recommended to set an appropriate value.

  • No labels