Description
Environment
AFFECTED CS IDs
Smart Checklist
Activity
Jaime Sicam December 21, 2021 at 4:18 AM
Brad Ash September 21, 2019 at 3:19 PM
@sergei.glushchenko I see this is marked as resolved in 8.0.6, but I have the same issue in 8.0.7
My bin log index is set in mysqlcnf.d to a custom filelog_bin_index =/var/log/mysql/mysql-bin.log.index
and unless I explicitly pass --log-bin-index=/var/log/mysql/mysql-bin.log.index, I get this error at the end of my xtrabackup
xtrabackup: Error cannot find current log file in the '/var/log/mysql/mysql-bin.index'
Xtrabackup - xtrabackup version 8.0.7 based on MySQL server 8.0.16 Linux (x86_64) (revision id: 069e0e6)
MySQL - Ver 8.0.17 for Linux on x86_64 (MySQL Community Server - GPL)
Sergei Glushchenko March 5, 2019 at 8:43 PM
Workarounds are:
edit my.cnf (add .index to log-bin-index, or override log-bin-index in [xtrabackup])
run backup with --no-defaults and specify username, socket, etc via command line
pass --log-bin-index via command line (with .index)
Something went wrong on our end
If this keeps happening, share this information with your admin, who should contact support.
Hash 7EYCJU
Trace 7b922ba3567240feb36122b6273ec973
Details
Details
Assignee
Reporter
Time tracking
Affects versions
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist
This is still an issue with Percona Server 8.0.26 and Percona Xtrabackup 8.0.26:
# cat /etc/my.cnf|grep log-bin log-bin log-bin-index=index.txtSHOW MASTER LOGS output:
mysql> SHOW MASTER LOGS; +-------------------+-----------+-----------+ | Log_name | File_size | Encrypted | +-------------------+-----------+-----------+ | mysql2-bin.000001 | 3513496 | No | | mysql2-bin.000002 | 16424459 | No | | mysql2-bin.000003 | 13234741 | No | | mysql2-bin.000004 | 569348409 | No | | mysql2-bin.000005 | 5723383 | No | | mysql2-bin.000006 | 66830908 | No | +-------------------+-----------+-----------+ 6 rows in set (0.01 sec)Contents of index.txt:
# cat /var/lib/mysql/index.txt ./mysql2-bin.000001 ./mysql2-bin.000002 ./mysql2-bin.000003 ./mysql2-bin.000004 ./mysql2-bin.000005 ./mysql2-bin.000006Backup process:
xtrabackup --backup --target-dir=/root/backups /* redacted */ 211221 04:17:24 [01] Copying performance_schema/keyring_componen_202.sdi to /root/backups/performance_schema/keyring_componen_202.sdi 211221 04:17:24 [01] ...done 211221 04:17:24 Finished backing up non-InnoDB tables and files 211221 04:17:24 Executing FLUSH NO_WRITE_TO_BINLOG BINARY LOGS 211221 04:17:24 Selecting LSN and binary log position from p_s.log_status 211221 04:17:24 [00] Copying /var/lib/mysql/mysql2-bin.000007 to /root/backups/mysql2-bin.000007 up to position 1906 211221 04:17:24 [00] ...done xtrabackup: Error cannot open binlog index file 'index.txt.index'