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

UM join mem overflow sometimes does not abort properly

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.4.3
    • None
    • None

    Description

      I found that the abort triggered by a mem overflow does not always work with the new multithreaded join code. The session will hang, and the memory used up to that point for that query will never get deallocated.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          pleblanc Patrick LeBlanc (Inactive) added a comment -

          marked it in testing, should be in review.

          pleblanc Patrick LeBlanc (Inactive) added a comment - marked it in testing, should be in review.
          pleblanc Patrick LeBlanc (Inactive) added a comment -

          Added a test to the regression suite. https://github.com/mariadb-corporation/mariadb-columnstore-regression-test/pull/174

          PR for the engine mods: https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/1001

          pleblanc Patrick LeBlanc (Inactive) added a comment - Added a test to the regression suite. https://github.com/mariadb-corporation/mariadb-columnstore-regression-test/pull/174 PR for the engine mods: https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/1001
          dleeyh Daniel Lee (Inactive) added a comment -

          Build verified: 1.4.3-1 Azure build (20200220)

          verified on a 10gb dbt3 databasse.

          set infinidb_um_mem_limit=10;
          set infinidb_ordered_only=ON;

          repeated query 10 times

          select count from orders, lineitem where l_orderkey = o_orderkey;

          dleeyh Daniel Lee (Inactive) added a comment - Build verified: 1.4.3-1 Azure build (20200220) verified on a 10gb dbt3 databasse. set infinidb_um_mem_limit=10; set infinidb_ordered_only=ON; repeated query 10 times select count from orders, lineitem where l_orderkey = o_orderkey;

          People

            dleeyh Daniel Lee (Inactive)
            pleblanc Patrick LeBlanc (Inactive)
            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.