diff options
-rw-r--r-- | synapse/storage/events.py | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/synapse/storage/events.py b/synapse/storage/events.py index 85d7fd0910..65d5c1a370 100644 --- a/synapse/storage/events.py +++ b/synapse/storage/events.py @@ -1535,9 +1535,11 @@ class EventsStore(EventsWorkerStore): # We now need to update the backwards extremities for the chunks. txn.executemany(""" - INSERT INTO chunk_backwards_extremities (chunk_id, event_id) - SELECT ?, ? WHERE ? NOT IN (SELECT event_id FROM events) - """, [(chunk_id, eid, eid) for eid in prev_event_ids]) + INSERT INTO chunk_backwards_extremities (chunk_id, event_id) + SELECT ?, ? WHERE NOT EXISTS ( + SELECT event_id FROM events WHERE event_id = ? + ) + """, [(chunk_id, eid, eid) for eid in prev_event_ids]) self._simple_delete_txn( txn, |