v-thomp4

This should give you a list of the services that are stuck in service purgatory:
select id, state from service_expose_map where removed is null and instance_id in (select id from instance where state='purged');

update service_expose_map set removed=now(), state='removed' where id in ( SERVICE, ID's, HERE);