-
Bug
-
Resolution: Won't Do
-
Minor
-
None
-
4.0.1
-
None
-
MOODLE_400_STABLE
When upgrading to Moodle 4.0.1 from 3.11 on a site with 22,000 users the upgrade of the myoverview block has been running for over three hours. Seems to be an issue with upgrade_block_set_my_user_parent_context('myoverview', '__default', 'my-index'); and specifically the query
DELETE mysql_deltable FROM mdl_user_preferences mysql_deltable JOIN ( SELECT p.id AS pid
|
FROM mdl_user_preferences p
|
JOIN mdl_block_instances bi ON p.name IN (CONCAT('block', bi.id, 'hidden'), CONCAT('docked_block_instance_', bi.id)) |
WHERE blockname = 'myoverview' |
AND pagetypepattern = 'my-index' |
AND subpagepattern = '2') mysql_subquery ON mysql_subquery.pid = mysql_deltable.id |