When I upgraded to 2.3 (from 2.2) on a site in which I had table-locking turned on for backups--->, the backup would hang. To get the site back I had to restart mysql.

Without table locking turned on, backup_migrate works fine.

running Drupal 6.19

My box specs:

Architecture: x86_64
MySQL version 5.0.91-community
Apache version 2.2.16
PHP version 5.2.14

thanks for the great module

CommentFileSizeAuthor
#8 backup-migrate-table-lock-952584.patch1.74 KBronan
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

jvieille’s picture

jvieille CreditAttribution: jvieille commented

I confirm this issue.
Actually, backup sometimes succeeds with table locking, but lasts 50x more times

jvieille’s picture

jvieille CreditAttribution: jvieille commented

I confirm this issue.
Actually, backup sometimes succeeds with table locking, but lasts 50x more times

longhornke85’s picture

longhornke85 CreditAttribution: longhornke85 commented

I also confirm this issue.
Since I did the update Monday the site keeps crashing.
I disabled the backup now

Shai’s picture

Shai CreditAttribution: Shai commented

I wrote, via the drupal.org contact form to @ronan, the module maintainer. This is a well maintained module so I'm hopeful this will be attended to quickly.

@longhornke85 you have two other choices besides turning off the module completely.

  1. You can downgrade to version 2.2 by completely removing the backup_migrate 2.3 directory and replacing it with the 2.2 directory. If you use Drush, the command is:

    drush dl backup_migrate-6.x-2.2

    Note that because the upgrade from 2.2 to 2.3 did not include any database-related changes, downgrading Mshould proceed without incident.

  2. Uncheck the box that says "lock tables during backup." I believe that checkbox is on the profile settings under database. That feature did not exist in backup_migrate 1.x and I never had any problems with database corruption.
ronan’s picture

ronan CreditAttribution: ronan commented

I have finally been able to reproduce this and am working on a solution. In the mean time I'd recommend simply disabling the 'Lock Tables' option. We have dozens of sites running scheduled backups without table locking and have never experienced any kind of corruption so you should be pretty safe to run without locking.

I'll report back when I have a patch or update to try.

Thanks
Ronan

ronan’s picture

ronan CreditAttribution: ronan commented
Status: Active » Fixed

I've commited a fix that should go in the next dev release sometime today. Could you guys test that out for me and let me know if it solves your problems?

Thanks

Shai’s picture

Shai CreditAttribution: Shai commented

Hi Ronan,

Thanks much!

If you posted the patch here I'd test it even before it's deployed on drupal.org.

Shai

ronan’s picture

ronan CreditAttribution: ronan commented
FileSize
backup-migrate-table-lock-952584.patch1.74 KB

Here's a patch, let me know if it applies,

Thanks

Shai’s picture

Shai CreditAttribution: Shai commented

Patch applied and fixed problem. Thanx.

Shai

momper’s picture

momper CreditAttribution: momper commented

thanx

Status: Fixed » Closed (fixed)

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