From 13d858c96fe125da0f8e289cf597986b925e6612 Mon Sep 17 00:00:00 2001
From: sandhose REINDEX
on the entire datab
however extreme care must be taken to avoid database corruption.
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.
-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.
-- cgit 1.5.1