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

Post upgrade to 23.10.4, some queries are taking forever to execute..

    XMLWordPrintable

Details

    • 2025-9, 2025-10, 2025-11, 2026-1

    Description

      One of the customer reported that post upgrade from 23.02.14 to 23.10.4, some queries(SELECT using joins) are taking forever to execute.

      Locally can simulate this scenario.
      23.02.14 the same query getting aborted because of my resource limitation. Customer noted query takes 1-2mins.

      Whereas at 23.10.4, query still running seeing executing from 6hrs so far.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MCOL-6075 Research/Reproduce 23.10.4 Memory Allocation Related Errors

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              alexey.antipovsky Aleksei Antipovskii
              suresh.ramagiri@mariadb.com suresh ramagiri
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 10d Original Estimate - 10d
                  10d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 25d
                  25d

                  Git Integration

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