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

Query Cache Overload Causing PrimProc OOM

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • None
    • 23.02.4
    • None
    • None

    Description

      In cases where the size of a ColumnStore table exceed the amount of RAM on the server, the following two scenarios cause PrimProc to run up the RAM consumption on the system until the process is whacked by the OOM killer.

      SELECT * INTO OUTFILE '/tmp/result.txt'
      FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
      LINES TERMINATED BY '\n'
      FROM columnstore_table;
      

      INSERT INTO innodb_table SELECT * FROM columnstore_table;
      

      Attachments

        Issue Links

          Activity

            People

              drrtuy Roman
              toddstoffel Todd Stoffel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.