Peter Palfrader schrieb am Thursday, dem 16. August 2018: > 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)
I have cleaned them up manually, added a constraint also on binpkgs (there was one for srcpkgs already), ensured we run no more than one indexer at any time. Will soon start on having the backlog processed. -- | .''`. ** Debian ** Peter Palfrader | : :' : The universal https://www.palfrader.org/ | `. `' Operating System | `- https://www.debian.org/