SAP Knowledge Base Article - Preview

2543393 - INSERT raises Error 1204 with Signal 11 in kbfalloc() - SAP ASE 15.7

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. Client IP address is 'xxx.xx.xx.xx'.

  The message for this error is not shown in the ASE errorlog:

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 a possible heap memory corruption:

kbfalloc() retrieved null MEMFRAG from free list at 0x0x2aaab7dbfe10. Heap memory corruption may have occurred.

  • ASE then reports an "infected with signal 11" error in the module kbfalloc() with a stack trace for this process while attempting to roll back the transaction:

Current process (0x12b30103) infected with signal 11 (SIGSEGV)
Address 0x0x000000000160846f (kbfalloc+0xb2f), siginfo (code, address) = (1, 0x0x0000000000000010)

  • The stack trace includes functions:

kbfalloc
ubfallocf
createpool_n_alloc
memallocheap 
scan_get_rowbuf
rec_undo_session
abort__all
xact__rollbackxact
xact__rollback_local
dropo
drop_with_retry
tmp_alldrop
s_free
s_pop
s_cleanframe
exc__raise
exc_raise
s_remap_lockid
s_lockstmt

  Note: A complete stack trace is available under Attachments. 


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 SP13x

Product

SAP Adaptive Server Enterprise 15.7

Keywords

CR810936, CR#810936, 810936 , 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.