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
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.