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 ONE Support launchpad (Login required).

Search for additional results

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