MySQL Backup Enterprise (MEB) Not Working For A Slave Server That Replicates From Multiple Masters (multi-source replication)
Last updated on MARCH 19, 2018
Applies to:
MySQL Enterprise Backup - Version 4.0 to 4.0 [Release 4.0]Information in this document applies to any platform.
Symptoms
Using MySQL Enterprise Backup (MEB) 4.0.0 using mysqlbackup to backup slave server which replicates from multiple master using the command:
mysqlbackup --defaults-file=/etc/my.cnf.d/my.cnf --compress --host 127.0.0.1 --password --port=3306 --with-timestamp --backup-dir=/var/backup/ --backup-image=my.backup --slave-info backup-to-image
The below error is displayed:
mysqlbackup: INFO: System tablespace file format is Barracuda.
mysqlbackup: INFO: Starting to copy all innodb files...
mysqlbackup: ERROR: SHOW SLAVE STATUS: num_rows or num_fields assertion failed
mysqlbackup: ERROR: Unable to retrieve current log file name from server during initialization for online backup.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms