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.