Back Up Migrate hangs and never completes

by TheSnowboardingDev   Last Updated October 09, 2019 16:07 PM - source

I am running into an issue where running drush bam-backup is never completing. It ran for about 18 hours and nothing happened..

The command works and completed on our staging server within about 45 minutes, and when I run SELECT SUM(data_length / 1024 / 1024) FROM information_schema.TABLES; from the sql console, I get a result of 963MB.

On our production server, the same sql query, I get a result of 2.835GB. At most I would expect the back up on production to take at most 3 times as long as it does on staging, but 18 hours seems like something is wrong...

We originally thought that it could be because the db was too large because of all the revision tables, so we cleaned those out; the production database was 109GB before cleaning out the field_revision_field% tables :mind-blown:!

After cleaning them out it's now at 2.835GB.

What could cause drush bam-backup to never complete and just hang there for 18+ hours? I tried running the drush bam-backup command with -v to spit out everything that is happening, but it just says starting backup... and nothing else.

Tags : 7 drush backups

Related Questions

Drush bam-destinations was not found

Updated May 17, 2019 01:07 AM

Backup and Migrate - exclude by wildcard

Updated September 23, 2019 15:07 PM

Backup and Restore Module Limitations

Updated October 10, 2019 20:07 PM

How can I automate backups on Pantheon?

Updated May 25, 2020 12:07 PM