search

ossf / Project-Security-Metrics

Collect, curate, and communicate relevant security metrics for open source projects.
https://openssf.org
Apache License 2.0
63 stars 24 forks source link

Scorecard not refreshing #61

Closed scovetta closed 3 years ago

scovetta commented 3 years ago

The scorecard is failing to refresh (downloading latest data from BigQuery), investigating. The other data refreshed successfully.

scovetta commented 3 years ago

Needed to update the query:

SELECT partition_id FROM openssf.scorecardcron.INFORMATION_SCHEMA.PARTITIONS WHERE table_name = 'scorecard' AND total_rows > 100 ORDER BY partition_id DESC LIMIT 1

The total_rows > 100 is just in case of a recent failed run, which often only has a few rows. The table_name is needed because there can sometimes be other test tables.

Load is working now.

scovetta commented 3 years ago

Fix is in place now.