Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Transactions and isolation levels » Transaction blocking and deadlock » Transaction blocking » Deadlocks

 

Viewing deadlocks from Sybase Central

You can see a diagram of deadlocks that have occurred in the database since the log_deadlocks option was set to On.

Prerequisites

You must have the MONITOR and SET ANY SYSTEM OPTION system privileges.

 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Select the database in the left pane of Sybase Central, and then click File » Options.

  3. Turn on the log_deadlocks option:

    1. In the Options list, click log_deadlocks.

    2. In the Value field, click On.

    3. Click Set Permanent Now.

    4. Click Close.

  4. In the right pane, click the Deadlocks tab.

Results

A deadlock diagram appears showing deadlocks that occurred. Each node in the deadlock diagram represents a connection and gives details about which connection was deadlocked, the user name, and the SQL statement the connection was trying to execute when the deadlock occurred. There are two types of deadlocks: connection deadlocks and thread deadlocks. Connection deadlocks are characterized by a circular dependency for the nodes. A thread deadlock is indicated by nodes that are not connected in a circular dependency, and the number of nodes is equal to the thread limit on the database plus one.

Next

You can use application profiling to help diagnose the cause of the deadlocks.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0