SAP Knowledge Base Article - Preview

2277965 - DUMP DATABASE appears to hang - SAP ASE

Symptom

  • All processes hanging in the ASE server.
  • Memory dump analysis shows that spid 3027 executing DUMP DATABASE is blocking the rest of processes (spids).
  • This is the information about the blocking process:
stacktrace 3027

upsleepgeneric
plcblock__lock
plcblock__flush
xls_flush_plcqueue
plc__flush
xls_preflush
finishlog
xact__endxact
xact__commitxact
xact__commit_local
xact_commit
dam_prepare_dump_end
dpdb_main
s_execute 
 
who 3027

  User: sapsa, Program: nsrdasv, Command: 228 DUMP DATABASE
 
sqltext 3027
 
*************** SPID: 3027 ******************
SQL Text: DUMP DATABASE PE2


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

sysdams deadlock cumulative  incremental CR739363 CR#739363 739363 CR796082 CR#796082 796082 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed

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.