mahara-contributors team mailing list archive

[Mahara Bot <820727@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/561
Committed: http://gitorious.org/mahara/mahara/commit/28599c24a22d6a5b09b972ecbd68793ce16dc7aa
Submitter: Hugh Davenport (hugh@xxxxxxxxxxxxxxx)
Branch:    master

commit 28599c24a22d6a5b09b972ecbd68793ce16dc7aa
Author: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>
Date:   Thu Aug 4 15:21:30 2011 +1200

    Read artefact table in chunks when rebuilding parent cache (bug #820727)
    
    The cron job to rebuild the artefact_parent_cache table uses all the
    available memory when the artefact table gets big, so it needs to read
    it in in smaller chunks.
    
    This version of the function ensures that all artefacts with the same
    owner are read in at the same time, which means all artefact parent
    relationships are available.
    
    See http://mahara.org/interaction/forum/topic.php?id=2467 and
    http://mahara.org/interaction/forum/topic.php?id=2645 for more
    details.
    
    Change-Id: I459a2d4a9637716809476c5547bdf1ab7e81f0d4
    Signed-off-by: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/820727

Title:
  rebuild_artefact_parent_cache_complete running out of memory

Status in Mahara ePortfolio:
  Confirmed

Bug description:
  See the following thread:
  http://mahara.org/interaction/forum/topic.php?id=2645

  That rewrite held the memory limit problem at bay for a little while,
  but now with a bigger artefact table (~300000 rows) cron.php is
  running out of memory again.

  rebuild_artefact_parent_cache_complete() should be modified so it
  reads the artefact table a bit at a time, instead of all at once.

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