[MCOL-3819] CLONE - UM join mem overflow sometimes does not abort properly Created: 2020-02-20  Updated: 2020-03-16  Resolved: 2020-03-16

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: 1.2.6

Type: Bug Priority: Major
Reporter: Patrick LeBlanc (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

I found that the abort triggered by a mem overflow does not always work with the new multithreaded join code. The session will hang, and the memory used up to that point for that query will never get deallocated.

 Comments   
Comment by Daniel Lee (Inactive) [ 2020-03-16 ]

Build verified: 1.2.6-1 BB

engine commit:
d4173ef

erified on a 10gb dbt3 databasse.
set infinidb_um_mem_limit=10;
set infinidb_ordered_only=ON;
repeated query 10 times
select count from orders, lineitem where l_orderkey = o_orderkey;

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