diff options
| author | Patrick Cloke <clokep@users.noreply.github.com> | 2023-02-01 15:45:10 -0500 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-02-01 15:45:10 -0500 |
| commit | 230a831c734246aa4db7bd842947c7ea277ca126 (patch) | |
| tree | 8172b242a3c708906a44a86d6b0804cb03afef08 /changelog.d | |
| parent | Bump docker/build-push-action from 3 to 4 (#14952) (diff) | |
| download | synapse-230a831c734246aa4db7bd842947c7ea277ca126.tar.xz | |
Attempt to delete more duplicate rows in receipts_linearized table. (#14915)
The previous assumption was that the stream_id column was unique (for a room ID, receipt type, user ID tuple), but this turned out to be incorrect. Now find the max stream ID, then map this back to a database-specific row identifier and delete other rows which match the (room ID, receipt type, user ID) tuple, but *not* the row ID.
Diffstat (limited to 'changelog.d')
| -rw-r--r-- | changelog.d/14915.bugfix | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/changelog.d/14915.bugfix b/changelog.d/14915.bugfix new file mode 100644 index 0000000000..4969e5450c --- /dev/null +++ b/changelog.d/14915.bugfix @@ -0,0 +1 @@ +Fix a bug introduced in Synapse 1.70.0 where the background updates to add non-thread unique indexes on receipts could fail when upgrading from 1.67.0 or earlier. |