Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
-
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