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

Incremental backups do not create/update xtrabackup_binlog_info

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.4.13, 2.3.NEXT, 8.0.5
    • Component/s: None
    • Labels:
      None
    • Environment:

      Description

      When preparing a full backup, `xtrabackup_binlog_info` is correctly created. 

      When preparing an incremental, `xtrabackup_binlog_info` is not updated (nor created if the previous one is removed)

       

      package versions:

      ```

      hi percona-toolkit 3.0.12-1.bionic amd64 Advanced MySQL and system command-line tools
      hi percona-xtrabackup-24 2.4.12-1.bionic amd64 Open source backup tool for InnoDB and XtraDB
      hi percona-xtradb-cluster-57 5.7.23-31.31-2.bionic amd64 Percona XtraDB Cluster with Galera
      hi percona-xtradb-cluster-client-5.7 5.7.23-31.31-2.bionic amd64 Percona XtraDB Cluster database client binaries
      hi percona-xtradb-cluster-common-5.7 5.7.23-31.31-2.bionic amd64 Percona XtraDB Cluster database common files (e.g. /etc/mysql/my.cnf)
      hi percona-xtradb-cluster-galera-3 3.28-1.bionic amd64 Metapackage for latest version of galera3.
      hi percona-xtradb-cluster-galera-3.x 3.28-1.bionic amd64 Galera components of Percona XtraDB Cluster
      hi percona-xtradb-cluster-server-5.7 5.7.23-31.3

      ```

      Command used to take the incremental backup:

      ```

      xtrabackup --backup --no-timestamp --slave-info --galera-info --safe-slave-backup --incremental-basedir=/srv/backup/mysql/full --use-memory=16 --parallel=8 --target-dir=/srv/backup/mysql/incr

      ```

      Command used to prepare the backup:

      ```

      xtrabackup -prepare --target-dir=/srv/backup/mysql/full-incremental-dir=/srv/backup/mysql/incr

      ```

       

       

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                sergei.glushchenko Sergei Glushchenko
                Reporter:
                rmarchei Ruggero Marchei
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 4 hours
                  4h