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

PrimProc was OOM-killed without spill despite DiskBasedAggregation=Y

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 23.02.25
    • None
    • None
    • None

    Description

      despite disk based aggregation configured.
      In 23.02.25 spill did not happen - the processes died with a few statements still running and none finished. Memory grows before any spill, it seems and the watchdog kills primproc, e.g.:

      ...
      Nov 04 11:07:17 insttaxa1d0028.corp.amdocs.com env[1506345]: ExeMgr[1506345]: 17.095721 |0|0|0| C 16 CAL0044: FATAL ERROR: ExeMgr has allocated too much memory! Percent allocation-96, allowed-95. ExeMgr is restarting.
      Nov 04 11:07:17 insttaxa1d0028.corp.amdocs.com ExeMgr[1506345]: 17.095721 |0|0|0| C 16 CAL0044: FATAL ERROR: ExeMgr has allocated too much memory! Percent allocation-96, allowed-95. ExeMgr is restarting.
      Nov 04 11:08:51 insttaxa1d0028.corp.amdocs.com systemd[1]: mcs-primproc.service: A process of this unit has been killed by the OOM killer.
      Nov 04 11:08:53 insttaxa1d0028.corp.amdocs.com systemd[1]: mcs-primproc.service: State 'stop-sigterm' timed out. Killing.
      ...
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              YK Yakov Kushnirsky
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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