Tue Jun 19, 2018 2:58 am
Login Register Lost Password? Contact Us


Memory limit exceeded error when trying a rollup group

Questions around writing code and queries

Fri May 18, 2018 10:23 am Change Time Zone

Hi ,

I am trying to run aggregate function using the rollup group. I am getting a memory limit exceeded error.

Error: System error: 1300: Graph graph1[1], rollupgroup[5]: SLAVE #1 [10.224.89.21:20100]: Graph graph1[1], sort[3]: Memory limit exceeded: current 40960, requested 1, limit 40960 active(1) heap(40960/40960), - caused by (1300, Memory limit exceeded: current 40960, requested 1, limit 40960 active(1) heap(40960/40960)), Out of memory whilst loading group for rollup group, group/set size = 207904, Fixed rows, size = 8252

I am unable to understand the issue. Any inputs on this? what can be the possible reason? When does these kinds of issues occur?
ManishJaychand
 
Posts: 1
Joined: Fri May 18, 2018 10:19 am

Fri May 18, 2018 1:44 pm Change Time Zone

Manish,

Here's the important part of the error message:
Out of memory whilst loading group for rollup group, group/set size = 207904, Fixed rows, size = 8252
If that doesn't help you with the problem, please post the code that created the error along with a description of the hardware you're running the cluster on.

HTH,

Richard
rtaylor
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 1359
Joined: Wed Oct 26, 2011 7:40 pm


Return to Programming

Who is online

Users browsing this forum: No registered users and 0 guests

cron