pq: duplicate key value violates unique constraint "federationsender_joined_hosts_event_id_idx"

[neilalexander]

This resulted in a crash loop on d.m.org after what looks to be a kafka replay from a previous crash. We should recover from this sanely rather than panic.

Feb 06 20:39:39 dendrite[12400]: time="2021-02-06T20:39:39.509156748Z" level=panic msg="roomserver output log: write room event failure" func="onMessage\n\t" file=" [/home/dendrite/dendrite/federationsender/consumers/roomserver.go:113]"

[sseneca]

Is federatonsender_joined_hosts_event_id_idx and federatonsender_joined_hosts_room_id_idx a typo? Because that's what's created here and here (same is true for sqlite3). Thought I'd ask since you changed this issue's title.

I'm getting this issue too, my Dendrite server can't start up any more.

[carroarmato0]

I just got the same issue I think. Dendrite keeps crashing.

2021-03-27 13:18:30 | time="2021-03-27T12:18:30.557186925Z" level=info msg="Dendrite version 0.3.11" func="NewBaseDendrite\n\t" file=" [github.com/matrix-org/dendrite/setup/base.go:110]"
-- | --
2021-03-27 13:18:30 | time="2021-03-27T12:18:30.580469025Z" level=info msg="Enabled perspective key fetcher" func="NewInternalAPI\n\t" file=" [github.com/matrix-org/dendrite/signingkeyserver/signingkeyserver.go:103]" num_public_keys=2 server_name=matrix.org
2021-03-27 13:18:30 | time="2021-03-27T12:18:30.738832999Z" level=panic msg="roomserver output log: write room event failure" func="onMessage\n\t" file=" [github.com/matrix-org/dendrite/federationsender/consumers/roomserver.go:113]" add="[$D9qdG_A4j8Sabk-ceXioc4PzjZIBWaycDy-h2IHJ-4Q]" del="[$OsLr5BDhAEEjn907uD9aRzaWUmh6yREjI_wpR7ZPo7Q]" error="pq: duplicate key value violates unique constraint \"federatonsender_joined_hosts_event_id_idx\"" event="{\"auth_events\":[\"$OsLr5BDhAEEjn907uD9aRzaWUmh6yREjI_wpR7ZPo7Q\",\"$1ZgLuJEdH_EqUF2LMLGm33v3zJs4Yo4yP28wM6OREw8\",\"$VCSywbpDMzmScq-_uXkLCh1i68Gn4xy1jH0oq9tDZXM\",\"$cL3H1pLIlwCIulZJM1UXDdGMGOgiASKuL66NNeu5mgc\"],\"content\":{\"avatar_url\":\"mxc://matrix.org/AmTHuRJCxeuFgddwCnvrHfII\",\"displayname\":\"Follpvosten\",\"membership\":\"join\"},\"depth\":12473,\"hashes\":{\"sha256\":\"BmveQ4pTUO4KyiD8v0S1Rqc54ZOma/86YItLCB61aco\"},\"origin\":\"matrix.org\",\"origin_server_ts\":1616838462617,\"prev_events\":[\"$m03wzUnhzaD36UBJPOzh_p1J_UJUoeRFGKgPKpWgJb8\"],\"prev_state\":[],\"room_id\":\"!gJYEKNllaubNlNkFIj:jupiterbroadcasting.com\",\"sender\":\"@Follpvosten:matrix.org\",\"signatures\":{\"matrix.org\":{\"ed25519:a_RXGa\":\"r1tHnOR/fmJHAKy8gi0SSA460oZuUktun83O42GMk8Y+1PC5B6pqjAdzu0NXPfESpJhOw2tjePRtM3s6N4QTDg\"}},\"state_key\":\"@Follpvosten:matrix.org\",\"type\":\"m.room.member\",\"unsigned\":{\"age_ts\":1616838462617,\"replaces_state\":\"$OsLr5BDhAEEjn907uD9aRzaWUmh6yREjI_wpR7ZPo7Q\"}}" event_id="$D9qdG_A4j8Sabk-ceXioc4PzjZIBWaycDy-h2IHJ-4Q"

[kegsay]

Fixed in https://github.com/matrix-org/dendrite/pull/1824