Causing PHP processes to remain open

  • Resolved justin-bigscoots

    (@justin-bigscoots)


    2 years, 4 months ago

    Recently we’ve been seeing many sites going down from PHP processes remaining open unable to handle new requests, each time we are seeing the same scripts involved, example:

    query() /home/nginx/domains/domain.com/public/wp-content/plugins/broken-link-checker/includes/admin/db-upgrade.php:349
delta() /home/nginx/domains/domain.com/public/wp-content/plugins/broken-link-checker/includes/admin/db-upgrade.php:56
make_schema_current() /home/nginx/domains/domain.com/public/wp-content/plugins/broken-link-checker/includes/admin/db-upgrade.php:26
upgrade_database() /home/nginx/domains/domain.com/public/wp-content/plugins/broken-link-checker/core/init.php:276

    Any ideas here? I don’t sadly have more information to provide.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support Imran – WPMU DEV Support

    (@wpmudev-support9)

    Hello @justin-bigscoots !

    I’m sorry to hear that you’re experiencing this issue!

    Looks like this is related to the recent updated version and the updates running and performing small database updates to the plugin’s tables. It seems that some of those may have gotten stuck for some reason.

    I would venture a guess that some Object Caching may be involved here. Can you clear that cache on the respective sites and see if that fixes the issue? Deactivating and activating the plugin may be needed after clearing the cache.

    Once that’s done, the issue shouldn’t occur as this would happen only during an update.

    Please note that we’re currently working on a completely new version of the plugin so such issues will be addressed there as well (though we didn’t have more reports of this issue so it may be specific to some server setups).

    Kind regards,
    Pawel

    Thread Starter justin-bigscoots

    (@justin-bigscoots)

    Its happened to at least 10 sites at this point, I know we are not the only host experiencing it and its not related to object caching. I did catch one where an ALTER was being spammed, there was over 20 queries where an ALTER was trying to be ran on a single table. It does seem to only happen initially on the update then stop but hoping we can prevent it as time goes on while people update.

    We’ve seen a similar issue (probably the exact same) on sites on two other hosts in the past 48 hours as well.

    @wpmudev-support9 – We had one client site crash on Sunday evening — but it had been updated on the Friday before. So the issue did not occur immediately after the update.

    And, clearing object cache along with deactivating/reactivating the plugin on hundreds of sites is not a trivial process. Can this issue be escalated?

    The Welsh Bridge Union has suffered three major crashes over the past 24 hours. Our hosting company – Scala – finally diagnosed the problem as a fault in the Broken Link Checker. They had to resort to killing the MySQL queries) and also increased the max_user_connections’, and advised me to Disable the plugin until lit can be resolved.
    Please can you expedite a solution – if we leave the plugin disabled, over time the site performance will degrade.
    Tony Haworth – webmaster

    Plugin Support Imran – WPMU DEV Support

    (@wpmudev-support9)

    Hello all!

    Apologies for the inconvenience caused by this issue!

    Our team is preparing a fix for release, however it will take a few days for it to be publicly available here. In the meantime we’ve prepared a patched version of the file that seems to be causing the issue in this case. If you’d like to use it, here are the steps:

    – take a backup just in case, as a general precaution
    – please find the file here: https://pastebin.com/raw/5sFsMnpf
    – save the code as init.php
    – upload the file to wp-content/plugins/broken-link-checker/core/ replacing the previously existing file

    Once that’s done, the issue should be fixed.

    Once again, apologies for the hassle here!

    Kind regards,
    Pawel

    Fantastic, thanks @wpmudev-support9 Pawel!

    I see in the changelog 1.11.21 was also just released a few minutes ago — is that the official fix for this issue?

    1.11.21 – Fix strict comparison causing db queries

    Plugin Support Kris – WPMU DEV Support

    (@wpmudevsupport13)

    Hi @eatingrules

    Yes, this is an official fix from our devs.

    Kind Regards,
    Kris

    Wonderful – thank you so much! Really appreciate the quick fix from the team. ??

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Causing PHP processes to remain open’ is closed to new replies.