PDA

View Full Version : Backup of Replication Database: relay-log.info ERROR



mismatch
July 19th, 2007, 09:42 AM
Hi There,

I heard about ZRM and I am currently in the process of testing out its functionality to determine if we can use this in our company.

I am trying to make a full backup of a replication database (replication set to 1 in config file) and I get an error saying it could not copy relay-log.info.

We are storing this file in a different location in our replication database and I assume that ZRM is looking for this file in the default location. Is there any variable we can set that would change the directory it is looking for (for this particular file:relay-log.info)?

The Error is:
WeeklyTest:backup:ERROR: Could not copy file /var/lib/mysql/data/table_info/relay-log.info
WeeklyTest:backup:ERROR: copy-plugin exited with error 512
WeeklyTest:backup:ERROR: Error backing up relay-log.info


Here is the output of the backup performed:

schedule:INFO: ZRM for MySQL Community Edition - version 1.2
Logging to /var/log/mysql-zrm/mysql-zrm-scheduler.log
backup:INFO: ZRM for MySQL Community Edition - version 1.2
WeeklyTest:backup:INFO: backup-set=WeeklyTest
WeeklyTest:backup:INFO: backup-date=20070719094943
WeeklyTest:backup:INFO: host=xx.xx.xx.xx
WeeklyTest:backup:INFO: backup-date-epoch=1184863783
WeeklyTest:backup:INFO: mysql-zrm-version=ZRM for MySQL Community Edition - version 1.2
WeeklyTest:backup:INFO: mysql-version=5.0.41-community-log
WeeklyTest:backup:INFO: backup-directory=/var/lib/mysql-zrm/WeeklyTest/20070719094943
WeeklyTest:backup:INFO: replication=master.info
gzip: stdin: unexpected end of file
/bin/tar: Child returned status 1
/bin/tar: Error exit delayed from previous errors
close of pipe failed
WeeklyTest:backup:ERROR: Could not copy file /var/lib/mysql/data/table_info/relay-log.info
WeeklyTest:backup:ERROR: copy-plugin exited with error 512
WeeklyTest:backup:ERROR: Error backing up relay-log.info
WeeklyTest:backup:INFO:
WeeklyTest:backup:INFO: backup-level=0
WeeklyTest:backup:INFO: logical-databases=exampledb mysql test
WeeklyTest:backup:INFO: next-binlog=changes.000050
WeeklyTest:backup:INFO: last-backup=/var/lib/mysql-zrm/WeeklyTest/20070719094851
WeeklyTest:backup:INFO: /var/lib/mysql-zrm/WeeklyTest/20070719094943/backup.sql=90ce110965bc80fedcf03b4f5dbda5b4
WeeklyTest:backup:INFO: /var/lib/mysql-zrm/WeeklyTest/20070719094943/master.info=cce8df67f3149644a3f08d6ba94b3036
WeeklyTest:backup:INFO: backup-size=0.37 MB
WeeklyTest:backup:INFO: read-locks-time=00:00:00
WeeklyTest:backup:INFO: flush-logs-time=00:00:00
WeeklyTest:backup:INFO: backup-time=00:00:02
WeeklyTest:backup:INFO: backup-status=Backup done but with errors
WeeklyTest:backup:INFO: Backup done but with errors
ERROR: /usr/bin/mysql-zrm did not finish successfully

Please let me know of any possible solutions to this problem.

-- rp

kkg
July 19th, 2007, 11:01 PM
Hi There,

I heard about ZRM and I am currently in the process of testing out its functionality to determine if we can use this in our company.

I am trying to make a full backup of a replication database (replication set to 1 in config file) and I get an error saying it could not copy relay-log.info.

We are storing this file in a different location in our replication database and I assume that ZRM is looking for this file in the default location. Is there any variable we can set that would change the directory it is looking for (for this particular file:relay-log.info)?

The Error is:
WeeklyTest:backup:ERROR: Could not copy file /var/lib/mysql/data/table_info/relay-log.info
WeeklyTest:backup:ERROR: copy-plugin exited with error 512
WeeklyTest:backup:ERROR: Error backing up relay-log.info


Here is the output of the backup performed:

schedule:INFO: ZRM for MySQL Community Edition - version 1.2
Logging to /var/log/mysql-zrm/mysql-zrm-scheduler.log
backup:INFO: ZRM for MySQL Community Edition - version 1.2
WeeklyTest:backup:INFO: backup-set=WeeklyTest
WeeklyTest:backup:INFO: backup-date=20070719094943
WeeklyTest:backup:INFO: host=xx.xx.xx.xx
WeeklyTest:backup:INFO: backup-date-epoch=1184863783
WeeklyTest:backup:INFO: mysql-zrm-version=ZRM for MySQL Community Edition - version 1.2
WeeklyTest:backup:INFO: mysql-version=5.0.41-community-log
WeeklyTest:backup:INFO: backup-directory=/var/lib/mysql-zrm/WeeklyTest/20070719094943
WeeklyTest:backup:INFO: replication=master.info
gzip: stdin: unexpected end of file
/bin/tar: Child returned status 1
/bin/tar: Error exit delayed from previous errors
close of pipe failed
WeeklyTest:backup:ERROR: Could not copy file /var/lib/mysql/data/table_info/relay-log.info
WeeklyTest:backup:ERROR: copy-plugin exited with error 512
WeeklyTest:backup:ERROR: Error backing up relay-log.info
WeeklyTest:backup:INFO:
WeeklyTest:backup:INFO: backup-level=0
WeeklyTest:backup:INFO: logical-databases=exampledb mysql test
WeeklyTest:backup:INFO: next-binlog=changes.000050
WeeklyTest:backup:INFO: last-backup=/var/lib/mysql-zrm/WeeklyTest/20070719094851
WeeklyTest:backup:INFO: /var/lib/mysql-zrm/WeeklyTest/20070719094943/backup.sql=90ce110965bc80fedcf03b4f5dbda5b4
WeeklyTest:backup:INFO: /var/lib/mysql-zrm/WeeklyTest/20070719094943/master.info=cce8df67f3149644a3f08d6ba94b3036
WeeklyTest:backup:INFO: backup-size=0.37 MB
WeeklyTest:backup:INFO: read-locks-time=00:00:00
WeeklyTest:backup:INFO: flush-logs-time=00:00:00
WeeklyTest:backup:INFO: backup-time=00:00:02
WeeklyTest:backup:INFO: backup-status=Backup done but with errors
WeeklyTest:backup:INFO: Backup done but with errors
ERROR: /usr/bin/mysql-zrm did not finish successfully

Please let me know of any possible solutions to this problem.

-- rp


ZRM currently only supports backup of the relay-log.info from the default location. But this is something that will be done in the coming releases. I would suggest creating a bug report for this in http://forums.zmanda.com/bugzilla/ so that this can be tracked.

This will ensure that this is tracked.

kkg
July 19th, 2007, 11:09 PM
Hi There,

I heard about ZRM and I am currently in the process of testing out its functionality to determine if we can use this in our company.

I am trying to make a full backup of a replication database (replication set to 1 in config file) and I get an error saying it could not copy relay-log.info.

We are storing this file in a different location in our replication database and I assume that ZRM is looking for this file in the default location. Is there any variable we can set that would change the directory it is looking for (for this particular file:relay-log.info)?

The Error is:
WeeklyTest:backup:ERROR: Could not copy file /var/lib/mysql/data/table_info/relay-log.info
WeeklyTest:backup:ERROR: copy-plugin exited with error 512
WeeklyTest:backup:ERROR: Error backing up relay-log.info


Here is the output of the backup performed:

schedule:INFO: ZRM for MySQL Community Edition - version 1.2
Logging to /var/log/mysql-zrm/mysql-zrm-scheduler.log
backup:INFO: ZRM for MySQL Community Edition - version 1.2
WeeklyTest:backup:INFO: backup-set=WeeklyTest
WeeklyTest:backup:INFO: backup-date=20070719094943
WeeklyTest:backup:INFO: host=xx.xx.xx.xx
WeeklyTest:backup:INFO: backup-date-epoch=1184863783
WeeklyTest:backup:INFO: mysql-zrm-version=ZRM for MySQL Community Edition - version 1.2
WeeklyTest:backup:INFO: mysql-version=5.0.41-community-log
WeeklyTest:backup:INFO: backup-directory=/var/lib/mysql-zrm/WeeklyTest/20070719094943
WeeklyTest:backup:INFO: replication=master.info
gzip: stdin: unexpected end of file
/bin/tar: Child returned status 1
/bin/tar: Error exit delayed from previous errors
close of pipe failed
WeeklyTest:backup:ERROR: Could not copy file /var/lib/mysql/data/table_info/relay-log.info
WeeklyTest:backup:ERROR: copy-plugin exited with error 512
WeeklyTest:backup:ERROR: Error backing up relay-log.info
WeeklyTest:backup:INFO:
WeeklyTest:backup:INFO: backup-level=0
WeeklyTest:backup:INFO: logical-databases=exampledb mysql test
WeeklyTest:backup:INFO: next-binlog=changes.000050
WeeklyTest:backup:INFO: last-backup=/var/lib/mysql-zrm/WeeklyTest/20070719094851
WeeklyTest:backup:INFO: /var/lib/mysql-zrm/WeeklyTest/20070719094943/backup.sql=90ce110965bc80fedcf03b4f5dbda5b4
WeeklyTest:backup:INFO: /var/lib/mysql-zrm/WeeklyTest/20070719094943/master.info=cce8df67f3149644a3f08d6ba94b3036
WeeklyTest:backup:INFO: backup-size=0.37 MB
WeeklyTest:backup:INFO: read-locks-time=00:00:00
WeeklyTest:backup:INFO: flush-logs-time=00:00:00
WeeklyTest:backup:INFO: backup-time=00:00:02
WeeklyTest:backup:INFO: backup-status=Backup done but with errors
WeeklyTest:backup:INFO: Backup done but with errors
ERROR: /usr/bin/mysql-zrm did not finish successfully

Please let me know of any possible solutions to this problem.

-- rp


As a work around, you could try creating a symlink to this file in the default location.

--kkg

mismatch
July 20th, 2007, 02:54 PM
I already tried symlinks. If we do a symlink the backup is executed successfully but the backup only copies the link and not the actual file itself.

I tried a hard link and that solved the problem in my test server. But when I went to try it on another one, it wouldn't work because the two locations are in different partitions.

I shall submit a bug report soon.

-- rp