Retrieves information about deadlocks from an internal buffer created by the database server.
|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.|
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.|
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.
DBA authority required
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|