"emails sent" counter stuck at zero

buttondown / roadmap

Buttondown's public roadmap

51 stars 0 forks source link

"emails sent" counter stuck at zero #2457

Open james-baker opened 7 months ago

james-baker commented 7 months ago

email id 6a441564-656e-47ec-bc77-2770bbf01851 in the two polling requests that happen every two seconds: "status": "sent" on the email object itself, but every number that /analytics returns is stuck at zero

meanwhile, the email hit inboxes several minutes ago

This doesn't seem like #2060 as I'm not seeing any security-policy junk in my console. (Although, I am seeing hundreds of integers spit out from console.js:36, which seem to count down then up then down between 0 and 3000?!)

james-baker commented 7 months ago

Reproduced on my 2nd/smaller newsletter, with email id b81aff91-ae00-4352-afd5-c82861248c12

james-baker commented 5 months ago

Has not reproduced in the last month or two

james-baker commented 3 months ago

Happened again today as/after I sent email 0f710bb6-e604-47f6-bd5b-3c4e1f1b722c Exact same behavior, spinner turns to checkmark but the analytics all stay at zero. Did a hard refresh upon logging in an hour ago so hopefully no cache weirdness.

jmduke commented 1 month ago

So, caching is much more aggressive here but it's still caching. (You can imagine at a high level: we have a big JSON blob of events, it gets updated slightly less slowly than we like, and then extremely slowly in periods of high backlog.) This is less of an object-level issue and more of a systemic one: we need to migrate to something like Clickhouse because the size of the events table is just too large to be able to do these sorts of real-time aggregations.