synapse_scripts
synapse_scripts copied to clipboard
ERROR: relation "state_forward_extremities" does not exist
Hi,
When I run the script on matrix-synapse v0.99.5.2 I get the following error: ERROR: relation "state_forward_extremities" does not exist. See the full log bellow:
~/synapse_scripts$ psql matrix < synapse_janitor.sql
NOTICE: function synapse_clean_redacted_messages() does not exist, skipping
DROP FUNCTION
CREATE FUNCTION
NOTICE: function synapse_get_server_name() does not exist, skipping
DROP FUNCTION
CREATE FUNCTION
NOTICE: function synapse_get_unused_rooms() does not exist, skipping
DROP FUNCTION
CREATE FUNCTION
NOTICE: function synapse_clean_unused_rooms() does not exist, skipping
DROP FUNCTION
CREATE FUNCTION
synapse_clean_redacted_messages
---------------------------------
(1 row)
NOTICE: synapse_clean_unused_rooms() Cleaning up 62 unused rooms
ERROR: relation "state_forward_extremities" does not exist
LINE 1: DELETE FROM state_forward_extremities AS x WHERE x.room_id I...
^
QUERY: DELETE FROM state_forward_extremities AS x WHERE x.room_id IN (SELECT y.room_id FROM synapse_clean_unused_rooms__tmp AS y)
CONTEXT: PL/pgSQL function synapse_clean_unused_rooms() line 16 at SQL statement
Thanks in advance for your help.