clean up stale status="ongoing" visits
softwareheritage=> select count(*) from origin_visit where status = 'ongoing' and date < date(now()) - 365 ;
count
-------
65189
(1 row)
As shown above, there is a number of stale visits in the scheduler DB: in the example we have 65k visits that are marked as still ongoing, even if they started more than 1 year ago.
We should clean them up.
A related question is how to avoid they remain around on an ongoing basis…
Migrated from T1469 (view on Phabricator)