[MCOL-5515] verify MCOL-5499 Created: 2023-06-15  Updated: 2023-12-21

Status: Stalled
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: 23.10

Type: Task Priority: Major
Reporter: Kirill Perov Assignee: Roman
Resolution: Unresolved Votes: 0
Labels: rm_stability

Issue Links:
Relates
relates to MCOL-5499 Same host communication has an unlimi... Closed
Sprint: 2023-6, 2023-7, 2023-8, 2023-10, 2023-11, 2023-12

 Description   

verify MCOL-5499 with different amounts of free memory



 Comments   
Comment by Kirill Perov [ 2023-07-07 ]

drrtuy,

Docker image mariadb/enterprise-columnstore-dev:develop-23.02- used (taken at 05 Jul 2023).

docker run command like:

docker run -m 3GB --kernel-memory 3GB --memory-reservation 3GB --memory-swap 3GB --hostname=mcs3 --name mcs3 -d mariadb/enterprise-columnstore-dev:develop-23.02-

tested limits: 3, 5, 6, 7+(no limits) Gbs

query:
SELECT * INTO OUTFILE '/tmp/result.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n' FROM flights;

result: 3 and 5 Gbs - error: ERROR 1815 (HY000): Internal error: MCS-2004: Cannot connect to ExeMgr.
6 and 7+ Gbs - success

4 queries running in parallel on 6GB container raise error.
4 queries running in parallel on 7+GB container succeeded.

Comment by Kirill Perov [ 2023-07-11 ]

Using VirtualBox the results are different.
For same query and with memory limited to 6GB and 4GB, PrimProc is using almost all free memory, but OOM killer not happened and query succeeded.
For 6GB, htop shows total RAM as 5.55GB , PP using 5.1GB
For 4GB, htop shows total RAM as 3.55GB , PP using 3GB

Also 2 queries in parallel succeeded at both configs.

Comment by Kirill Perov [ 2023-07-11 ]

alexey.vorovich
Roman require restart for some debug purposes (change config I think).

Comment by Kirill Perov [ 2023-07-11 ]

drrtuy please review above and let me know what is next step to debug MCS in container

Comment by Kirill Perov [ 2023-07-18 ]

At the moment I'm working on creating test environment with docker and systemd enabled.

Comment by Kirill Perov [ 2023-07-31 ]

drrtuy
Under linux host, query succeeded in container with 3GB limit.

Only 2 queries in parallel fail.

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