Key (room_id)=(!NFBkIKQHXkwtmAyxaE:permaweb.io) is still referenced from table "destination_rooms".

[Y0ngg4n]

Hey guys tried the script but get following Error Message:

postgres@7bef9c5eb50c:~/data$ psql -d synapse -f synapse_scripts/synapse_janitor.sql 
DROP FUNCTION
CREATE FUNCTION
DROP FUNCTION
CREATE FUNCTION
DROP FUNCTION
CREATE FUNCTION
DROP FUNCTION
CREATE FUNCTION
 synapse_clean_redacted_messages 
---------------------------------
 
(1 row)

psql:synapse_scripts/synapse_janitor.sql:87: NOTICE:  synapse_clean_unused_rooms() Cleaning up 3 unused rooms

psql:synapse_scripts/synapse_janitor.sql:87: ERROR:  update or delete on table "rooms" violates foreign key constraint "destination_rooms_room_id_fkey" on table "destination_rooms"
DETAIL:  Key (room_id)=(!NFBkIKQHXkwtmAyxaE:permaweb.io) is still referenced from table "destination_rooms".
CONTEXT:  SQL statement "DELETE FROM rooms AS x WHERE x.room_id IN (SELECT y.room_id FROM synapse_clean_unused_rooms__tmp AS y)"
PL/pgSQL function synapse_clean_unused_rooms() line 21 at SQL statement

I have left the Room Technology already long ago.

[ansuz]

As per the README, this project is unmaintained and its use is discouraged.