1925953 - Signal 11 with ASE crash at ssql__choose_victim or ssql_release | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1925953 - Signal 11 with ASE crash at ssql__choose_victim or ssql_release

Symptom

ASE is crashing in functions ssql__choose_victim or ssql_release with a signal 11 in errorlog.

For ssql__choose_victim()

... kernel  Current process (0x6b2d04f4) infected with signal 11 (SIGSEGV)
... kernel  Address 0x0000000100adcf48 (ssql__choose_victim+0x78), siginfo (code, address) = (51, 0x0000000000000008)
... kernel  **** Saved signal context (0x000000017c07e360): ****
... kernel  __sc_onstack: 0x0, __sc_uerror: 55
... kernel  uc_sigmask: 0xffffffff1ffef8770xffffffffffffffff0xffffffffffffffff0x7fffffffffffffff
... kernel  Machine Save State:
... kernel   PC (iar): 0000000100adcf48 (ssql__choose_victim+0x78)
... kernel   Link Register (lr): 0000000100adcc4c (ssql_save_SQL+0xaf8)
... kernel   Stack Pointer (stkp): 000000017c07e850
... kernel   msr : a00000000000d032ctr : 000000010180601ccr  : 22444880
...
... kernel  **** end of signal context ****
... kernel  Spinlocks held by  kpid 1798112500


... kernel  Spinlock SSQLCACHE_SPIN at address 000000016167ab40 owned by 1798112500
... kernel  End of spinlock display.
... kernel  pc: 0x0000000100032670pcstkwalk+0x78()
... kernel  pc: 0x0000000100031f9cucstkgentrace+0x310()
... kernel  pc: 0x0000000100031324ucbacktrace+0x178()
... kernel  pc: 0x00000001008273d0terminate_process.fdpr.chunk.1+0xac()
... kernel  pc: 0x000000010228dd44kisignal+0x464()
... kernel  pc: 0x0000000100adcf48ssql__choose_victim+0x78()
... kernel  pc: 0x0000000100adcc4cssql_save_SQL+0xaf8()
... kernel  pc: 0x0000000100ae1498sqt_put_in_stmtcache+0x100()
... kernel  pc: 0x00000001005bcb70s_compile.fdpr.chunk.5+0x2e4()
... kernel  [Handler pc: 0x0000000101a0dc98hdl_stack+0x0 installed by the following function:-]
... kernel  [Handler pc: 0x0000000101a0ded8 s_handle+0x0 installed by the following function:-]
... kernel  pc: 0x000000010175d914sequencer.fdpr.chunk.15+0x238()
... kernel  pc: 0x00000001017640f0execproc+0x424()
... kernel  pc: 0x000000010189bef8s_execute.fdpr.chunk.106+0xc0()
... kernel  [Handler pc: 0x0000000101a0dc98hdl_stack+0x0 installed by the following function:-]
... kernel  [Handler pc: 0x0000000101a0ded8 s_handle+0x0 installed by the following function:-]
... kernel  pc: 0x000000010175dfd8 sequencer+0x388()
... kernel  pc: 0x0000000100810628tdsrecv__dynexec+0x270()
... kernel  pc: 0x000000010080fe28tdsrecv_dynamic.fdpr.chunk.1+0x1cc()
... kernel  [Handler pc: 0x0000000101a0dce4ut_handle+0x0 installed by the following function:-]
... kernel  pc: 0x0000000101a2259cconn_hdlr.fdpr.chunk.20+0xc()
... kernel  end of stack trace, spid 139, kpid 1798112500, suid 6
... kernel  ueshutdown: exiting
... kernel  Main thread performing final shutdown.
... kernel  Unable to insert task into scheduler as the scheduler has already shutdown.


For ssql_release()

...  kernel  Current process (0x1caf0473) infected with signal 11 (SIGSEGV)
...  kernel  Address 0x0x00000000011349ea (ssql_release+0x95), siginfo (code, address) = (128, 0x(nil))
...  kernel  **** Saved signal context (0x0x000000015d0fb200): ****
...  kernel  uc_flags: 0x0, uc_link: 0x(nil)
...  kernel  uc_sigmask: 0x416000 0xb 0x80 0x0
...  kernel  uc_stack: ss_sp: 0x(nil), ss_size: 0x0, ss_flags: 0x2
...  kernel  General Registers (uc_mcontext.gregs):
...  kernel   PC : 0x00000000011349ea (ssql_release+0x95)
...
...  kernel  **** end of signal context ****
...  kernel  Spinlocks held by  kpid 481231987

...  kernel  Spinlock SSQLCACHE_SPIN at address 0x000000014483de40 owned by 481231987
...  kernel  End of spinlock display.
...  kernel  pc: 0x00000000014b01db pcstkwalk+0x3a3()
...  kernel  pc: 0x00000000014afcb3 ucstkgentrace+0x263()
...  kernel  pc: 0x00000000014abc2e ucbacktrace+0x50()
...  kernel  pc: 0x0000000000779c1c terminate_process+0x15bc()
...  kernel  pc: 0x00000000014fe638 kisignal+0x31f()
...  kernel  pc: 0x00000000011349ea ssql_release+0x95()
...  kernel  pc: 0x00000000007bddcd tdsrecv__dyndealloc+0x7a()
...  kernel  pc: 0x00000000007bc9cb tdsrecv_dynamic+0x1f0()
...  kernel  [Handler pc: 0x0x000000000140dc10 ut_handle installed by the following function:-]
...  kernel  pc: 0x00000000007d63e5 conn_hdlr+0x1be5()
...  kernel  end of stack trace, spid 491, kpid 481231987, suid 6
...  kernel  ueshutdown: exiting
...  kernel  Main thread performing final shutdown.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 ESD #4.x, SP50 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 15.7 SP100, SP101 and SP102 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 15.7 ESD #4.x, SP50
  • SAP Adaptive Server Enterprise (ASE) 15.7 SP100, SP101 and SP102

Product

SAP Adaptive Server Enterprise 15.7

Keywords

CR738117, 738117, ssql__choose_victim, ssql_release , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.