sa_report_deadlocks system procedure

sa_report_deadlocks( )

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	INTEGER	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	INTEGER	The connection handle of the connection owning the lock being waited on.
is_victim	BIT	Identifies the rolled back transaction.
rollback_operation_count	UNSIGNED INTEGER	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.

You must have the MONITOR system privilege.

None

You can execute the following query to identify deadlocks.

CALL sa_report_deadlocks( );

sa_report_deadlocks system procedure

Syntax

Result set

Remarks

Privileges

Side effects

See also

Examples