MySQL Backup Enterprise (MEB) Not Working For A Slave Server That Replicates From Multiple Masters (multi-source replication) (Doc ID 2144558.1)

Last updated on MARCH 06, 2017

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