Ignore duplicate redaction entries
MODIFY
roomserver/storage/postgres/redactions_table.go
roomserver/storage/postgres/redactions_table.go
@@ -39,7 +39,8 @@ CREATE INDEX IF NOT EXISTS roomserver_redactions_redacts_event_id ON roomserver_
const insertRedactionSQL = "" +
"INSERT INTO roomserver_redactions (redaction_event_id, redacts_event_id, validated)" +
- " VALUES ($1, $2, $3)"
+ " VALUES ($1, $2, $3)" +
+ " ON CONFLICT DO NOTHING"
const selectRedactionInfoByRedactionEventIDSQL = "" +
"SELECT redaction_event_id, redacts_event_id, validated FROM roomserver_redactions" +

MODIFY
roomserver/storage/sqlite3/redactions_table.go
roomserver/storage/sqlite3/redactions_table.go
@@ -37,7 +37,7 @@ CREATE TABLE IF NOT EXISTS roomserver_redactions (
`
const insertRedactionSQL = "" +
- "INSERT INTO roomserver_redactions (redaction_event_id, redacts_event_id, validated)" +
+ "INSERT OR IGNORE INTO roomserver_redactions (redaction_event_id, redacts_event_id, validated)" +
" VALUES ($1, $2, $3)"
const selectRedactionInfoByRedactionEventIDSQL = "" +

Ignore duplicate redaction entries (#1522)