Wordpres Crashes after Post Publish

  • Hi Everyone,

    For several weeks I’ve been having trouble where the database server of my VPS crashes. It happens every time when publishing a new post.

    Today, the entire server even crashes. So the problems seems to increase.

    I’m guessing it’s probably some plugin, but I couldn’t really figure out which plugin. I’ve tried disabling all of them and enabling them one by one. The back end just goes slower and slower as I do so, but it doesn’t seem to crash at one particular plugin.

    Even so, that when I disable all and back enable all, publishing a new post doesn’t crash the server. But when I play around in the back end a bit, or wait a day it then crashes the server.

    I’ve also installed Query Monitor, but didn’t noticed anything strange or extra slow.

    Would anyone have a suggestion on how to locate such a problem?

    Thank you in advance,
    Jordy

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Look in /var/log/messages and other server log files to see what’s coincident with the time the DB server crashes.

    Thread Starter Cinecom

    (@cinecom)

    Hi Steve,

    Thank you so much for the quick response! I’ve looked in there before, but it’s mostly Chinese to me ??

    I assume this is the log that crashed the server. After This line I only get messages saying ‘unable to connect to database server’:

    [Tue Feb 21 16:11:48.214662 2017] [:error] [pid 16396] [client xxx.xxx.xxx.xxx:xxxxx] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATEwp_optionsSEToption_value= '1487689844.5773971080780029296875' WHEREoption_name= '_transient_doing_cron' made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, wp_cron, spawn_cron, set_transient, update_option, referer: https://www.cinecom.net/news/shoot-interview-5-tips-beginners/

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    That’s the last transaction, but ….

    What’s in the other system log files at that time? Any Out of Memory (OOM) conditions? You have a server configuration problem, not an WP problem.

    Thread Starter Cinecom

    (@cinecom)

    That doesn’t sound good. I’ve emailed my server admin about this, because I don’t think I have access to more logs at this time.

    Thanks for the info Steve!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Wordpres Crashes after Post Publish’ is closed to new replies.