SAP Knowledge Base Article - Preview

2302835 - Undetected deadlock between connections in "latch sleep" and "lock sleep" - SAP ASE

Symptom

You are running applications on SAP ASE database.

  • Two or more connections appear to hang indefinitly with status of "latch sleep" and "lock sleep"
  • The "lock sleep" connection is blocked by that connection in "latch sleep"
  • The only way to clear the hung spids is to reboot the ASE server.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP136
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP01
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02
  • SAP Adaptive Server Enterprise (ASE) 15.7 SP136 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP01 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 for Business Suite

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

deadlock, 2630, "latch sleep", "lock sleep", 792164, "HK GC" , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , Bug Filed

About this page

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

Search for additional results

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