Bug #64849 MysqlHotCopy delete original database when no disk space

• Submitted: 2 Apr 2012 21:56
• Modified: 12 May 2012 20:12
• Reporter: Loki Tek
• Status: No Feedback
• Category: Tests: Backup
• Severity: S7 (Test Cases)
• Version: 1.23
• OS: Any
• CPU Architecture: Any
• Tags: mysqlhotcopy

[2 Apr 2012 21:56] Loki Tek

Description:
When using mysqlhotcopy on a disk that is almost full, it seems that mysqlhotcopy will delete the original database files

How to repeat:
Have mysql running
fill up the hard drive to be 98% full
try to mysqlhotcopy a database that is greater than 5% of disk space remaining:
mysqlhotcopy --quiet -u root large_database /backup_folder_on_same_disk

mysqlhotcopy will remove the original database while trying to copy it to the backup folder location

Suggested fix:
MysqlHotCopy should error out indicating that it cannot create the backup AND leave the original files alone.

[10 Apr 2012 19:49] Sveta Smirnova

Thank you for the report.

I can not repeat described behavior. Please remove option --quiet and send us full output of the mysqlhotcopy command.

[10 Apr 2012 19:50] Sveta Smirnova

Please also specify which server version do you use.

[11 Apr 2012 16:34] Loki Tek

mysql  Ver 14.12 Distrib 5.0.77

I'll try to re-create a server almost full situation to get more information from this.

[11 Apr 2012 16:43] Loki Tek

Server is: CentOS release 5.7

[12 Apr 2012 20:12] Sveta Smirnova

Thank you for the feedback.

Please try with latest version: 5.0.77 is pretty old. Current 5.0 is 5.0.95

[13 May 2012 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".