Incomplete bridging breaks Dimension: QueryRoomsForUser failed

[madprogramer]

Background information

• Dendrite version or git SHA: v0.9.4 (Docker Image)
• Monolith or Polylith?: Monolith
• SQLite3 or Postgres?: Postgres
• Running in Docker?: yes
• Using matrix-docker-ansible-deploy

Description

• What is the problem: Chats are not updating, bridge invites cannot be joined.
• Who is affected: Clients on my server
• How is this bug manifesting: Clientside messages fail to send. Logs show frequent "QueryRoomsForUser failed" errors (see below for sample)
• When did this first appear: While bridging with https://github.com/mautrix/facebook , I noticed that room invites were taking a bit long (slowdown). I shut down my server, updated, played with config a few times but now can no longer connect to any chats. Incomplete bridge joins fail repeatedly.

Sample Logs:

Aug 22 11:01:01 SERVER.NET matrix-dendrite[7580]: time="2022-08-22T09:01:01.280932827Z" level=info msg="Creating new room" req.id=hH3IMYEP7Xjo req.method=POST req.path=/_matrix/client/v3/createRoom roomID="!wMEbJbPcVcfmIZbX:madpro.world" roomVersion=9 userID="@facebookbot:madpro.world" user_id="@facebookbot:madpro.world"
Aug 22 11:01:24 SERVER.NET matrix-dendrite[7580]: time="2022-08-22T09:01:24.360892437Z" level=error msg="QueryRoomsForUser failed" error="GetRoomsByMembership: cannot map user ID to state key NID: context canceled" req.id=fb62suvMLyFW req.method=GET req.path=/_matrix/client/r0/joined_rooms user_id="@dimension:madpro.world"
Aug 22 11:02:01 SERVER.NET matrix-dendrite[7580]: time="2022-08-22T09:02:01.282699128Z" level=error msg="roomserverAPI.SendInputRoomEvents failed" error="InputRoomEventsResponse: context canceled" req.id=hH3IMYEP7Xjo req.method=POST req.path=/_matrix/client/v3/createRoom user_id="@facebookbot:madpro.world"

[madprogramer]

Possibly Related: #1844

[madprogramer]

Deleting jetstream/$G/streams/DendriteInputRoomEvent and restarting did the trick. I guess that finally stopped the failed bridging for good.

Compare #2150