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