Database upgrade to 3.1 crashes MySQL

  • Resolved jrue

    (@jrue)


    13 years, 1 month ago

    Hi there. I upgraded our site on my local development box, and it just hangs. I’m pretty sure it’s in the database upgrade. The site we’re running has a large DB — over a hundred thousands of posts, and hundreds of users.

    After the upgrade, I tried running a simple MySQL query:

    SELECT COUNT(*) from wp_posts;

    And it just hangs, crashes MySQL. I replaced the DB with a backup from 3.0.5, and no issues at all. I tried the upgrade process several times, and it consistently breaks. (though it works perfectly on all our boxes with a brand new install and a blank db, it’s only when I do the upgrade to our existing database) I had some of our other developers try the upgrade using our database on different boxes with different versions of MySQL, and we all have the same result

    Could it be an issue during the database upgrade? Has anyone else had similar issues?

    Thanks in advance.

Viewing 2 replies - 1 through 2 (of 2 total)
  • adiant

    (@adiant)

    13 years, 1 month ago

    I have had similar problems with MySQL-based applications in the past, on crappy web hosting. Typically, what was happening is that the upgrade required significant processor time and was being shut down midway through. The result was a corrupted table.

    I was always able to get the Repair Table feature of phpMyAdmin to make the table readable, though I would have to restore the database and retry the upgrade after talking to web hosting support, to get them to shut off their system management tool that killed the original upgrade.

    Thread Starter jrue

    (@jrue)

    13 years, 1 month ago

    For those who might be wondering, it was an error in the custom theme we wrote that would break the upgrade and end up corrupting our database.

    Before you upgrade to 3.1, it’s best to switch to the TwentyTen built-in theme, then run the upgrade. You can switch back after upgrading.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database upgrade to 3.1 crashes MySQL’ is closed to new replies.