Alain Raap

Hi Ken,

The backup preferences are the same on 3.9 and 4.1, general logs and general histories are excluded from the backup.
The 2Gig backup takes 10 hours to complete, as I already mentioned it's a course that's already used for a long time
and with a lot of users and quizzes. Maybe it would better to create a new course and stop using these old courses

Hi Ken,

The backups that cause the long time to run are very large courses (2GB) with a lot of users and quizes included. They are already used for a long time and because of the long time to run they were a reason to exclude them from the normal automated backup run. But now the largest course that ran 12 hours in Moodle 3.9, doesn't finish between the last and next automated backup anymore. 

The only difference in the environments is Redhat 7/Moodle 3.9/PHP 7.2 versus Redhat 8/Moodle 4.1/PHP 7.4.

Hi Ken,

Yes, not a typo😉and no, not an early badge needed😊

We’re just looking forward what to expect from the next LTS release 4.1 (in November I believe?)

But it’s a serious problem I discovered, and I think it must be somewhere in the new code (or maybe old courses that take a lot more time to backup)? Can’t get a finger behind it.

Maybe you can give it a try yourself?

I've upgraded my lab environment for Moodle 4.1dev (20220812) to Moodle 4.1dev (20220826) and I get these database errors after the upgrade (in Performance report -> database). I see that there were changes on several database tables in this build. Anyone who had the same problem?

Details

course

Missing index 'originalcourseid' (not unique (originalcourseid)). 

CREATE INDEX mdl_cour_ori_ix ON mdl_course (originalcourseid);

enrol

Missing index 'roleid' (not unique (roleid)). 

CREATE INDEX mdl_enro_rol_ix ON mdl_enrol (roleid);

scale

Missing index 'userid' (not unique (userid)). 

CREATE INDEX mdl_scal_use_ix ON mdl_scale (userid);

scale_history

Missing index 'userid' (not unique (userid)). 

CREATE INDEX mdl_scalhist_use_ix ON mdl_scale_history (userid);

post

Missing index 'courseid' (not unique (courseid)). 

CREATE INDEX mdl_post_cou_ix ON mdl_post (courseid);

Missing index 'coursemoduleid' (not unique (coursemoduleid)). 

CREATE INDEX mdl_post_cou2_ix ON mdl_post (coursemoduleid);

question_statistics

Missing index 'questionid' (not unique (questionid)). 

CREATE INDEX mdl_quesstat_que_ix ON mdl_question_statistics (questionid);

question_response_analysis

Missing index 'questionid' (not unique (questionid)). 

CREATE INDEX mdl_quesrespanal_que_ix ON mdl_question_response_analysis (questionid);

mnet_host

Missing index 'last_log_id' (not unique (last_log_id)). 

CREATE INDEX mdl_mnethost_las_ix ON mdl_mnet_host (last_log_id);

mnet_session

Missing index 'userid' (not unique (userid)). 

CREATE INDEX mdl_mnetsess_use_ix ON mdl_mnet_session (userid);

Missing index 'mnethostid' (not unique (mnethostid)). 

CREATE INDEX mdl_mnetsess_mne_ix ON mdl_mnet_session (mnethostid);

grade_import_values

Missing index 'userid' (not unique (userid)). 

CREATE INDEX mdl_gradimpovalu_use_ix ON mdl_grade_import_values (userid);

portfolio_log

Missing index 'tempdataid' (not unique (tempdataid)). 

CREATE INDEX mdl_portlog_tem_ix ON mdl_portfolio_log (tempdataid);

file_conversion

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_fileconv_use_ix ON mdl_file_conversion (usermodified);

repository_instances

Missing index 'userid' (not unique (userid)). 

CREATE INDEX mdl_repoinst_use_ix ON mdl_repository_instances (userid);

Missing index 'contextid' (not unique (contextid)). 

CREATE INDEX mdl_repoinst_con_ix ON mdl_repository_instances (contextid);

rating

Missing index 'scaleid' (not unique (scaleid)). 

CREATE INDEX mdl_rati_sca_ix ON mdl_rating (scaleid);

course_published

Missing index 'courseid' (not unique (courseid)). 

CREATE INDEX mdl_courpubl_cou_ix ON mdl_course_published (courseid);

Missing index 'hubcourseid' (not unique (hubcourseid)). 

CREATE INDEX mdl_courpubl_hub_ix ON mdl_course_published (hubcourseid);

