- 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.
SAP Adaptive Server Enterprise (ASE) 15.7 SP135
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 pageThis 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.