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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Using transactions and isolation levels » Transaction blocking and deadlock » Transaction blocking » Deadlock

 

Viewing deadlocks from Sybase Central

When you are connected to a database in Sybase Central, you can see a diagram of any deadlocks that have occurred in the database since the log_deadlocks option was set to On. Deadlock information is recorded in an internal buffer.

 ♦  To use Sybase Central deadlock reporting
  1. Select the database in the left pane of Sybase Central, and then choose File » Options.

  2. Turn on the log_deadlocks option.

    1. In the Options list, select log_deadlocks.

    2. In the Value field, type On.

    3. Click Set Permanent Now.

    4. Click Close.

    For more information, see log_deadlocks option.

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

    A deadlock diagram appears if there are deadlocks in the database. 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.