2270963 - Signal 11 in proc__search leads to ASE crash due to Des Upd Spinlock - SAP ASE

• SAP ASE server shuts down unexpectedly. 
• The ASE errorlog contains a message 'infected with signal 10'  or 'infected with signal 11' in the module proc__search followed by a stack trace, for example:
  

  Current process (hex#) infected with signal 10 (SIGBUS)
  Address hex# (proc__search+0x48c)
  
  Current process (hex#) infected with signal 11 (SIGSEGV)
  Address hex# (proc__search+#)

• Stack traces include functions:
  
  proc__search
  proc_get
  s_getTreeOrPlan or
  sqt_get_plan

   Note: A complete stack trace is available under Attachments.

• The ASE spid may also fail in proc__search() due a timeslice  error.
  
   
• As a result ASE will shudown as the terminated proces (spid) holds the spinlock Des Upd Spinlocks, for example:
  
  Spinlocks held by kpid 1833501109
  Spinlock Des Upd Spinlocks at address 0x0000000145bc5a00 owned by 1833501109

• A stacktrace in memfree() may also occur - referencing the functions:
  
  memfree
  proc__deallocmem
  proc_clean
  des__clean
  des_objdrop
  ssql__rmplans
  ssql_save_SQL
  sqt_put_in_stmtcache
  s_compile
  

SAP Adaptive Server Enterprise (ASE) 16.0

"Des Upd Spinlocks", crash, stacktrace, spinlocks, proc__search, "signal 11", 819987, CR 819987, 815567, CR 815567, 826065, CR 826065 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed