Re: Outdated leaf packages to be removed
On Mon, 2014-01-27 at 02:00 +0100, Michael Banck wrote:
> Hi,
>
> On Mon, Jan 27, 2014 at 01:43:08AM +0100, Michael Banck wrote:
> > > Maybe a way to avoid the (few) cases where linux/i386 is lagging behind
> > > (due to FTBFS) could be running it against amd64 as well, and not
> > > considering the sources not appearing in both.
>
> Those are the ones which get dropped in that case, if I got the query
> right:
>
> - chocolate-doom | 2.0.0-1 | 1.7.0-3
built fine:
https://buildd.debian.org/status/fetch.php?pkg=chocolate-doom&arch=hurd-i386&ver=2.0.0-1&stamp=1388788085
> - feh | 2.9.3-1 | 2.3-2
built fine:
https://buildd.debian.org/status/fetch.php?pkg=feh&arch=hurd-i386&ver=2.9.3-1&stamp=1390771164
> - fldigi | 3.21.77-2 | 3.21.77-1
built fine:
https://buildd.debian.org/status/fetch.php?pkg=fldigi&arch=hurd-i386&ver=3.21.77-2&stamp=1390771692
> - gcc-mingw-w64 | 4.8.2-12+12 | 4.8.2-11+12
build-rdeps gnat-4.8: gcc-mingw-w64 (via gnat-mingw-w64->
mingw-w64-x86-64-dev) gnat-4.8 is not yet built, see bug #732681
> - gromacs | 4.5.5-2 | 4.6.5-1
Probably easy to fix
> - haskell-yesod-form | 1.3.0.1-1+b10 | 1.3.0.1-1+b11
> - json-wheel | 1.0.6-2+b12 | 1.0.6-2+b10
built fine
> - juman | 7.0-1.1 | 7.0-3
FTBFS on 12 of 13 architectures.
> - lhasa | 0.2.0+git-1 | 0.0.7-2
built fine
> - libgwenhywfar | 4.10.0beta-1 | 4.9.0beta-1
built fine
> - libkexiv2 | 4:4.11.5-1 | 4:4.11.3-2
built fine
> - nettoe | 1.5-1 | 1.4.2-1
built fine
> - python-libdiscid | 0.4.1-1 | 0.4-1
built fine
> - rasqal | 0.9.31-3 | 0.9.31-2
built fine
> - ruby-rmagick | 2.13.2-2 | 2.13.1-6
built fine
> - uc-echo | 1.12-4 | 1.12-3
built fine
> - xserver-xorg-video-qxl | 0.1.1-1 | 0.1.0-2.1
built fine
> This is the new query, again really clumsy:
>
> SELECT DISTINCT b1.source,
> b1.binver AS hurdver,
> b2.binver AS version
> FROM any_associations_source b1,
> any_associations_source b2,
> any_associations_source b3,
> binaries b4
> WHERE b1.source = b2.source
> AND b2.source = b3.source
> AND b1.package = b2.package
> AND b2.package = b3.package
> AND b2.bin = b4.id
> AND b1.architecture = 4
> AND b2.architecture = 7
> AND b3.architecture = 16
> AND b1.suite = 5
> AND b2.suite = 5
> AND b3.suite = 5
> AND b1.binver <> b2.binver
> AND b2.binver = b3.binver
> AND b1.binver < b2.binver
> AND b1.binver !~ 'b.$'
> AND b2.binver !~ 'b.$'
> AND b3.binver !~ 'b.$'
> AND b4.install_date < CURRENT_DATE - interval '10 days'
> ORDER BY SOURCE;
>
>
> Michael
>
>
Reply to: