Bug#905687: snapshot.debian.org: openssl 1.0.1t-1+deb8u9 not indexed?
Peter Palfrader schrieb am Thursday, dem 16. August 2018:
> Peter Palfrader schrieb am Thursday, dem 16. August 2018:
>
> > 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.
>
> Update.
>
> We are running the indexing jobs. But they are failing.
>
> /srv/snapshot.debian.org/bin/snapshot:228:in `query_row': More than one result when querying for SELECT binpkg_id AS id FROM binpkg WHERE name=? AND version=? AND srcpkg_id=?. (RuntimeError)
> from /srv/snapshot.debian.org/bin/snapshot:806:in `add_pkg'
> from /srv/snapshot.debian.org/bin/snapshot:825:in `add_binpkg'
> from /srv/snapshot.debian.org/bin/snapshot:1058:in `index_binary_package'
> from /srv/snapshot.debian.org/bin/snapshot:1199:in `block in index_mirrorrun_from_parsing'
> from /srv/snapshot.debian.org/bin/snapshot:214:in `query'
> from /srv/snapshot.debian.org/bin/snapshot:1196:in `index_mirrorrun_from_parsing'
> from /srv/snapshot.debian.org/bin/snapshot:1222:in `index_mirrorrun'
> from /srv/snapshot.debian.org/bin/snapshot:1245:in `block in index'
> from /srv/snapshot.debian.org/bin/snapshot:214:in `query'
> from /srv/snapshot.debian.org/bin/snapshot:1241:in `index'
> from /srv/snapshot.debian.org/bin/snapshot:1371:in `index'
> from /srv/snapshot.debian.org/bin/snapshot:1480:in `<main>'
Hm.
snapshot=> select * from (select count(*) as c, name, version from binpkg group by name, version) as s where s.c > 1 order by s.c, s.name, s.version limit 3;
c | name | version
---+--------------------------------------+-----------------
2 | affs-modules-4.10.0-rc6-powerpc64-di | 4.10~rc6-1~exp2
2 | affs-modules-4.7.0-1-powerpc64-di | 4.7.2-1
2 | affs-modules-4.7.0-1-powerpc64-di | 4.7.4-2
(3 rows)
snapshot=> select count(*) from (select count(*) as c, name, version from binpkg group by name, version) as s where s.c > 1 ;
count
-------
3235
(1 row)
Probably the result of a race while inserting. But I thought we had a unique
constraint there..
--
| .''`. ** Debian **
Peter Palfrader | : :' : The universal
https://www.palfrader.org/ | `. `' Operating System
| `- https://www.debian.org/
Reply to: