mahara-contributors team mailing list archive

[Mahara Bot <1018590@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/1374
Committed: http://gitorious.org/mahara/mahara/commit/8fd6d5d5a8d22e3e90d7c47b3caf035d9b157cbf
Submitter: Hugh Davenport (hugh@xxxxxxxxxxxxxxx)
Branch:    1.5_STABLE

commit 8fd6d5d5a8d22e3e90d7c47b3caf035d9b157cbf
Author: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>
Date:   Wed Jun 27 18:25:31 2012 +1200

    Insert fewer rows per query in MySQL textbox upgrade (bug #1018590)
    
    The upgrade to convert textboxes to artefacts tries to insert 5000
    rows at a time into the artefact table.  This is too much data for
    MySQL's default max_allowed_packet setting.  Reducing the number of
    rows inserted per query to 100 (or a bit larger, depending on
    max_allowed_packet) fixes the upgrade problem.
    
    See https://mahara.org/interaction/forum/topic.php?id=4474#post20477
    
    Change-Id: I8335323e247abb570a434cd105d4590cad103018
    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/1018590

Title:
  Textbox upgrade inserts too many rows per query in MySQL

Status in Mahara ePortfolio:
  Fix Committed

Bug description:
  The upgrade to convert textboxes to artefacts tries to insert 5000
  rows at a time into the artefact table.  This is too much data for
  MySQL's default max_allowed_packet setting, and should be reduced.

  See https://mahara.org/interaction/forum/topic.php?id=4474#post20477

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