[MDL-70536] Create a CLI script to reset user dashboards - Moodle Tracker

XML

Word

Printable

Details

Type: Improvement
Status: Closed
Priority: Minor
Resolution: Fixed
Affects Version/s: 3.9.3, 3.11
Fix Version/s: 3.11
Component/s: Administration, Dashboard (My home)
Labels:
- CatalystIT
- ci
- partner
- release_notes
- triaged

Affected Branches:
MOODLE_311_STABLE, MOODLE_39_STABLE
Fixed Branches:
MOODLE_311_STABLE
Pull from Repository:
https://github.com/brendanheywood/moodle
Pull 3.11 Branch:
~~MDL-70536~~-reset-page-cli-MOODLE_311_STABLE
Pull 3.11 Diff URL:
https://github.com/moodle/moodle/compare/MOODLE_311_STABLE...brendanheywood:MDL-70536-reset-page-cli-MOODLE_311_STABLE
Pull Main Branch:
~~MDL-70536~~-reset-page-cli
Pull Main Diff URL:
https://github.com/moodle/moodle/compare/master...brendanheywood:MDL-70536-reset-page-cli
Testing Instructions:
Hide

Run the attached test script which generate a bunch of test dashboards so we can reset them (run it for as long as you want, you can kill it at any point):

php MDL-70536-dashboard-generator.php

Open a database shell and run the following statement and verify the result is ~10000 (Exact number is not important).

SELECT COUNT(*) FROM mdl_my_pages;

Run the new cli script

php admin/cli/dashboard_reset.php

Confirm it shows help.

Actually run it now:

php admin/cli/dashboard_reset.php -e

Confirm you get a nice progress bar showing progress

In the DB shell, run the same SELECT again

Confirm the value is ~10,000 smaller (there may be other pages not touched in this table).

Repeat steps 1-2.

Run the script again (step 5), but this time in non ttl mode:

php admin/cli/dashboard_reset.php -e | cat -v

Confirm you still get a simpler but dynamic progress bar

Repeat steps 7-8.
Show
Run the attached test script which generate a bunch of test dashboards so we can reset them (run it for as long as you want, you can kill it at any point): php MDL-70536-dashboard-generator.php Open a database shell and run the following statement and verify the result is ~10000 (Exact number is not important). SELECT COUNT (*) FROM mdl_my_pages; Run the new cli script php admin /cli/dashboard_reset .php Confirm it shows help. Actually run it now: php admin /cli/dashboard_reset .php -e Confirm you get a nice progress bar showing progress In the DB shell, run the same SELECT again Confirm the value is ~10,000 smaller (there may be other pages not touched in this table). Repeat steps 1-2. Run the script again (step 5), but this time in non ttl mode: php admin /cli/dashboard_reset .php -e | cat - v Confirm you still get a simpler but dynamic progress bar Repeat steps 7-8.

Description

Our moodle instance has 100,000+ users. It is not possible to reset dashboards from the GUI. This should be a cli script. We just upgraded to 3.9. It has been years since we have ever seen the GUI script to reset dashboards run to completion (it always times out), but it is especially a problem now with the update to 3.9 and all the great new dashboard blocks.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

image-2021-02-18-11-26-03-878.png
136 kB
18/Feb/21 11:26 AM
MDL-70536-dashboard-generator.php
0.3 kB
11/Feb/21 7:06 AM

Issue Links

has a non-specific relationship to

MDL-70444 Make my_reset_page_for_all_users for dashboards more robust

Closed

will be (partly) resolved by

MDL-70583 Implement a renderer for progress_bar in cli output

Closed

Activity

People

Assignee:: Brendan Heywood

Reporter:: Diane Soini

Peer reviewer:: Peter Burnett

Integrator:: Victor Déniz Falcón

Tester:: Janelle Barcega

Participants:: Amaia Anabitarte, Brendan Heywood, Chris Fryer, CiBoT, Diane Soini, Janelle Barcega, Mary Cooch, Peter Burnett, Victor Déniz Falcón

Votes:: 4 Vote for this issue

Watchers:: 24 Start watching this issue

Dates

Created:: 29/Dec/20 6:40 AM

Updated:: Yesterday 3:49 PM

Resolved:: 19/Feb/21 9:38 PM

Fix Release Date:: 17/May/21

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

3h 30m