SAP Knowledge Base Article - Preview

2422004 - Parallel Queries Sometimes Hang


  • A query uses a search argument that will  result in a full table scan.
  • The table as 900 million rows (Approx. 450GB)
  • Stored Procedure cache size is 30GB
  • 8 Partitions - Roundrobin
  • 8 Worker Processes
  • The query stalls and does not complete and must be killed to terminate

 A stacktrace sample collected from a memdump while the query was active reveals that it is attempting to allocate memory for the parallel query

pc: 0x000000008040fca8 memalloc+0x1a8(0x000000000000b7e0, 0x0000000000000807, 0x00000102a450b800, 0x00000102a4650000, 0x00000101e0d1dd38)
        Frame Pointer= 0x0000010039e9efc1 , Frame size=224
pc: 0x0000000080921fd4 LePipebufSource::LePipebufSource(proc_hdr*,int,int,int,int,unsigned short,double,proc_hdr*,long)+0x244(0x000001026409f800, 0x00000102a450c000, 0x0000000000000008, 0x0000000000000001, 0x000000000009c751)
        Frame Pointer= 0x0000010039e9f141 , Frame size=384
pc: 0x0000000080923dd4 LeRetnCode LePipeSimple::LePipeCreate(int,int,LePartitions*,LeVtuple*,proc_hdr*,int,int*,int*,LePipebufSource*,int,double,proc_hdr*,long,int)+0x4a4(0x00000102a79f72a8, 0x0000000000000001, 0x0000000000000008, 0x00000102a79f7578, 0x0000000000000000)
        Frame Pointer= 0x0000010039e9f2d1 , Frame size=400
pc: 0x0000000080913b20 LeRetnCode LeXCHGOp::SetPipesOn(int,ExeCtxt&)+0x140(0x00000102ab012a88, 0x0000000000000001, 0x0000000000000000, 0x0000000000000001, 0x0000000082b0db70)
        Frame Pointer= 0x0000010039e9f451 , Frame size=384
pc: 0x0000000081cbb374 LeRetnCode LeOperator::SetPipesOn(int,ExeCtxt&)+0x54(0x0000000081cbcbb8, 0x0000000000000001, 0x00000102aaf31e70, 0x0000000082afce58, 0x0000000081cbcbc0)
        Frame Pointer= 0x0000010039e9f501 , Frame size=176
pc: 0x000000008052f230 _$o1cexrK0.__1cJLeEmittOpM_LeOpAcquire6MrnHExeCtxt__nKLeRetnCode__+0x58(0x00000102ab018170, 0x00000102aaf31e70, 0x00000102a450c790, 0x0000000082afce58, 0x0000000000000000)
        Frame Pointer= 0x0000010039e9f5f1 , Frame size=240
pc: 0x0000000081cb6160 LeRetnCode LeOperator::LeOpAcquire(ExeCtxt&)+0x2c(0x0000000000000000, 0x00000102aaf31e70, 0x0000000000000000, 0x0000000000000000, 0x0000000000000120)
        Frame Pointer= 0x0000010039e9f6a1 , Frame size=176
pc: 0x00000000804369ac int LePlanAcquireNoPreAcq(ExeCtxt*,int,int,int,LeRootOp*,proc_hdr*,pss*,int,int)+0x2c(0x00000102aaf31e70, 0x0000000000000000, 0x000000000000b800, 0xffffffffa450c000, 0x00000102ab018170)
        Frame Pointer= 0x0000010039e9f761 , Frame size=192
pc: 0x0000000080436eac LePlanAcquire+0xcc(0x00000102aaf31e70, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x00000102aaf31e70)
        Frame Pointer= 0x0000010039e9f831 , Frame size=208



SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL03



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 ONE Support launchpad (Login required).

Search for additional results

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