SAP Knowledge Base Article - Preview

2993854 - Query spid becomes stuck in compiling state and never finishes - SAP ASE

Symptom

  • After migrating to ASE 16.0 SP02 PL09 HF1, spid from query never finishes
  • Query worked fine in ASE 15.7 SP140
  • Not able to kill spid in isql using:
    kill XXX
  • Not able to kill spid from application side
  • dbcc stacktrace(XXX) - shows
    pc: 0x0000000001f79e8f upyield+0x28f()
    pc: 0x0000000001bb31c2 memalloc+0x772()
    pc: 0x0000000001fe2da8 CgEvals::_CgCompOp(tree*)+0x118()
    pc: 0x0000000001fe3127 CgEvals::_CgCompLogOp(tree*)+0xa7()
    pc: 0x0000000001fe1c4e CgEvals::_CgCompExpr(tree*)+0xee()
    pc: 0x000000000191a413 EvalConstExpr(tree*, proc_hdr*, proc_hdr*, int, int)+0x63()
    pc: 0x000000000187e6f0 IsOrSarg(tree*, PesState*, short, bool, bool)+0x18d0()
    pc: 0x000000000171be82 PecConjPredicate::_PecCompareValue(PecConjPredicate&, int)+0x92()
    pc: 0x000000000171e7af PecConjPredicate::PecChoseBetterBound_PLT_PGE(PesState*, PecConjPredicate&, int, ColCmpType, PeCompareValueCode)+0xcf()
    pc: 0x000000000171e8ba PecConjPredicate::PecChoseBetterBound_PGE_PLT(PesState*, PecConjPredicate&, int, ColCmpType, PeCompareValueCode)+0x2a()
    pc: 0x000000000171ef58 PecConjPredicate::PecChoseHeteroBound(PesState*, PecConjPredicate&, int, ColCmpType)+0xf8()
    pc: 0x0000000001874183 RgInterval::_AnyFinalRefineRange(_STL::_List_iterator<PecConjPredicate*, _STL::_Nonconst_traits<PecConjPredicate*> >, _STL::_List_iterator<PecConjPredicate*,
    _STL::_Nonconst_traits<PecConjPredicate*> >)+0x1a3()
    pc: 0x0000000001874448 RgInterval::AnyRefineEachList()+0xd8()
    pc: 0x0000000001871e75 AnyInterval::AnyRefineAndCrtColBounds()+0x45()
    pc: 0x000000000171cb4a PesState::PesRefinePredList(OptBlock*)+0xea()
    pc: 0x00000000018b942f OptBlock::OptDoPredElim()+0x7f()
    pc: 0x000000000167bfdf OptCriteria::ocInit(int)+0x80f()
    pc: 0x000000000167847d OptGlobal::_GblSearchEngine(int*)+0x33d()
    pc: 0x0000000001679069 OptGlobal::GblOptimize(int*)+0x239()
    pc: 0x0000000001679f0b Optimize+0x1bb()
    pc: 0x0000000001d94474 s_compile_stmt+0x784()
    pc: 0x0000000001d918e1 s_compile+0x8f1()
    [Handler pc: 0x0x0000000001e072f0 hdl_stack installed by the following function:-]
    [Handler pc: 0x0x0000000001dcd500 s_handle installed by the following function:-]
    pc: 0x0000000001dd14c7 sequencer+0x8c7()
    pc: 0x00000000015e0c0f tdsrecv_language+0x1df()
    [Handler pc: 0x0x0000000001f0d010 ut_handle installed by the following function:-]
    pc: 0x00000000015f54f8 conn_hdlr+0xf18()


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) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.