Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14051

'Undo log record is too big.' error occurring in very narrow range of string lengths

    XMLWordPrintable

Details

    Description

      A user is seeing an 'Undo log record is too big.' error that only occurs if they update 2 mediumtext fields at once, and if the length of the existing values in each those fields happen to be between 3962 and 4030 characters long.

      Some other interesting notes about this:

      • The table definition has ROW_FORMAT=COMPACT, so it uses the Antelope format.
      • The only indexes on the two mediumtext fields have prefix lengths of 255.
      • The problem is repeatable on MySQL 5.5 and 5.7, and MariaDB 10.1 and 10.2, so I don't think it has been fixed in any released version of MySQL or MariaDB.

      I have attached an SQL file that can be used to reproduce this issue.

      Upstream bug report:

      https://bugs.mysql.com/bug.php?id=88150

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              6 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.