In the case of this error message, this error may occur for the same error cause or another error may occur depending on the Altibase version.
In addition, the cause of the error may be different depending on the version of Altibase for this error message.
# Results from version 5.5.1 or later
# Result of execution in version 5.3.3
The description of the error can be checked using the altierr utility as follows.
When performing queries such as order by and group by on a memory table, the temporary area is used. The temporary area also uses memory space.
This error occurs when the ALTIBASE HDB server makes a memory allocation request to execute a query and an error is returned by the EXECUTE_STMT_MEMORY_MAXIMUM attribute value.
The value of the following property must be increased.
1. If the error occurs during query execution, check the "EXECUTE_STMT_MEMORY_MAXIMUM" property value with the following SQL statement.
2. Increase the property value appropriately with the ALTER statement. (The unit is byte.)
The following is an example of setting to 2G.
3. The above command is applied to the entire server after execution, but it is applied as the setting value of the property file when Altibase is restarted.
Therefore, to apply it permanently, the property value must be changed in the property file as well.
Change the property value in the $ALTIBASE_HOME/conf/altibase.properties file as above.
The EXECUTE_STMT_MEMORY_MAXIMUM property specifies the maximum value, and memory is not allocated as much as the preset value.
However, the memory usage may increase as much as the set value, so be careful when setting it.
Therefore, it is recommended to increase it appropriately empirically rather than setting it large in advance.
The "Insufficient memory" error can be a number of memory allocation failure errors in addition to the cases described here.
Therefore, if the above solutions do not solve the problem, please contact Altibase Technical Support.