search

thewca / statistics

12 stars 16 forks source link

Database export has not been replaced in >=19 days #93

Closed JonEsparaz closed 1 year ago

JonEsparaz commented 1 year ago

The database export is supposed to be automatically replaced every 7 days:

https://github.com/thewca/statistics/blob/6e5c104801fc57489df25e1b419883c7d991f38c/scripts/get_db_export.sh#L19-L22

But it has not updated since 12/28/2022:

image

I don't see anything in the code that suggests an issue handling a change in year (I could be wrong). Is there a way to check if the cron is running?

JonEsparaz commented 1 year ago

Actually, I think the issue is with the developer DB dump, not this script. The wca-developer-database-dump.sql I just pulled was created ‎Thursday, ‎December ‎29, ‎2022, ‏‎6:11:16 PM:

image

campos20 commented 1 year ago

The code snipped that you pasted is for local run. When creating the statistics locally, we don't download the export again within a week. This issue is in the WCA main website. If the export is not updated, the results here will not be updated as well.