[MCOL-867] PM join can eat too much RAM in PrimProc Created: 2017-08-10  Updated: 2021-01-16  Resolved: 2021-01-16

Status: Closed
Project: MariaDB ColumnStore
Component/s: PrimProc
Affects Version/s: 1.0.10
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None

Attachments: PDF File profile1.pdf    

 Description   

With a 500GB DBT3 on a single server setup 64GB RAM server the following query causes PrimProc to consume all RAM and swap with the PM joiner until the kernel kills it:

select l_shipmode, l_comment, o_clerk from lineitem join orders on l_orderkey = o_orderkey where o_orderdate = '1997-05-06';



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2017-08-10 ]

Attached a 1 second memory profile whilst things are exploding. This is from a develop-1.0 build.

Comment by David Hill (Inactive) [ 2019-08-02 ]

Customer has hit this issue. I added its Issue number.

Generated at Thu Feb 08 02:24:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.