SAP Knowledge Base Article - Preview

3191222 - Various stack patterns linked to complex queries with large number of joins - SAP ASE

Symptom

  • Various stack patterns linked to complex queries with large number of joins
  • A common aspect is inclusion of module SsNeHyPerm, but this not always seen
  • Below a number of patterns that have been reported when query is complex and number of joins is 6 or (much) greater
  • A signal 11 (SIGSEGV) is raised and the address line may be empty or contain any of the sample code functions below

    Current process (0x573b5c98) infected with signal 11 (SIGSEGV)
    Address 0x0x0000000000000080 ()
    or (for example)
    Address 0x0x0000000000000080 (SsNeHyPerm::_SsNeHyPsEvalNCostOrdTree)

  1. SsNeHyPerm::_SsNeHyPsEvalNCostOrdTree
    SsNeHyPerm::SsNeEvalMinorState
    SearchStratNodeElem::SsNeFindOptimal
    SsNeHyPerm::SsNeEvalMinorState
    SeHyPermStrat::SeEvalMajorState
    SearchEngine::SeFindOptimalOptBlockPlan

  2. PopBase::popCompress
    PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute
    TopLogProps0::printlong
    EqcN::eqcJoin(EquivClass*, EquivClass*, int, bool)
    SsNeHyPerm::_SsNeHyPsEvalNCostOrdTree
    SsNeHyPerm::SsNeEvalMinorState

  3. PopBase::popExpand(TopLogProps*)
    PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute()
    Pop<SerialCost, SerialProps>::popEnforceAll()
    EquivClass::eqcEagerEnforce()
    SsNeHyPerm::_SsNeHyPsEvalNCostOrdTree()


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.