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

Upgrade of block_myoverview from 3.11 to 4.0.1 is taking hours

    XMLWordPrintable

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 4.0.1
    • None
    • Blocks, Dashboard (My home)
    • None
    • MOODLE_400_STABLE

    Description

      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 

      Attachments

        Activity

          People

            Unassigned Unassigned
            tim.martinez Tim Martinez
            David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: