search

Azure / hpcpack

The repo to track public issues for Microsoft HPC Pack product.
MIT License
30 stars 11 forks source link

on job cleanup (scheduled task) projects are not cleared #42

Open haaver opened 6 months ago

haaver commented 6 months ago

Problem Description

project names from drop down list (job view) remain and fill up the list.

Steps to Reproduce

enter jobs with different project names. wait until the history cleans them up.

Expected Results

project name filter should only show project names of jobs currently listed.

Actual Results

project name filter list still lists the project names for jobs not listed any longer.

Additonal Comments

SP_DeleteOldJobs procedure might be the faulty one as one of the last query is faulty and should rather look like that (approx line 100): DELETE FROM JobProjectName WHERE Id NOT IN (SELECT isnull(ProjectId, 1) FROM Job group by ProjectId UNION ALL SELECT isnull(ProjectId, 1) FROM JobHistory group by ProjectId);

YutongSun commented 1 month ago

We made a fix for this in the upcoming HPC Pack 2019 Update 3.