Skip to content
This repository has been archived by the owner on Mar 1, 2024. It is now read-only.

New item announcements can potentially be skipped if a feed contains multiple items in a row with identical pub_dates #3

Open
connorkuehl opened this issue Jul 28, 2023 · 0 comments
Labels
bug Something isn't working

Comments

@connorkuehl
Copy link
Owner

For example, if goose is processing the following notifications:

   title   |        pub_date
-----------+------------------------
Article A  | 2023-07-26 20:50:41+00
Article B  | 2023-07-26 20:50:45+00 <-- identical
Article C  | 2023-07-26 20:50:45+00 <-- identical

And a situation like this occurs:

fetch pending notifications -> announce Article A -> announce Article B -> goose process killed/crashed -x

When goose comes back up, the SQL query for fetching the pending notifications will not include Article C because its WHERE clause has something like articles.pub_date > last_pub_date.

@connorkuehl connorkuehl added the bug Something isn't working label Jul 28, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant