Marc Lehmann schrieb am Wednesday, dem 08. August 2018:
> Package: snapshot.debian.org
> Severity: normal
>
> Dear Maintainer,
>
> thanks for the having this wonderful service, and providing a stable (over
> years) machine readable interface to it. I am using it for a while now to
> fetch packages and package metadata, but recently run into a problem with
> a security update that is available on snapshot.debian.org, but seemingly
> not indexed.
>
> Specifically, I see openssl 1.0.1t-1-deb8u9, apparently accepted
> 2018-07-28:
>
>
> http://snapshot.debian.org/archive/debian-security/20180806T184500Z/pool/updates/main/o/openssl/
Apparently we haven't done indexing in a while. It's possible that we
forgot to re-enable this after the move of master from sibelius to
sallinen.
snapshot=> select * from file where name='openssl_1.0.1t-1+deb8u9.dsc';
file_id | name | size | hash
| node_id
----------+-----------------------------+------+------------------------------------------+----------
52592898 | openssl_1.0.1t-1+deb8u9.dsc | 2423 |
5accd20beb57cdd4867aef2dce6bea04cd2067f1 | 54016625
(1 row)
snapshot=> select * from node where node_id=54016625;
node_id | parent | first | last
----------+--------+-------+-------
54016625 | 18993 | 57150 | 57463
(1 row)
snapshot=> select * from mirrorrun where mirrorrun_id = 57150;
mirrorrun_id | archive_id | run | mirrorrun_uuid
| importing_host
--------------+------------+---------------------+--------------------------------------+---------------------
57150 | 2 | 2018-07-28 03:05:28 |
13764e16-87a4-40de-afa5-4a25ddd9ddb0 | sallinen.debian.org
(1 row)
snapshot=> select * from indexed_mirrorrun order by mirrorrun_id desc limit 4;
mirrorrun_id | source
--------------+------------
56938 | recurse(Q)
56937 | index(Q)
56936 | index(Q)
56935 | index(Q)
(4 rows)
snapshot=> select * from mirrorrun order by mirrorrun_id desc limit 4;
mirrorrun_id | archive_id | run | mirrorrun_uuid
| importing_host
--------------+------------+---------------------+--------------------------------------+---------------------
57471 | 1 | 2018-08-16 09:15:38 |
af2f35e4-027f-4efe-b940-3706e1efc91a | sallinen.debian.org
57470 | 6 | 2018-08-16 09:07:20 |
a306ca7d-ca3a-4ac1-bcf7-419e957b47b1 | sallinen.debian.org
57469 | 7 | 2018-08-16 09:01:00 |
e34deae0-ea47-4c3c-a176-087256d87f39 | sallinen.debian.org
57468 | 6 | 2018-08-16 04:12:05 |
ec1c210c-f868-45dd-9078-9d8c3a765d6b | sallinen.debian.org
(4 rows)
--
| .''`. ** Debian **
Peter Palfrader | : :' : The universal
https://www.palfrader.org/ | `. `' Operating System
| `- https://www.debian.org/
