WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Stuck upgrading database after 3.7 updated (4 posts)

  1. rbredow
    Member
    Posted 10 months ago #

    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-

  2. rbredow
    Member
    Posted 10 months ago #

    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.

  3. bemdesign
    Member
    Posted 10 months ago #

    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.

  4. rbredow
    Member
    Posted 10 months ago #

    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.

Reply

You must log in to post.

About this Topic