SAP Knowledge Base Article - Preview

3319334 - Server hung during 'alter database' and processes stuck in runnable state - SAP ASE

Symptom

  • Processes are hanging, being in a runnable state while waiting for the diskmap lock held by an ALTER DATABASE to be released.
    • Due to (many) reconnections attempts, ASE may report error 1601 : There are not enough 'user connections' available to start a new process

  • HK WASH process seemed blocked.
  • Unable to kill the spid and it is in runnable state.
  • A spid is running 'alter database' and also in runnable state


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP03 & SP04

Product

SAP Adaptive Server Enterprise 16.0

Keywords

827867,CR 827867,CR827867,CR#827867,alter database,runnable,readLock,dmap_lock,hanging,buf__writewait,alterdb , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.