database error – MySQL has gone away!

  • lou27

    (@lou27)


    15 years, 9 months ago

    Hi,

    I need a little help about this error that keep on registering on my error_logs.. it makes a sudden outburst of our server load.. our host actually suspended our site for a couple of days and its really a pain.. Here’s the error

    WordPress database error MySQL server has gone away for query UPDATE ns_options SET option_value = …etc.. WHERE option_name = ‘cron’ made by wp_unschedule_event, _set_cron_array, update_option, DbProfile->query

    What seems to be the problem?

    Any help will be highly appreciated.

    Thanks so much,
    Lou

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator James Huff

    (@macmanx)

    15 years, 9 months ago

    “WordPress database error MySQL server has gone away” is the result of the MySQL server crashing. What happened before that error?

    Thread Starter lou27

    (@lou27)

    15 years, 9 months ago

    Hi James,

    I’m sorry for the late reply. At the front end, it causes slow down due to high server load. In my error_logs, the last error before the “database error” is this:

    PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 45737284 bytes) in /home/mysite/public_html/wp-includes/class-http.php on line 1243

    I think it is about the upgrade. Yesterday, I also got this error.

    [05-Sep-2010 11:22:41] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘LIMIT 1’ at line 1 for query SELECT id FROM ns_wpsc_purchase_logs WHERE sessionid= LIMIT 1 made by require, require_once, include, the_content, apply_filters, call_user_func_array, wpsc_transaction_results, include, DbProfile->query

    Do you think I need to downgrade to 3.0 again?

    Thanks so much,
    Lou

    Moderator James Huff

    (@macmanx)

    15 years, 9 months ago

    There should be no difference in memory consumption between 3.0 and 3.0.1.

    If you’re seeing this error either suddenly (no specific task was done to cause the error) or frequently, try deactivating all plugins to rule-out a plugin-specific issue and try switching themes to rule-out a theme-specific issue.

    Otherwise, here are three ways to increase PHP’s memory allocation:

    1. If you can edit or override the system php.ini file, increase the memory limit. For example, memory_limit = 256M

    2. If you cannot edit or override the system php.ini file, add php_value memory_limit 256M to your .htaccess file.

    3. If neither of these work, it’s time to ask your hosting provider to temporarily increase PHP’s memory allocation on your account. Keep in mind that most decent hosting providers allocate 32 MB to PHP under each account, and most decent hosting providers allow users to temporarily increase the memory allocation. If your hosting provider won’t accommodate you, perhaps it’s time to find a new hosting provider.

    Thread Starter lou27

    (@lou27)

    15 years, 9 months ago

    Hi James,

    I already tried the plug-in deactivations, but still no luck. I’ll definitely try to increase the php memory allocation thing. Thanks so much for your response. =)

    Lou

    Thread Starter lou27

    (@lou27)

    15 years, 9 months ago

    Hi,

    I tried this solution and monitored the error_logs day by day, but this didn’t worked. I also tried the workaround by robsnotebook – tried to increase the “time out” thing.. but doesn’t seem to work.. our site is now suspended.. Should I downgrade our wordpress version – I had read that wordpress 3.0 requires 256mb memory, maybe it would help?

    Is there any other solutions?

    Thanks a lot,
    Lou

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

The topic ‘database error – MySQL has gone away!’ is closed to new replies.