We are using Moodle 3.7 with PHP 7 and MS SQL.We did not any customization Moodle Code.
Query block each other when Clear old session task run in Moodle Corn.,See below Two query which block each other.
SELECT u.*, s.sid, s.timecreated AS s_timecreated, s.timemodified AS s_timemodified
FROM mdl_user u
JOIN mdl_sessions s ON s.userid = u.id
WHERE s.timemodified < '1562738746' AND u.id <> '1'
DELETE [mdl_sessions] WHERE [sid]=@1
Is this modle Default BUG!!!!.
Please help us solve Issue,