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.
SAP Knowledge Base Article - Preview