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
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.