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

Error in MariaBackup incremental backup

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.2.8
    • Fix Version/s: 10.1.29, 10.2.10
    • Component/s: Backup
    • Labels:
      None
    • Environment:
      Centos 7
    • Sprint:
      10.2.10

      Description

      I have a backup script, which takes a full backup 1 day of the week followed by incremental backups for the following days.

      Command ran was:

      mariabackup \
      --backup \
      --parallel=8 \
      --user=$mysql_user \
      --password=$mysql_pass \
      --no-timestamp \
      --compress \
      --compress-threads=8 \
      --incremental-basedir=$last_backup \
      --socket=$socket \
      --defaults-group="mysqld$instance" \
      --target-dir=$inc_backup_path 2> $logfile_i

      Previously we had this working using the command:

      innobackupex \
      --parallel=8 \
      --user=$mysql_user \
      --password=$mysql_pass \
      --no-timestamp \
      --compress \
      --compress-threads=8 \
      --incremental \
      --incremental-basedir=$last_backup \
      --socket=$socket \
      --defaults-group="mysqld$instance" \
      $inc_backup_path 2> $logfile_i

      Any ideas?

      We previously were unable to perform backups at all until the 10.2.8 version of mariabackup.

      Our tables range in size from 1-2GB to upwards of a 1T.

        Attachments

        1. 10.2.diff
          2 kB
          Andrii Nikitin
        2. crash_data.txt
          20 kB
          Wayne
        3. log-from-backup.txt
          33 kB
          Wayne
        4. MDEV-13798.test
          2 kB
          Andrii Nikitin
        5. mysql.cnf.upload
          2 kB
          Wayne

          Issue Links

            Activity

              People

              • Assignee:
                wlad Vladislav Vaintroub
                Reporter:
                wayne Wayne
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: