23 Nov
2012
23 Nov
'12
02:10
Hello, I have noticed, that NAV is reporting jobs as overdue, even though a job end with success. I believe the problem is caused by trigger trim_old_ipdevpoll_job_log_entries, which should delete the old jobs from the ipdevpoll_job_log table.
DELETE FROM ipdevpoll_job_log WHERE id IN (SELECT id FROM ipdevpoll_job_log WHERE job_name=NEW.job_name AND netboxid=NEW.netboxid ORDER BY end_time ASC OFFSET 100);
When there are 100 log entries for a job in the nav database the trigger will delete the newest logged job instead of oldest one. I believe, that the ORDER BY clause should be DESC not ASC.
Regards,
M.