Kbase 20468: User Died During Microtransaction (2256)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/06/2009 |
|
Status: Verified
SYMPTOM(s):
User Died During Microtransaction (2256)
Database crashes
Error in log file.
SYSTEM ERROR: User died during microtransaction. (2256)
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
CAUSE:
Microtransactions occur when a record is updated that spans two or more database blocks. The update to each block that is handled separately, and transaction log records (before-image notes) are generated for the change to the blocks.
If a record has, for example, three fragments, three blocks must be updated in order to update the record. These three updates taken together are a microtransaction.
There are other types of microtransactions, such as inserting or deleting an index entry, creating or deleting a record, and so on.
Due to the way transaction rollback and crash recovery works, an unsuccessful completion of a microtransaction cannot be undone except during crash recovery (the database must be shut down). It is abnormal and unusual for a microtransaction not to be completed successfully, not an application error.
FIX:
Restart database and allow crash recovery to complete.