Unable to fetch vulnerable projects
Summary
Error on https://gitlab.com/groups/gitlab-org/-/security/dashboard/?state=DETECTED&state=CONFIRMED
Unable to fetch vulnerable projects
Steps to reproduce
- Access https://gitlab.com/groups/gitlab-org/-/security/dashboard/?state=DETECTED&state=CONFIRMED
- Wait for time-out. Error appears.
Example Project
https://gitlab.com/groups/gitlab-org/-/security/dashboard/?state=DETECTED&state=CONFIRMED
What is the current bug behavior?
Project security status doesn't populate
What is the expected correct behavior?
It should populate
Relevant logs and/or screenshots
Output of checks
This bug happens on GitLab.com
Possible fixes
https://gitlab.com/groups/gitlab-org/-/security/vulnerable_projects is returning 500 errors
Sentry link: https://sentry.gitlab.net/gitlab/gitlabcom/issues/1718443
Rewrite queries used in https://gitlab.com/gitlab-org/gitlab/blob/master/ee/app/presenters/security/vulnerable_project_presenter.rb#L15 and https://gitlab.com/gitlab-org/gitlab/blob/master/ee/app/finders/security/vulnerable_projects_finder.rb#L12 to use data from Vulnerabilities::Statistic model instead.
/cc @matt_wilson @lkerr