PDA

View Full Version : Backup done but with errors



aankdavid
April 23rd, 2008, 08:08 PM
root@myhost:~# mysql-zrm-scheduler --now --backup-set dailyrun
schedule:INFO: ZRM for MySQL Community Edition - version 2.0
Logging to /var/log/mysql-zrm/mysql-zrm-scheduler.log
backup:INFO: ZRM for MySQL Community Edition - version 2.0
dailyrun:backup:INFO: START OF BACKUP
dailyrun:backup:INFO: PHASE START: Initialization
dailyrun:backup:INFO: Mail address: aankdavid@gmail.com is ok
dailyrun:backup:INFO: ZRM Temporary configuration file = /etc/mysql-zrm/dailyrun/tmpIxrCQ.conf
dailyrun:backup:INFO: {
dailyrun:backup:INFO: verbose=1
dailyrun:backup:INFO: encrypt-plugin=/usr/share/mysql-zrm/plugins/encrypt.pl
dailyrun:backup:INFO: retention-policy=10D
dailyrun:backup:INFO: destination=/data/david/backup
dailyrun:backup:INFO: decrypt-option=-d
dailyrun:backup:INFO: password=******
dailyrun:backup:INFO: backup-mode=logical
dailyrun:backup:INFO: rss-header-location=/etc/mysql-zrm/
dailyrun:backup:INFO: compress-plugin=/usr/bin/gzip
dailyrun:backup:INFO: user=root
dailyrun:backup:INFO: quiet=0
dailyrun:backup:INFO: webserver-url=http://10.1.80.4/mysql-zrm/reports/html/
dailyrun:backup:INFO: backup-level=0
dailyrun:backup:INFO: encrypt=/usr/share/mysql-zrm/plugins/encrypt.pl
dailyrun:backup:INFO: mailto=aankdavid@gmail.com
dailyrun:backup:INFO: databases=cgw1_telkom_mca cgw5_tsel_tunai
dailyrun:backup:INFO: html-reports=backup-status-info
dailyrun:backup:INFO: host=localhost
dailyrun:backup:INFO: html-report-directory=/var/www/htdocs/mysql-zrm/reports/
dailyrun:backup:INFO: compress=/usr/bin/gzip
dailyrun:backup:INFO: mysql-binlog-path=/var/log/mysql
dailyrun:backup:INFO: }
dailyrun:backup:INFO: Getting mysql variables
dailyrun:backup:INFO: mysqladmin --user="root" --password="*****" --host="localhost" variables
dailyrun:backup:INFO: datadir is /var/lib/mysql/
dailyrun:backup:INFO: mysql_version is 4.1.21-log
dailyrun:backup:INFO: InnoDB data file are /var/lib/mysql/ibdata1
dailyrun:backup:INFO: InnoDB log dir is /var/lib/mysql/.
dailyrun:backup:INFO: backup set being used is dailyrun
dailyrun:backup:INFO: backup-set=dailyrun
dailyrun:backup:INFO: backup-date=20080424110223
dailyrun:backup:INFO: mysql-server-os=Linux/Unix
dailyrun:backup:INFO: host=localhost
dailyrun:backup:INFO: backup-date-epoch=1209009743
dailyrun:backup:INFO: retention-policy=10D
dailyrun:backup:INFO: mysql-zrm-version=ZRM for MySQL Community Edition - version 2.0
dailyrun:backup:INFO: mysql-version=4.1.21-log
dailyrun:backup:INFO: backup-directory=/data/david/backup/dailyrun/20080424110223
dailyrun:backup:INFO: backup-level=0
dailyrun:backup:INFO: backup-mode=logical
dailyrun:backup:INFO: PHASE END: Initialization
dailyrun:backup:INFO: PHASE START: Running pre backup plugin
dailyrun:backup:INFO: Executing pre-backup-plugin
dailyrun:backup:INFO: PHASE END: Running pre backup plugin
dailyrun:backup:INFO: PHASE START: Flushing logs
dailyrun:backup:INFO: Flushing the logs
dailyrun:backup:INFO: mysqladmin --user="root" --password="*****" --host="localhost" flush-logs
dailyrun:backup:INFO: Getting master logname using command mysql --user="root" --password="*****" --host="localhost" -e "show master status"
dailyrun:backup:INFO: PHASE END: Flushing logs
dailyrun:backup:INFO: PHASE START: Creating logical backup
dailyrun:backup:INFO: Command used for logical backup is mysqldump --opt --extended-insert --single-transaction --create-options --default-character-set=utf8 --user="root" --password="*****" --host="localhost" --databases cgw1_telkom_mca cgw5_tsel_tunai > "/data/david/backup/dailyrun/20080424110223/backup.sql"
dailyrun:backup:INFO: Logical backup done for the following database(s)
cgw1_telkom_mca cgw5_tsel_tunai
dailyrun:backup:INFO: logical-databases=cgw1_telkom_mca cgw5_tsel_tunai
dailyrun:backup:INFO: PHASE END: Creating logical backup
dailyrun:backup:INFO: PHASE START: Calculating backup size & checksums
dailyrun:backup:INFO: next-binlog=log.000036
dailyrun:backup:INFO: last-backup=/data/david/backup/dailyrun/20080424104515
dailyrun:backup:INFO: backup-size=12.72 MB
dailyrun:backup:INFO: PHASE END: Calculating backup size & checksums
dailyrun:backup:INFO: PHASE START: Compression/Encryption
dailyrun:backup:INFO: Compressing Encrypting backup
dailyrun:backup:INFO: Command used is 'tar --same-owner -cpsC "/data/david/backup/dailyrun/20080424110223" --exclude=backup-data --exclude=index --exclude=zrm_checksum . 2>/tmp/UJ81VHS6Op | "/usr/bin/gzip" 2>/tmp/xE6y9VXFKb | "/usr/share/mysql-zrm/plugins/encrypt.pl" > "/data/david/backup/dailyrun/20080424110223/backup-data" 2>/tmp/aLVd35HGLH'
dailyrun:backup:ERROR: Compressing Encrypting backup failed
dailyrun:backup:ERROR: Output of command: 'compress/encrypt' is {
Passphrase file /etc/mysql-zrm/.passphrase not found at /usr/share/mysql-zrm/plugins/encrypt.pl line 80.
}
dailyrun:backup:INFO: PHASE END: Compression/Encryption
dailyrun:backup:INFO: read-locks-time=00:00:07
dailyrun:backup:INFO: flush-logs-time=00:00:00
dailyrun:backup:INFO: compress-encrypt-time=00:00:07
dailyrun:backup:INFO: backup-time=00:00:08
dailyrun:backup:INFO: backup-status=Backup done but with errors
dailyrun:backup:INFO: Backup done but with errors
dailyrun:backup:INFO: PHASE START: Running post backup plugin
dailyrun:backup:INFO: Executing post-backup-plugin
dailyrun:backup:INFO: PHASE END: Running post backup plugin
dailyrun:backup:INFO: PHASE START: Mailing backup report
dailyrun:backup:INFO: mailing file /tmp/RFEiUntaoO
dailyrun:backup:INFO: mail command is cat "/tmp/RFEiUntaoO"|mail -s "[ZRM for MySQL Report] backup-set dailyrun" aankdavid@gmail.com
dailyrun:backup:INFO: PHASE END: Mailing backup report
dailyrun:backup:INFO: PHASE START: Cleanup
dailyrun:backup:INFO: mailing file /tmp/IrPB6cK5F9
dailyrun:backup:INFO: mail command is cat "/tmp/IrPB6cK5F9"|mail -s "[ZRM for MySQL Report] ERROR during backup of backup-set dailyrun" aankdavid@gmail.com
dailyrun:backup:INFO: PHASE END: Cleanup
dailyrun:backup:INFO: END OF BACKUP
ERROR: /usr/bin/mysql-zrm did not finish successfully
reporter:ERROR: Missing file /data/david/backup/dailyrun/dailyrun/index, can not parse this index file
reporter:ERROR: Missing file /data/david/backup/dailyrun/mysql-zrm.conf/index, can not parse this index file

