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

InnoDB recovery and mariadb-backup --prepare fail to report detailed progress

Details

    Description

      A user is facing this scenario where mariabackup --prepare has been running for 12+ hours, and it's reporting page numbers to recover. Then it goes on to multiple iterations of recovery with no indication of how much work is remaining or how much time remains to complete the process.

      It will be great if `--prepare` can report the percentage of pages recovery completed per iteration and a global percentage completion consolidating all iteration batches.

      Attachments

        1. preparelog.txt
          332 kB
          Faisal Saeed
        2. big_restore.log
          33 kB
          Timofey Turenko

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32042 Special handling of crash recovery in buf_page_get_gen() may cause overhead

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34830 LSN in the future is not being treated as serious corruption

          • Major - Major loss of function.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31386 InnoDB: Failing assertion: page_type == i_s_page_type[page_type].type_value

          • 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-31827 InnoDB multi-batch recovery stops prematurely

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31080 InnoDB: Failing assertion: space->size == check.size in fil_validate() during deferred tablespace recovery

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11027 InnoDB log recovery is too noisy

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31350 test innodb.recovery_memory failed on '21 failed attempts to flush a page'

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31353 InnoDB recovery hangs after reporting corruption

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31362 recv_sys_t::apply(bool): Assertion `!last_batch || recovered_lsn == scanned_lsn' failed

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34062 mariadb-backup --backup is extremely slow at copying ib_logfile0

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34070 mariadb-backup --prepare with larger --use-memory may be slower

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34907 Bogus debug assertion failure in multi-batch recovery while parsing FILE_ records

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-14481 Execute InnoDB crash recovery in the background

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-30053 mariabackup should indicate memory needed for prepare

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32029 Assertion failures in log_sort_flush_list upon crash recovery

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34156 InnoDB fails to apply the redo log to page_compressed tablespace

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Marko Mäkelä made transition -
            Open Needs Feedback
            		1d 3h 26m 2
            Marko Mäkelä made transition -
            Needs Feedback Open
            		35d 12h 56m 2
            Marko Mäkelä made transition -
            Open Confirmed
            		1m 40s 1
            Marko Mäkelä made transition -
            Confirmed In Progress
            		114d 22h 9m 1
            Marko Mäkelä made transition -
            In Progress In Testing
            		25d 22h 42m 1
            Matthias Leich made transition -
            In Testing Stalled
            		21d 3h 40m 1
            Marko Mäkelä made transition -
            Stalled Closed
            		3d 2h 34m 1

            People

              marko Marko Mäkelä
              Faisal Faisal Saeed (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              11 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.