Deletion of scheduler stuck on deleting from JobRun_PredJobRun, how can we check the progress?
INFO [DeleteSchedulerHelper] Step 3>Deleting JobRunPredJobRun
Release : 6.3.0
The JobRun_PredJobRun table can have a lot of rows and can take time in some environments.
There should be some logging in the jaws.log like below:
[QueryTimingService] 102.2% of last 0:01:00 spent in DB/API operations (possibly on multiple threads/overlapping queries) 79.1%: 27x (avg. time: 1.76) flush 8.1%: 4,098x (avg. time: 0.001) query: delete from JobRun where id = :id 4.4%: 4,098x (avg. time: 0.001) sql: DELETE FROM JobRun_PredJobRun WHERE predJobRunId = ? 3.3%: 4,098x (avg. time: 0) sql: DELETE FROM JobRun_PredJobRun WHERE jobRunId = ?
To verify how many rows are still in that table you can run a query like below using your scheduler name:
You can run this query to get a count of the number of rows, and run it again later to verify if you are seeing the number of rows drop, if so, it is still making progress and may take time to complete.