[DB Error] MySQL has gone away, Database Upgrade Required

  • Anonymous User 1437452

    (@anonymized-1437452)


    15 years, 3 months ago

    Hello everyone

    This is Vishal Gupta (Microsoft MVP). I run AskVG.com and need some help from you all.

    Yesterday I faced a strange problem. Whenever I tried to open the site, it opened a blank page. When I tried to access Admin panel, I got following message:

    Database Upgrade Required

    Your WordPress database is out-of-date, and must be upgraded before you can continue.

    The upgrade process may take a while, so please be patient.

    There was a button “Upgrade WordPress”, I clicked on it and it showed a long list of SQL commands but each line contained following error:

    WordPress database error MySQL server has gone away

    There was a button at below “Continue”, when I clicked on it, it again showed the same “database Upgrade Required” page. So it became an endless loop.

    We decided to restore a recent database backup and it worked and the site started working again.

    So now my questions are as follows:

    1. Why this problem occurred suddenly? We didnt change any setting, we didnt install or update any plug-in, we didnt add any script. We didnt do anything new except creating new post.

    2. How can we assure that this problem will not occur again?

    So guys, please help and tell me what was the reason behind this strange problem?

    PS: Also since a few days I’m getting various core dump files in “public_html” folder. Size of each file is 50MB. When I asked our host he told that its not a server side problem. It must be a plugin which is causing these core dump files.

Viewing 5 replies - 1 through 5 (of 5 total)
  • MichaelH

    (@michaelh)

    15 years, 3 months ago

    Congratulations on having backups!!! Give yourself a bonus!!!

    1. Could be a corrupt database table/tables. Could be a database server issue.
    2. Don’t know that you can “assure that this problem will not occur again.” Might monitor your database for any problems. Maybe repair or optimize routinely, but that’s just insurance. Having PROPER (e.g. daily, weekly, monthly, yearly) backups is your best line of defense.

    Thread Starter Anonymous User 1437452

    (@anonymized-1437452)

    15 years, 3 months ago

    ^^ Thanks for replying. 🙂

    So the reason is still unknown and can you please provide some details about those 50 MB core dump files? Why are those files being created frequently? How can I stop it?

    Thread Starter Anonymous User 1437452

    (@anonymized-1437452)

    15 years, 3 months ago

    I checked the “error_log” file present in “public_html” folder and found this:

    [12-Jan-2009 02:35:36] PHP Fatal error: Out of memory (allocated 10485760) (tried to allocate 77824 bytes) in /home/vishal/public_html/wp-content/plugins/simple-tags/2.7/inc/simple-tags.widgets.php on line 171
    [12-Jan-2009 02:35:37] PHP Fatal error: Out of memory (allocated 4718592) (tried to allocate 19456 bytes) in /home/vishal/public_html/wp-includes/comment-template.php on line 925
    [12-Jan-2009 02:35:37] PHP Fatal error: Out of memory (allocated 8126464) (tried to allocate 19456 bytes) in /home/vishal/public_html/wp-content/plugins/all-in-one-seo-pack/all_in_one_seo_pack.php on line 1229
    [12-Jan-2009 02:50:41] WordPress database error MySQL server has gone away for query SELECT option_value FROM wp_options WHERE option_name = ‘rich_editing’ LIMIT 1 made by require, require_once, require_once, require_once, do_action, call_user_func_array, cforms_addbuttons, get_user_option, get_option
    [12-Jan-2009 02:50:41] WordPress database error MySQL server has gone away for query SELECT option_value FROM wp_options WHERE option_name = ‘rich_editing’ LIMIT 1 made by require, require_once, require_once, require_once, do_action, call_user_func_array, cforms_addbuttons, get_user_option, get_option

    And also noticed the “MySQL Server has gone away” error came again today but at that time I was not online so didnt check it.

    So it means that it was not a corrupt db problem. Is it related to Memory shortage by any chance? Can this error occur if we run out of memory?

    MichaelH

    (@michaelh)

    15 years, 3 months ago

    Don’t know the answer to that.

    Since you suspect a plugin, deactivating all plugins, then reactiving, one-by-one, to find the culprit plugin, is one possibility.

    Might also talk to your host about increasing memory allocated to PHP.

    deelipk

    (@deelipk)

    15 years, 3 months ago

    I had same problem. And I solved it. Have you installed automatic wordpress update plugin? That is the reason of this problem. I repetitively had this problem until I deactivated that plugin.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[DB Error] MySQL has gone away, Database Upgrade Required’ is closed to new replies.