The upgrade to 6.x-6.18 (using drush) hangs at:

The following updates are pending:

 boost module                                                                  
 6122 - Update 6122 - Remove default value for all text columns.               
 6123 - Update 6123 - Add indexes to boost_cache_relationships table           
 6124 - Update 6124 - Add missing page_type index to boost_cache_relationships 
 table                                                                         
 6125 - Update 6125 - Reset boost-gzip-cookie-test.html.gz file                

Do you wish to run all pending updates? (y/n): y
ALTER TABLE {boost_cache} CHANGE `filename` `filename` TEXT NOT NULL [success]
ALTER TABLE {boost_cache} CHANGE `url` `url` TEXT NOT NULL           [success]
ALTER TABLE {boost_crawler} CHANGE `url` `url` TEXT NOT NULL         [success]

When I Ctrl-C and then choose drush updatedb, it hangs immediately. I restored my database from backup and tried again, and it hanged in the same spot (10 minutes so far).

I'm happy to give you access to my dev server if you need it to debug the problem. Note that I didn't disable boost or flush the caches before upgrading. I can try that if you want.

Thanks for the great module.

Comments

mikeytown2’s picture

mikeytown2 commented

So boost_update_6122 is the one that hangs correct?

This is what it's trying to do:

  db_change_field($ret, 'boost_crawler', 'url', 'url', array(
        'description' => 'URL of page',
        'type' => 'text',
        'size' => 'normal',
        'not null' => TRUE,
      ));

Sounds like I should truncate that first before updating, since it's a temp table. You have a lot of URL's cached correct? Try this, don't have time to create a patch today.

...
  db_change_field($ret, 'boost_cache', 'url', 'url', array(
        'description' => 'URL of cached page',
        'type' => 'text',
        'size' => 'normal',
        'not null' => TRUE,
      ));
  db_query('TRUNCATE {boost_crawler}');
  db_change_field($ret, 'boost_crawler', 'url', 'url', array(
        'description' => 'URL of page',
        'type' => 'text',
        'size' => 'normal',
        'not null' => TRUE,
      ));
...
dankohn’s picture

dankohn commented

Actually, it finished after about 30 minutes. And yes, I have about 70,000 pages in my XML sitemap. If you want to package up a dev version for me, I'll try it out before upgrading my production server. Thanks!

No code updates available.                                           [ok]
You have pending database updates. Please run `drush updatedb` or    [warning]
visit update.php in your browser.
The following updates are pending:

 boost module                                                                  
 6122 - Update 6122 - Remove default value for all text columns.               
 6123 - Update 6123 - Add indexes to boost_cache_relationships table           
 6124 - Update 6124 - Add missing page_type index to boost_cache_relationships 
 table                                                                         
 6125 - Update 6125 - Reset boost-gzip-cookie-test.html.gz file                

Do you wish to run all pending updates? (y/n): y
ALTER TABLE {boost_cache} CHANGE `filename` `filename` TEXT NOT NULL [success]
ALTER TABLE {boost_cache} CHANGE `url` `url` TEXT NOT NULL           [success]
ALTER TABLE {boost_crawler} CHANGE `url` `url` TEXT NOT NULL         [success]
ALTER TABLE {boost_cache_relationships} ADD INDEX base_dir (base_dir)[success]
ALTER TABLE {boost_cache_relationships} ADD INDEX page_callback      [success]
(page_callback)
ALTER TABLE {boost_cache_relationships} ADD INDEX page_id (page_id)  [success]
ALTER TABLE {boost_cache_relationships} ADD INDEX child_page_callback[success]
(child_page_callback)
ALTER TABLE {boost_cache_relationships} ADD INDEX child_page_type    [success]
(child_page_type)
ALTER TABLE {boost_cache_relationships} ADD INDEX child_page_id      [success]
(child_page_id)
ALTER TABLE {boost_cache_relationships} ADD INDEX hash_url (hash_url)[success]
ALTER TABLE {boost_cache_relationships} ADD INDEX timestamp          [success]
(timestamp)
ALTER TABLE {boost_cache_relationships} ADD INDEX page_type          [success]
(page_type)
boost-gzip-cookie-test.html.gz did not need to be reset              [success]
Cache cleared.
Finished performing updates.                                         [ok]
mikeytown2’s picture

mikeytown2 commented
Status: Active » Fixed

committed the change

Status: Fixed » Closed (fixed)

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