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

Cluster crashes when LONGTEXT or LONGBLOB fields are involved in a query

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 1.2.0
    • 6.1.1
    • None
    • None
    • 2021-8, 2021-9

    Description

      Columnstore claims support for 2GB long LONGTEXT and LONGBLOB, to be in line with InnoDB.

      However, internal implementation is insufficiently strong. On one hand, it allocates the buffer for the maximum row size, but then it is unable to handle the data because the buffer length in the code is integer, and cannot exceed 2GB.

      It has been noted that our main competitors - RedShift and SnowFlake limit LONTEXT and LONGBLOB to just 16MB.

      For 6.1.1 the resolution will be:

      • reduce the limit to 16MB
      • Change the documentation accordingly - jacob.moorman

      After the change, the crash may still be present if the table would have over 100 LONGTEXT fields, an unrelaistic scenario.

      The original ticket - MCOL-3879 will, in due time, protect from that as well.

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              gdorman Gregory Dorman (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.