Завершение планировщика Регулярная задача Moodle Stuck 3.6.2 ⇐ Php

[Anonymous]

Moodle версия 3.6.2, PHP 7.2 NTS, Windows
Я использую планировщик задач для запуска Cron Daily, когда я проверяю Moodle DeginledTasks
Я замечаю, что задача завершает opplion_regular_task (когда я запускаю в Интернете, это не может получить блокировку задачи). Все еще застрял там, когда я проверяю DB MDL_LOCK_DB Завершение задачи_ГРЕЛЯ_TASK, и когда я проверяю процесс DB SSMS < /p>

Execute scheduled task: Calculate regular completion data (core\task\completion_regular_task)
... started 00:15:48. Current memory use 23.2MB.
Starting course completion batch processing...
>> Processed 0 records.
>> Completion cron finished.

< /code>
`< /p>
SELECT
r.session_id AS VictimSession,
r.blocking_session_id AS BlockingSession,
r.wait_type,
r.wait_time,
r.last_wait_type,
r.status,
r.command,
r.wait_resource,
st.text AS RunningSQL
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) st
WHERE r.blocking_session_id 0;
< /code>
`< /p>
VictimSession | BlockingSession | wait_type | wait_time | last_wait_type | status | command
52 | 52 | LCK_M_IX | 10768 | LCK_M_IX | suspended | UPDATE

• purge cache moodle
• delete file on moodledata (like cache, session, lock,temp)
• Debug on config moodle, show all error add some code like try and catch (to check if it's work or not, the code is showing but it's stuck again)
• check on log php and log moodle (got nothing, it's not error)
• add index on table (maybe the data on db is too much)
• check on forum moodle (find nothing)

I though it's because I using NFS and it's locking (race condition), but even after I put moodledata on local server it's still got same result, I only test cron on 1 server (other is shutdown, to make sure no double run cron)
This never happen before and usually after purgecache everything is back to normal.
Already stuck almost 2 weeks and still no clue for fixing this problem any idea?

Подробнее здесь: https://stackoverflow.com/questions/796 ... tuck-3-6-2