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/
       
      

       

       

        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

                  Smart Checklist