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

Xtrabackup fails if log_bin_index is defined in my.cnf

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 8.0.5
    • Fix Version/s: 8.0.6
    • Component/s: None
    • Labels:
      None

      Description

      With XtraBackup 8.0.5 if we have log_bin_index defined in my.cnf the backup will fail with:

      xtrabackup: Error cannot open binlog index file 'mysqld-bin'

      The problem is that xtrabckup is not appending the .index extension to the value from my.cnf in write_current_binlog_file(), like MySQL does normally.

      To reproduce simply setup a MySQL 8.0.15 and setup binary logging like:

       

      [mysql]
      ...
      log_bin
      log_bin_index = custom_log_bin
      

       

      And then backup with XtraBackup 8.0.5:

       

      xtrabackup --defaults-file=./my.sandbox.cnf --backup --target-dir=$HOME/backup/
       
      

       

       

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              sergei.glushchenko Sergei Glushchenko (Inactive)
              Reporter:
              marcos.albe Marcos Albe
              Votes:
              0 Vote for this issue
              Watchers:
              3 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 - 2 hours, 20 minutes
                  2h 20m