Symptom
- Why are there deadlocks on a replay when there are none reported in the capture for example:
00:0011:00000:00978:20XX/07/06 17:01:30.33 server Workload capture status: started, Stop reason: n/a, Elapsed time: 0 sec, Query time: 0 sec, Batches: 0, Packets: 0, Number of files: 10, Total File size: 240 bytes, Overhead: 0 sec, 0%, apture file under directory: /mydirectory/workload
00:0013:00000:00986:20XX/07/06 17:36:13.24 server Workload capture status: stopped, Stop reason: request, Elapsed time: 2082 sec, Query time: 7251 sec, Batches: 369353, Packets: 518926, Number of files: 10, Total File size: 208177359 bytes, Overhead: 0 sec, 0%, Capture file under directory: /mydirectory/workload
- But the replay reports are showing many deadlocks:
Error Number | Total Count | Ratio | Severity | Message Sample | |||||
1205 | 200 | 100.00% | 13 | Your server command (family id #0, process id #155) encountered a deadlock situation. Please re-run your command. |
Read more...
Environment
- SAP Adaptive Server Enterprise 15.7
- SAP Adaptive Server Enterprise 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
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.