search

xwiki-labs / synapse_scripts

Tools for maintaining a matrix synapse chat server // SEEKING MAINTAINERS
63 stars 12 forks source link

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

Open Y0ngg4n opened 3 years ago

Y0ngg4n commented 3 years ago

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 commented 3 years ago

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