Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-47387

Some course restores throw an error/moodle/dmlwriteexception

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Not a bug
    • Affects Version/s: 2.7.2
    • Fix Version/s: None
    • Component/s: Backup
    • Labels:
      None
    • Affected Branches:
      MOODLE_27_STABLE

      Description

      • A clean install from the MOODLE_27_STABLE branch
      • Course restore
      • Log output:
        [23-Sep-2014 18:03:43 UTC] Default exception handler: Error writing to database Debug: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
        INSERT INTO mdl_backup_controllers (backupid,operation,type,itemid,format,interactive,purpose,userid,status,execution,executiontime,checksum,controller,timecreated,timemodified) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
        [array (
        0 => 'd2013ceb949e1805d4807f26bcc4bc78',
        1 => 'restore',
        2 => 'course',
        3 => 2,
        4 => 'moodle2',
        5 => 1,
        6 => 10,
        7 => '2',
        8 => 500,
        9 => 1,
        10 => 0,
        11 => '251623dc4e5171ff58cf2e4812b3601a',
        12 => <base64 encoded controller omitted due to copyright>,
        13 => 1411495423,
        14 => 0,
        )]
        Error code: dmlwriteexception
      • line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown
      • line 1167 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1213 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
      • line 87 of /backup/util/dbops/restore_controller_dbops.class.php: call to mysqli_native_moodle_database->insert_record()
      • line 418 of /backup/controller/restore_controller.class.php: call to restore_controller_dbops::save_controller()
      • line 137 of /backup/util/ui/base_ui.class.php: call to restore_controller->save_controller()
      • line 118 of /backup/restore.php: call to base_ui->save_controller()

      Once/If I am able to find an open course that causes this issue as well, I'll link the mbz.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              jnoah Justin Noah
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: