Compensation mechanism

What is compensation all about?

*Isolation level: what changes of a transaction T are exposed to other transactions *

Postgres does not implement the READ-UNCOMMITTED isolation level. We have to notify the clients ASAP on entities that are changing status, this implies committing database changes ASAP before the asynchronous tasks associated with the relevant command are complete and in order to keep transactions as short as possible, create a entity change log which we can use to revert the changes if any asynchronous task fails. The process of logging those changes and roll back them if something fails is called compensation.

Compensation change log

Change log is recorded in the database in the business_entity_snapshot table

       Column      |          Type          | Modifiers 
  id              | uuid                   | not null
  command_id      | uuid                   | not null
  command_type    | character varying(256) | not null
  entity_id       | character varying(128) | 
  entity_type     | character varying(128) | 
  entity_snapshot | text                   | 
  snapshot_class  | character varying(128) | 
  snapshot_type   | integer                | 
  insertion_order | integer                |

Each command may affect multiple entities A parent command may call other commands as part of its execution.

What changes are logged?

   Insertion – the ID of the new entity (compensation = delete entity by Id)
   Deletion – the deleted entity (compensation = re-insertion of the entity)
   Update – the entity before the change (compensation = update entity with “old values”)
   UpdateStatus – the status before change (compensation = update entity with “old status” - this is an optimization)

BusinessEntity interface

All compensatable entities must implement BusinessEntity interface This interface exposes the get/set of the entity ID The business entity must be serializable, so does the type of the ID in order to log the changes


   CHANGED_ENTITY – update/delete
   NEW_ENTITY_ID – insert
   CHANGED_STATUS_ONLY – update status 


CompensationContext provides the API for adding entries to the “change log” and to flush the “change log” to DB

When to compensate?

   Exception in execution has occurred
   The status of the transaction is inactive (if code is run in transaction)
   Failure in execution
   Server restart with existing entries at business_entity_snapshot

Example: ActivateStorageDomainCommand

ChangeStorageDomainStatusInTransaction – change storage domain status to LOCKED, in a transaction + compensation code (pay attention – the code is run in a transaction scope which is comitted prior to the next step) ActivateStorageDomainCommand VDS command is executed (this takes some time) If VDS command successful

   Perform some stuff
   Change storage domain status to active (in transaction  + compensation code)
   Perform some other stuff


Make sure your entity implements BusinessEntitySnapshot Make sure its DAO implements ModificationDao and StatusAwareDao (optional, for status changes optimization) Add at DbFacade.mapEntityToDAO an entry that maps the entity to its DAO

Using compensation at a command

Implement a CTOR that takes a commandId as parameter for Compensation after server restart Annotate the command with @NonTransactiveCommandAttribute(forceCompensation=true) in order to eliminate creation of transaction that wraps the entire command, and in order to create a new CompensationContext Remember to use short transactions as possible For the last update part of the command – compensation code is not required – the transaction will rollback this part, if needed