Navigation: Suites / Filters / Types / Fields / Sort / Format / Search / Results

Bugs search

Useful queries for testing (buster)

Suites[1]

Filters

off / include / exclude
  • tagged confirmed
  • tagged patch
  • tagged pending
  • tagged security
  • tagged wontfix
  • tagged moreinfo
  • tagged upstream
  • tagged unreproducible
  • tagged help
  • tagged d-i
  • forwarded upstream
  • claimed bugs
  • fixed in deferred/delayed
  • packages not in main
  • packages not in jessie
  • packages not in stretch
  • packages not in buster
  • packages in base system
  • packages in standard installation
  • orphaned packages
  • merged bugs
  • marked as done
  • outdated binaries in jessie
  • outdated binaries in stretch
  • outdated binaries in buster
  • outdated binaries in sid
  • different versions in buster and sid
  • newer in Ubuntu than in sid
  • RT tag for jessie: ignore
  • RT tag for jessie: will-remove
  • RT tag for jessie: can-defer
  • RT tag for jessie: is-blocker
  • RT tag for jessie: no-auto-remove
  • RT tag for jessie: pu
  • RT tag for stretch: ignore
  • RT tag for stretch: will-remove
  • RT tag for stretch: can-defer
  • RT tag for stretch: is-blocker
  • RT tag for stretch: no-auto-remove
  • RT tag for stretch: pu
  • RT tag for buster: ignore
  • RT tag for buster: will-remove
  • RT tag for buster: can-defer
  • RT tag for buster: is-blocker
  • RT tag for buster: no-auto-remove
  • RT tag for buster: pu
  • RT unblock hint
  • key packages
  • pseudo packages
  • packages marked for autoremoval
  • closed in packages in new
  • newer than days
  • modified in the last days

Bugs or packages selection


  ignore:
  ignore:
  ignore:
 
 

Additional fields

Sort

Format

161 bugs found

