[DRILL-6838] Query with Runtime Filter fails with IllegalStateException: Memory was leaked by query

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.15.0
• Fix Version/s: 1.15.0
• Component/s: Execution - Flow

Environment

Drill 1.15 + PR -> https://github.com/apache/drill/pull/1504

• Assignee: Weijie Tong
• Reporter: Abhishek Ravi
• Reviewer: Sorabh Hamirwasia
• Created: 09/Nov/18 00:59
• Updated: 20/Dec/18 01:22
• Resolved: 20/Dec/18 01:22

Description

When running TPC-H queries with Runtime Filter feature enabled on DRILL 1.15.0 SNAPSHOT, I saw failures with following error:

Error: SYSTEM ERROR: IllegalStateException: Memory was leaked by query. Memory leaked: (1048576)
Allocator(frag:5:38) 6000000/1048576/77833920/50062914560 (res/actual/peak/limit)


Fragment 5:38

Please, refer to logs for more information.

[Error Id: 2ca07049-ac92-4944-929c-16f261e43f7e on qa-node185.qa.lab:31010] (state=,code=0)

The failure is observed when the query has nested joins. (TPC-H query 7 can easily reproduce the issue). I have attached logs for a simpler sample query that fails.

 

 

 

Issue Links

• is part of: DRILL-6792 Find the right probe side fragment to any storage plugin