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:
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.