| Bug #75092 | Full Backup succeeds but incrementals fail | ||
|---|---|---|---|
| Submitted: | 3 Dec 2014 14:33 | Modified: | 10 Dec 2015 2:06 |
| Reporter: | Noel Lucas | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench: Administration | Severity: | S2 (Serious) |
| Version: | 6.2.4 | OS: | Windows (2008 R2) |
| Assigned to: | CPU Architecture: | Any | |
[20 Dec 2014 7:17]
MySQL Verification Team
Hello Noel Lucas,
Thank you for report.
Observed this behavior when there is a space in between dir names but problem observed only with incremental backup and full backup succeeded.
// MySQL workbench - incremental backuplog
MySQL Enterprise Backup version 3.11.1 Windows-6.0-x86 [Tue 11/04/2014 ]
Copyright (c) 2003, 2014, Oracle and/or its affiliates. All Rights Reserved.
// Manually executed incemental backup in WB
mysqlbackup: INFO: Starting with following command line ...
D:\ushastry\MEB\meb-3.11.1-windows-x86-64bit\bin\mysqlbackup.exe
--defaults-file=D:\ushastry\MySQLBackupHome\9bf3b530-880d-11e4-b815-bc305bc8d894.cnf
--incremental --incremental-base=dir:D:\ushastry\MySQLBackupHome\Bug
75092\2014-12-20_12-24-38
--incremental-backup-dir=D:\ushastry\MySQLBackupHome\Bug 75092\inc\2014-12-20_12-25-29
--show-progress=stdout backup
mysqlbackup: ERROR: Found extraneous commands at the end.
Use --help option for usage description.
mysqlbackup failed with errors!
Thanks,
Umesh
[20 Dec 2014 7:19]
MySQL Verification Team
// MEB CLI ( workaround is to enclose dir if there is space in it) D:\ushastry\MEB\meb-3.11.1-windows-x86-64bit\bin>mysqlbackup.exe --defaults-file=D:\ushastry\MySQLBackupHome\9bf3b530-880d-11e4-b815-bc305bc8d894.cnf --incremental --incremental-base-dir=D:\ushastry\MySQLBackupHome\Bug 75092\2014-12-20_12-24-38 --incremental-backup-dir=D:\ushastry\MySQLBackupHome \Bug 75092\inc\2014-12-20_12-25-29 --show-progress=stdout backup MySQL Enterprise Backup version 3.11.1 Windows-6.0-x86 [Tue 11/04/2014 ] Copyright (c) 2003, 2014, Oracle and/or its affiliates. All Rights Reserved. mysqlbackup: INFO: Starting with following command line ... mysqlbackup.exe --defaults-file=D:\ushastry\MySQLBackupHome\9bf3b530-880d-11e4-b815-bc305bc8d894.cnf --incremental --incremental-base=dir:D:\ushastry\MySQLBackupHome\Bug 75092\2014-12-20_12-24-38 --incremental-backup-dir=D:\ushastry\MySQLBackupHome\Bug 75092\inc\2014-12-20_12-25-29 --show-progress=stdout backup mysqlbackup: ERROR: Found extraneous commands at the end. Use --help option for usage description. mysqlbackup failed with errors!
[20 Dec 2014 7:19]
MySQL Verification Team
// Full backup completed without any issue
MySQL Enterprise Backup version 3.11.1 Windows-6.0-x86 [Tue 11/04/2014 ]
Copyright (c) 2003, 2014, Oracle and/or its affiliates. All Rights Reserved.
mysqlbackup: INFO: Starting with following command line ...
D:\ushastry\MEB\meb-3.11.1-windows-x86-64bit\bin\mysqlbackup.exe
--defaults-file=D:\ushastry\MySQLBackupHome\9bf3b530-880d-11e4-b815-bc305bc8d894.cnf
--backup-dir=D:\ushastry\MySQLBackupHome\Bug 75092\2014-12-20_12-24-38
--show-progress=stdout backup
..
-------------------------------------------------------------
Parameters Summary
-------------------------------------------------------------
Start LSN : 2358065664
End LSN : 2358066122
-------------------------------------------------------------
mysqlbackup completed OK!
[20 Dec 2014 7:22]
MySQL Verification Team
// One more issue observed here - INCREMENTAL backup failed but status shows as "SUCCESS" which could lead to problem unless someone goes and check backup log
[20 Dec 2014 7:34]
MySQL Verification Team
Screenshot..
Attachment: 75092.png (image/png, text), 38.33 KiB.
[10 Dec 2015 2:06]
Philip Olson
Posted by developer: Fixed as of the upcoming MySQL Workbench 6.3.6 release, and here's the changelog entry: Scheduled incremental backups would not function if the file path contained spaces. Thank you for the bug report.
Description: Used MySQL WB 6.1 to schedule a weekly full backup and a daily incremental backup. The full backup runs successfully. The incrementals fail with the error shown below (incrementals.log). Incrementals.log: MySQL Enterprise Backup version 3.11.0 Windows-6.0-x86 [Tue 08/26/2014 ] Copyright (c) 2003, 2014, Oracle and/or its affiliates. All Rights Reserved. mysqlbackup: INFO: Starting with following command line ... C:\Program Files\MySQL\MySQL Enterprise Backup 3.11\mysqlbackup.exe --defaults-file=D:\Backups\5b3b3900-7449-11e4-9e41-ecf4bbc7dcd5.cnf --incremental --incremental-base=dir:D:\Backups\Prod Aperio\2014-11-30_01-00-00 --incremental-backup-dir=D:\Backups\Prod Aperio\inc\2014-12-02_21-00-00 --show-progress=stdout backup mysqlbackup: ERROR: Found extraneous commands at the end. Use --help option for usage description. mysqlbackup failed with errors! How to repeat: Schedule via MySQL Workbench.