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 for Me (Login required).

Search for additional results

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