mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: mahara
     Importance: High
     Assignee: Robert Lyon (robertl-9)
         Status: In Progress

** Affects: mahara/1.10
     Importance: High
     Assignee: Robert Lyon (robertl-9)
         Status: New

** Affects: mahara/15.04
     Importance: High
     Assignee: Robert Lyon (robertl-9)
         Status: New


** Tags: upgrade

** Tags added: upgrade

** Also affects: mahara/15.04
   Importance: Undecided
       Status: New

** Also affects: mahara/1.10
   Importance: Undecided
       Status: New

** Changed in: mahara/1.10
    Milestone: None => 1.10.6

** Changed in: mahara/15.04
    Milestone: None => 15.04.3

** Changed in: mahara/1.10
   Importance: Undecided => High

** Changed in: mahara/15.04
   Importance: Undecided => High

** Changed in: mahara/1.10
     Assignee: (unassigned) => Robert Lyon (robertl-9)

** Changed in: mahara/15.04
     Assignee: (unassigned) => Robert Lyon (robertl-9)

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1479543

Title:
  Upgrading from 1.9 to 15.04 in mysql can timeout on big sites

Status in Mahara:
  In Progress
Status in Mahara 1.10 series:
  New
Status in Mahara 15.04 series:
  New

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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1479543/+subscriptions