How to delete double GLOBALDESCRIPTION=1 record in DB after upgrade to 8.5.0

[IT4IT Service Team]

After confluence upgrade to version 8.5.0 we hit the problem described here

https://confluence.atlassian.com/confkb/after-upgrading-confluence-shows-error-occurred-during-template-rendering-contact-your-administrator-for-assistance-error-1283491784.html

When I want to delete the offending record  I get an error about foreign constraints.

ERROR: update or delete on table "content" violates foreign key constraint "fkwjyn6091q3l1gl7bh143ma2a" on table "content" DETAIL: Key (contentid)=(1) is still referenced from table "content". SQL state: 23503

How to delete the record/fix the problem 

[Enrico Siefert]

I have the same issue.

I "worked around" this on my *test system* by temporary disabling all triggers.

alter table content disable trigger ALL;

delete from content where contentid = 1;

alter table content enable trigger ALL

(!) This is usually a very bad Idea, I just did it on our test system to check if the server is able to start afterwards.