SAP Knowledge Base Article - Preview

2422004 - Parallel Queries Sometimes Hang

Symptom

  • 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


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL03

 

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

Search for additional results

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