SAP Knowledge Base Article - Preview

2962046 - Signal 11 in bufsearch_cache_getlatch() crashed ASE server - SAP ASE 16.0

Symptom

  • ASE errorlog reports the following error:
     
    Error: 696, Severity: 21, State: 2
    An attempt was made to fetch logical page '858200' from cache 'tempdb_cache1'. Page belongs to database 'tempdb' (102), object '<Unknown>' (0), index '<Unknown>' (0), partition '<Unknown>' (-1432092673) and not to database 'tempdb' (102), object 'temp worktable' (-1432092673), index '<Unknown>' (0), partition '<Unknown>' (-1432092673).

    Restart of ASE will clear the error. Please contact your System Administrator for help.
  • Few minutes later, an "infected with signal 11" error is reported in the ASE errorlog :

Current process (0x4c25072e) infected with signal 11 (SIGSEGV)
Address 0x0x0000000001afe667 (bufsearch_cache_getlatch+0x497), siginfo (code, address) = (1, 0x0x0000000000000018)

  The failing process (spid) is holding the tempdb cache spinlock which crashed the ASE:

Spinlocks held by kpid 1277495086
Spinlock tempdb_cache1 at address 0x00002aaac0ba0480 owned by 1277495086

  The stack trace includes the following functions:

bufsearch_cache_getlatch
getpage_with_validation
bt__latchrootpage
bt__traverse
bt__getstartp
bt_getnext
dol_bt_getnext
getnext
dropallconstr
dropo
dropobject

  • Another symptom is a housekeeper process crashed  with Signal 11 in the module hk__wash_mass():

Current process (0x850043) infected with signal 11 (SIGSEGV)
Address 0x0x0000000001b2f3dc (hk__wash_mass+0xec), siginfo (code, address) = (128, 0x(nil))

  while holding a tempdb cache spinlock when performs wash:

Spinlocks held by kpid 8716355
Spinlock tempdb_cache5 at address 0x00002aaac4674300 owned by 8716355

  The stack trace includes the following functions:

pcstkwalk
ucstkgentrace
ucbacktrace
terminate_process
kisignal
hk__wash_mass
hk__pool_wash
hk__wash_main

Note: Complete stack traces are available under Attachments.


Read more...

Environment

 SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL08

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR821747, CR#821747, 821747, LRUUNLINK, traceflag, trace, flag, 897, Housekeeper , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.