Routing harvesting duplicates channelepochs (and related epochs) in the routing DB about eidaws HOT 3 OPEN

affected are the entities channelepoch, epoch (if referred to by a channel epoch), and routing (if referring to such an epoch, however, this is always the case...)

evidence:
Select network.code as net, station.code as sta, channelepoch.id,
channelepoch.locationcode as loc, channelepoch.code as chan,
epoch.starttime as start,
epoch.endtime as end,
epoch.lastseen as ep_lastseen,
routing.lastseen as rout_lastseen,
service.name
from network inner join channelepoch on network.id = channelepoch.network_ref
inner join station on station.id = channelepoch.station_ref
inner join epoch on channelepoch.epoch_ref = epoch.id
left join routing on routing.epoch_ref = epoch.id
left join endpoint on routing.endpoint_ref = endpoint.id
left join service on endpoint.service_ref = service.id
where station.code = 'HAMIK'
and channelepoch.code = 'HGZ'
order by epoch.starttime, epoch.lastseen, channelepoch.id;
-- 5000
-- note: only channelepochs have routing,
-- but all - channelepoch, epoch and routing are multiplied

Select station.code as sta,
epoch.starttime as start,
epoch.endtime as end,
epoch.lastseen as ep_lastseen,
routing.lastseen as rout_lastseen,
service.name
from station inner join stationepoch on station.id = stationepoch.station_ref
inner join epoch on stationepoch.epoch_ref = epoch.id
left join routing on routing.epoch_ref = epoch.id
left join endpoint on routing.endpoint_ref = endpoint.id
left join service on endpoint.service_ref = service.id
where station.code = 'HAMIK'
order by epoch.starttime, epoch.lastseen, stationepoch.id;
-- 1 epoch, no routing

Select network.code as sta,
epoch.starttime as start,
epoch.endtime as end,
epoch.lastseen as ep_lastseen,
routing.lastseen as rout_lastseen,
service.name
from network inner join networkepoch on network.id = networkepoch.network_ref
inner join epoch on networkepoch.epoch_ref = epoch.id
left join routing on routing.epoch_ref = epoch.id
left join endpoint on routing.endpoint_ref = endpoint.id
left join service on endpoint.service_ref = service.id
where network.code = 'CH'
order by epoch.starttime, epoch.lastseen, networkepoch.id
-- 1 epoch, no routing.

from eidaws.

(note that this issue would widely be mediated by the cleanup mechanism for routes which disappeared from EIDA (old lastseen dates), however that process is not automated.

from eidaws.

While channelepochs and routes are duplicated rather than the lastseen date updated,
for network epochs and station epochs the lastseen date is not updated (which is probably fine as long as it is not used).

from eidaws.