SAP Knowledge Base Article - Preview

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

Symptom

  • 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


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

"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

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.