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

memory leak select F, count(*) from t1 (select count(*) F from t2 group by c1, c2) a group by 1

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • Icebox
    • None
    • None
    • ubuntu
      columnstore develop-6,
      mdb 10.6-enterprise

    Description

      set TotalUmMemory to 4G
      restart mdb & mdb-columnstore
      create table test200(c1 int, c2 bigint, c3 varchar(1000))engine=columnstore;
      fill table with 150,000,000 records like:
      1 1 1
      2 2 2
      ........
      150000000 150000000 150000000

      run following query several times:
      select F, count as count14 from (select count F from test200 where c1 <= 80000000 group by c1, c2) a group by 1;

      from some point query will start to fail with error like "ERROR 1815 ... memory limit is exceeded."

      looks like about 12Gb of system memory will be used by PrimProc and ExeMgr

      restart mariadb-columnstore can solve the problem - system memory will be released and query may run again (but not many times)

      same problem doesn't happen if table is created with default engine

      Attachments

        Activity

          People

            kirill.perov@mariadb.com Kirill Perov
            kirill.perov@mariadb.com Kirill Perov
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.