[MCOL-5145] memory leak select F, count(*) from t1 (select count(*) F from t2 group by c1, c2) a group by 1 Created: 2022-06-19  Updated: 2022-10-10  Resolved: 2022-10-10

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

Type: Bug Priority: Major
Reporter: Kirill Perov Assignee: Kirill Perov
Resolution: Fixed Votes: 0
Labels: None
Environment:

ubuntu
columnstore develop-6,
mdb 10.6-enterprise



 Description   

set TotalUmMemory to 4G
restart mdb & mdb-columnstore
create table test200(c1 int, c2 bigint, c3 varchar(1000))engine=columnstore;
fill table with 150,000,000 records like:
1 1 1
2 2 2
........
150000000 150000000 150000000

run following query several times:
select F, count as count14 from (select count F from test200 where c1 <= 80000000 group by c1, c2) a group by 1;

from some point query will start to fail with error like "ERROR 1815 ... memory limit is exceeded."

looks like about 12Gb of system memory will be used by PrimProc and ExeMgr

restart mariadb-columnstore can solve the problem - system memory will be released and query may run again (but not many times)

same problem doesn't happen if table is created with default engine



 Comments   
Comment by Kirill Perov [ 2022-09-13 ]

reproduced for rnd-agg branch
can be observed at my GCP VM
'kirillperov-testvm'

Comment by Kirill Perov [ 2022-09-26 ]

not found at current develop, I will put this check back to test200

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