Nothing4You

so just dropping duplicates then?

are there no references to the duplicates from posts? if there are and the duplicate rows are just deleted it’ll cascade deletion and purge all those posts from the db as well

how are you planning to fix this?

this feels like more db index corruption that already existed for users previously, unlikely to be an issue in lemmy itself

It seems that p.d didn’t or wasn’t able to fetch the community moderator list yet, which would prevent it from accepting any new posts to the community, as it’s set to allow posting by mods only and the bot isn’t detected as mod yet.

I think the only way (without manual intervention) might be to access the community after 24h to have Lemmy refresh this from the origin server.