SAP Knowledge Base Article - Preview

2424726 - Signal 11 in mem__pageallocate_this_engine() or mem_pageallocate() - SAP ASE

Symptom

  • Running REORG REBUILD or UPDATE STATISICS
  • A connection gets terminated
  • ASE errorlog reports a signal 11 in the module mem__pageallocate_this_engine() or mem_pageallocate() together with a stack trace:
     
    • Current process (0x1b230120) infected with signal 11 (SIGSEGV)
      Address 0x0x0000000001af7bc0 (mem__pageallocate_this_engine+0x100), siginfo (code, address) = (128, 0x(nil))

    • Current process (0x1d3d02d0) infected with signal 11 (SIGSEGV)
      Address 0x0x0000000000e3a075 (mem_pageallocate+0xd5), siginfo (code, address) = (1, 0x0x00000000110a140e)
       
  • The stack trace includes some or all of the following :

mem__pageallocate_this_engine
mem_pageallocate
mem_getpages
memalloc
memalloc_zero

lmlink
startsort
sort

ups_build_stat_noindex
update_statistics_col
ups__updstats_column

update_statistics

  Note: A complete stack trace is available under Attachments.

  • ASE can crash as a result when the process (spid) is holding spinlock erprocelc_spin:

Spinlocks held by kpid 455278880
Spinlock eresourcep->erprocelc_spin at address 0x0000000145875d00 owned by 455278880


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0
  • SAP Adaptive Server Enterprise Cluster Edition (ASE CE) 15.7 and 16.0
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition

Keywords

SEGV, segmentation, storage, access, violation, fault, segfault, kisignal, stacktrace,  stack, registers, CR805293, CR#805293, 805293 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.