MySQL Replication



  • We have replication set up. That requires log-bin=mysql-bin.
  • [Note: I can't find where replication is setup.  But, I do want to get it setup for fall]


Temporary Fix:

  • This may or may not be the fix. We have to find the right configuration.
  • binlog-ignore-db=courses13

Stack Trace:

  • "Attempt quiz now"
  • Debug info: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
 INSERT INTO mdl_question_usages (contextid,component,preferredbehaviour) VALUES(?,?,?)
 [array (0 => '142',1 => 'mod_quiz',2 => 'deferredfeedback',)]
   line 397 of /lib/dml/moodle_database.php: dml_write_exception thrown
   line 893 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
   line 935 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
   line 67 of /question/engine/datalib.php: call to mysqli_native_moodle_database->insert_record()
   line 93 of /question/engine/lib.php: call to question_engine_data_mapper->insert_questions_usage_by_activity()
   line 234 of /mod/quiz/startattempt.php: call to question_engine::save_questions_usage_by_activity()