Hi,

Having a similar issue to:
MDL-76274 bump_submission_for_stale_conversions adhoc task runs in situations when it shouldn't - Moodle Tracker

The cron job is trying to delete records and using high CPU resources.

We deleted the table "mdl_assignfeedback_editpdf_queue" and the ad_hock task is still running.

We upgraded from 3.11.8 to 3.11.18.

We restarted postgres and are getting this.

Does anyone have a similar issue or resolution?

—

2024-01-03 11:23:52.073 AST [85232] STATEMENT:  SELECT f3.id, f3.timemodified as fmodified, asu.id as submissionid
                              FROM mdl_files f1
                         LEFT JOIN mdl_files f2 ON f1.contenthash = f2.filename
                                   AND f2.component = 'core' AND f2.filearea = 'documentconversion'
                              JOIN mdl_assign_submission asu ON asu.id = f1.itemid
                              JOIN mdl_assign_grades asg ON asg.userid = asu.userid AND asg.assignment = asu.assignment
                              JOIN mdl_files f3 ON f3.itemid = asg.id
                             WHERE f1.filearea = 'submission_files'
                                   AND f3.timecreated >= $1
                                   AND (f1.filename LIKE $2 ESCAPE '\' OR f1.filename LIKE $3 ESCAPE '\' OR f1.filename LIKE $4 ESCAPE '\' OR f1.filename LIKE $5 ESCAPE '\' OR f1.filename LIKE $6 ESCAPE '\' OR f1.filename LIKE $7 ESCAPE '\' OR f1.filename LIKE $8 ESCAPE '\' OR f1.filename LIKE $9 ESCAPE '\' OR f1.filename LIKE $10 ESCAPE '\' OR f1.filename LIKE $11 ESCAPE '\' OR f1.filename LIKE $12 ESCAPE '\' OR f1.filename LIKE $13 ESCAPE '\' OR f1.filename LIKE $14 ESCAPE '\' OR f1.filename LIKE $15 ESCAPE '\')
                                   AND f2.filename IS NULL
                                   AND f3.component = 'assignfeedback_editpdf'
                                   AND f3.filearea = 'combined'
                                   AND f3.filename = 'combined.pdf'
                                   AND f3.timemodified >= asu.timemodified

—