dotnet / nuget-trends

Check out NuGet packages adoption and what's trending on NuGet.
https://nugettrends.com
MIT License
144 stars 25 forks source link

Download numbers seem broken #258

Closed bruno-garcia closed 4 months ago

bruno-garcia commented 4 months ago

image

KristofferStrube commented 4 months ago

I am experiencing the same. image

bruno-garcia commented 4 months ago

I'll take a look at it on the weekend. I got a bunch of errors in Sentry a while ago and didn't get around debugging that yet

bruno-garcia commented 4 months ago

starting by looking at the data and there are rows for each day, just doesn't seem to change the counts since 2024-01-19:

nugettrends=> select  * from daily_downloads where package_id = 'Sentry' order by date desc limit 100;
 package_id |        date         | download_count
------------+---------------------+----------------
 Sentry     | 2024-02-10 00:00:00 |       46888265
 Sentry     | 2024-02-09 00:00:00 |       46888265
 Sentry     | 2024-02-08 00:00:00 |       46888265
 Sentry     | 2024-02-07 00:00:00 |       46888265
 Sentry     | 2024-02-06 00:00:00 |       46888265
 Sentry     | 2024-02-05 00:00:00 |       46888265
 Sentry     | 2024-02-04 00:00:00 |       46888265
 Sentry     | 2024-02-03 00:00:00 |       46888265
 Sentry     | 2024-02-02 00:00:00 |       46888265
 Sentry     | 2024-02-01 00:00:00 |       46888265
 Sentry     | 2024-01-31 00:00:00 |       46888265
 Sentry     | 2024-01-30 00:00:00 |       46888265
 Sentry     | 2024-01-29 00:00:00 |       46888265
 Sentry     | 2024-01-28 00:00:00 |       46888265
 Sentry     | 2024-01-27 00:00:00 |       46888265
 Sentry     | 2024-01-26 00:00:00 |       46888265
 Sentry     | 2024-01-25 00:00:00 |       46888265
 Sentry     | 2024-01-24 00:00:00 |       46888265
 Sentry     | 2024-01-23 00:00:00 |       46888265
 Sentry     | 2024-01-22 00:00:00 |       46888265
 Sentry     | 2024-01-21 00:00:00 |       46888265
 Sentry     | 2024-01-20 00:00:00 |       46888265
 Sentry     | 2024-01-19 00:00:00 |       46804424
 Sentry     | 2024-01-18 00:00:00 |       46712023
 Sentry     | 2024-01-17 00:00:00 |       46621565
 Sentry     | 2024-01-16 00:00:00 |       46545989
 Sentry     | 2024-01-15 00:00:00 |       46521582
 Sentry     | 2024-01-14 00:00:00 |       46512669
 Sentry     | 2024-01-13 00:00:00 |       46455237
 Sentry     | 2024-01-12 00:00:00 |       46371960
 Sentry     | 2024-01-11 00:00:00 |       46285280
 Sentry     | 2024-01-10 00:00:00 |       46193329
 Sentry     | 2024-01-09 00:00:00 |       46111350
 Sentry     | 2024-01-08 00:00:00 |       46085477
 Sentry     | 2024-01-07 00:00:00 |       46075212
 Sentry     | 2024-01-06 00:00:00 |       46020557
bruno-garcia commented 4 months ago

the job is running and the inserts are happening: image

bruno-garcia commented 4 months ago

https://github.com/NuGet/NuGetGallery/issues/9791#issuecomment-1937101754

bruno-garcia commented 4 months ago

Raised a detailed bug report:

NuGet Trends also asked for help on Twitter: https://twitter.com/NuGetTrends/status/1756432702742356373

sentry-io[bot] commented 4 months ago

Sentry feedback: SPA-KE

bruno-garcia commented 4 months ago

Working again!