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

Exception during upgrade

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Not a bug
    • Affects Version/s: 3.0.3
    • Fix Version/s: None
    • Component/s: Database SQL/XMLDB, Logging
    • Labels:
    • Affected Branches:
      MOODLE_30_STABLE

      Description

      Report from Michael Woods in MDL-53795

      We are running MySQL 5.5.46. We pull latest changes via git and upgrade via CLI. We actually got a DDL execution error. Do you think it's related? Or something else completely? I've never seen a crash via a CLI upgrade before. I've pasted the error messages below.
      In order to get users back up and running, we needed to (temporarily) remove the 'upgraderunning' value in mdl_config, but the upgrade still needs to happen. I just don't want to do it until well out of hours now, in case the below errors happen again.

      Are you sure you want to upgrade this server to this version?
      type y (means yes) or n (means no)
      : y
      -->System
      ++ Success ++
      -->mod_hotpot
      ++ Success ++
      -->ltiservice_toolsettings
      ++ Success ++
      -->logstore_standard
      Default exception handler: DDL sql execution error Debug: Incorrect key file for table 'mdl_logstore_standard_log'; try to repair it
      CREATE INDEX mdl_logsstanlog_con_ix ON mdl_logstore_standard_log (contextid)
      Error code: ddlexecuteerror
      * line 449 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
      * line 905 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      * line 76 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
      * line 744 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
      * line 135 of /admin/tool/log/store/standard/db/upgrade.php: call to database_manager->add_key()
      * line 545 of /lib/upgradelib.php: call to xmldb_logstore_standard_upgrade()
      * line 1647 of /lib/upgradelib.php: call to upgrade_plugins()
      * line 171 of /admin/cli/upgrade.php: call to upgrade_noncore()
       
      !!! DDL sql execution error !!!
      !! Incorrect key file for table 'mdl_logstore_standard_log'; try to repair it
      CREATE INDEX mdl_logsstanlog_con_ix ON mdl_logstore_standard_log (contextid)
      Error code: ddlexecuteerror !!
      !! Stack trace: * line 449 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
      * line 905 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      * line 76 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
      * line 744 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
      * line 135 of /admin/tool/log/store/standard/db/upgrade.php: call to database_manager->add_key()
      * line 545 of /lib/upgradelib.php: call to xmldb_logstore_standard_upgrade()
      * line 1647 of /lib/upgradelib.php: call to upgrade_plugins()
      * line 171 of /admin/cli/upgrade.php: call to upgrade_noncore()
      * !!
      

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                4 Vote for this issue
                Watchers:
                14 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: