search

br1ghtyang / asterixdb

Automatically exported from code.google.com/p/asterixdb
0 stars 0 forks source link

TPC-H q21 not enough memory for SF=10 #597

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
To reproduce the issue, run the tpch q21 in the web interface on SF=10 with 3 
nodes, the default configuration, and one IO device.

q21 gets the message "Unable to allocate frame: Not enough memory 
[HyracksDataException]" and does not output any results.  The stack trace is 
attached.  Thanks in advance for the help.

Original issue reported on code.google.com by cmcintyr...@gmail.com on 2 Aug 2013 at 6:58

Attachments:

GoogleCodeExporter commented 8 years ago 
Here is the plan for q21.

Original comment by cmcintyr...@gmail.com on 2 Aug 2013 at 9:01

Attachments:

GoogleCodeExporter commented 8 years ago

Original comment by westm...@gmail.com on 3 Aug 2013 at 12:42

GoogleCodeExporter commented 8 years ago 
Christopher,  

I assume you are using the default -Xmx which is 1024m?
Can you increase that and see if it works?

The memory manager's memory budget is proportional to the -Xmx:
memoryManager = new MemoryManager((long) 
(memoryMXBean.getHeapMemoryUsage().getMax() * MEMORY_FUDGE_FACTOR));

Yingyi

Original comment by buyingyi@gmail.com on 7 Aug 2013 at 8:46

GoogleCodeExporter commented 8 years ago 
Sorry for the late response.  I was using the default -Xmx if I recall 
correctly.  With the -Xmx set to 16384m, the query finishes successfully.

Original comment by cmcintyr...@gmail.com on 15 Aug 2013 at 12:52

GoogleCodeExporter commented 8 years ago

Original comment by buyingyi@gmail.com on 2 Jun 2014 at 11:23