diff options
| author | Erik Johnston <erik@matrix.org> | 2020-09-28 18:00:30 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-09-28 18:00:30 +0100 |
| commit | bd380d942fdf91cf1214d6859f2bc97d12a92ab4 (patch) | |
| tree | 515186a89d274f7d4272f4cdcb0e9698dac7e2ef /docs/postgres.md | |
| parent | Create a mechanism for marking tests "logcontext clean" (#8399) (diff) | |
| download | synapse-bd380d942fdf91cf1214d6859f2bc97d12a92ab4.tar.xz | |
Add checks for postgres sequence consistency (#8402)
Diffstat (limited to 'docs/postgres.md')
| -rw-r--r-- | docs/postgres.md | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/docs/postgres.md b/docs/postgres.md index e71a1975d8..c30cc1fd8c 100644 --- a/docs/postgres.md +++ b/docs/postgres.md @@ -106,6 +106,17 @@ Note that the above may fail with an error about duplicate rows if corruption has already occurred, and such duplicate rows will need to be manually removed. +## Fixing inconsistent sequences error + +Synapse uses Postgres sequences to generate IDs for various tables. A sequence +and associated table can get out of sync if, for example, Synapse has been +downgraded and then upgraded again. + +To fix the issue shut down Synapse (including any and all workers) and run the +SQL command included in the error message. Once done Synapse should start +successfully. + + ## Tuning Postgres The default settings should be fine for most deployments. For larger |