synapse_scripts icon indicating copy to clipboard operation
synapse_scripts copied to clipboard

ERROR: relation "state_forward_extremities" does not exist

Open ghost opened this issue 6 years ago • 0 comments

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.

ghost avatar Jun 09 '19 23:06 ghost