Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Duplicates in the bookwyrm_status table #3472

Open
prolibre opened this issue Nov 18, 2024 · 0 comments · May be fixed by #3471
Open

Duplicates in the bookwyrm_status table #3472

prolibre opened this issue Nov 18, 2024 · 0 comments · May be fixed by #3471
Labels
bug Something isn't working

Comments

@prolibre
Copy link

prolibre commented Nov 18, 2024

Bookwrym 1.7.4

I'm sorry, I'm back with “duplicates”, but this time in status :-(
This morning I noticed two similar responses to one of my status. Looking in the table concerned (bookwyrm_status) I see that they are indeed duplicates (with the same remote_id).

Capture d’écran 2024-11-19 170916

Searching with

SELECT * FROM “public”. “bookwyrm_status” WHERE remote_id IN ( SELECT remote_id FROM “public”. “bookwyrm_status” GROUP BY remote_id HAVING COUNT(*) > 1 );

I find about ten status with a double.

In each case, these duplicates come from other bookwyrm instances (with different versions: 0.7.4, 0.7.3 and 0.7.1).

@prolibre prolibre added the bug Something isn't working label Nov 18, 2024
@hughrun hughrun linked a pull request Nov 25, 2024 that will close this issue
14 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant