PDA

View Full Version : backup failed



ntenz
November 10th, 2009, 12:25 AM
Hi there,

I have installed a trial version of zmanda and installed the client on a server. But evertime I try to create a backup it fails.

zmc_dblogger:9:55:23, Tue Nov 10, 2009: Message received: {ID:2, subsystem:Tasks, severity:Info}{configuration:test}{datestamp:20091 110095523}{log_message:16: Task is running}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:schedule, severity:warning}{configuration:test}{datestamp:20 091110095524}{log_message:last backup directory is not valid}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:START OF BACKUP}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:PHASE START: Initialization}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:warning}{configuration:test}{datestamp:20 091110095524}{log_message:last backup directory is not valid}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:The quick backup-type is supported only for snapshot backups. Setting backup-type to 'regular'}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:warning}{configuration:test}{datestamp:20 091110095524}{log_message:Your subscription for Zmanda Recovery Manager will expire in 18 days. Click <a href='http://network.zmanda.com/shop/home.php?cat=3' target='_new'>here</a> to purchase or renew, or contact Zmanda Sales (zsales@zmanda.com) to renew.}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:License check successful}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:backup-set=test}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:backup-date=20091110095524}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:mysql-server-os=Linux/Unix}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:backup-type=regular}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:host=tvserver}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:backup-date-epoch=1257843324}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:retention-policy=2D}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:mysql-zrm-version=ZRM for MySQL Enterprise Edition - version 3.1}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:mysql-version=5.1.34-percona-log}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:backup-directory=/data/mysql-zrm/test/20091110095524}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:backup-level=0}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:backup-mode=logical}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:PHASE END: Initialization}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:PHASE START: Running pre backup plugin}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:PHASE END: Running pre backup plugin}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:PHASE START: Flushing logs}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:PHASE END: Flushing logs}
zmc_dblogger:9:55:24, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:info}{configuration:test}{datestamp:20091 110095524}{log_message:PHASE START: Creating logical backup}
zmc_dblogger:9:58:4, Tue Nov 10, 2009: Message received: {ID:2, subsystem:backup, severity:failure}{configuration:test}{datestamp:20 091110095804}{log_message:mysqldump did not succeed.<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp; Command used is "/usr/bin"/mysqldump --opt --extended-insert --create-options --default-character-set=utf8 --single-transaction --user="zmanda" --password="*****" --host="tvserver" --databases bot tmpbot > "/data/mysql-zrm/test/20091110095524/backup.sql"}



TimeStamp: 04:00:02

BACKUP SUMMARY:
Backup Type = Copy
Backup Level = 0
MySQL Version = 5.1.34-percona-log
Host = tvc
Retention policy = 2D
Compress = No
Encrypted = No

STATISTICS:

ERRORS:
- mysqldump did not succeed.
- Command used is \"/usr/bin\"/mysqldump --opt --extended-insert --create-options --default-character-set=utf8 --single-transaction --user=\"zmanda\" --password=\"*****\" --host=\"tvserver\" --databases bot tmpbot > \"/data/mysql-zrm/test/20091104040002/backup.sql\"
WARNINGS:
The database(s) bot11 tmpbot will be backed up in logical mode since they contain tables that use a transactional engine.

paddy
November 10th, 2009, 08:49 AM
It appears that you are using ZRM enterprise edition. Please check to see if "zmanda" mysql user has sufficient privileges to perform backup. Please see documentation for the list of privileges that are required.

Can you please open a support case?

Please set verbose=1 in the /etc/mysql-zrm/test/mysql-zrm.conf file and run backup again. Please attach a copy of /var/log/mysql-zrm/mysql-zrm.log file.

thanks,
Paddy