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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.