bug# tags package title popcon severity modified
#924393   acme-tiny acme-tiny: Please update to ACMEv2 API 309 5 serious 2019-03-12
#924635 [bus|sid]   libactivemq-java libactivemq-java depends on the removed libspring-jms-java 62 5 serious 2019-03-15
#924835 [bus|exp|sid]   src:adacontrol adacontrol: FTBFS: test tfw_gpr.txt failed 27 5 serious 2019-03-18
#924822 [bus|sid]   src:adms adms: FTBFS: admstpathYacc.y:14604: error: unterminated argument list invoking macro "adms_message_error" 11 5 serious 2019-03-17
#923866   aptly aptly: unable to delete local repositories 232 6 grave 2019-03-22
#924818 [bus|sid]   src:astroidmail astroidmail: FTBFS: dh_installman: failed to read astroid.1.gz 25 5 serious 2019-03-17
#907277   autoconf autoconf: AC_SEARCH_LIBS for __atomic_foo fails with AC_LANG([C++]) and g++-8 53986 5 serious 2019-03-11
#924813 [bus|sid]   src:bagel bagel: FTBFS: mpicxx.h:22:4: error: #error 'Please use the same version of GCC and g++ for compiling MPICH and user MPI programs' 24 5 serious 2019-03-24
#899007 [bus|sid]   bauble bauble: Depends on unmaintained python-gdata 63 5 serious 2019-03-18
#925227 [bus|sid]   src:biabam biabam: debian-rules-missing-required-target binary-arch 108 5 serious 2019-03-21
#852035 [bus|exp|sid|str|u]   binutils binutils: bfd stumbles over duplicated symbols generated by gold 139356 5 serious 2019-03-06
#897086   binutils binutils: ld version script causes runtime crashes on mips/mipsel 139356 6 grave 2019-01-08
#918277 []   src:cairocffi cairocffi build depends on python3-xcffib that is currently not in buster 607 5 serious 2019-01-04
#868872 [bus||sid]   src:cairocffi cairocffi FTBFS: test failure 607 5 serious 2018-09-27
#925202   calypso Keep calypso out of testing/buster 31 6 grave 2019-03-21
#924976   python3-celery python3-celery: Incompatible with python3-redis/python3-kombu versions 2748 6 grave 2019-03-19
#923715   ceph-osd ceph-osd: missing systemd service in package: ceph-volume@.service 14510 6 grave 2019-03-22
#916145 [bus|sid]   closure-compiler closure-compiler: Not working with recent JS code 149 5 serious 2019-03-21
#917535 [bus|sid|str]   debian-archive-keyring debian-archive-keyring: ftp-master key for buster 200258 5 serious 2019-01-12
#917536 [bus|sid|str]   debian-archive-keyring debian-archive-keyring: release key for buster 200258 5 serious 2019-01-12
#749991 [d-i|str-i]   debian-installer debian-installer: Wrong kernel in debian-installer package 244 6 grave 2019-02-25
#921284   dh-golang build-using should only include copylefted files 241 5 serious 2019-02-06
#864423   dmraid Software RAID is not activated at boot time 1173 7 critical 2019-03-15
#925374   dns-root-data dns-root-data: ships an obsolete root zone signing key 96610 5 serious 2019-03-24
#924858 [bus|sid|R]   src:doxygen doxygen: FTBFS: make[4]: *** [doc/CMakeFiles/doxygen_pdf.dir/build.make:62: doc/CMakeFiles/doxygen_pdf] Error 1 7941 5 serious 2019-03-21
#923319 [bus||sid]   src:dynalogin dynalogin: FTBFS (Makefile:366: pam_dynalogin_la-pam_dynalogin.lo) 11 5 serious 2019-03-06
#924762 [u]   emacs emacs: commandline with extended characters kills the X server 14121 6 grave 2019-03-24
#923749 [bus||sid]   src:fannj fannj: FTBFS in buster/sid 13 5 serious 2019-03-06
#788721   src:firefox-esr [src:iceweasel] Some sources are not included in your package 92514 5 serious 2019-01-20
#909750 [u]   libfontconfig1 applications tries to write to /usr/* directories via libfontconfig1 180903 5 serious 2019-03-21
#866960 [u]   libfreetype6 libfreetype6: ABI/API change yielding a blank line between characters due to different rounding for TrueType fonts 199491 5 serious 2018-05-14
#923282 [bus|sid]   freezegun freezegun breaks cached-property autopkgtest 54 5 serious 2019-03-17
#924857 [bus|sid]   src:frobby frobby: FTBFS: make[3]: *** [Makefile:6: refman.pdf] Error 1 129 5 serious 2019-03-17
#923698   gcc-mingw-w64-x86-64 gcc-mingw-w64 miscompiles PARI 1469 5 serious 2019-03-07
#923750 []   src:gdcm gdcm: FTBFS in buster/sid 5057 5 serious 2019-03-17
#897975   gdm3 gdm3: restarts in a loop: IceLockAuthFile fail: Already exists (race condition?) 52777 6 grave 2018-08-07
#915333   ghc git-annex: Illegal Instruction on armel (Fujitsu Q700 like QNAP TS-21x/TS-22x) 4805 5 serious 2019-03-11
#919296 [C]   git-daemon-run git-daemon-run: fails with 'warning: git-daemon: unable to open supervise/ok: file does not exist' 91921 5 serious 2019-03-17
#924800 [bus|sid]   src:git-annex git-annex: FTBFS: dh_auto_test: make -j1 test returned exit code 2 1063 5 serious 2019-03-18
#924712   libc6-dev crypt() not available _XOPEN_SOURCE is defined 200310 5 serious 2019-03-21
#903514   src:glibc Deadlock in _dl_close join-ing threads accessing TLS 200310 6 grave 2018-09-07
#924891 [bus|sid]   src:glibc glibc: FTBFS: /<<PKGBUILDDIR>>/build-tree/amd64-libc/conform/UNIX98/ndbm.h/scratch/ndbm.h-test.c:1:10: fatal error: ndbm.h: No such file or directory 200310 5 serious 2019-03-25
#914999 [M]   libc6 [libc6] Locking problems into libc6 200310 7 critical 2019-01-10
#913978 []   gnome-control-center is not accessible with Orca screenreader 60256 6 grave 2019-01-19
#854743 []   src:golang-github-mailru-easyjson golang-github-mailru-easyjson: FTBFS (32-bit): constant 4294967295 overflows int 2 5 serious 2019-03-06
#925138   src:gosa gosa: crypto-transition not possible if upgrading from stretch 166 5 serious 2019-03-24
#918578   gosa gosa: GOsa web interface missing password field 166 5 serious 2019-03-19
#917711 [bus|sid]   src:grantlee5 grantlee5: FTBFS: dh_auto_test: cd obj-x86_64-linux-gnu && make -j2 test ARGS\+=-j2 returned exit code 2 20510 5 serious 2019-03-10
#870267 []   src:graphicsmagick graphicsmagick frequently FTBFS on ppc64el: test hang 14828 5 serious 2019-03-21
#915603   libgraphicsmagick++-q16-12 libgraphicsmagick++-q16-12: Requires soname/shlibs bump for libstdc++11 transition 14828 5 serious 2018-12-09
#925134   grub-efi-amd64 grub-efi-amd64-signed: doesn't mount cryptodisk 197025 7 critical 2019-03-25
#924151 [H]   grub2-common grub2-common: wrong grub.cfg for efi boot and fully encrypted disk 197025 6 grave 2019-03-23
#923930 []   src:heimdal FTBFS: FAIL test_chain (exit status: 1) 18795 5 serious 2019-03-10
#924840 [bus|sid]   src:highwayhash highwayhash: FTBFS: dh_makeshlibs: failing due to earlier errors 11 5 serious 2019-03-17
#924847 [bus|sid]   src:i2p i2p: FTBFS: [javac] /<<PKGBUILDDIR>>/apps/jetty/java/src/net/i2p/jetty/I2PRequestLog.java:378: error: method write in interface Writer cannot be applied to given types; 259 5 serious 2019-03-17
#923731 [bus|sid]   src:igv, src:picard-tools igv depends on packages which were removed in picard-tools 0 5 serious 2019-03-04
#919058 []   itstool its-tools: crashes when freeing xmlDocs 964 5 serious 2019-03-09
#923330   jajuk jajuk: Fails to start with Java Runtime Environment 1.7 minimum required. You use a JVM ext.JVM@23fc625e 47 6 grave 2019-03-24
#912467 []   src:jasperreports jasperreports: FTBFS with Java 11 due to javax.xml.soap removal 98 5 serious 2019-02-27
#924232   python-notebook, python3-notebook python{,3}-notebook: unhandled symlink to directory conversion: /usr/lib/python{2.7,3}/dist-packages/notebook/static/components/bootstrap 2378 5 serious 2019-03-12
#905697   src:kdepimlibs kdepimlibs: don't depend on libical 28890 5 serious 2019-02-14
#915319 [C|]   src:kde-runtime kde-runtime FTBFS with samba 4.9 33793 5 serious 2019-02-24
#925411   kernel-package kernel-package: Not suitable for release 3188 5 serious 2019-03-24
#924188   knxd-dev knxd-dev: missing dependency on library package - and a separate library package in the first place 32 5 serious 2019-03-17
#895271 [u]   konqueror konqueror: crahses while running programms which try to start it 21829 7 critical 2019-03-09
#925353   lava-server lava-server: logrotate complains about "parent directory has insecure permissions" 18 5 serious 2019-03-23
#877773 [bus|sid]   libleveldb1v5 libleveldb1v5: breaks ABI without SONAME bump 3616 6 grave 2019-02-17
#924841 [bus|sid]   src:lib3mf lib3mf: FTBFS: dh_makeshlibs: failing due to earlier errors 370 5 serious 2019-03-17
#924823 [bus|sid]   src:libcaca libcaca: FTBFS: mv: cannot stat 'latex/refman.pdf': No such file or directory 120617 5 serious 2019-03-17
#892812 [M|R]   libdrm-radeon1 [libdrm-radeon1] Periodic UI freezes 139369 5 serious 2019-03-17
#919571 []   src:libical libical: FTBFS on 32 bit architectures: timezones test fails 64095 5 serious 2019-01-17
#884128 [M]   src:libical libical: don't release with buster 64095 5 serious 2019-03-21
#914034   libio-socket-ssl-perl libio-socket-ssl-perl: TLSv1.3 connection deadlock 154031 5 serious 2018-12-13
#917203 [bus||sid]   src:libmcrypt FTBFS on at least two architectures: test failure in the enigma algorithm 28786 5 serious 2019-03-10
#921559   libmtp9 MTP broken for number of phones with "LIBMTP PANIC: Unable to initialize device" 102903 5 serious 2019-03-20
#906144   libmypaint-common libmypaint-common: drop Conflicts: mypaint-data 12632 5 serious 2019-03-13
#921952 [H]   src:libsass Don't include in buster without proper commitment to update in stable 619 5 serious 2019-03-11
#925478   lighttpd restart action breaks with systemd (Again) 2648 6 grave 2019-03-25
#866122 [u]   src:linux FP register corruption on ppc64el with lock elision 123101 5 serious 2019-02-10
#900821 [C]   src:linux apache reads wrong data over cifs filesystems served by samba 123101 5 serious 2019-01-16
#922184   linux-image-cloud-amd64 Stretch-backports linux-image-cloud-amd64 broken 163402 7 critical 2019-02-13
#904059   clang-6.0 clang-6.0: default target on armhf is armv8l-unknown-linux-gnueabihf 7557 5 serious 2018-09-23
#902255   src:llvm-toolchain-6.0 llvm-toolchain-6.0: unicode non free license 7557 5 serious 2018-12-20
#857653   liblld-6.0 liblld-4.0: missing liblld-4.0.so.1 7557 5 serious 2019-03-10
#916945   src:llvm-toolchain-7 llvm-toolchain-7: unicode non free license 15401 5 serious 2019-01-12
#908137   src:luajit luajit: lightuserdata problem with > 47 bit address space on arm64 12080 5 serious 2018-09-10
#924808 [bus|sid]   src:lua-nvim lua-nvim: FTBFS: E: Build killed with signal TERM after 150 minutes of inactivity 65 5 serious 2019-03-17
#924802 [bus|sid]   src:madness madness: FTBFS: CheckFunctionExists.c:17: undefined reference to `pow' 12 5 serious 2019-03-17
#924831 [bus|sid]   src:meep-mpich2 meep-mpich2: FTBFS: configure: error: could not find mpi library for --with-mpi 11 5 serious 2019-03-17
#917501 [|H]   src:meson meson: FTBFS (failing tests) 1522 5 serious 2019-01-13
#924548   gnome-core gnome-core: does not actually install a desktop environment on s390x 53398 5 serious 2019-03-23
#924816 [bus|sid]   src:mingw-ocaml mingw-ocaml: FTBFS: hasgot.c:(.text+0x13): undefined reference to `tgetent' 26 5 serious 2019-03-17
#924764 [bus||sid]   src:mingw-ocaml mingw-ocaml: FTBFS (cp: cannot stat 'objinfo_helper': No such file or directory) 26 5 serious 2019-03-17
#924311   miredo miredo: Fails to stop with sysvinit: start-stop-daemon: matching only on non-root pidfile /var/run/miredo.pid is insecure 266 5 serious 2019-03-11
#895320 []   mk-configure mk-configure FTBFS: Error: /undefined in setupLatin1 48 5 serious 2019-03-10
#923726   monero monero: Monero requires update to work after March 9th 31 6 grave 2019-03-04
#921232   mono-mcs mono: Internal compiler error building libsbml on s390x 26279 5 serious 2019-03-07
#924803 [bus|sid]   src:mpqc3 mpqc3: FTBFS: CheckSymbolExists.c:(.text+0x1b): undefined reference to `pthread_create' 20 5 serious 2019-03-17
#924843 [bus|sid]   src:msxpertsuite msxpertsuite: FTBFS: MassSpectrum.cpp:50:10: fatal error: pwiz/data/msdata/MSDataFile.hpp: No such file or directory 244 5 serious 2019-03-18
#924804 [bus|sid]   src:mtj mtj: FTBFS: [javac] /<<BUILDDIR>>/mtj-0.9.14+dfsg/src/no/uib/cipr/matrix/AbstractSymmBandMatrix.java:25: error: package org.netlib.blas does not exist 75 5 serious 2019-03-17
#923347   src:mysql-connector-python No sensible security support due to Oracle's policies 5355 5 serious 2019-03-10
#924119 []   src:notary notary: FTBFS (x509: certificate has expired or is not yet valid) 1 5 serious 2019-03-09
#899623   src:omniorb-dfsg omniorb-dfsg: Invalid maintainer address pkg-corba-devel@lists.alioth.debian.org 565 5 serious 2019-03-10
#924812 [bus|sid]   src:onionbalance onionbalance: FTBFS: build-dependency not installable: python-tox 17 5 serious 2019-03-17
#917759 [bus|exp|sid]   src:openhft-chronicle-wire openhft-chronicle-wire: FTBFS: Could not resolve dependencies for project net.openhft:chronicle-wire:bundle:1.1.13 4 5 serious 2019-02-11
#920037 [bus|sid]   src:openjdk-8 Don't include in buster 80047 5 serious 2019-02-06
#915723 [bus|sid]   src:openjdk-8 openjdk-8 needs a build dependency preventing build attempts on zero architectures 80047 5 serious 2019-03-19
#924562   openvswitch-switch openvswitch-switch breaks networking.service due to dependency loop 515 7 critical 2019-03-14
#919486   osinfo-db Please support Debian Buster 45384 5 serious 2019-01-16
#925354   pacemaker-dev pacemaker-dev: missing Breaks+Replaces: libcrmcluster1-dev 605 5 serious 2019-03-25
#925263   src:pjproject Do not release with Buster 3159 5 serious 2019-03-21
#922502   plasma-desktop plasma-desktop: regional settings allow do select system incompatible locales 20514 7 critical 2019-02-18
#925082   postfix postfix: "Chunk exceeds message size limit" when message_size_limit = 0 32553 6 grave 2019-03-25
#924937 [H]   libpq5 libpq5: OpenSSL license contamination of GPL reverse-dependencies 110369 5 serious 2019-03-20
#910964 [U]   libprotobuf17 libprotobuf17 needs Breaks: libprotobuf10 45897 5 serious 2018-10-27
#912035 []   src:pymongo pymongo: FTBFS due to hardcoded SHA1-based certificates in testsuite 3053 5 serious 2019-03-09
#924836 [bus|sid]   src:python-bottle python-bottle: FTBFS: build-dependency not installable: python-tox 2299 5 serious 2019-03-17
#924851 [bus|sid]   src:python-fakeredis python-fakeredis: FTBFS: dh_auto_test: pybuild --test --test-nose -i python{version} -p 2.7 returned exit code 13 10 5 serious 2019-03-17
#925457 []   src:python-jwcrypto python-jwcrypto: FTBFS ('module' object has no attribute 'decode_rfc6979_signature') 102 5 serious 2019-03-25
#924798 [bus|sid]   src:python-scales python-scales: FTBFS: build-dependency not installable: python-tox 7 5 serious 2019-03-17
#925208 []   src:python-smoke-zephyr python-smoke-zephyr: FTBFS randomly (tests hang the autobuilder) 27 5 serious 2019-03-21
#897489 [bus||sid]   src:python-whoosh python-whoosh: FTBFS due to non-deterministic behaviour in NFA.minimize 170 5 serious 2019-03-09
#876905 [bus|sid]   src:qtwebkit qtwebkit should not be released with buster 42505 5 serious 2019-03-23
#924583   razor spamassassin: razor2 had unknown error during get_server_info at /usr/share/perl5/Mail/SpamAssassin/Plugin/Razor2.pm line 186 2252 6 grave 2019-03-21
#882473 []   src:ruby-httpclient ruby-httpclient FTBFS and Debci failure: test_verification_without_httpclient fails 2436 5 serious 2019-03-09
#923986 []   src:ruby-pygments.rb ruby-pygments.rb: FTBFS randomly (failing tests) 1041 5 serious 2019-03-07
#924174   ruby-rails-assets-perfect-scrollbar ruby-rails-assets-perfect-scrollbar: broken symlink: /usr/share/ruby-rails-assets-perfect-scrollbar/app/assets/javascripts/perfect-scrollbar.js -> ../../../../javascript/utatti-perfect-scrollbar/dist/perfect-scrollbar.js 7 5 serious 2019-03-10
#921901 []   src:ruby-voight-kampff ruby-voight-kampff: FTBFS (expected: < 0.002, got: 0.002076509001199156) 1 5 serious 2019-03-13
#903448 [bus|sid]   ruby-websocket ruby-websocket-parser,ruby-websocket: error when trying to install together 3 5 serious 2019-03-09
#884033 []   scilab scilab segfaults building scilab-{ann,celestlab,plotlib} 2054 5 serious 2018-10-25
#925020 [bus|sid]   src:scilab scilab terminates immediately when started from the desktop 2054 5 serious 2019-03-19
#924838 [bus|sid]   src:scoop scoop: FTBFS: Could not import extension sphinx.ext.pngmath (exception: No module named pngmath) 50 5 serious 2019-03-17
#924123 []   src:shishi shishi: FTBFS with gcc 8.3 326 5 serious 2019-03-09
#923376   src:slapos.core Should only be in unstable 0 5 serious 2019-02-27
#924681 [bus|sid]   slang-histogram slang-histogram should be removed 1 5 serious 2019-03-17
#925444   smokeping smokeping: --pid-dir doesn't worj as expected 789 6 grave 2019-03-25
#923906 []   src:snapd-glib snapd-glib: FTBFS (dh_makeshlibs fails) 203 5 serious 2019-03-06
#923711   squashfs-tools mksquashfs: Leaks memory in deflate code; memory limits ineffective 9038 6 grave 2019-03-25
#818366   synaptic synaptic: fails to start under Wayland 87899 5 serious 2019-03-17
#924660   tails-installer tails-installer: Should not be part of Buster 552 5 serious 2019-03-15
#901952 [H]   tar xdelta: expected from file (/tmp/pristine-tar.SljdkfANnj/recreatetarball) of length 7557120 bytes 200380 5 serious 2019-01-28
#924848 [bus|sid]   src:telegram-cli telegram-cli: FTBFS: build-dependency not installable: libwolfssl-dev 58 5 serious 2019-03-17
#717636 [jes-i|str-i]   texlive-lang-other [latex-sanskrit] Package contain type1 startlock fragment from black book 7343 5 serious 2019-01-15
#924844 [bus|sid]   src:thin-provisioning-tools thin-provisioning-tools: FTBFS: ft-lib/bcache.c:35:13: error: conflicting types for 'raise' 8167 5 serious 2019-03-17
#925483   tilda tilda: does not start (segfault) 662 6 grave 2019-03-25
#901148 [u]   timidity timidity: upgrading to 2.14.0-2 broke sound via pulseaudio 6252 7 critical 2019-03-19
#925473 [C]   tomcat9 tomcat9: sysvinit script missing (Policy §9.11¶2 “must”) 454 5 serious 2019-03-25
#918973   libtss2-udev udev rules and created user conflict with the one shipped in trousers package 7057 5 serious 2019-02-06
#924634 [bus|sid]   libuima-as-java libuima-as-java depends on the removed libspring-jms-java 4 5 serious 2019-03-15
#905877 [C]   unattended-upgrades regression in 1.4: upgrades random packages from testing to experimental (doesn't respect pinning?) 84474 5 serious 2019-02-01
#878843   util-linux util-linux: fsck on btrfs /home hangs, stalling boot 200384 7 critical 2019-03-18
#924906 [u]   valgrind valgrind: m_transtab.c:2459 (vgPlain_init_tt_tc): Assertion 'sizeof(TTEntryC) <= 88' failed. 10471 5 serious 2019-03-18
#794466 [bus|sid|str]   src:virtualbox virtualbox: might not be suitable for stable releases due to lack of cooperation from upstream on security support for older releases 8852 5 serious 2019-03-14
#924856 [bus|sid]   src:wxpython4.0 wxpython4.0: FTBFS: sip: /<<BUILDDIR>>/wxpython4.0-4.0.4+dfsg/src/wacky_ints.sip:20: Invalid type for %MappedType 343 5 serious 2019-03-25
#924329 []   src:xastir xastir: FTBFS (magick/image-private.h: No such file or directory) 132 5 serious 2019-03-12
#925453   xenomai-kernel-source xenomai-kernel-source: ships patches for old kernel 169 6 grave 2019-03-25
#925451   xenomai-kernel-source xenomai-kernel-source: depends on kernel-package, which will not be in buster 169 5 serious 2019-03-25
#923918   gnee gnee unusable/insufficiently detailed to use it 177 6 grave 2019-03-07
#866898   xorg xorg: switching to a VT (with Ctrl-Alt-Fx) hangs entire system 158765 5 serious 2019-03-10
#920862   xorg xorg: Input doesn't work on LTSP clients while X is running, works otherwise 158765 7 critical 2019-01-30
#905268   xorg-server at-spi2-core: key repeat causes a blocked system 110067 7 critical 2018-08-02

Generated in 1.984 seconds.

select id, bugs.package, bugs.source, severity, title, last_modified, affects_stable, affects_testing, affects_unstable, affects_experimental , coalesce(popcon_src.insts, 0) as popcon
from bugs  left join popcon_src on (bugs.source = popcon_src.source) 
where id in (select id from bugs_rt_affects_testing) 
and not (id in (select id from bugs_tags where tag='patch')) 
and not (id in (select id from bugs_tags where tag='pending')) 
and not (id in (select id from bugs_tags where tag='security')) 
and not (id in (select id from bugs_usertags where email='bugsquash@qa.debian.org')) 
and not (id in (select id from deferred_closes)) 
and not (id not in (select id from bugs_packages, sources where bugs_packages.source = sources.source and component='main')) 
and not (id in (select id from bugs_merged_with where id > merged_with)) 
and not (status = 'done') 
AND (severity >= 'serious')
order by source asc