Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Database Options » Introduction to database options » Alphabetical list of options

ri_trigger_time option [compatibility] Next Page

rollback_on_deadlock [database]


Controls how transactions are treated when a deadlock occurs.

Allowed values

On, Off

Default

On

Scope

Can be set by any user and can be set for the PUBLIC group, as well as individual connections. Takes effect immediately.

Remarks

When this option is set to On, a transaction is automatically rolled back if it encounters a deadlock. The rollback happens after the current request completes. If this option is set to Off, SQL Anywhere automatically rolls back the statement that encountered the deadlock, and returns an error to that transaction indicating which form of deadlock occurred. Note that rolling back the statement likely would not release any of the locks acquired by the statement.

For more information about deadlocks, see Deadlock.