Razorfrog Web Design
Forum Replies Created
-
Hi – We’re seeing this issue on multiple sites. Any news on an update? Thank you!
Thank you, but that’s too long to wait. We’re moving our 170 sites to a more reliable system today.
Yes, correct. The latest version of the plugin.
Hi – This happened again today – the plugin just took down a server with 153 waiting queries. Same truncate/lock issues. Screenshot: https://rzfg.co/dFcFtJ
The site had the new setting “DELETE SQL-command instead TRUNCATE to clear tables was checked” turned ON.
What else can we do? I can’t have the Cleantalk plugin randomly take down entire servers every few weeks.
Thank you.
Also seeing this break WooCommerce settings pages. Will there be a fix published?
We’re seeing this on sites as well. Screenshot: https://rzfg.co/pMWOVQ
When will it be resolved? Should we downgrade versions?
Forum: Fixing WordPress
In reply to: WP 5.7 + Woocommerce 5.1 collation errorJust ran into this – I deactivated Mailpoet and the checkout problem went away. Thank you!
This happened again today – the plugin just took down a server with 153 waiting queries. Same truncate/lock issues. Screenshot: https://rzfg.co/M4Hmtl
@safronik When will the new version with the TRUNCATE fix be released?
Yes, it’s enabled:
mysql> show global variables like ‘autocommit’;
+—————+——-+
| Variable_name | Value |
+—————+——-+
| autocommit | ON |
+—————+——-+
1 row in set (0.03 sec)Server version: 8.0.19-10 Percona Server (GPL), Release ’10’, Revision ‘f446c04’
This issue happened again on a site today and crashed MySQL for the whole server. Site was running Version 5.153.
Same truncate issue: https://rzfg.co/WiBBzN
Is there anything else you can do? Or is it time to delete cleantalk from 175 sites and cancel our subscriptions?
Thank you.
I’ll update today. Was the issue fixed in 5.152.4 or 5.153?
@safronik said 5.152.4 above, that’s why I said we were already running Version 5.152.5
Our sites were already up to date when this last happened and running Version 5.152.5. So unfortunately the fix in 5.152.4 did not resolve the problem.
- This reply was modified 4 years, 1 month ago by Razorfrog Web Design.
Hi, I answered the DB engine question five days ago here: https://www.ads-software.com/support/topic/too-many-mysql-processes-killing-server/#post-14042485
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.