rebuild_artefact_parent_cache_complete running out of memory
Bug #820727 reported by
Richard Mansfield
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Fix Released
|
Medium
|
Richard Mansfield |
Bug Description
See the following thread: http://
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_
Changed in mahara: | |
status: | New → Confirmed |
importance: | Undecided → Medium |
assignee: | nobody → Richard Mansfield (richard-mansfield) |
milestone: | none → 1.5.0 |
Changed in mahara: | |
status: | Confirmed → Fix Committed |
Changed in mahara: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Reviewed: https:/ /reviews. mahara. org/561 gitorious. org/mahara/ mahara/ commit/ 28599c24a22d6a5 b09b972ecbd6879 3ce16dc7aa
Committed: http://
Submitter: Hugh Davenport (<email address hidden>)
Branch: master
commit 28599c24a22d6a5 b09b972ecbd6879 3ce16dc7aa
Author: Richard Mansfield <email address hidden>
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 mahara. org/interaction /forum/ topic.php? id=2645 for more
http://
details.
Change-Id: I459a2d4a963771 6809476c5547bdf 1ab7e81f0d4
Signed-off-by: Richard Mansfield <email address hidden>