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:
>
> > 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..
srcpkg_id also matter. So slightly less bad:
snapshot=> select * from (select count(*) as c, name, version, srcpkg_id from binpkg group by name, version, srcpkg_id) as s where s.c > 1 order by s.c, s.name, s.version;
c | name | version | srcpkg_id
---+-----------------+-----------------+-----------
2 | nomacs | 3.10.2+dfsg-1 | 534441
2 | puredata-core | 0.48.1-7 | 534442
2 | puredata-extra | 0.48.1-7 | 534442
2 | puredata-utils | 0.48.1-7 | 534442
2 | r-cran-rggobi | 2.1.22-1 | 534444
2 | r-cran-rgl | 0.99.16-3 | 534445
2 | r-cran-survival | 2.42-6-1 | 534447
2 | squeak-vm | 1:4.10.2.2614-5 | 534446
(8 rows)
--
| .''`. ** Debian **
Peter Palfrader | : :' : The universal
https://www.palfrader.org/ | `. `' Operating System
| `- https://www.debian.org/
Reply to: