mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

Public bug reported:

Upgrade Issue 1 - Add path and update records :

This adds a field 'path' to artefact table and thereafter runs a update
query to add data. We have around 500K rows and this takes around 94
minutes to upgrade! This can be done in one go without the limit of 200
and it works very well taking around 2-3 minutes!

Few times the upgrade failed due to "mysqli error: [1205: Lock wait
timeout exceeded; try restarting transaction]".

This is spun off from Bug #1499568

** Affects: mahara
     Importance: Medium
         Status: Confirmed

** Affects: mahara/15.04
     Importance: Medium
         Status: Confirmed

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

** Changed in: mahara/15.04
       Status: New => Confirmed

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

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

-- 
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/1500285

Title:
  Add path and update records slowness

Status in Mahara:
  Confirmed
Status in Mahara 15.04 series:
  Confirmed

Bug description:
  Upgrade Issue 1 - Add path and update records :

  This adds a field 'path' to artefact table and thereafter runs a
  update query to add data. We have around 500K rows and this takes
  around 94 minutes to upgrade! This can be done in one go without the
  limit of 200 and it works very well taking around 2-3 minutes!

  Few times the upgrade failed due to "mysqli error: [1205: Lock wait
  timeout exceeded; try restarting transaction]".

  This is spun off from Bug #1499568

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