2543393 - INSERT raises infected with signal 11 at kbfalloc - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2543393 - INSERT raises infected with signal 11 at kbfalloc - SAP ASE

Symptom

  • First, the process exhausts the lock pool raising error 1204  (other user processes are also raising the same error)
     
    Error: 1204, Severity: 17, State: 2 occurred for User xxxx
     
    ASE has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure ASE with more  LOCKS
      
  • Next, for the same process a message is logged indicating possible heap memory corruption
     
    kbfalloc() retrieved null MEMFRAG from free list at 0x0x2aaab7dbfe10. Heap memory corruption may have occurred.
     
  • ASE then infects this process and  stacktraces at kbfalloc() while attempting to rollback the transaction   
     
  • Common to these stacktraces are temporary table drop attempts along with a 'last error' value of 1204
     
    kernel  Current process (0x12b30103) infected with signal 11 (SIGSEGV)
    kernel  Address 0x0x000000000160846f (kbfalloc+0xb2f), siginfo (code, address) = (1, 0x0x0000000000000010)
    kernel  General Registers (uc_mcontext.gregs):
    kernel  (kbfalloc+0xb2f)
    <register snip>
    kernel  lasterror = 1204 preverror = 0 transtate = 0
    kernel  curcmd = 195 program = xxx
    kernel  terminate_process+0x1144()
    kernel  kisignal+0x31f()
    kernel  kbfalloc+0xb2f()
    kernel  ubfallocf+0x1d()
    kernel  createpool_n_alloc+0x31()
    kernel  memallocheap+0xcf()
    kernel  scan_get_rowbuf+0x50()
    kernel  rec_undo_session+0xc8a()
    kernel  abort__all+0x59()
    kernel  xact__rollbackxact+0x2d6()
    kernel  xact__rollback_local+0x31()
    kernel  dropo+0x274f()
    kernel  drop_with_retry+0xb4()
    kernel  tmp_alldrop+0x118()
    kernel  s_free+0xa05()
    kernel  s_pop+0x333()
    kernel  s_cleanframe+0x145()
    kernel  s_handle+0xb21()
    kernel  exc__raise+0x325()
    kernel  exc_raise+0x10c()
    kernel  s_remap_lockid+0x332()
    kernel  s_lockstmt+0x149()
    kernel  s_execute+0x1c29()
    kernel  sequencer+0x29e7()
    kernel  execproc+0x762()
    kernel  execrpc+0x7eb()
    kernel  tdsrecv_rpc+0x1c()
    kernel  end of stack trace, spid 655, kpid 313721091, suid -1595

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 SP132 ONE-OFF

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , 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.