Hello,
Due to https://jira.atlassian.com/browse/CONFSERVER-15964 we cannot purge a page as we get an error:
delete on table "content" violates foreign key constraint "fk594acc88c38fbea" on table "notifications"
Detail: Key (contentid)=(182682701) is still referenced from table "notifications".
As we would like to not stop the database for something as small as this, would it be possible to delete that notification through a script? We do have scriptrunner for confluence.
DELETE FROM NOTIFICATIONS WHERE CONTENTID IN (SELECT CONTENTID FROM CONTENT WHERE (CONTENT_STATUS = 'deleted' AND SPACEID = <SPACEID>) OR PREVVER IN (SELECT CONTENTID FROM CONTENT WHERE CONTENT_STATUS = 'deleted' AND SPACEID = <SPACEID>));
It would replace the above query.
Thank you!
