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

Unusual increase in memory consumption by ExeMgr which cause OOM error.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 6.2.1
    • Fix Version/s: Icebox
    • Component/s: ExeMgr
    • Labels:
      None

      Description

      Unusual increase in memory consumption by ExeMgr during execution of the specific query which cause OOM error.
      Running the same query iteratively I found that the memory consumption by ExeMgr is increasing iteratively as well and finally cause a OOM error.

      The query:

      select
      	s_name,
      	count(*) as numwait
      from
      	supplier,
      	lineitem l1,
      	orders,
      	nation
      where
      	s_suppkey = l1.l_suppkey
      	and o_orderkey = l1.l_orderkey
      	and o_orderstatus = 'F'
      	and l1.l_receiptdate > l1.l_commitdate
      	and exists (
      		select
      			*
      		from
      			lineitem l2
      		where
      			l2.l_orderkey = l1.l_orderkey
      			and l2.l_suppkey <> l1.l_suppkey
      	)
      	and not exists (
      		select
      			*
      		from
      			lineitem l3
      		where
      			l3.l_orderkey = l1.l_orderkey
      			and l3.l_suppkey <> l1.l_suppkey
      			and l3.l_receiptdate > l3.l_commitdate
      	)
      	and s_nationkey = n_nationkey
      	and n_name = 'EGYPT'
      group by
      	s_name
      order by
      	numwait desc,
      	s_name
      LIMIT 100;
      

      I use sysbench and 10G of data to run the query.

        Attachments

          Activity

            People

            Assignee:
            denis0x0D Denis Khalikov
            Reporter:
            denis0x0D Denis Khalikov
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.