event_subscriptions

Missing index 'courseid' (not unique (courseid)). 

CREATE INDEX mdl_evensubs_cou_ix ON mdl_event_subscriptions (courseid);

Missing index 'userid' (not unique (userid)). 

CREATE INDEX mdl_evensubs_use_ix ON mdl_event_subscriptions (userid);

task_log

Missing index 'userid' (not unique (userid)). 

CREATE INDEX mdl_tasklog_use_ix ON mdl_task_log (userid);

competency

Missing index 'scaleid' (not unique (scaleid)). 

CREATE INDEX mdl_comp_sca_ix ON mdl_competency (scaleid);

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_comp_use_ix ON mdl_competency (usermodified);

competency_coursecompsetting

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_compcour_use_ix ON mdl_competency_coursecompsetting (usermodified);

competency_framework

Missing index 'contextid' (not unique (contextid)). 

CREATE INDEX mdl_compfram_con_ix ON mdl_competency_framework (contextid);

Missing index 'scaleid' (not unique (scaleid)). 

CREATE INDEX mdl_compfram_sca_ix ON mdl_competency_framework (scaleid);

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_compfram_use_ix ON mdl_competency_framework (usermodified);

competency_coursecomp

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_compcour_use2_ix ON mdl_competency_coursecomp (usermodified);

competency_plan

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_compplan_use_ix ON mdl_competency_plan (usermodified);

competency_template

Missing index 'contextid' (not unique (contextid)). 

CREATE INDEX mdl_comptemp_con_ix ON mdl_competency_template (contextid);

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_comptemp_use_ix ON mdl_competency_template (usermodified);

competency_templatecomp

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_comptemp_use2_ix ON mdl_competency_templatecomp (usermodified);

competency_templatecohort

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_comptemp_use3_ix ON mdl_competency_templatecohort (usermodified);

competency_relatedcomp

Missing index 'competencyid' (not unique (competencyid)). 

CREATE INDEX mdl_comprela_com_ix ON mdl_competency_relatedcomp (competencyid);

Missing index 'relatedcompetencyid' (not unique (relatedcompetencyid)). 

CREATE INDEX mdl_comprela_rel_ix ON mdl_competency_relatedcomp (relatedcompetencyid);

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_comprela_use_ix ON mdl_competency_relatedcomp (usermodified);

competency_usercomp

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_compuser_use_ix ON mdl_competency_usercomp (usermodified);

competency_usercompcourse

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_compuser_use2_ix ON mdl_competency_usercompcourse (usermodified);

competency_usercompplan

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_compuser_use3_ix ON mdl_competency_usercompplan (usermodified);

competency_plancomp

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_compplan_use2_ix ON mdl_competency_plancomp (usermodified);

competency_evidence

Missing index 'contextid' (not unique (contextid)). 

CREATE INDEX mdl_compevid_con_ix ON mdl_competency_evidence (contextid);

Missing index 'actionuserid' (not unique (actionuserid)). 

CREATE INDEX mdl_compevid_act_ix ON mdl_competency_evidence (actionuserid);

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_compevid_use2_ix ON mdl_competency_evidence (usermodified);

competency_userevidence

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_compuser_use4_ix ON mdl_competency_userevidence (usermodified);

competency_userevidencecomp

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_compuser_use5_ix ON mdl_competency_userevidencecomp (usermodified);

competency_modulecomp

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_compmodu_use_ix ON mdl_competency_modulecomp (usermodified);

oauth2_endpoint

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_oautendp_use_ix ON mdl_oauth2_endpoint (usermodified);

oauth2_system_account

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_oautsystacco_use_ix ON mdl_oauth2_system_account (usermodified);

oauth2_user_field_mapping

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_oautuserfielmapp_use_ix ON mdl_oauth2_user_field_mapping (usermodified);

analytics_models

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_analmode_use_ix ON mdl_analytics_models (usermodified);

analytics_models_log

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_analmodelog_use_ix ON mdl_analytics_models_log (usermodified);

oauth2_access_token

Missing index 'usermodified' (not unique (usermodified)). 

CREATE INDEX mdl_oautaccetoke_use_ix ON mdl_oauth2_access_token (usermodified);

payment_accounts

Missing index 'contextid' (not unique (contextid)). 

CREATE INDEX mdl_paymacco_con_ix ON mdl_payment_accounts (contextid);

questionnaire_survey

column 'name' length is 191, expected 255 (C)