SAP Knowledge Base Article - Preview

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


  • 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()



SAP Adaptive Server Enterprise (ASE) 16.0


SAP Adaptive Server Enterprise 16.0


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.