Symptom
- Process running 'alter database' blocked by other process running 'dump database' or 'dump transaction'
- Auto-expansion is enabled and appears to not have worked
- Queries and outputs below show how to identify processes :
select spid, dbid, starttime, name from master.. syslogshold
go
spid dbid starttime name
------ ------ ---------------------------- -------------
123 4 Apr 01 2017 2:00PM $dmpxact
select spid, blocked as 'Blocked By', status, cmd, tran_name from master..sysprocesses
where blocked != 0 or cmd like "DUMP%"
go
spid Blocked By status cmd tran_name
------ --------------- -------------- -------------------------------- ----------
123 0 sleeping DUMP TRANSACTION $dmpxact
456 123 lock sleep ALTER DATABASE NULL
Read more...
Environment
SAP Adaptive Server Enterprise (ASE). Not version specific.
Product
Keywords
'alter database stuck' , alter database , 'alter database hang' , 'expand database' , 'increase database' , 'expand database stuck' , 'increase database hang' , 'alter database blocked' , 'sp_dbxt_extend_db' , auto expand , auto expansion, "Error: 1105", commands hanging , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
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.