Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-1862

Misleading error after preparing an incremental backup for Second time

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 2.3.10, 2.4.14
    • Fix Version/s: 2.4.15, 8.0.7
    • Component/s: None
    • Labels:
      None

      Description

      Hi,

      If I use an already prepared incremental backup to merge it again with a fresh copy of the base backup it fails with the following error on 2.3:

      InnoDB: Cannot create log files because data files are corrupt or not in sync with each other

      And fails with following error for 2.4:

      xtrabackup: error: The transaction log file is corrupted.

      Steps to reproduce this issue are:

      1. Take a base backup
      2. Take an incremental backup
      3. Copy the base backup and the incremental to another location
      4. Prepare the base backup
      5. Merge the incremental backup with the base backup
      6. Drop the prepared base backup
      7. Copy back the base backup
      8. Prepare the base backup
      9. Merge the already prepared incremental backup with the base backup

      I attached the log file of tests with XB 2.3.

      Please change the error provided with something more accurate for this situation. Also, please document incremental backups should not be used twice.

      Thanks!

        Attachments

          Activity

            People

            Assignee:
            sergei.glushchenko Sergei Glushchenko (Inactive)
            Reporter:
            juan.arruti Juan Arruti
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 1 hour, 58 minutes
                1h 58m

                  Smart Checklist