3301324 - Signal 11 in proc__deallocmem or procrm that can crash server - SAP ASE

• ASE errolog reports a signal 11 with stack trace including proc__deallocmem or procrm
• This may be triggered by running dbcc proc_cache(free_unused) when having large procedure cache size
• Typical log entries include :
  
  Current process (0x1b490810) infected with signal 11 (SIGSEGV)
  Address 0x0x0000000001d54da6 (proc__deallocmem+0x146) ...
  
  or
  
  Address 0x0x0000000001b5ea35 (procrm+0x1e5) ...
  
  SQL Text: dbcc proc_cache('free_unused')
  
  showing stack modules
  
  proc__deallocmem
  procrm
  freeprocs
  d_proccache
  exec_dbcc
  
  

• ASE will crash due Des Upd Spinlocks being held by spid hitting the signal 11
  
  Spinlocks held by kpid 1247743918
  Spinlock Des Upd Spinlocks at address ...

• SAP Adaptive Server Enterprise (ASE) 16.0
• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP NetWeaver (NW) - All versions (or specific version if related only to a specific SAP Basis)

CR#827615, CR827615, 827615 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem