Ich verwende Task Scheduler zum täglichen Ausführen von Cron, wenn ich auf Moodle afuledTasks
bemerkt, dass die Aufgabe die Fertigstellung von Aufgaben coment_regular_task festgefahren ist (wenn ich auf dem Web renne. Dort festgeklebt, wenn ich nach DB MDL_LOCK_DB Task Completion_Regular_task überprüfe und wenn ich nach Prozess db SSMS < /p>
überprüfe
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)
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?