ERR-110F0 Unable to extend the tablespace (SYS_TBS_MEM_DIC) because the database would be larger than MEM_MAX_DB_SIZE(12582912K)#
Version#
All versions
Explanation#
INSERT/UPDATE/DELETE statements cannot be executed on memory tablespaces.
Only the SELECT statement is executable.
Cause#
This error occurs when the total sum of memory tablespaces (SYS_TBS_MEM_DIC+SYS_TBS_MEM_DATA+USER_MEMORY_TABLESPACE) exceeds MEM_MAX_DB_SIZE.
Action#
MEM_MAX_DB_SIZE is the maximum amount of memory that can be used by memory tablespaces.
For further information, refer to the Altibase Monitoring Queries Guide.
The tablespace area cannot be returned unless a table is dropped. (The COMPACT command can return the blank page, but the effect is negligible.)
Therefore, if MEM_MAX_DB_SIZE is set lower than the actual amount, change the value of MEM_MAX_DB_SIZE from $ALTIBASE_HOME/conf/altibase.properties and restart the Altibase server process.
It is recommended to set the maximum value of MEM_MAX_DB_SIZE as the sum of VOLATILE_MAX_DB_SIZE and MEM_MAX_DB_SIZE within 60 to 70 percent of the physical memory.
-
Checking MEM_MAX_DB_SIZE
iSQL> SELECT value1 FROM v$property WHERE name = 'MEM_MAX_DB_SIZE'; VALUE1 ---------------------------------- 33554432 1 row selected.The above example shows the maximum size (bytes) that can be used.
-
Checking Usage
iSQL> SELECT SPACE_NAME, MAXSIZE, ALLOC_PAGE_COUNT*32*1024 FROM V$MEM_TABLESPACES; SPACE_NAME MAXSIZE ALLOC_PAGE_COUNT*32*1024 ---------------------------------------------------------------------------------- SYS_TBS_MEM_DIC 140737488322560 8421376 SYS_TBS_MEM_DATA 140737488322560 8421376 MEM_TBS 140737488322560 12615680 3 rows selected.The above example shows the current usage of the memory tablespace. There are 29,458,432 bytes allocated in total.
A maxsize value of 140737488322560 means unlimited.
For SYS_TBS_MEM_DIC and SYS_TBS_MEM_DATA, they have not reached MAXSIZE but the error has occurred because the sum of all the memory tablespaces has almost reached MEM_MAX_DB_SIZE.
The current sum shows the value of 899(29458432/32/1024) pages and the actual MEM_MAX_DB_SIZE is 1024(33554432/32/1024) pages. Thus, there are still 125 pages that can be allocated. However, as the default value of EXPAND_CHUNK_PAGE_COUNT (the number of pages by which to increase the size of the memory tablespace) is 128, it means that all the pages are currently being used. (The error occurs when MEM_MAX_DB_SIZE is exceeded because the transaction tried to expand.)
Note
Each memory tablespace has its own MAXSIZE. This error not only occurs when it has reached its MAXSIZE but also when the sum of all the memory tablespaces exceeds MEM_MAX_DB_SIZE.
-
Restarting Altibase server after increasing MEM_MAX_DB_SIZE
$ vi $ALTIBASE_HOME/conf/altibase.properties .... .... UNIXDOMAIN_FILEPATH =?/trc/cm-unix MEM_MAX_DB_SIZE = 1G <===== Change this value to the appropriate size (Using GB/MB unit) LOG_FILE_SIZE = 10M .... .... :wq! $ server restartIt needs to restart the server after modification.
-
Checkpoint Image File Size
For in-memory databases of Altibase, any modified data from in-memory databases is saved on disk when checkpointing is executed. The disk file where memory data is saved is called the Checkpoint Image file. This file cannot be resized, which means that once it is expanded, it cannot be reduced.
Note
In order to reduce the Checkpoint Image file size, REORG has to be executed. This has to be done with the migration of all data, including the disk database.
Reference#
N/A