1942294 - Tempdb 100% full and server locked up. disk init for the new tempdb device hangs- ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1942294 - Tempdb 100% full and server locked up. disk init for the new tempdb device hangs- ASE

Symptom

  • ASE ran out of space on tempdb with an 1105 error
  • Tried to increase tempdb space and the ASE server hung
  • Running DISK INIT to create a new device also hangs
  • sp_who shows all process with status:

runnable
sleeping

  • Running  'dbccstacktrace(diskinit_SPID)' reports the following calls

upyield
writeLock
map_lock
dmap_replace_map
db__diskremap_sysusages

  • sp_who shows multiple checkpoints on tempdb showing either:

runnable
sleeping


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

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.