SAP Knowledge Base Article - Preview

2162502 - Signal 11 at proc__findcachedSQLplan crashing the server - SAP ASE

Symptom

  • ASE errorlog reports signal 11 at address proc__findcachedSQLplan:

Current process (...) infected with signal 11 (SIGSEGV)
Address 0x0x0000000000e4fb3b (proc__findcachedSQLplan+0x6c)

  • The spid is holding 'Des Update Spinlock' and ASE goes down because of this:

Spinlock Des Upd Spinlocks at address ...

  • The stacktrace may include the following function calls:

proc__findcachedSQLplan
procrm
freeprocs
mem_getpages
ssqlcache_allocfn
ubfgrow
kbfalloc
ubfallocf
lwp_create


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 & 16.0

Product

SAP Adaptive Server Enterprise 15.7

Keywords

Signal 11 , sigsegv , proc__findcachedSQLplan+0x6c() , procrm+0x36e() , freeprocs+0x33d() , mem_getpages+0x5e2() , ssqlcache_allocfn+0x4a() , ubfgrow+0xf8() , kbfalloc+0x2c3() , ubfallocf+0x12() ,  , lwp_create+0x805() , proc__findcachedSQLplan+0x6c , procrm+0x36e , freeprocs+0x33d , mem_getpages+0x5e2 , ssqlcache_allocfn+0x4a , ubfgrow+0xf8 , kbfalloc+0x2c3 , ubfallocf+0x12 , lwp_create+0x805 , KBA , light weight procedures , memory corruption , 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.