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

Shrink the system tablespace when system tablespace contains MDEV-30671 leaked undo pages

Details

    Description

      Looks like the fix for MDEV-14795 didn't handle leaked undo pages (because even their extent has never been marked as freed). So MDEV-14795 assumes that it is used by server. This does NOT allow to shrink ibdata1 in a newer versions, even after a slow shutdown and even when UNDO is already moved to separate tablespaces (so instance re-creation is still required if the instance was ever affected by MDEV-30671.

      Attachments

        1. undo_leak_data.tar.gz
          9.40 MB
          Thirunarayanan Balathandayuthapani

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35289 innodb_fast_shutdown=0 might corrupt the system tablespace on 32-bit systems

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-14795 InnoDB system tablespace cannot be shrunk

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31234 InnoDB does not free UNDO after the fix of MDEV-30671, thus shared tablespace (ibdata1) may grow indefinitely for no good reason

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35398 Improve shrinking of system tablespace

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

          Activity

            Transition Time In Source Status Execution Times
            Thirunarayanan Balathandayuthapani made transition -
            Open Confirmed
            		35d 20h 58m 1
            Julien Fritsch made transition -
            Confirmed In Progress
            		35d 1h 23m 1
            Thirunarayanan Balathandayuthapani made transition -
            In Progress In Review
            		12m 3s 1
            Marko Mäkelä made transition -
            In Review Stalled
            		33d 8h 37m 1
            Thirunarayanan Balathandayuthapani made transition -
            Stalled Closed
            		11h 45m 1

            People

              thiru Thirunarayanan Balathandayuthapani
              valerii Valerii Kravchuk
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.