Database Failover

During workflow processing if the database shuts down, the application server automatically attempts to reconnect to the database repeatedly after configured time intervals, for a configurable number of times.

The conditions for database failover are as follows:

  • If the reconnect attempts still fail when the last retry has been executed, the processed workflows will be in an inconsistent state. The retry period cannot exceed the transaction timeout limit, which is by default set to 2 hours. When the application server starts the next time, the workflow will be marked as a failed workflow and an error notification email is sent to the user.
  • If one of the reconnection attempts succeeds before the number of retries has passed, workflows will re-execute the last executed activity at the time of failure.