ERR-11118
The update log size ‘…’ is bigger than TRX_UPDATE_MAX_LOGSIZE ‘…’
Version
All versions
Explanation
This error occurs when there is a bulk modifying operation.
This error message applies only to memory tables.
Cause
In Altibase, this error occurs and the ROLLBACK is executed for the corresponding transaction when the number of redo log files due to bulk transactions exceeds TRX_UPDATE_MAX_LOGSIZE (The TRX_UPDATE_MAX_LOGSIZE property restricts the number of log files created by a DML statement.).
Action
If the transaction has to be executed with a single query only, the user is advised to change the property in a session level as follows.
ALTER SESSION SET TRX_UPDATE_MAX_LOGSIZE = 0; (Disabling property) |
However, the user should remember that the number of redo logfiles will increase and this might cause a disk full error. Also, when executing bulk operations, an X lock is acquired in a table to prevent resource increase due to MVCC. Thus, caution is advised that any SELECT or DML statements might have to wait for an X lock to be released.
Reference
N/A
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.