search

SoftwareDesignLab / vulnerability-intelligence-platform

Vulnerability Intelligence Platform
https://www.cve.live
MIT License
1 stars 0 forks source link

CVEs not showing in recent #148

Closed aep7128 closed 1 year ago

aep7128 commented 1 year ago

The Crawler is running and grabbing/inserting CVEs to the DB, but recent vulns aren't showing on the web app. Last action performed is to update the vulnerabilityaggregate table to cache the found vulns.

Might be an issue with the prepared statement, or an issue for how the table is being called by the API

Image

Image

aep7128 commented 1 year ago

I'm just extending the end time by 24 hours, I think some of these CVEs are shown in different time zones, or there's an error with how the default dates are made. This will be the temporary fix for now just to get CVEs showing again

aep7128 commented 1 year ago

Issue still occurs in staging, adding this back in TODO

aep7128 commented 1 year ago

this resolved now in staging, Issue was because of an error that was being thrown by the stored procedure used to update the cache. for solution, I just chopped the stored procedure and used a prepared statement instead. the cache was only filled for today though, why not have it pull from the actual vulnerability table if there's no change in the cache? Will add a task for the API to do that.