Elementor update causes database freeze-up
On Nov 9 and Nov 23, as part of regular maintenance updates, I tried updating Elementor from version 3.4.4 to the latest version (3.4.6 or 3.4.8). Both times, the Commons database was brought to a halt by an influx of database connections, within minutes.
Effective immediately, I won't be updating Elementor anymore during regular maintenance updates. Specifically, I will add it to the list of blocked plugins in my wp-cli-cac update tools. Ray, if you have your own version of these tools, please do the same.
The next time Elementor is updated to a new major version, say 3.5, I might consider trying the update again in isolation. I'll leave this ticket open for further investigation.
Updated by Boone Gorges 10 months ago
A possible clue is that the mysql processlog shows many entries during these incidents that look like this:
1220 commons_admin 184.108.40.206:59488 commons_wp Sleep 284 NULL 1713 1713 1221 commons_admin 220.127.116.11:59494 commons_wp Sleep 211 NULL 1713 1713 1222 commons_admin 18.104.22.168:59498 commons_wp Sleep 291 NULL 1713 1713
Some query is taking place that matches 1713 rows. At one point I had the idea to see which tables in the Commons database have 1713 rows, but this is a much harder thing to query than you might expect.
Updated by Raymond Hoh 10 months ago
Here's the changelog between Elementor v3.4.4 and v3.4.6: https://github.com/elementor/elementor/compare/v3.4.4...v3.4.6The only commits that stand out are:
The first one seems likely because Elementor is doing a save routine on every page load. Just a guess though.
Updated by Stefano Morello 3 months ago
Boone Gorges wrote in #note-5:
Thanks, Ray. Yes, it seems likely that the first one is the culprit. The next time I try updating Elementor, maybe I'll try manually commenting out that line to see if I can narrow it down in that way.
I'm working with the MFA program at QC to build a new website for their program, and was hoping to use Elementor to develop some layouts. Before I do that, I just wanted to check if there's any update on this issue. I think the latest version of Elementor is 3.7.something by now.
Updated by Boone Gorges 3 months ago
Hi Stefano - We're still running version 3.4.4 of Elementor (the current version appears to be 3.6.7 - see https://wordpress.org/plugins/elementor/). You should feel free to use the version that's on the Commons, and we'll work in a future release to try working around the issue described in this ticket.