Project 'infra/sysadm-environment' was moved to 'swh/infra/sysadm-environment'. Please update any links and bookmarks that may still have the old path.
Listing ongoing and number of origins increasing regularly. From 200k yesterday [1]
(prior to the deployment of the lister) to ~800k [2] today. Progress.
[1] Snapshot taken yesterday through the scheduler metrics updates I did:
09:21:00 softwareheritage-scheduler@belvedere:5432=> select last_update, origins_known from scheduler_metrics sm inner join listers l on sm.lister_id=l.id where l.name='gitlab' and l.instance_name='gitlab';+------------------------------+---------------+| last_update | origins_known |+------------------------------+---------------+| 2021-07-27 15:55:27.30701+00 | 200200 |+------------------------------+---------------+(1 row)Time: 10.492 ms
[2] Current snapshot taken this morning
09:14:27 softwareheritage-scheduler@belvedere:5432=> select now(), visit_type, count(*) from listed_origins lo inner join listers l on l.id=lo.lister_id where l.name='gitlab' and l.instance_name='gitlab' group by visit_type order by count(*) desc;+-------------------------------+------------+--------+| now | visit_type | count |+-------------------------------+------------+--------+| 2021-07-28 07:14:02.974307+00 | git | 790160 |+-------------------------------+------------+--------+(1 row)Time: 727.838 ms09:14:46 softwareheritage-scheduler@belvedere:5432=> select now(), visit_type, count(*) from listed_origins lo inner join listers l on l.id=lo.lister_id where l.name='gitlab' and l.instance_name='gitlab' group by visit_type order by count(*) desc;+-------------------------------+------------+--------+| now | visit_type | count |+-------------------------------+------------+--------+| 2021-07-28 07:16:08.109911+00 | git | 791580 |+-------------------------------+------------+--------+(1 row)Time: 599.655 ms
18:01:36 softwareheritage-scheduler@belvedere:5432=> select now(), visit_type, count(*) from listed_origins lo inner join listers l on l.id=lo.lister_id where l.name='gitlab' and l.instance_name='gitlab' group by visit_type order by count(*) desc;+-------------------------------+------------+---------+| now | visit_type | count |+-------------------------------+------------+---------+| 2021-07-28 16:27:11.594417+00 | git | 1138860 |+-------------------------------+------------+---------+(1 row)Time: 5622.079 ms (00:05.622)
17:31:19 softwareheritage-scheduler@belvedere:5432=> select now(), visit_type, count(*) from listed_origins lo inner join listers l on l.id=lo.lister_id where l.name='gitlab' and l.instance_name='gitlab' group by visit_type order by count(*) desc;+-------------------------------+------------+---------+| now | visit_type | count |+-------------------------------+------------+---------+| 2021-07-29 15:46:55.979469+00 | git | 1747880 |+-------------------------------+------------+---------+(1 row)Time: 3298.658 ms (00:03.299)
I'll close this now as the deployment per say is done.