Bad gateway if a handle is gone

[ghost]

Requesting for a RIPE handle which is gone from the RIPE database gives a 502 bad gateway
Example: https://cp-aec-stg.cert.at/api/1.0/ripe/settings/5086/ORG-MAA1-RIPE

[MarkHofstetter]

#82 is closely related. The problem is that the handle still reverences the organisation. My suggestion would be a script that removes(?) the handles from the fodyorg_x_organization intersection - which always has to be executed after an import.
Should there be a notifcation to the "customer" that the handle is gone etc etc

[MarkHofstetter]

or just run:
update fodyorg_x_organization set deleted = 1 where ripe_org_hdl not in (select ripe_org_hdl
from fody.organisation_automatic);

after import

[ghost]

Workaround implemented

[ghost]

Setting the flag deleted to 1 is not sufficient, deleting works.

[certrik]

@wagner-certat please comment and close if solved.

[ghost]

@certrik Only a workaround is available.