0

Just upgraded from 7.18 to 7.23 and selected to upgrade all modules and all I got is neverending 'Preparing to update your site' on Installing updates page on /authorize.php?batch=1&op=start&id=40

So what if I refresh page or something will the site crash or something?

UPDATE: It just crashed after like 20 minutes of nothing and I got this error:

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /authorize.php?batch=1&id=40&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: DELETE FROM {queue} WHERE (item_id = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 8656 ) in SystemQueue->deleteItem() (line 273 of /modules/system/system.queue.inc).Uncaught exception thrown in shutdown function.PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: UPDATE {batch} SET batch=:db_update_placeholder_0 WHERE (bid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => a:12:{s:4:"sets";a:1:{i:0;a:15:{s:7:"sandbox";a:0:{}s:7:"results";a:2:{s:3:"log";a:1:{s:5:"views";a:1:{i:0;a:2:{s:7:"message";s:57:"Installed <em class="placeholder">views</em> successfully";s:7:"success";b:1;}}}s:5:"tasks";a:0:{}}s:7:"success";b:0;s:5:"start";d:1377856599.71076107025146484375;s:7:"elapsed";i:0;s:5:"title";s:18:"Installing updates";s:12:"init_message";s:40:"Preparing to update your site<br/> ";s:8:"finished";s:38:"update_authorize_update_batch_finished";s:4:"file";s:35:"modules/update/update.authorize.inc";s:16:"progress_message";s:29:"Completed @current of @total.";s:13:"error_message";s:22:"An error has occurred.";s:3:"css";a:0:{}s:5:"total";i:12;s:5:"count";i:12;s:5:"queue";a:2:{s:4:"name";s:17:"drupal_batch:40:0";s:5:"class";s:10:"BatchQueue";}}}s:16:"has_form_submits";b:0;s:11:"current_set";i:0;s:11:"progressive";b:1;s:3:"url";s:36:"/authorize.php?batch=1";s:11:"url_options";a:0:{}s:10:"source_url";s:0:"";s:8:"redirect";s:28:"/authorize.php";s:5:"theme";s:5:"seven";s:17:"redirect_callback";s:11:"drupal_goto";s:2:"id";s:2:"40";s:13:"error_message";s:110:"Please continue to <a href="/authorize.php?batch=1&id=40&op=finished">the error page</a>";} [:db_condition_placeholder_0] => 40 ) in _batch_shutdown() (line 537 of /includes/batch.inc).
Improve this question
1
  • First, see if there are errors in webserwer's log. Second, you do have backups? Third: we need to see an error log from MySQL too, now when we know it's MySQL dying. And test your tables for health.
    – Mołot
    Aug 30, 2013 at 10:12

1 Answer 1

Reset to default
2

If you have drush try running drush updatedb.

Errors you are getting you should restore backup of your site and update modules one by one.

You can also login phpmyadmin and try to optimize and cleanup mysql if you don't have a copy as it seems your db is crashing and it could be pending database updates. If you don't have drush try going to yoursite.com/update.php to run db updates.

If at all possible use drush for managing your site gives you option to update as well as rollback any updates.

Improve this answer
2
  • can I use drush on windows 8 x64?
    – user13176
    Aug 30, 2013 at 11:30
  • 1
    @user13176 if you can install PHP CLI on it, yes. I do. But that does not change the fact that now you should try to check your database's error log to be sure. "optimize and cleanup" pgrujic mentioned.
    – Mołot
    Aug 30, 2013 at 11:39

Not the answer you're looking for? Browse other questions tagged or ask your own question.