Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5866

Min reservation error message is slightly inaccurate

    XMLWordPrintableJSON

Details

    • ghx-label-2

    Description

      When I set the mem_limit to exactly the value suggested in the error message, the query is still rejected. If I set the value slightly higher, then then query runs.

      set max_row_size=200m;
set mem_limit=100m;

select count(distinct l_shipdate) from lineitem;
ERROR: Rejected query from pool root.default: minimum memory reservation is greater than memory available to the query for buffer reservations. Mem available for buffer reservations based on mem_limit: 100.00 MB, memory reservation needed: 512.94 MB. Set mem_limit to at least 641.17 MB. See the query profile for more information.

set mem_limit=641.17m;
select count(distinct l_shipdate) from lineitem;
ERROR: Rejected query from pool root.default: minimum memory reservation is greater than memory available to the query for buffer reservations. Mem available for buffer reservations based on mem_limit: 641.17 MB, memory reservation needed: 512.94 MB. Set mem_limit to at least 641.17 MB. See the query profile for more information.

      If I set the mem_limit to 641.18m, then the query runs fine. Maybe this is a minor inconsistency/rounding/truncation issue between our reporting and our parsing of the mem spec in the memory limit.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. IMPALA-5838 Suggested MEM_LIMIT in rejected query error may be too low

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              Unassigned Unassigned
              alex.behm Alexander Behm
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: