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

Error in MariaBackup incremental backup

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.2.8
    • 10.1.29, 10.2.10
    • Backup
    • None
    • Centos 7
    • 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
        2. crash_data.txt
          20 kB
        3. log-from-backup.txt
          33 kB
        4. MDEV-13798.test
          2 kB
        5. mysql.cnf.upload
          2 kB

        Issue Links

          Activity

            People

              wlad Vladislav Vaintroub
              wayne Wayne
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.