A restauração do MySQL ZRM falhou com o comando mysql error unknown \ 0

2

Estou restaurando um backup incremental com o servidor ZRM no banco de dados mysql. Eu estou tendo dados de blobs nas tabelas. O backup incremental não está sendo restaurado e causando erro no mysql unknown command 'max_allowed_packet_size' .

Tentei alterar o %code% para 1 GB e também obter o problema. Verificou a configuração do ZRM para adicionar o -hex-blob, mas não adiantou.

Erro após restaurar o backup com --verbose:

restore:INFO: ZRM for MySQL Community Edition - version 2.2.0
restore:INFO: Reading options from file /etc/mysql-zrm/mysql-zrm.conf
BackupSet1:restore:WARNING: Could not open file /etc/mysql-zrm/BackupSet1/last_backup. No such file or directory
BackupSet1:restore:INFO: Using /usr/share/mysql-zrm/plugins/ssh-copy.pl as the default plugin since copy-plugin has not been specified
BackupSet1:restore:INFO: ZRM Temporary configuration file = /etc/mysql-zrm/BackupSet1/tmpewWlH.conf
BackupSet1:restore:INFO: {
BackupSet1:restore:INFO:        backup-level=0
BackupSet1:restore:INFO:        destination=/mysql_backup/mysql-zrm
BackupSet1:restore:INFO:        databases=main
BackupSet1:restore:INFO:        source-directory=/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902
BackupSet1:restore:INFO:        mail-policy=always
BackupSet1:restore:INFO:        backup-mode=raw
BackupSet1:restore:INFO:        password=******
BackupSet1:restore:INFO:        backup-type=regular
BackupSet1:restore:INFO:        copy-plugin=/usr/share/mysql-zrm/plugins/ssh-copy.pl
BackupSet1:restore:INFO: }
BackupSet1:restore:INFO: Getting mysql variables
BackupSet1:restore:INFO: mysqladmin --password="*****"  variables
BackupSet1:restore:INFO: datadir is /var/lib/mysql/
BackupSet1:restore:INFO: mysql_version is 5.5.20-log
BackupSet1:restore:INFO: InnoDB data file are /var/lib/mysql/ibdata1
BackupSet1:restore:INFO: InnoDB log dir is /var/lib/mysql/.
BackupSet1:restore:INFO: Command used is 'cat "/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902/backup-data"  | "/usr/share/mysql-zrm/plugins/encrypt.pl" -d |  "/usr/bin/gzip" -d  | tar  --same-owner -xpsC  "/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902"  2>/tmp/gIJmM6bLwF'
BackupSet1:restore:INFO: Executing pre-restore-plugin
BackupSet1:restore:INFO: BINLOG =  mysqlbinlog --password="*****" --database=main "/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902"/mysql-bin.[0-9]* >> /tmp/nADdF9OfBn
BackupSet1:restore:INFO: Restoring incremental to file
BackupSet1:restore:INFO: mysqlbinlog --password="*****"  --database=main "/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902"/mysql-bin.[0-9]* >> /tmp/nADdF9OfBn
BackupSet1:restore:INFO: restoring using command mysql --password="*****" -e "source /tmp/nADdF9OfBn;"
BackupSet1:restore:ERROR: Output of command: 'mysql --password="*****" -e "source /tmp/nADdF9OfBn;"' is {
ERROR at line 202087 in file: '/tmp/nADdF9OfBn': 'Unknown command '
restore:INFO: ZRM for MySQL Community Edition - version 2.2.0
restore:INFO: Reading options from file /etc/mysql-zrm/mysql-zrm.conf
BackupSet1:restore:WARNING: Could not open file /etc/mysql-zrm/BackupSet1/last_backup. No such file or directory
BackupSet1:restore:INFO: Using /usr/share/mysql-zrm/plugins/ssh-copy.pl as the default plugin since copy-plugin has not been specified
BackupSet1:restore:INFO: ZRM Temporary configuration file = /etc/mysql-zrm/BackupSet1/tmpewWlH.conf
BackupSet1:restore:INFO: {
BackupSet1:restore:INFO:        backup-level=0
BackupSet1:restore:INFO:        destination=/mysql_backup/mysql-zrm
BackupSet1:restore:INFO:        databases=main
BackupSet1:restore:INFO:        source-directory=/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902
BackupSet1:restore:INFO:        mail-policy=always
BackupSet1:restore:INFO:        backup-mode=raw
BackupSet1:restore:INFO:        password=******
BackupSet1:restore:INFO:        backup-type=regular
BackupSet1:restore:INFO:        copy-plugin=/usr/share/mysql-zrm/plugins/ssh-copy.pl
BackupSet1:restore:INFO: }
BackupSet1:restore:INFO: Getting mysql variables
BackupSet1:restore:INFO: mysqladmin --password="*****"  variables
BackupSet1:restore:INFO: datadir is /var/lib/mysql/
BackupSet1:restore:INFO: mysql_version is 5.5.20-log
BackupSet1:restore:INFO: InnoDB data file are /var/lib/mysql/ibdata1
BackupSet1:restore:INFO: InnoDB log dir is /var/lib/mysql/.
BackupSet1:restore:INFO: Command used is 'cat "/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902/backup-data"  | "/usr/share/mysql-zrm/plugins/encrypt.pl" -d |  "/usr/bin/gzip" -d  | tar  --same-owner -xpsC  "/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902"  2>/tmp/gIJmM6bLwF'
BackupSet1:restore:INFO: Executing pre-restore-plugin
BackupSet1:restore:INFO: BINLOG =  mysqlbinlog --password="*****" --database=main "/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902"/mysql-bin.[0-9]* >> /tmp/nADdF9OfBn
BackupSet1:restore:INFO: Restoring incremental to file
BackupSet1:restore:INFO: mysqlbinlog --password="*****"  --database=main "/mysql_backup/mysql-zrm/DailyBackup_SSH/20130212170902"/mysql-bin.[0-9]* >> /tmp/nADdF9OfBn
BackupSet1:restore:INFO: restoring using command mysql --password="*****" -e "source /tmp/nADdF9OfBn;"
BackupSet1:restore:ERROR: Output of command: 'mysql --password="*****" -e "source /tmp/nADdF9OfBn;"' is {
ERROR at line 202087 in file: '/tmp/nADdF9OfBn': 'Unknown command '%pre%''.
}
ERROR: Incremental restore failed
BackupSet1:restore:ERROR: Incremental restore failed
BackupSet1:restore:INFO: Removing all of the uncompressed/unencrypted data
BackupSet1:restore:INFO: Executing post-restore-plugin
BackupSet1:restore:ERROR: Restore failed
''. } ERROR: Incremental restore failed BackupSet1:restore:ERROR: Incremental restore failed BackupSet1:restore:INFO: Removing all of the uncompressed/unencrypted data BackupSet1:restore:INFO: Executing post-restore-plugin BackupSet1:restore:ERROR: Restore failed

Todas as sugestões são muito apreciadas e agradecemos antecipadamente.

    
por Viswanath 15.02.2013 / 09:41

1 resposta

1

Não obtivemos nenhuma solução para restaurar o backup de dados do blob capturado, causando Unknown command de erro. Para evitar esse erro de restauração, adicionamos extra-mysqldump-options="--hex-blob --skip-extended-insert" no arquivo mysql-zrm.conf .

Espero que isso ajude alguém !!

    
por 16.10.2013 / 07:38