When attempting to vote on any posts, my self-hosted site is unable to store the vote. Checking on the logs I get an error message that states there is no unique or exclusion constraint matching the ON CONFLICT specification. This points towards a problem with the database, but I'm not sure if it can be solved by rebuilding some index, or by fixing the upstream handling of duplicate data.
I'm getting a constant barrage of errors similar to the one below:
WARN Error encountered while processing the incoming HTTP request: lemmy_server::root_span_builder: there is no unique or exclusion constraint matching the ON CONFLICT specification
0: lemmy_apub::activities::voting::vote_post
at crates/apub/src/activities/voting/mod.rs:126
1: lemmy_apub::activities::voting::vote::receive
at crates/apub/src/activities/voting/vote.rs:71
2: lemmy_apub::activities::community::announce::receive
at crates/apub/src/activities/community/announce.rs:141
3: lemmy_server::root_span_builder::HTTP request
with http.method=POST http.scheme="http" http.host=communities.azkware.net http.target=/inbox otel.kind="server" request_id=7e024b6a-3e4c-47b6-984d-0e2f04a52602 http.status_code=400 otel.status_code="OK"
at src/root_span_builder.rs:16