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 , SAP Business Suite on Sybase ASE Database Platform , 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.