Site Crash – Transient Loop

  • Gravitate

    (@gravitate)


    9 years, 2 months ago

    One of our clients sites kept crashing occasionally. We could never figure it out. We would just end up rebooting the server and things would start to work agian. The last time it happened I noticed that DB Connections were too high.

    The DB error I would get was:

    WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE wp_options SET option_value = ‘b307b2d59d3b831588851e8184b55229’ WHERE option_name = ‘_transient_random_seed’

    So I tried disabling one Plugin at a time and it ended up being “Math Captcha”.

    I also tested it with no other plugins activated and it still was causing the issue. I tested disabling and re-enabling the plugin several times to make sure it wasn’t a fluke.
    http://screencast.com/t/vE5q5joxm

    We’re now just using another method instead of using this plugin, but, I wanted to inform you of the issue.

    https://wordpress.org/plugins/wp-math-captcha/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author dFactory

    (@dfactory)

    9 years, 2 months ago

    It’s was caused by WordPress wp_rand() function that we used to generate unique ID.

    In recent MC release we switched to custom helper, that does not rely on wp_rand() and does not generate extra DB queries.

    But thanks anyway.

    Thread Starter Gravitate

    (@gravitate)

    9 years, 2 months ago

    Thanks for the quick reply.
    I was currently at 2.0 so I will try 2.4.

    I reviewed the changelog and didn’t see any notes about this issue in there.

    What version was this change on?

    Plugin Author dFactory

    (@dfactory)

    9 years, 2 months ago

    1.2.4

    Tweak: Switch from wp_generate_password() to custom function due to Jetpack statistics DB calls issue

    Thread Starter Gravitate

    (@gravitate)

    9 years, 2 months ago

    ok, thanks.
    I thought that was a separate issue as we are not using Jetpack Statistics, but I see that your fix for that would also fix our issue as well.

    Plugin Author dFactory

    (@dfactory)

    9 years, 2 months ago

    We thought is was Jetpack related, but after your post I realized that it might have been a more general issue.

    Either way it should be fixed.

    Regards,
    Bartosz / dfactory

    panchoo

    (@panchoo)

    9 years, 1 month ago

    Scary! 🙁

    Plugin Author dFactory

    (@dfactory)

    9 years, 1 month ago

    What is scary in this is the fact that WordPress native wp_generate_password() function fires a DB call after each 8 usages.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Site Crash – Transient Loop’ is closed to new replies.