[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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: