Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5187

OOM happening when querying large datasets and using distinct

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Won't Fix
    • 22.08.1, 6.4.6
    • N/A
    • N/A
    • ububts 20.04 LTS

    Description

      I set TotalUmMemory to 25%, but ExeMgr use far beyond usage memory.
      Finally ExeMgr was killed by oom-killer.
      I tried two sql on large datasets.

      1. select distinct columnA, columnB, columnC from table.
      2. select columnA, columnB, columnC from table group by columnA, columnB, columnC.

      1. is OOM,
      but 2. is MCS-2003: Aggregation/Distinct memory limit is exceeded.

      I think 1. and 2. are similar query.
      I think that 1. should return same message (MCS-2003: Aggregation/Distinct memory limit is exceeded.)

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5431 Remove dataset sorting from WFS.

          • Major - Major loss of function.
          • Open
          is part of

          New Feature - A new feature of the product, which has yet to be developed. MCOL-5250 Disk-based DISTINCT

          • Major - Major loss of function.
          • Stalled
          relates to

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MCOL-4626 Columnstore cluster becomes non operational when running out of memory on a query

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5430 Window Functions in projection with GROUP BY delivers wrong results

          • Major - Major loss of function.
          • Open

          Activity

            People

              drrtuy Roman
              Atsushi Kugimiya
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.