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

During innodb_undo_truncate=ON recovery, InnoDB may fail to shrink undo* files

Details

    Description

      During recovery, InnoDB should truncate the undo log tablespace in recv_sys_t::apply()
      even though there are no pages to recover. Because trx_lists_init_at_db_start() could have applied the redo log for undo tablespace page0 and deleted the page redo log
      records.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          thiru Thirunarayanan Balathandayuthapani created issue -
          thiru Thirunarayanan Balathandayuthapani made changes -
          Field Original Value New Value
          Status Open [ 1 ] Confirmed [ 10101 ]
          thiru Thirunarayanan Balathandayuthapani added a comment -

          https://github.com/MariaDB/server/pull/3332

          thiru Thirunarayanan Balathandayuthapani added a comment - https://github.com/MariaDB/server/pull/3332
          marko Marko Mäkelä made changes -
          marko Marko Mäkelä made changes -
          Affects Version/s 10.6 [ 24028 ]
          Affects Version/s 10.11 [ 27614 ]
          Affects Version/s 11.4 [ 29301 ]
          Labels recovery
          Summary During recovery, InnoDB fails to truncate when there are no pages to recover During innodb_undo_truncate=ON recovery, InnoDB may fail to shrink undo* files
          thiru Thirunarayanan Balathandayuthapani made changes -
          Fix Version/s 10.5.26 [ 29832 ]
          Fix Version/s 10.5 [ 23123 ]
          Fix Version/s 10.6 [ 24028 ]
          Fix Version/s 10.11 [ 27614 ]
          Fix Version/s 11.2 [ 28603 ]
          Fix Version/s 11.4 [ 29301 ]
          Resolution Fixed [ 1 ]
          Status Confirmed [ 10101 ] Closed [ 6 ]
          JIraAutomate JiraAutomate made changes -
          Fix Version/s 10.6.19 [ 29833 ]
          Fix Version/s 10.11.9 [ 29834 ]
          Fix Version/s 11.1.6 [ 29835 ]
          Fix Version/s 11.2.5 [ 29836 ]
          Fix Version/s 11.4.3 [ 29837 ]

          People

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