Symptom
A SIGSEGV may occur or ELC_VALIDATION_ERROR message is frequently logged when updating rows in a base table if statement cache and literal autoparam are enabled.
This issue can be observed if a materialized view (precomputed result set) exists for the base table and the materialized view contains data.
ex:
terminate_process
kisignal
subparams
s_execsetvar
s_execute
sequencer
00:0004:00000:00028:2023/09/13 11:22:35.18 server ELC_VALIDATION_ERROR: Page address not aligned to memory page size. memptr = 0x151d47020, pelc = 0x147727970, chunksize = 2, engine id = 2, validate_flag = 1
00:0004:00000:00028:2023/09/13 11:22:35.18 server ELC_VALIDATION_CORRECTION: Backup page pointer 0x151d47000 was used. pelc = 0x147727970
, chunksize = 2 engine id = 2
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.x
Product
Keywords
Sybase, ASEServer, SAPASE, dataserver, SIGSEGV, "signal 11", subp, "materialized view", materialized, stacktrace , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Known Error
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.
SAP Knowledge Base Article - Preview