On 12/01/19 at 08:32 +0100, Andreas Beckmann wrote: > Hi, > > I just looked at #917650, the qi FTBFS which goes back to jessie (at least). > > Source packages that build binary-arch packages, but no amd64 binary > packages are usually not tested by archive wide rebuilds and may > silently FTBFS for a long time. > This should not affect packages building only arch:all binary packages, > since they can be (are?) tested during amd64 rebuilds, too. > > Does anyone have an idea how to quickly build a list of these for sid? > Ideally something like > source-package version arch1 arch2 arch3 ... > (where [all amd64] are not in arch-list)
Hi, Using UDD, with: select distinct source from packages where release='sid' and architecture != 'all' except select source from packages where release='sid' and architecture = 'amd64' order by source; The complete list is: adlibtracker2 apex arcboot-installer arm-trusted-firmware atf-allwinner atitvout cmucl cuse4bsd dgen digitools elilo-installer fdflush fenix fenix-plugins flash-kernel fnfx freebsd-quota freebsd-smbfs freebsd-utils fuse4bsd fwupd-arm64-signed fwupd-armhf-signed fwupdate-arm64-signed fwupdate-armhf-signed fwupdate-i386-signed fwupd-i386-signed game-data-packager gatos gnumach google-android-build-tools-installer gpiozero grub-efi-arm64-signed grub-efi-ia32-signed hurd hurd-libfuse iprutils ixp4xx-microcode k8temp kfreebsd-10 kfreebsd-defaults kfreebsd-downloader-10 kfreebsd-kernel-headers libcxl libdfp libica libinotify-kqueue libocxl librtas libservicelog libsoc libsystemd-dummy libvecpf libvpd linux-signed-arm64 linux-signed-i386 longrun lphdisk lsvpd mac-fdisk mali-midgard-driver mariadb-connector-c micro-evtd mig mv2120-utils ne10 netdde openssl-ibmca paflib partman-prep partman-ufs partman-zfs pcsx2 pdbg pforth pixbros pixfrogger powerpc-utils ppc64-diag qcontrol qi raspi3-firmware rpi.gpio s390-dasd s390-netdevice s390-sysconfig-writer s390-tools s390-zfcp s3switch servicelog smlsharp spellcast steam steamcmd sysconfig ufsutils xf86-video-omap x-loader xserver-xorg-video-geode xserver-xorg-video-nv yforth zfsutils zipl-installer zsnes (103 rows) Note that's about source packages that currently have binary packages in the archive. If they have always failed to build on some architecture, they wouldn't be listed. The list with architectures is: select source, array_agg(distinct architecture) from packages where release = 'sid' and architecture != 'all' and source not in ( select source from packages where release='sid' and architecture = 'amd64' ) group by source; source | array_agg --------------------------------------+---------------------------------------------- adlibtracker2 | {i386} apex | {armel} arcboot-installer | {mips} arm-trusted-firmware | {arm64} atf-allwinner | {arm64} atitvout | {i386} cmucl | {i386} cuse4bsd | {kfreebsd-amd64,kfreebsd-i386} dgen | {i386} digitools | {i386} elilo-installer | {i386} fdflush | {hurd-i386,i386,mips} fenix | {armel,armhf,i386,kfreebsd-i386,mips,mipsel} fenix-plugins | {armel,armhf,i386,kfreebsd-i386,mips,mipsel} flash-kernel | {arm64,armel,armhf} fnfx | {i386} freebsd-quota | {kfreebsd-amd64,kfreebsd-i386} freebsd-smbfs | {kfreebsd-amd64,kfreebsd-i386} freebsd-utils | {kfreebsd-amd64,kfreebsd-i386} fuse4bsd | {kfreebsd-amd64,kfreebsd-i386} fwupd-arm64-signed | {arm64} fwupd-armhf-signed | {armhf} fwupdate-arm64-signed | {arm64} fwupdate-armhf-signed | {armhf} fwupdate-i386-signed | {i386} fwupd-i386-signed | {i386} game-data-packager | {i386} gatos | {i386} gnumach | {hurd-i386,i386,kfreebsd-i386} google-android-build-tools-installer | {i386} gpiozero | {arm64,armel,armhf} grub-efi-arm64-signed | {arm64} grub-efi-ia32-signed | {i386} hurd | {hurd-i386} hurd-libfuse | {hurd-i386} iprutils | {ppc64el} ixp4xx-microcode | {armel} k8temp | {kfreebsd-amd64,kfreebsd-i386} kfreebsd-10 | {kfreebsd-amd64,kfreebsd-i386} kfreebsd-defaults | {hurd-i386,kfreebsd-amd64,kfreebsd-i386} kfreebsd-downloader-10 | {kfreebsd-amd64,kfreebsd-i386} kfreebsd-kernel-headers | {kfreebsd-amd64,kfreebsd-i386} libcxl | {ppc64el} libdfp | {ppc64el,s390x} libica | {s390x} libinotify-kqueue | {kfreebsd-amd64,kfreebsd-i386} libocxl | {ppc64el} librtas | {ppc64el} libservicelog | {ppc64el} libsoc | {arm64,armhf} libsystemd-dummy | {hurd-i386,kfreebsd-amd64,kfreebsd-i386} libvecpf | {ppc64el} libvpd | {ppc64el} linux-signed-arm64 | {arm64} linux-signed-i386 | {i386} longrun | {i386} lphdisk | {i386} lsvpd | {ppc64el} mac-fdisk | {i386} mali-midgard-driver | {armhf} mariadb-connector-c | {hurd-i386,kfreebsd-amd64,kfreebsd-i386} micro-evtd | {armel} mig | {hurd-i386,i386,kfreebsd-i386} mv2120-utils | {armel} ne10 | {arm64,armhf} netdde | {hurd-i386} openssl-ibmca | {s390x} paflib | {ppc64el} partman-prep | {ppc64el} partman-ufs | {kfreebsd-amd64,kfreebsd-i386} partman-zfs | {kfreebsd-amd64,kfreebsd-i386} pcsx2 | {i386} pdbg | {ppc64el} pforth | {armel,armhf,hurd-i386,i386,kfreebsd-i386} pixbros | {armel,armhf,i386,kfreebsd-i386,mips,mipsel} pixfrogger | {armel,armhf,i386,kfreebsd-i386,mips,mipsel} powerpc-utils | {ppc64el} ppc64-diag | {ppc64el} qcontrol | {armel,armhf} qi | {armel} raspi3-firmware | {arm64,armhf} rpi.gpio | {arm64,armel,armhf} s390-dasd | {s390x} s390-netdevice | {s390x} s390-sysconfig-writer | {s390x} s390-tools | {s390x} s390-zfcp | {s390x} s3switch | {i386} servicelog | {ppc64el} smlsharp | {i386} spellcast | {i386} steam | {i386} steamcmd | {i386} sysconfig | {s390x} ufsutils | {kfreebsd-amd64,kfreebsd-i386} xf86-video-omap | {armel,armhf} x-loader | {armel,armhf} xserver-xorg-video-geode | {hurd-i386,i386,kfreebsd-i386} xserver-xorg-video-nv | {hurd-i386,kfreebsd-amd64,kfreebsd-i386} yforth | {armel,i386,kfreebsd-amd64,kfreebsd-i386} zfsutils | {kfreebsd-amd64,kfreebsd-i386} zipl-installer | {s390x} zsnes | {hurd-i386,i386,kfreebsd-i386} (103 rows) - Lucas