[DRILL-6477] Drillbit hangs/crashes with OOME Java Heap Space for a large query through WebUI

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.13.0
• Fix Version/s: 1.14.0
• Component/s: Web Server
• Labels: ready-to-commit
• Assignee: Kunal Khatua
• Reporter: Kunal Khatua
• Reviewer: Parth Chandra
• Created: 07/Jun/18 19:12
• Updated: 04/Oct/18 13:06
• Resolved: 13/Jun/18 15:53

Description

For queries submitted through the WebUI and retrieving a large resultset, the Drillbit often hangs or crashes due to the (foreman) Drillbit running out of Heap memory.

This is because the Web client translates the resultset into a massive object in the heap-space and tries to send that back to the browser. This results in the VM thread actively trying to perform GC if the memory is not sufficient.

 

Issue Links

• causes: DRILL-5006 Drill web UI hangs if execute a query with a large result set
• links to: GitHub Pull Request #1309