Too many MySQL processes / killing server

  • Hi, this has happened?three times in the last 10 days. Cleantalk mysql queries fully saturated the SQL connection pool and take down all sites on the server.

    Our SQL is configured for 151 connections. 152 connections shown here: https://pastebin.com/raw/iFu2pY50

    Some kind of issue with wp_cleantalk_sfw_logs and wp_cleantalk_sfw_temp.

    My only solution has been to restart the entire server and MySQL.

    How can we adjust settings so that this does not happen again? I’d like to continue being a paid user of Cleantalk on our 175+ sites.

    Thank you!

Viewing 15 replies - 1 through 15 (of 57 total)
  • Plugin Support sergecleantalk

    (@sergecleantalk)

    Hello,

    I will ask our developers for help. We will contact you within 1-3 business days.

    Plugin Support sergecleantalk

    (@sergecleantalk)

    Let me ask you a few more things. Do you have all 175+ websites on 1 server? What is your websites’ load (visitors a day approximately)? We will try to simulate it.

    Could you also try to disable Anti-Crawler option here: WordPress Dashboard -> Settings -> Antispam by Cleantalk

    Did it help?

    Thread Starter Razorfrog Web Design

    (@razorfrog)

    No, split across 8 servers. This one has 20 sites. Approx 4k visitors/day on this box.

    Anti-Crawler is not activated, just SpamFireWall.

    Plugin Support sergecleantalk

    (@sergecleantalk)

    Thank you, we will inform you when there will be any news.

    Hello,

    Which DB engine has cleantalk_sfw_logs and cleantalk_sfw tables?

    You can try to re-enable plugin with “Complete deactivation” option enabled in the plugin settings on some of your website and check if it helps. This action will force to re-create plugin tables.

    Best regards.

    Hello,

    Thank you for the feedback! We have fixed the problem. As Artyom advised, please, make sure that the “Complete deactivation” setting is enabled when deactivating the plugin.

    Please, reinstall the plugin. ( Download link: https://github.com/CleanTalk/wordpress-antispam/releases/download/dev-version/cleantalk-spam-protect.zip )

    Here is an instruction:

    1. Go to WordPress Administrator Panel —> Plugins.
    2. Find the plugin “Spam Protection by CleanTalk” —> Deactivate.
    3. After the automatic page refresh find the plugin again “Spam Protection by CleanTalk” —> Delete. Confirm “Yes, delete these files”.
    5. Go to Plugins —> Add New —> Upload Plugin.
    4. Download the plugin archive from the link above.
    6. Choose the downloaded archive and press “Install Now”.

    Let us know the result. Please, contact us.

    Thread Starter Razorfrog Web Design

    (@razorfrog)

    Thank you. Would you recommend we reset like this on our 175+ sites? Or wait until the next time the problem arises? That would be a substantial amount of time to reset them all.

    Plugin Author Denis

    (@shagimuratov)

    @razorfrog,

    Please follow the instructions above just for 1-2 sites. First of all, we have to be sure that the issue is solved.

    We will discuss among our team about mass update, please let as some time.

    @razorfrog ,

    Which DB engine has cleantalk_sfw_logs and cleantalk_sfw tables?

    Also, could you send links to some of your websites which have this issue?

    Best regards.

    Hello,

    We see that you’ve updated your plugin to the latest version. Does the problem still exists?

    Best regards.

    Thread Starter Razorfrog Web Design

    (@razorfrog)

    Apologies for not replying. We haven’t seen the issue return since 1/22/21

    Both sites with issues use InnoDB for those tables.

    Plugin Support katereji

    (@katereji)

    Hello.
    Thank you for the feedback.
    Contact us if you have questions concerning our services.
    Be well.

    Thread Starter Razorfrog Web Design

    (@razorfrog)

    The issue returned again today on a new site and new server. This is the third time that MySQL processes have gone out of control and crashed the server.

    Site was running Version 5.152.5

    Screenshot: https://rzfg.co/HxHBzN

    Thread Starter Razorfrog Web Design

    (@razorfrog)

    A colleague pointed this out:

    It looks like the TRUNCATE command on the logs table could be bypassed. Line 352 in cleantalk-spam-protect/lib/Cleantalk/ApbctWP/Firewall/SFW.php

    https://gist.github.com/jordantrizz/d636803b33d9fa4f2ede0cee5968d73a

    There was some talk on the Joomla forum but not much about addressing the locks.

    https://www.drupal.org/project/cleantalk/issues/3154238

    Plugin Support sergecleantalk

    (@sergecleantalk)

    Hello,

    I will transfer this to our developers.

    We will contact you within 1-2 business days.

Viewing 15 replies - 1 through 15 (of 57 total)
  • The topic ‘Too many MySQL processes / killing server’ is closed to new replies.