Slowness when upgrading to v18.10+ when using elasticsearch

Bug #1812120 reported by Robert Lyon
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
High
Robert Lyon
18.10
Fix Released
High
Unassigned
19.04
Fix Released
High
Robert Lyon

Bug Description

This is because there are a couple of db updates to the view table where we add a new column so that means the elasticsearch queue will be updated/checked for each view row at least twice when we don't need to

Robert Lyon (robertl-9)
Changed in mahara:
status: New → In Progress
importance: Undecided → High
assignee: nobody → Robert Lyon (robertl-9)
milestone: none → 19.04.0
Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "master" branch: https://reviews.mahara.org/9442

Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/9442
Committed: https://git.mahara.org/mahara/mahara/commit/52adc5e42583e909563c7ba576cc6c7c6f5bbbb5
Submitter: Robert Lyon (<email address hidden>)
Branch: master

commit 52adc5e42583e909563c7ba576cc6c7c6f5bbbb5
Author: Robert Lyon <email address hidden>
Date: Thu Jan 17 11:13:00 2019 +1300

Bug 1812120: Making sites with elasticsearch upgrade faster

As sites with 100,000+ views take forever to upgrade

We don't need to re-index the view row changes when adding the new
columns

behatnotneeded

Change-Id: I90143f592c5203a4dfc2fd20d2d4ef1148cf9e95
Signed-off-by: Robert Lyon <email address hidden>

Revision history for this message
Mahara Bot (dev-mahara) wrote : A patch has been submitted for review

Patch for "18.10_STABLE" branch: https://reviews.mahara.org/9535

Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/9535
Committed: https://git.mahara.org/mahara/mahara/commit/57f0edd03762a21f98d3791978f2016fb72edd64
Submitter: Robert Lyon (<email address hidden>)
Branch: 18.10_STABLE

commit 57f0edd03762a21f98d3791978f2016fb72edd64
Author: Robert Lyon <email address hidden>
Date: Thu Jan 17 11:13:00 2019 +1300

Bug 1812120: Making sites with elasticsearch upgrade faster

As sites with 100,000+ views take forever to upgrade

We don't need to re-index the view row changes when adding the new
columns

behatnotneeded

Change-Id: I90143f592c5203a4dfc2fd20d2d4ef1148cf9e95
Signed-off-by: Robert Lyon <email address hidden>
(cherry picked from commit 52adc5e42583e909563c7ba576cc6c7c6f5bbbb5)

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.