Symptom
- ASE is configured to print deadlock information in the errorlog via configuration parameter, 'print deadlock information = 1'.
- SCC is configured to send a warning ALERT on the deadlock when the count = 1.
- After a deadlock occurs ASE does log the information but SCC does not send the expected ALERT.
- A snippet of the deadlock message reported by ASE
server Deadlock Id 5 detected
Deadlock Id 5 detected. 1 deadlock chain(s) involved.
Deadlock Id 5: Process (Familyid 0, Spid 15, Suid 1) was executing a UPDATE command at line 3.
Deadlock Id 5: Process 15 was involved in application 'isql'.
Deadlock Id 5: Process 15 was involved on host name 'test'.
Deadlock Id 5: Process 15 was involved in transaction '$user_transaction'.
SQL Text: UPDATE tempdb.dbo.foo SET col1 = 1
Deadlock Id 5: Process (Familyid 0, Spid 16, Suid 1) was executing a UPDATE command at line 1.
Deadlock Id 5: Process 16 was involved in application 'isql'.
Deadlock Id 5: Process 16 was involved on host name 'test'.
Deadlock Id 5: Process 16 was involved in transaction '$user_transaction'.
SQL Text: UPDATE tempdb.dbo.bar SET col1 = 1
Deadlock Id 5: Process (Familyid 0, Spid 16) was waiting for a 'update page' lock on page 897 of table 'bar' in database 'tempdb' but process
(Familyid 0, Spid 15) already held a 'exclusive page' lock on it.
Deadlock Id 5: Process (Familyid 0, Spid 15) was waiting for a 'update page' lock on page 889 of table 'foo' in database 'tempdb' but process
(Familyid 0, Spid 16) already held a 'exclusive page' lock on it.
Deadlock Id 5: Process (Familyid 0, Spid 15) was chosen as the victim.
Victim process host = `test', user = `sa' program name = `isql' host processes = `19926' .
Read more...
Environment
- Sap Control Center Framework - 3.2.7
- SCC Management Agent Plugin - 3.2.7
- ASE Management Agent Plugin - 3.2.8
- SAP Adaptive Server Enterprise (ASE) 15.7
Product
SAP Adaptive Server Enterprise 15.7 ; SAP DB Control Center all versions
Keywords
Sap control center, KPI, deadlocks , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.