Project

General

Profile

Actions
Copy link

Bug #14987

open

Elementor update causes database freeze-up

Added by Boone Gorges almost 3 years ago. Updated over 2 years ago.

Status:
New
Priority name:
Normal
Assignee:
Boone Gorges
Category name:
WordPress Plugins
Target version:
Future release
Start date:
2021-11-23
Due date:
% Done:

0%

Estimated time:
Deployment actions:

Description

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.

See https://redmine.gc.cuny.edu/issues/14986, https://redmine.gc.cuny.edu/issues/14951

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.

Related issues

Related to CUNY Academic Commons - Bug #14951: Commons downResolvedBoone Gorges2021-11-09

Actions
Related to CUNY Academic Commons - Bug #14986: Commons Site Down?ResolvedBoone Gorges2021-11-23

Actions
Actions
Copy link
 #1

Updated by Boone Gorges almost 3 years ago

A possible clue is that the mysql processlog shows many entries during these incidents that look like this:

1220    commons_admin    146.96.128.221:59488    commons_wp    Sleep    284        NULL    1713    1713
1221    commons_admin    146.96.128.221:59494    commons_wp    Sleep    211        NULL    1713    1713
1222    commons_admin    146.96.128.221: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.

Actions
Copy link
 #2

Updated by Boone Gorges almost 3 years ago

Actions
Copy link
 #3

Updated by Boone Gorges almost 3 years ago

Actions
Copy link
 #4

Updated by Raymond Hoh almost 3 years 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.6

The 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.

Actions
Copy link
 #5

Updated by Boone Gorges almost 3 years ago

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.

Actions
Copy link
 #6

Updated by Stefano Morello over 2 years 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.

Hi Boone,
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.

Actions
Copy link
 #7

Updated by Boone Gorges over 2 years 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.

Actions
Copy link

Also available in: Atom PDF