Upgrading from 1.9 to 15.04 in mysql can timeout on big sites
Bug #1479543 reported by
Robert Lyon
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Fix Released
|
High
|
Robert Lyon | ||
1.10 |
Fix Released
|
High
|
Robert Lyon | ||
15.04 |
Fix Released
|
High
|
Robert Lyon | ||
15.10 |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
If there are lots of artefact and elasticsearch is running then the adding of the 'path' column and updating all the artefacts to have new path value can cause very long upgrade, or even upgrade timing out/locking up the database.
The problem is that there is a trigger on the artefact table - but as the path value is not stored by elasticsearch we don't need to get elasticsearch to reindex all the artefact rows.
So we will drop the trigger for this bit and re-add the trigger after the artefact table has add it's path column added.
tags: | added: upgrade |
Changed in mahara: | |
status: | In Progress → Fix Committed |
Changed in mahara: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Patch for "master" branch: https:/ /reviews. mahara. org/5022