https://redmine.gc.cuny.edu/https://redmine.gc.cuny.edu/favicon.ico2021-11-23T21:20:48ZCUNY Graduate Center - Project Tracking SystemCUNY Academic Commons - Bug #14987: Elementor update causes database freeze-uphttps://redmine.gc.cuny.edu/issues/14987?journal_id=656122021-11-23T21:20:48ZBoone Gorgesboone@gorg.es
<ul></ul><p>A possible clue is that the mysql processlog shows many entries during these incidents that look like this:</p>
<pre>
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
</pre>
<p>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.</p> CUNY Academic Commons - Bug #14987: Elementor update causes database freeze-uphttps://redmine.gc.cuny.edu/issues/14987?journal_id=656152021-11-23T21:21:21ZBoone Gorgesboone@gorg.es
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/14951">Bug #14951</a>: Commons down</i> added</li></ul> CUNY Academic Commons - Bug #14987: Elementor update causes database freeze-uphttps://redmine.gc.cuny.edu/issues/14987?journal_id=656182021-11-23T21:21:46ZBoone Gorgesboone@gorg.es
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-5 priority-high4 closed" href="/issues/14986">Bug #14986</a>: Commons Site Down?</i> added</li></ul> CUNY Academic Commons - Bug #14987: Elementor update causes database freeze-uphttps://redmine.gc.cuny.edu/issues/14987?journal_id=656282021-11-24T00:19:55ZRaymond Hoh
<ul></ul><p>Here's the changelog between Elementor v3.4.4 and v3.4.6: <a class="external" href="https://github.com/elementor/elementor/compare/v3.4.4...v3.4.6">https://github.com/elementor/elementor/compare/v3.4.4...v3.4.6</a></p>
The only commits that stand out are:
<ul>
<li><a class="external" href="https://github.com/elementor/elementor/commit/5ab9687a110ca4fdcc60c96da663066f263380fb#diff-c6c59e80e257857fe00b32cac938839e7b6b0e7f653abd61be0e37111e1e70c7">https://github.com/elementor/elementor/commit/5ab9687a110ca4fdcc60c96da663066f263380fb#diff-c6c59e80e257857fe00b32cac938839e7b6b0e7f653abd61be0e37111e1e70c7</a></li>
<li><a class="external" href="https://github.com/elementor/elementor/commit/fd44d0db72eaab5ceb118fb7b2b18139d421c3bb">https://github.com/elementor/elementor/commit/fd44d0db72eaab5ceb118fb7b2b18139d421c3bb</a></li>
</ul>
<p>The first one seems likely because Elementor is doing a save routine on every page load. Just a guess though.</p> CUNY Academic Commons - Bug #14987: Elementor update causes database freeze-uphttps://redmine.gc.cuny.edu/issues/14987?journal_id=656432021-11-29T17:02:32ZBoone Gorgesboone@gorg.es
<ul></ul><p>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.</p> CUNY Academic Commons - Bug #14987: Elementor update causes database freeze-uphttps://redmine.gc.cuny.edu/issues/14987?journal_id=719872022-07-15T06:37:38ZStefano Morello
<ul></ul><p>Boone Gorges wrote in <a href="#note-5">#note-5</a>:</p>
<blockquote>
<p>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.</p>
</blockquote>
<p>Hi Boone, <br />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.</p> CUNY Academic Commons - Bug #14987: Elementor update causes database freeze-uphttps://redmine.gc.cuny.edu/issues/14987?journal_id=719902022-07-15T19:42:03ZBoone Gorgesboone@gorg.es
<ul></ul><p>Hi Stefano - We're still running version 3.4.4 of Elementor (the current version appears to be 3.6.7 - see <a class="external" href="https://wordpress.org/plugins/elementor/">https://wordpress.org/plugins/elementor/</a>). 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.</p>