Hi.
I've just noticed that our adhoc tasks have not run in 4 days. This was brought to my attention when someone mentioned that forum posts weren't being delivered (internal notification and email).
Looking in the 'task_adhoc' table, i can see there are 8k+ adhoc tasks, dating back 4 days (\mod_forum\task\send_user_notifications) and 2k(ish) other tasks like 'forum digests', 'delete modules', etc. So it would appear that something happened around that time that caused these tasks to stop running.
Looking in the 'lock_db' table i can see a few locked tasks, a couple of which refer to 'adhoc'.
id | resourcekey | expires | owner | |
---|---|---|---|---|
253465 | core_message_migrate_data_2_22143 | 1599326657 | 9a50e1d2-8510-4ad1-b50f-897fae126874 | |
253463 | cron_adhoc_33596 | 1599326657 | 9c3667cf-6908-424f-87bd-7890e79d0412 | |
251874 | cron_adhoc_task_runner_0 | 1599326657 | 1a204629-30ef-4d8c-83ac-469488dc1d9a | |
73830 | 2_22143 | 1596038106 | 551f372b-ba9a-41ce-8a5d-62b74c86e9b9 | |
73829 | adhoc_33596 | 1596038105 | b8df5e7c-ff7e-45a1-a327-fde815421081 |
We ran a LARGE user sync task the night before, so guess that this has created a task lock.
My question is... would any of these locks be responsible for stopping the adhoc tasks from running, and if so, is it safe to delete these records?
On a similar note, i notice approx 300k rows in the lock_db table, but the 'expires' and 'owner' columns are NULL. Should they be there, or should they be cleaned up?
Moodle v3.9.1
Thanks in advance