I noticed earlier today that I was no longer able to clone sites on my remote server. After some further investigation, I determined the real problem was that the backup task which is run as part of the migrate, was generating an empty database.sql file. I then tried to run tha backup on its own, and discovered the same thing was happening.

I've attached the output of running the provision-backup command.

from the output, rsync is saying the database.sql file being generated is 0 size.

If someone can point me in the right direction in regards to the commands that are running, I can try to get the actual output of the backup command to see why it's spitting out an empty databse dump.

CommentFileSizeAuthor
failed-backup.txt25.43 KBzxaos
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

joestewart’s picture

I don't know if it helps, but an empty database.sql was reported with the DEFINER problems - http://drupal.org/node/1324466#comment-5634106

zxaos’s picture

I wasn't using the Ubercart module, and the database dump in-fact works when called on the remote server.

Further examination showed that the issue may have been caused by my server thinking that my aegir instance has changed hostnames (it hasn't) so the mysql users might have the wrong hosts. This probably isn't an aegir bug, but rather some other issue.

However, an issue does still remain in that the backup task was reporting success when it was in fact generating backups that would not be able to be restored due to the empty database file - whatever the reason it occured, that should be raising and error of some kind probably.

Steven Jones’s picture

Title: provision-backup succeeds, but generates an empty database.sql file » An empty DB backup should raise an error

You're right, and this should be simple to fix, we just need to check to see if the size of our DB is > 0 and if not, raise an error.

ergonlogic’s picture

Version: 6.x-1.9 » 7.x-3.x-dev
Issue summary: View changes
Status: Active » Postponed (maintainer needs more info)

Is this still an issue in Aegir 3.x?

ergonlogic’s picture

Status: Postponed (maintainer needs more info) » Fixed

Such a check was put in a while back.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.