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

memalloc+0x1a8(0x000000000000b7e0, 0x0000000000000807, 0x00000102a450b800, 0x00000102a4650000, 0x00000101e0d1dd38)
        Frame Pointer= 0x0000010039e9efc1 , Frame size=224
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
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
LeRetnCode LeXCHGOp::SetPipesOn(int,ExeCtxt&)+0x140(0x00000102ab012a88, 0x0000000000000001, 0x0000000000000000, 0x0000000000000001, 0x0000000082b0db70)
        Frame Pointer= 0x0000010039e9f451 , Frame size=384
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
LeRetnCode LeOperator::LeOpAcquire(ExeCtxt&)+0x2c(0x0000000000000000, 0x00000102aaf31e70, 0x0000000000000000, 0x0000000000000000, 0x0000000000000120)
        Frame Pointer= 0x0000010039e9f6a1 , Frame size=176
LePlanAcquireNoPreAcq(ExeCtxt*,int,int,int,LeRootOp*,proc_hdr*,pss*,int,int)+0x2c(0x00000102aaf31e70, 0x0000000000000000, 0x000000000000b800, 0xffffffffa450c000, 0x00000102ab018170)
        Frame Pointer= 0x0000010039e9f761 , Frame size=192
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 for Me (Login required).

Search for additional results

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