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