Support » Fixing WordPress » Stuck upgrading database after 3.7 updated

  • Resolved rbredow

    (@rbredow)


    I’m attempting to upgrade a site to 3.7. The download and install proceeded as normal, but updating the wordpress database appears to be stuck. I found these two errors in my apache log:

    [Fri Oct 25 22:40:57 2013] [error] [client XX.XX.XX.XX] WordPress database error Duplicate entry '_transient_wflginfl_3325210349' for key 'option_name' for query ALTER TABLE wp_options ADD UNIQUE KEY option_name (option_name) made by wp_upgrade, make_db_current_silent, dbDelta, referer: http://www.185vfx.com/wp-admin/upgrade.php?_wp_http_referer=%2Fwp-admin%2Fabout.php%3Fupdated
    [Fri Oct 25 22:40:57 2013] [error] [client XX.XX.XX.XX] WordPress database error Duplicate key name 'type_status_date' for query ALTER TABLE wp_posts ADD KEY type_status_date (post_type,post_status,post_date,ID) made by wp_upgrade, make_db_current_silent, dbDelta, referer: http://www.185vfx.com/wp-admin/upgrade.php?_wp_http_referer=%2Fwp-admin%2Fabout.php%3Fupdated

    mysql is still accessable from phpmyadmin, but mysqld is pegged at 100% CPU and there doesn’t appear to be any other progress. The site isn’t even displaying the “maintenance mode” warning.

    Any suggestions?

    Thanks-

Viewing 3 replies - 1 through 3 (of 3 total)
  • I let it run overnight and the database upgrade finally completed. I can’t tell for sure, but it looks like it took another 30+ minutes but it worked. Not a huge database so I’m surprised it took so long (even after I ran an optimize on the tables before the upgrade) but I’m up and running.

    Resolved.

    Shared hosting by chance? Possibly a bunch of site were pegging the same MySQL instance to update their databases. Anyway, glad you got it all sorted out.

    VPS, so not a shared MySQL server. I was the only one hammering my MySQL server. And, it was still responsive when I checked in on mysql. OK on disk and RAM too…so just not sure why it ran so slowly.

    I do have a few other sites configured similarly so I’ll try them next and report back if I learn anything.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Stuck upgrading database after 3.7 updated’ is closed to new replies.