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

Min reservation error message is slightly inaccurate

    Details

    • Epic Color:
      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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: