Hi Ivo,
On Sun, Mar 17, 2019 at 10:48:52AM +0100, Ivo De Decker wrote:
> Just out of curiosity:
>
> What query did you use to generate this list?
This list was generated manually. I started with the dose results from
my cross buildd and filtered for reasons with "skew". That gave me a
list of binary packages + affected source packages. Then I went to
buildd.debian.org and checked which archs needed syncing. Given the low
number, I didn't automate it beyond this.
If you want to sync up packages regularly, I'd expect that a udd query
can produce such a list.
The following query could serve as a starting point:
select pa.package, pa.architecture, pa.version, pb.version, pb.architecture
from packages as pa join packages as pb on pa.package = pb.package where
pa.release = 'sid' and pb.release = 'sid' and pa.version < pb.version and
pa.architecture in ('amd64', 'arm64', 'armel', 'armhf', 'mips', 'mipsel',
'mips64el', 's390x', 'ppc64el', 'i386') and pb.architecture in ('amd64',
'arm64', 'armel', 'armhf', 'mips', 'mipsel', 'mips64el', 's390x', 'ppc64el',
'i386') and (pa.version like '%+b%' or pb.version like '%+b%');
Helmut
