3112838 - A reorg causes process to sleep in des__in_use_error and can't be killed due to TF 2792 - SAP ASE

• ASE encounters a blocking situation when traceflag 2792 is enabled in the server
  
  Active traceflags: 2792
  
  
• A spid is executing a command on a table while a reorg ($ALTER TABLE) is in progress
• sp_spaceused and dbcc upgrade_object are known to encounter this, but other commands may be affected
  
  
• The reorg process can be blocked and/or show to be 'lock sleep'
• A dbcc stacktrace on the blocking shows functions including:
  

  upsleepgeneric
  des__in_use_error
  des_do_get

• Server has to be rebooted to clear the process

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

sybase, 824239, CR 824239, sp_spaceused, des__in_use_error, sleep, hang, ASE , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed