-
Bug
-
Resolution: Not a bug
-
Critical
-
None
-
3.0.3
-
MOODLE_30_STABLE
Report from mcwoods 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()
|
* !!
|
- is a regression caused by
-
-
- Closed
-