I've been using this module for a long time and have never come across this before.

When attempting a download backup, the backup fails silently. Checking Watchdog shows the following errors:

  • Could not complete the backup.
  • MySQL server has gone away query: DELETE FROM cache_form WHERE cid = 'form_form-a8507f40fba239b9d0faf04d3713b03b' in /home/aangel/public_html/includes/cache.inc on line 179.
  • MySQL server has gone away query: DELETE FROM cache_form WHERE cid = 'storage_form-a8507f40fba239b9d0faf04d3713b03b' in /home/aangel/public_html/includes/cache.inc on line 179.
  • MySQL server has gone away query: UPDATE sessions SET uid = 1, cache = 0, hostname = '24.6.229.167', session = 'updates_remaining|a:0:{}node_overview_filter|a:0:{}ad_overview_filter|a:0:{}user_overview_filter|a:0:{}dblog_overview_filter|a:0:{}messages|a:1:{s:5:\"error\";a:10:{i:0;s:114:\"Your temporary directory <em></em> is not writable. Backup and migrate needs to be able to create temporary files.\";i:1;s:106:\"The file <em>/backup_migrate_4cc73f7ee6b58.dev-remote-2010-10-26T13-52-14.mysql</em> cannot be written to.\";i:2;s:170:\"user warning: MySQL server has gone away\nquery: UNLOCK TABLES in /home/aangel/public_html/sites/all/modules/backup_migrate/includes/destinations.db.mysql.inc on line 171.\";i:3;s:191:\"user warning: MySQL server has gone away\nquery: UPDATE variable SET value = &#039;i:0;&#039; WHERE name = &#039;dev_query&#039; in /home/aangel/public_html/includes/bootstrap.inc on line 609.\";i:4;s:159:\"user warning: MySQL server has gone away\nquery: DELETE FROM cache WHERE cid = &#039;variables&#039; in /home/aangel/public_html/includes/cache.inc on line 179.\";i:5;s:210:\"user warning: MySQL server has gone away\nquery: UPDATE variable SET value = &#039;s:1:\\&quot;0\\&quot;;&#039; WHERE name = &#039;site_offline&#039; in /home/aangel/public_html/includes/bootstrap.inc on line 609.\";i:6;s:159:\"user warning: MySQL server has gone away\nquery: DELETE FROM cache WHERE cid = &#039;variables&#039; in /home/aangel/public_html/includes/cache.inc on line 179.\";i:7;s:30:\"Could not complete the backup.\";i:8;s:197:\"user warning: MySQL server has gone away\nquery: DELETE FROM cache_form WHERE cid = &#039;form_form-a8507f40fba239b9d0faf04d3713b03b&#039; in /home/aangel/public_html/includes/cache.inc on line 179.\";i:9;s:200:\"user warning: MySQL server has gone away\nquery: DELETE FROM cache_form WHERE cid = &#039;storage_form-a8507f40fba239b9d0faf04d3713b03b&#039; in /home/aangel/public_html/includes/cache.inc on line 179.\";}}', timestamp = 1288126344 WHERE sid = '28dfde90d65c65b0a6fc49aaa7f91773' in /home/aangel/public_html/includes/session.inc on line 70.

Some details:

  • version 6.19 of core
  • update.php has been run and everything is up-to-date
  • was attempting a download backup
  • the rest of the site works fine before and after the attempted backup i.e. no problem connecting to the database

Any idea what's happening?

Comments

bserem’s picture

bserem commented

just happened to me, to a very busy MySQL server when tried to backup through Drush

anybody found anyway to fix this problem? I'll try backup up the database manually (with mysqldump) but I prefer drush for many reasons!

dgorton’s picture

dgorton commented
Status: Active » Postponed (maintainer needs more info)

I've run into this before but it's always been a server/mysql configuration issue. This has helped me in the past: http://drupal.org/node/259580. Try those out and let us know if the issue persists!

ronan’s picture

ronan commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Is this still an issue? If so please reopen.