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

Some course restores throw an error/moodle/dmlwriteexception

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Not a bug
    • Icon: Critical Critical
    • None
    • 2.7.2
    • Backup
    • None
    • MOODLE_27_STABLE

      • 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.

            Unassigned Unassigned
            jnoah Justin Noah
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.