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

GROUP_CONCAT execution allocates enourmous amount of RAM for its result RGDatas

    XMLWordPrintable

Details

    • 2023-4, 2023-5, 2023-6

    Description

      There is MDB client variable group_concat_max_len that controls the max length of GROUP_CONCAT output field. The variable default value differs by distros and can be either 1MB or 3 MB.
      The value of this field sets the outcome RG column width here in buildAggregateColumn().
      There are multiple places where code makes a new RowGroup and the corresponding RGData using 3MB as its column width and if a user sets the value to a higher value this causes PP to crash.
      The suggested solution is to convert GROUP_CONCAT into a StringStore only column and avoid using group_concat_max_len value as a column width.

      Attachments

        Issue Links

          Activity

            People

              tntnatbry Gagan Goel (Inactive)
              drrtuy Roman
              Roman Roman
              Daniel Lee Daniel Lee (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.