Posts made by Jerry Lau

Moodle in English -> General help -> Finding the offending module - task_adhoc failed (course module xxx could not be deleted) -> Re: Finding the offending module - task_adhoc failed (course module xxx could not be deleted)

by Jerry Lau -

I think I found them .. the problem is how to fix them?

MySQL> select id, course, module, instance, section, idnumber, deletioninprogress from mdl_course_modules where deletioninprogress = '1';

+--------+--------+--------+----------+---------+-----------------+--------------------+
| id     | course | module | instance | section | idnumber        | deletioninprogress |
+--------+--------+--------+----------+---------+-----------------+--------------------+
| 754132 |   5973 |     35 |      648 |  102932 | mm:54:4990:24:t |                  1 |
| 754133 |   5973 |     35 |      649 |  102932 | mm:99:4990:24:t |                  1 |
| 754134 |   5973 |      5 |    31294 |  102932 |                 |                  1 |
| 791661 |   6181 |     35 |      753 |  105978 | mm:66:4990:22:t |                  1 |
| 791662 |   6181 |     35 |      754 |  105978 | mm:65:4990:25:t |                  1 |
| 791663 |   6181 |     35 |      755 |  105978 | mm:53:4990:24:t |                  1 |
| 794212 |   6196 |     35 |      788 |  106137 | mm:66:4990:22:t |                  1 |
| 794213 |   6196 |     35 |      789 |  106137 | mm:65:4990:25:t |                  1 |
| 794214 |   6196 |     35 |      790 |  106137 | mm:53:4990:24:t |                  1 |
| 799350 |   6217 |     13 |   289508 |  106452 |                 |                  1 |
| 799351 |   6217 |     13 |   289509 |  106452 |                 |                  1 |
| 799352 |   6217 |     13 |   289510 |  106452 |                 |                  1 |
| 799353 |   6217 |     37 |   112299 |  106452 |                 |                  1 |
| 799354 |   6217 |     13 |   289511 |  106452 |                 |                  1 |
| 799355 |   6217 |     37 |   112300 |  106452 |                 |                  1 |
| 799356 |   6217 |     13 |   289512 |  106452 |                 |                  1 |
| 799357 |   6217 |     13 |   289513 |  106452 |                 |                  1 |
| 799358 |   6217 |     37 |   112301 |  106452 |                 |                  1 |
| 799359 |   6217 |     13 |   289514 |  106452 |                 |                  1 |
| 799360 |   6217 |     37 |   112302 |  106452 |                 |                  1 |
| 799361 |   6217 |      6 |     3039 |  106452 |                 |                  1 |
| 799362 |   6217 |     50 |      138 |  106452 |                 |                  1 |
+--------+--------+--------+----------+---------+-----------------+--------------------+
22 rows in set (0.11 sec)


What does instance and section refer to?


Average of ratings: -

Moodle in English -> General help -> Finding the offending module - task_adhoc failed (course module xxx could not be deleted)

by Jerry Lau -

So we have these adhoc tasks failing because one of users saw that their activity deletion is stuck "Activity deletion in progress" for some time

I then saw the table and log file and I am sure this is culprit..

How can I fix these entries and narrow down the module?  I know the plugin is ALLY but how do I go about fixing this?

Adhoc task failed: core_course\task\course_delete_modules,Coding error detected, it must be fixed by a programmer: The course module 791661 could not be deleted. #0 /our/moodle//lib/modinfolib.php(2232): course_modinfo->get_cm(791661)
#1 /our/moodle//admin/tool/ally/lib.php(89): get_course_and_cm_from_cmid('791661', NULL, '6181')
#2 /our/moodle//course/lib.php(1185): tool_ally_pre_course_module_delete(Object(stdClass))
#3 /our/moodle//course/classes/task/course_delete_modules.php(66): course_delete_module('791661')
#4 /our/moodle//lib/cronlib.php(185): core_course\task\course_delete_modules->execute()
#5 /our/moodle//lib/cronlib.php(74): cron_run_inner_adhoc_task(Object(core_course\task\course_delete_modules))
#6 /our/moodle//admin/cli/cron.php(61): cron_run()

our task_adhoc table

+------+-----------+----------------------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id   | component | from_unixtime(nextruntime) | faildelay | customdata                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
+------+-----------+----------------------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 1665 |           | 2019-04-24 01:37:03        |     86400 | {"cms":{"794211":{"id":"794211"},"794212":{"id":"794212"},"794213":{"id":"794213"},"794214":{"id":"794214"}},"userid":"138658","realuserid":"138658"}                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| 1799 |           | 2019-04-24 10:26:02        |     86400 | {"cms":{"791660":{"id":"791660"},"791661":{"id":"791661"},"791662":{"id":"791662"},"791663":{"id":"791663"}},"userid":"138658","realuserid":"138658"}                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| 1841 |           | 2019-04-23 22:01:02        |     86400 | {"cms":{"799332":{"id":"799332"},"799333":{"id":"799333"},"799334":{"id":"799334"},"799335":{"id":"799335"},"799336":{"id":"799336"},"799337":{"id":"799337"},"799338":{"id":"799338"},"799339":{"id":"799339"},"799340":{"id":"799340"},"799341":{"id":"799341"},"799342":{"id":"799342"},"799343":{"id":"799343"},"799344":{"id":"799344"},"799345":{"id":"799345"},"799346":{"id":"799346"},"799347":{"id":"799347"},"799348":{"id":"799348"},"799349":{"id":"799349"},"799350":{"id":"799350"},"799351":{"id":"799351"},"799352":{"id":"799352"},"799353":{"id":"799353"},"799354":{"id":"799354"},"799355":{"id":"799355"},"799356":{"id":"799356"},"799357":{"id":"799357"},"799358":{"id":"799358"},"799359":{"id":"799359"},"799360":{"id":"799360"},"799361":{"id":"799361"},"799362":{"id":"799362"}},"userid":"11847","realuserid":"11847"} |
+------+-----------+----------------------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)
Suggestions always welcome smile

Thanks
Average of ratings: -