why every I run mysql-zrm-scheduler --now --backup-set dailyrun
i get Backup status=Backup done but with errors
how to solve this error?
Thanks

kkg
April 23rd, 2008, 08:12 PM
Provide the Passphrase file /etc/mysql-zrm/.passphrase

--kkg

aankdavid
April 23rd, 2008, 08:13 PM
this detail log:
root@myhost:~# more /var/log/mysql-zrm/mysql-zrm.log

Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: START OF BACKUP
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: PHASE START: Initialization
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: Mail address: aankdavid@gmail.com is ok
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: ZRM Temporary configuration file
= /etc/mysql-zrm/dailyrun/tmpBXhzz.conf
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: {
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: verbose=1
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: encrypt-plugin=/usr/shar
e/mysql-zrm/plugins/encrypt.pl
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: retention-policy=10D
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: destination=/data/david/
backup
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: decrypt-option=-d
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: password=******
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: backup-mode=logical
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: rss-header-location=/etc
/mysql-zrm/
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: compress-plugin=/usr/bin
/gzip
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: user=root
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: quiet=0
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: webserver-url=http://10.
1.80.4/mysql-zrm/reports/html/
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: backup-level=0
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: encrypt=/usr/share/mysql
-zrm/plugins/encrypt.pl
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: mailto=aankdavid@gmail.com
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: databases=cgw1_telkom_mc
a cgw5_tsel_tunai
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: html-reports=backup-stat
us-info
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: host=localhost
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: html-report-directory=/v
ar/www/htdocs/mysql-zrm/reports/
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: compress=/usr/bin/gzip
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: mysql-binlog-path=/var/l
og/mysql
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: }
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: Getting mysql variables
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: mysqladmin --user="root" --passw
ord="*****" --host="localhost" variables
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: datadir is /var/lib/mysql/
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: mysql_version is 4.1.21-log
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: InnoDB data file are /var/lib/my
sql/ibdata1
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: InnoDB log dir is /var/lib/mysql
/.
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: backup set being used is dailyru
n
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: backup-set=dailyrun
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: backup-date=20080424104515
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: mysql-server-os=Linux/Unix
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: host=localhost
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: backup-date-epoch=1209008715
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: retention-policy=10D
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: mysql-zrm-version=ZRM for MySQL
Community Edition - version 2.0
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: mysql-version=4.1.21-log
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: backup-directory=/data/david/bac
kup/dailyrun/20080424104515
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: backup-level=0
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: backup-mode=logical
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: PHASE END: Initialization
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: PHASE START: Running pre backup
plugin
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: Executing pre-backup-plugin
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: PHASE END: Running pre backup pl
ugin
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: PHASE START: Flushing logs
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: Flushing the logs
Thu Apr 24 10:45:15 2008: dailyrun:backup:INFO: mysqladmin --user="root" --passw
ord="*****" --host="localhost" flush-logs
Thu Apr 24 10:45:16 2008: dailyrun:backup:INFO: Getting master logname using com
mand mysql --user="root" --password="*****" --host="localhost" -e "show master s
tatus"
Thu Apr 24 10:45:16 2008: dailyrun:backup:INFO: PHASE END: Flushing logs
Thu Apr 24 10:45:16 2008: dailyrun:backup:INFO: PHASE START: Creating logical ba
ckup
Thu Apr 24 10:45:16 2008: dailyrun:backup:INFO: Command used for logical backup
is mysqldump --opt --extended-insert --single-transaction --create-options --def
ault-character-set=utf8 --user="root" --password="*****" --host="localhost" --da
tabases cgw1_telkom_mca cgw5_tsel_tunai > "/data/david/backup/dailyrun/200804241
04515/backup.sql"
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: Logical backup done for the foll
owing database(s)
cgw1_telkom_mca cgw5_tsel_tunai
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: logical-databases=cgw1_telkom_mc
a cgw5_tsel_tunai
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: PHASE END: Creating logical back
up
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: PHASE START: Calculating backup
size & checksums
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: next-binlog=log.000035
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: last-backup=/data/david/backup/d
ailyrun/20080424104046
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: backup-size=12.72 MB
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: PHASE END: Calculating backup si
ze & checksums
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: PHASE START: Compression/Encrypt
ion
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: Compressing Encrypting backup
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: Command used is 'tar --same-own
er -cpsC "/data/david/backup/dailyrun/20080424104515" --exclude=backup-data -
-exclude=index --exclude=zrm_checksum . 2>/tmp/tUTBZf7Yji | "/usr/bin/gzip" 2>
/tmp/gH5FsBvIXI | "/usr/share/mysql-zrm/plugins/encrypt.pl" > "/data/david/backu
p/dailyrun/20080424104515/backup-data" 2>/tmp/pxTUhbujyb'
Thu Apr 24 10:45:23 2008: dailyrun:backup:ERROR: Compressing Encrypting backup
failed
Thu Apr 24 10:45:23 2008: dailyrun:backup:ERROR: Output of command: 'compress/en
crypt' is {
Passphrase file /etc/mysql-zrm/.passphrase not found at /usr/share/mysql-zrm/plu
gins/encrypt.pl line 80.
}
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: PHASE END: Compression/Encryptio
n
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: read-locks-time=00:00:07
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: flush-logs-time=00:00:01
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: compress-encrypt-time=00:00:07
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: backup-time=00:00:08
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: backup-status=Backup done but wi
th errors
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: Backup done but with errors
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: PHASE START: Running post backup
plugin
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: Executing post-backup-plugin
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: PHASE END: Running post backup p
lugin
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: PHASE START: Mailing backup repo
rt
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: mailing file /tmp/Oh8jfUbSmh
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: mail command is cat "/tmp/Oh8jfU
bSmh"|mail -s "[ZRM for MySQL Report] backup-set dailyrun" aankdavid@gmail.com
Thu Apr 24 10:45:23 2008: dailyrun:backup:INFO: PHASE END: Mailing backup report
Thu Apr 24 10:45:24 2008: dailyrun:backup:INFO: PHASE START: Cleanup
Thu Apr 24 10:45:24 2008: dailyrun:backup:INFO: mailing file /tmp/Het9h1dSuk
Thu Apr 24 10:45:24 2008: dailyrun:backup:INFO: mail command is cat "/tmp/Het9h1
dSuk"|mail -s "[ZRM for MySQL Report] ERROR during backup of backup-set dailyrun
" aankdavid@gmail.com
Thu Apr 24 10:45:24 2008: dailyrun:backup:INFO: PHASE END: Cleanup
Thu Apr 24 10:45:24 2008: dailyrun:backup:INFO: END OF BACKUP