Symptom
- A user running a query with SELECT DISTINCT, WHERE and ORDER BY is unexpectedly disconnected.
- The ASE errorlog contains an "infected with signal 11" error in the module EquivClass::eqcFindPdTreeLogProps() with a stack trace:
Current process (0x3c5901d9) infected with signal 11 (SIGSEGV)
Address 0x0x0000000001a97c6a (EquivClass::eqcFindPdTreeLogProps(TreeLogProps*, TreeLogProps*, bool)+0x58a), siginfo (code, address) = (1, 0x0x0000000000000058)
- The following functions are in the stack trace:
EquivClass::eqcGetPdTreeLogProps
EqcN::eqcGenNlJoinPop
PopReptnIndScan<ParallelCost, ParallelProps>::_popAvailPartCompute
OptBlock::OptDeepPdTransform
OptBlock::OptPostProcess
SearchEngine::SeFindOptimal
OptGlobal::_GblSearchEngine
OptGlobal::GblOptimize
Optimize
Note: A complete stack trace is available under Attachments.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
CR#820058, CR820058, 820058, merge_join, alternative_greedy_search, SEGV, segmentation, storage, access, violation, fault, segfault, kisignal, stacktrace, registers , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.
SAP Knowledge Base Article - Preview