A lock statistics admin tool, specifically tailored to report on cron task timings.
This tool exposes which tasks are currently running and where, and also shows a detailed history of how long each task has taken in the past.
Since Moodle 3.10 there is now an internal record of which tasks are running and their host and pid and very similar metadata to what this plugin records. The reporting in core is not quite the same but for simple visbiity of what tasks are currently running this plugin is mostly redudant. See also:
https://tracker.moodle.org/browse/MDL-67211
As the reports in core are improved more this plugin will be fully redundant, so it is best to consider this plugin deprecated but with no clear timeline on when support will end.
Moodle verion | Branch |
---|---|
Moodle 2.7 to 3.8 | master |
Moodle 3.9 | MOODLE_39_STABLE |
Moodle 3.10 - 3.11 | MOODLE_310_STABLE |
Totara 9 - 12 | master |
Totara 13 | MOODLE_310_STABLE |
It implements a proxy lock factory which adds instrumentation around the real lock factory. It will log details about each cron task when a lock is obtained and released. This is the data that is obtained:
Most of the time, most cron tasks are quick and finish in seconds. These typically are not the tasks you are interesting in the history off. So this plugin compresses the history quick tasks so you still get overall stats for all tasks, and detailed stats for slower bigger tasks, and without bloating out the database with too much data. Old stats can be removed after a set time period too.
Install the plugin the same as any standard moodle plugin either via the Moodle plugin directory:
https://moodle.org/plugins/tool_lockstats
https://docs.moodle.org/en/Installing_plugins
OR you can use git to clone it into your source:
git clone git@github.com:catalyst/moodle-tool_lockstats.git admin/tool/lockstats
This is an example of using the Postgres lock factory, add this to your config.php:
$CFG->lock_factory = "\\tool_lockstats\\proxy_lock_factory";
$CFG->proxied_lock_factory = "auto";
# If you want to be explicit you can do this:
$CFG->proxied_lock_factory = "\\core\\lock\\postgres_lock_factory";
// To allow unit tests to pass.
$CFG->phpunit_lock_factory = "\\tool_lockstats\\proxy_lock_factory";
$CFG->phpunit_proxied_lock_factory = "\\core\\lock\\postgres_lock_factory";
Using the UI you can configure additional settings at,
Site administration > Plugins > Admin tools > Lock statistics
The values you can configure are,
This allows you to prevent logging the history for specific tasks.
If the task exceeds this value in seconds then a new history entry will be logged.
A task exists that will clean up history entries that exceed this value in days.
Provides additional debugging messages in the cron.log for when the locks are obtained and released.
You can view the current locked tasks, lock history and details via the UI at,
Site administration > Server > Lock statistics
The list of current locks is also exposed via a cli script:
$ php admin/tool/lockstats/cli/list_locks.php
PID HOST TYPE TIME KEY NAME
10806 zebrafish adhoc 00:00:06 adhoc_65943 \tool_testtasks\task\timed_adhoc_task
10810 zebrafish adhoc 00:00:05 adhoc_65945 \tool_testtasks\task\timed_adhoc_task
10808 zebrafish adhoc 00:00:05 adhoc_65944 \tool_testtasks\task\timed_adhoc_task
Found 3 lock(s)
And you can watch this for a dynamic list of processes:
watch -n 1 php admin/tool/lockstats/cli/list_locks.php