SAP Knowledge Base Article - Preview

2430458 - Phantom spid holds a blocking latch on the data cache buffer - SAP ASE

Symptom

  • A phantom spid is holding a latch that blocks an active spid and in turn it blocks other spids. 
  • Just before the blocking occurred, there was a number of repeating messages indicating the cache was undersized for the user defined tempdb:

The 4K memory pool of named cache tempdb_aqt (cache id 10, cachelet id 30) is configured too small for current demands (state 1). Transaction progress may cease or response time may increase.

  • This is the same cache where the phantom spid holds a blocking latch on the buffer. 

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 SP135

Product

SAP Adaptive Server Enterprise 15.7

Keywords

CR799128, CR#799128, 799128, 6103, 821, cleanup, killed, attempt, unhash,  buffer, hashed , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.