SAP Knowledge Base Article - Preview

2436184 - A query is executed using bloomfilters in parallel may be aborted - SAP ASE

Symptom

  • A query runs in a parallel using bloomfilters is aborted
  • 1> dbcc stacktrace (spid)
    2> go
    Start dbcc stacktrace...
    pc: 0x0000000001770af8 upyield+0x3e8()
    pc: 0x000000000086951a LeScanContext::syncOnBloomFilters(ExeCtxt&)+0x74()
    pc: 0x000000000086bdd5 LeScanOp::_LeOpNext(ExeCtxt&)+0x8b5()
    pc: 0x0000000001a010fa LeAPScanOp::_LeOpNext(ExeCtxt&)+0x8a()
    pc: 0x00000000008211c6 LeDMLOp::bulkInsClose(ExeCtxt&, int)+0x158a()
    pc: 0x00000000019ca5ea LeHashContext::GetNext(ExeCtxt&)+0x120()
    pc: 0x00000000019cab30 LeHashOp::_LeOpNext(ExeCtxt&)+0x2a()
    pc: 0x00000000008211c6 LeDMLOp::bulkInsClose(ExeCtxt&, int)+0x158a()
    pc: 0x0000000000835120 LeEmitXchgOp::_LeOpNext(ExeCtxt&)+0xb0()
    pc: 0x000000000081966c LePlanNext+0x27c()
    pc: 0x00000000008138e9 LePlanOpenAndExecute+0x59()
    pc: 0x0000000000884621 LeExecuteWorkUnits+0x61()
    [Handler pc: 0x0x00000000010a71b0 le_execerr installed by the following
    function:-]
    pc: 0x00000000010b3865 exec_lava+0x635()
    pc: 0x000000000087d9eb LavaThreadDriverMain+0x33b()
    [Handler pc: 0x0x0000000000f44670 so_handle installed by the following
    function:-]
    [Handler pc: 0x0x0000000001343b10 hdl_stack installed by the following
    function:-]
    [Handler pc: 0x0x00000000012d87e0 s_handle installed by the following
    function:-]
    [Handler pc: 0x0x0000000001343af0 hdl_backout installed by the following


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

stacktrace, bloom filter, bloomfilters, parallel query, CR 781853, CR#781853, 781853 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.