certat / do-portal

This project is in maintenance mode and will only receive bug fixes, but no new features. A new version of this software is being developed.
5 stars 5 forks source link

Bad gateway if a handle is gone #84

Open ghost opened 5 years ago

ghost commented 5 years ago

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

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

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

Workaround implemented

ghost commented 5 years ago

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

certrik commented 4 years ago

@wagner-certat please comment and close if solved.

ghost commented 4 years ago

@certrik Only a workaround is available.