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

BLOB leak when emptying an instantly altered table

    XMLWordPrintable

Details

    Description

      When a table becomes empty after an instant ADD COLUMN operation, it would be converted to the canonical format.

      If the added columns had long DEFAULT values, these values can be stored off-page. These pages would not be freed when the table becomes empty.

      It appears that btr_free_but_not_root() or similar should be executed in order to mark the BLOB pages freed. Otherwise, the space for the BLOB pages would not be released until the table is dropped or rebuilt.

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.