SAP Knowledge Base Article - Preview

2103133 - Error "Deadlock detected" using SQL Anywhere 9. Reason unclear.

Symptom

  • Under workload it happens that we get unexplainable deadlocks.
  • In order to identify the specific statements we used the system procedure sa_report_deadlocks() and turned on the detailed Console Log using start parameter "-zr SQL -z".
  • Always the same scenario discovered: connection #1 does an UPDATE on table A and connection #2 does a DELETE on table B. These two statements are blocking each other.
  • Isolation level 1 is used.
  • How to resolve this problem?


Read more...

Environment

Sybase SQL Anywhere 9

Product

SQL Anywhere 9.0

Keywords

KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.