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/