Out of memory error

roos.niclas · March 1, 2018, 12:07am

Hi,

I’m getting an out of memory error, but the weird things is that when I look in the Admin view as the query is running, the memory isn’t anywhere near 100%.

Here’s the query profile: 014bad8e-6145-4030-94e2-013cce4a035b.zip (31.5 KB)

I have a cluster with three CentOS 7 servers, 32 GB memory each, and I’m trying to work on a dataset with roughly 530 million records and 25 GB on disk. However, the attached query profile is for a subset of the data that should be significantly smaller, but it still fails.

Thanks,

Niclas

balaji.ramaswamy · March 1, 2018, 1:18am

Hi @roos.niclas

Can you please check if any other jobs were running. Click on UI, External Tools and check all the options and see if any background acceleration jobs are running

See screenshot attached

Thanks,
@balaji.ramaswamy
UI-external-tools

Topic		Replies	Views
One or more nodes ran out of memory while executing the query	1	1532	August 24, 2018
OUT_OF_MEMORY ERROR: Query was cancelled because it exceeded the memory limits set by the administrator	4	2370	March 7, 2022
Queries that used to Run on v4.7 error out with memory exception on v11	6	1631	December 13, 2020
Out_of_memory error	2	2402	January 18, 2018
Query exceeded memory limits	4	2632	January 25, 2022

Out of memory error

Related topics