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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Reference » System Objects » System procedures » Alphabetical list of system procedures

 

sa_report_deadlocks system procedure

Retrieves information about deadlocks from an internal buffer created by the database server.

Syntax
sa_report_deadlocks( )
Result set
Column name Data type Description
snapshotId BIGINT The deadlock instance (all rows pertaining to a particular deadlock have the same ID).
snapshotAt TIMESTAMP The time when the deadlock occurred.
waiter INT The connection handle of the waiting connection.
who VARCHAR(128) The user ID associated with the connection that is waiting.
what LONG VARCHAR

The command being executed by the waiting connection.

This information is only available if you have turned on capturing of the most recently-prepared SQL statement by specifying the -zl option on the database server command line or have turned this feature on using the sa_server_option system procedure.

object_id UNSIGNED BIGINT The object ID of the table containing the row.
record_id BIGINT The row ID of the associated row.
owner INT The connection handle of the connection owning the lock being waited on.
is_victim BIT Identifies the rolled back transaction.
rollback_operation_count UNSIGNED INT The number of uncommitted operations that may be lost if the transaction rolls back.
Remarks

When the log_deadlocks option is set to On, the database server logs information about deadlocks in an internal buffer. You can view the information in the log using the sa_report_deadlocks system procedure.

Permissions

DBA authority required

Side effects

None

See also