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

Bugs search

Useful queries

Suites[1]

Filters

off / include / exclude
  • 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 wheezy
  • packages not in jessie
  • packages not in stretch
  • packages in base system
  • packages in standard installation
  • orphaned packages
  • merged bugs
  • marked as done
  • outdated binaries in wheezy
  • outdated binaries in jessie
  • outdated binaries in stretch
  • outdated binaries in sid
  • different versions in stretch and sid
  • newer in Ubuntu than in sid
  • RT tag for wheezy: ignore
  • RT tag for wheezy: will-remove
  • RT tag for wheezy: can-defer
  • RT tag for wheezy: is-blocker
  • 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 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 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

208 bugs found

bug# package title hints RT modified
#451535 partman-crypto debian-installer: allow to 'reuse' encrypted volumes block-udeb     2016-09-27
#665199 slapd slapd: fails to install, remove, distupgrade, and install again     2017-02-05
#665334 fontforge non-DFSG postscript embedded in fontforge (currently August 2014     2017-01-29
#694320 gsfonts [gsfonts] Fonts include copyrighted adobe fragment all right reserved     2017-01-29
#694323 lmodern [gsfonts] Fonts include copyrighted adobe fragment all right reserved     2017-01-29
#694324 tex-gyre Fonts include copyrighted adobe fragment all right reserved   wheezy-can-defer   2014-08-30
#709198 debconf debconf: should not use python in maintainer scripts     2017-01-29
#717636 texlive-lang-indic [latex-sanskrit] Package contain type1 startlock fragment from black book     2016-07-28
#733239 dh-python dh-python: there is no script in the new version of the package - giving up-Jessie     2017-02-25
#734101 libjs-jquery-mobile libjs-jquery-mobile: New Release     2017-01-29
#741464 grub-pc-bin grub-pc-bin: freezes after "terminal_input at_keyboard" block-udeb     2017-02-20
#744753 anacron anacron: Anacron not triggered when system resumes under systemd     2017-02-09
#749272 varnish varnish doesn't source /etc/default/varnish when started but uses it when reloaded     2017-02-23
#750895 python3-tempita python3-tempita: doesn't work     2017-02-11
#760414 src:ola ola: Source package includes non-source files without corresponding source     2017-02-25
#766397 emacs24 emacs/gnus: Uses s_client to for SSL.     2017-02-22
#771187 primesense-nite-nonfree primesense-nite-nonfree: Package broken because openni.org is gone     2017-02-11
#781155 openbsd-inetd openbsd-inetd: openbsd-inetd.service should be the main service file     2017-01-03
#782456 plymouth plymouth: With plymouth installed, starting the DM sometimes fails     2017-02-08
#787527 chromium-browser Some sources are not included in your package block unblock     2017-02-06
#788585 dsh dsh: overwrites host list with a symlink     2015-11-22
#788769 yelp-tools yelp-check validate fails without networking: relax-ng: failed to load external entity [..] mallard-1.0.rng     2016-05-29
#790796 sensord sensord: RRD data loss     2017-02-01
#792321 src:libkscreen Segfaults on session start     2016-07-10
#794856 src:opencv opencv: non DFSG file in the source package unblock     2017-02-22
#795055 src:libtirpc libtirpc: non-free files     2017-01-29
#797161 src:libprelude libprelude2 contains files with different SONAME versioning req:#856021     2017-02-23
#801564 squid squid: prompting due to modified conffiles which were not modified by the user: /etc/squid/squid.conf     2017-02-07
#804908 bluez-obexd service is not started under systemd     2017-02-11
#806879 src:xsp xsp: FTBFS when built with dpkg-buildpackage -A (dh_clideps fails)     2017-02-07
#808463 ntfs-3g ntfs-3g: non-free code in boot.c block-udeb     2017-01-27
#809167 cron cron: Cron Daemon Use-After-Free Vulnerability May Cause Local Root Privilege Escalation     2017-01-29
#809669 unattended-upgrades unattended-upgrades: files got created under /var/ mountpoint     2017-02-21
#811234 ekg FTBFS with parallel build: ../compat/strlcat.o: No such file or directory age/2 unblock     2017-02-23
#811980 libusbtc08 libusbtc08: FTBFS with GCC 6: symbol changes     2017-02-11
#812002 smokeqt smokeqt: FTBFS with GCC 6: deleted function     2017-02-06
#812574 grub-pc grub-pc: wants to overwrite admin configuration on each upgrade block-udeb     2017-02-19
#813949 bluetooth bluetooth: error causing service to be unusable: Not enough free handles to register service     2016-08-10
#816063 emacs24 emacs24: TLS certificate validation is silently broken     2017-02-23
#816699 src:ga libga-dev and libarmci-mpi-dev: error when trying to install together     2017-02-19
#817236 debootstrap schroot: no access to pseudo-terminals in new chroots block-udeb     2017-02-15
#818787 doxygen doxygen: Changes default HAVE_DOT to YES without having graphviz in the Depends line.     2016-09-13
#820381 rar rar crashes.   stretch-will-remove   2017-02-20
#822472 haskell-devscripts various haskell -dev packages are missing Built-Using attributes     2016-07-04
#824442 src:glibc <linux/if.h> and <net/if.h> conflict needs to be resolved block-udeb     2017-02-14
#825608 libnet-jifty-perl libnet-jifty-perl: FTBFS: t/006-uploads.t failure     2017-01-28
#826216 w3c-sgml-lib w3c-sgml-lib: inconsistencies in copyright file unblock     2017-02-19
#827199 src:hfst hfst: FTBFS: twolc test fails on big-endian systems     2017-02-06
#827395 firefox-esr firefox-esr: Firefox-esr privacy invading defaults load beacons on 1st run     2017-01-23
#828159 firefox-esr firefox-esr: session tabs lost after upgrade from iceweasel to firefox-esr     2016-07-30
#828601 src:wpa wpa: FTBFS with openssl 1.1.0 block-udeb req:#855143 [C|M]     2017-02-24
#832649 kscreen multi-display is broken (menu and panel appears only on external display)     2016-10-20
#834204 src:libsdl1.2 libsdl1.2: Nonfree file: src/video/fbcon/riva_mmio.h     2016-08-13
#834921 src:python-ws4py python-ws4py FTBFS: WSManagerTest fails unblock     2017-02-25
#836168 doxygen doxygen: Injects unescaped '%' signs into LaTeX source     2016-08-31
#836241 plasma-workspace plasma-workspace: Digital clock widget wants qml-module-org-kde-kholidays     2017-02-11
#837581 xfslibs-dev xfslibs-dev: Don't put the .so symlink to /lib/*.so block-udeb     2017-01-14
#838116 libgpod-nogtk-dev libgpod-nogtk-dev: fails to install in sid/i386 with --install-recommends     2017-01-29
#838303 kde-plasma-desktop kde-plasma-desktop: KDE does not start after log in     2016-10-20
#839840 src:ghc ghci segfaults on armel, related to doctest failure     2016-10-07
#843467 libxbase64-1 libxbase64-1: unhandled symlink to directory conversion: /usr/share/doc/PACKAGE age/5 unblock     2017-02-23
#843895 src:hw-detect disk-detect/multipath: run update-dev before probing for devices block-udeb     2017-02-10
#843926 libjemalloc1 jemalloc uses a hard coded page size detected during build     2017-01-27
#844227 binutils FTBFS on mips*, ./.libs/libmutter-cogl.so: undefined reference to `eglQueryString' unblock     2017-02-18
#844285 pidgin pidgin: steals (warps) mouse cursor (not just focus) when new message comes in [SEC=UNCLASSIFIED]     2017-02-25
#844584 isc-dhcp-client dhclient should perform additional validity checks block-udeb     2017-01-23
#844897 src:libprelude libprelude: FTBFS: PreludeEasy.cxx:2452:75: error: 'SWIG_From_long_SS_long' was not declared in this scope req:#856021     2017-02-23
#844943 src:python-bleach python-bleach: FTBFS: ImportError: No module named sanitizer     2017-02-25
#845414 src:cdebconf cdebconf: makes debian-installer FTBFS due to libdebconf.so issues (binutils) block-udeb     2016-11-23
#847571 smarty-lexer smarty3: lexing failed because a rule matched an empty string     2017-02-18
#848368 src:llvm-toolchain-3.9 llvm-toolchain-3.9: Please add ELF symbols versions to the libraries     2017-01-23
#848813 src:blacs-mpi blacs-mpi: FTBFS: make[3]: *** No rule to make target '/usr/lib/openmpi/include/mpif.h', needed by 'mpif.h'. Stop.     2017-01-31
#848863 dleyna-server dleyna-server: Segfault when plugging in a secondary screen     2017-01-07
#849098 llvm-toolchain-3.8 llvm-toolchain-3.9: Please add ELF symbols versions to the libraries     2016-12-22
#849099 llvm-toolchain-3.7 llvm-toolchain-3.9: Please add ELF symbols versions to the libraries remove:#836602 [M]     2016-12-22
#849132 src:google-perftools google-perftools FTBFS on i386: FAIL: profiler_unittest.sh     2017-02-13
#849504 nbd-server Data corruption with copy-on-write and multiple threads block-udeb     2017-02-25
#849720 synaptic [synaptic] Synaptic ignores its settings     2017-01-17
#849831 firefox-esr firefox: contains JSHint work under non-free licence     2017-01-28
#849832 icedove firefox: contains JSHint work under non-free licence     2017-01-27
#849875 wpasupplicant broadcom-sta-dkms: Wifi association took too long, failing activation block-udeb req:#855143 [C|M]     2017-01-30
#849932 gtk-sharp2-gapi gtk-sharp2-gapi: gapi2-codegen generates fields with void type     2017-02-02
#850114 kscd kscd: Only play first trackon all modes(loop track, loop ,and no loop and random and no random mode)     2017-01-04
#850149 shotwell shotwell: Freezes when trying to open an image in fullscreen mode req:#854912 [M]     2017-02-18
#850464 nfs-kernel-server nfs-blkmap.service fails to start at boot     2017-02-02
#850692 pyrit pyrit: failed with 'BitEnumField' object has no attribute 'names' unblock     2017-02-14
#851013 src:python-pyramid python-pyramid: FTBFS: dh_auto_test: pybuild --test -i python{version} -p 2.7 returned exit code 13     2017-02-08
#851060 libnids1.21 libnids1.21: can't assemble TCP streams on armhf     2017-02-23
#851196 src:libplist libplist: CVE-2017-5209     2017-02-12
#851373 ghc git-annex FTBFS on armel/armhf: ghc: panic! (the 'impossible' happened)     2017-01-14
#851555 tasksel Blends install options removed from tasksel menu     2017-01-16
#851671 icinga-web icinga-web: Mysql error: Specified key was too long; max key length is 767 bytes     2017-02-20
#851750 kpatch kpatch: module FTBFS for Linux 4.9     2017-02-24
#852288 nbd-server Data corruption when multiple threads are allowed and copyonwrite is enabled block-udeb     2017-02-23
#852320 openssh-server openssh-server: install script sliently override config block-udeb     2017-01-24
#852363 python-pisa python-pisa: xhtml2pdf throws exception (html5lib.inputstream)     2017-02-08
#852385 src:libplist libplist: CVE-2017-5545     2017-02-02
#852622 src:xcffib xcffib FTBFS in stretch remark     2017-01-25
#852645 src:dafny dafny: FTBFS     2017-02-22
#852732 torbrowser-launcher torbrowser-launcher: upon upggrade 6.0.8 to 6.5: "SIGNATURE VERIFICATION FAILED: You might be under attack ..."     2017-02-19
#852781 openssh-server openssh-server: Wrong default for setting PermitRootLogin (yes instead of prohibit-password) in clean install block-udeb     2017-01-29
#852903 src:android-platform-tools-swt android-platform-tools-swt: FTBFS: ProfileProvider.java:92: error: cannot find symbol     2017-01-31
#852923 src:dojo dojo: FTBFS: OPTIMIZER FAILED: JavaException: java.lang.RuntimeException: null     2017-01-28
#852929 src:scalable-cyrfonts scalable-cyrfonts: FTBFS: LaTeX requires e-TeX.     2017-01-28
#852943 src:willow willow: Embedded ICC profiles violate DFSG rm:#856113     2017-02-25
#853006 src:qemu qemu: CVE-2016-9602: 9p: virtfs allows guest to access host filesystem     2017-01-31
#853034 unar unar: Fuzzer-generated crashing testcases for a dozen identified file formats     2017-02-23
#853171 plasma-desktop [plasma-desktop] segmentation fault when disabling a screen with kscreen without upower installed on the system     2017-01-30
#853207 bluez bluez: bluetooth.service doesn't start with systemd     2017-02-11
#853232 libphp-phpmailer libphp-phpmailer: CVE-2017-5223     2017-02-14
#853723 tracker-extract tracker-extract gets killed by seccomp when gstreamer tries to regenerate cache (dup2 related)     2017-02-23
#853902 icinga-web icinga-web: Can't locate CGI/Util.pm in @INC during installation     2017-02-17
#854000 src:libplist CVE-2017-5834 CVE-2017-5835 CVE-2017-5836     2017-02-14
#854008 kstars-data-extra-tycho2 kstars-data-extra-tycho2: deepstars.dat installed in wrong directory age/2 unblock     2017-02-24
#854050 icoutils icoutils: CVE-2017-6009     2017-02-16
#854054 icoutils icoutils: CVE-2017-6010 CVE-2017-6011     2017-02-16
#854058 elserv elserv: non-functional with emacs24 & emacs25     2017-02-03
#854078 network-manager network-manager: nm-online returns before network devices got an address unblock     2017-02-16
#854186 network-manager network-manager: DHCP connection stopped working (however, it works perfectly by using the console) unblock     2017-02-20
#854228 libblacs-openmpi1 Libraries not linked with their deps     2017-02-08
#854243 src:bind9 bind9 - Reads /dev/random in named and does not longer answer block-udeb     2017-02-05
#854260 src:sddm sddm: Please remove Conflicts= and OnFailure= from sddm.service file req:#855624 [C]     2017-02-25
#854277 design-desktop-animation design-desktop-animation: please drop dependency on pencil2d     2017-02-25
#854278 mp3splt CVE-2017-5666     2017-02-14
#854288 src:apt-dpkg-ref apt-dpkg-ref FTBFS: build dependency clisp is not in stretch age/5 unblock     2017-02-24
#854325 ifupdown2 ifupdown2: missing Conflicts: ifupdown unblock     2017-02-16
#854335 src:python-websockets python-websockets: Non-determistically FTBFS due to unreliable timing in tests     2017-02-21
#854554 dpkg dpkg: trigger problem with cracklib-runtime while upgrading libcrypt-cracklib-perl from jessie to stretch     2017-02-08
#854592 php-phpseclib dokuwiki: Unable to login, missing usr/share/php/Crypt/AES.php     2017-02-13
#854616 scdaemon scdaemon cannot access yubikey using ccid driver without pcscd block-udeb     2017-02-13
#854692 gcc-6 pybind11: FTBFS due to an internal compiler error unblock     2017-02-23
#854701 src:python-asyncssh python-asyncssh: FTBFS (failing tests)     2017-02-09
#854719 hostapd hostapd: Failed to set beacon parameters block-udeb req:#855143 [C|M]     2017-02-24
#854727 src:zziplib Multiple vulnerabilities / unsuitable for stretch?     2017-02-25
#854735 profanity CVE-2017-5592     2017-02-09
#854738 mcabber CVE-2017-5604     2017-02-17
#854739 src:sleekxmpp CVE-2017-5591     2017-02-20
#854740 src:slixmpp CVE-2017-5591     2017-02-09
#854792 accountsservice fails when there are two users with the same UID     2017-02-25
#854804 sane-utils saned: CVE-2017-6318: SANE_NET_CONTROL_OPTION response packet may contain memory contents of the server     2017-02-25
#854828 get-iplayer get-iplayer: get_iplayer fails to save any content, *_original.partial.mp4.flv files are empty     2017-02-18
#854837 dicompyler Package dicompyler does not work     2017-02-18
#854851 binaryornot Please remove or replace lenna images unblock     2017-02-21
#854880 firmware-atheros firmware-atheros ships binary ath9k_htc firmwares containing GPL code     2017-02-11
#854941 syncevolution-dbus sync-ui: fails to do anything req:#856040 [C]     2017-02-24
#854985 kodi kodi.service spamming the logs due to xinit being missing age/5 unblock     2017-02-22
#855038 piuparts All test ends with "INFO: SKIP: All tests. Package cannot be tested with piuparts:"     2017-02-25
#855066 src:jarisplayer src/jaris/player/Player.hx:1533: characters 17-33 : Only inline or read-only (default, never) fields can be used as a pattern     2017-02-13
#855094 initramfs-tools-core initramfs-tools-core: Error on upgrade if cryptsetup is installed, but a current busybox isn't     2017-02-14
#855096 unison unison: segfaults after connection has been established     2017-02-14
#855129 flatpak flatpak: Portals can't read /proc/$pid/root in Debian unblock     2017-02-16
#855130 src:med-fichier med-fichier: MED library is not compatible with HDF5 1.10     2017-02-25
#855227 src:qemu qemu: CVE-2017-2630: nbd: oob stack write in client routine drop_sync     2017-02-15
#855244 libmariadbclient-dev libmariadbclient-dev: hardcoded -lmysqlclient, package not providing it though     2017-02-15
#855275 src:dot-forward dot-forward: FTBFS: cannot read [...]/debian/dot-forward/usr/sbin/* age/5 unblock     2017-02-22
#855277 src:nvidia-graphics-drivers nvidia-graphics-drivers: CVE-2017-0309, CVE-2017-0310, CVE-2017-0311, CVE-2017-0321, CVE-2017-0318 unblock     2017-02-23
#855278 src:nvidia-graphics-drivers-legacy-340xx nvidia-graphics-drivers-legacy-340xx: CVE-2017-0309, CVE-2017-0310, CVE-2017-0311, CVE-2017-0321, CVE-2017-0318 age/5 unblock     2017-02-24
#855279 src:nvidia-graphics-drivers-legacy-304xx nvidia-graphics-drivers-legacy-304xx: CVE-2017-0309, CVE-2017-0310, CVE-2017-0311, CVE-2017-0321, CVE-2017-0318     2017-02-16
#855324 pdfsam pdfsam fails to start     2017-02-21
#855344 icedove thunderbird: retains mails from removed IMAP accounts     2017-02-23
#855405 src:pcre3 pcre3: CVE-2017-6004 block-udeb unblock unblock-udeb     2017-02-17
#855451 inn2 inn2: FTBFS: objdump: … passwd/auth_krb5': No such file     2017-02-23
#855491 texlive-latex-recommended texlive-latex-recommended: emph macro is broken in fontspec 2.5c; please update to 2.5d unblock     2017-02-20
#855494 mgltools-pmv mgltools-pmv: runPmv does not start     2017-02-19
#855529 chromium-widevine chromium-widevine: dbgsym package in contrib causes src package to also go into contrib block unblock     2017-02-20
#855541 purple-matrix purple-matrix: Not ready for release yet     2017-02-22
#855576 openstack-dashboard openstack-dashboard: fails to install: django.core.exceptions.ImproperlyConfigured: AUTH_USER_MODEL refers to model 'openstack_auth.User' that has not been installed     2017-02-20
#855588 atheme-services memory leak could lead to Denial Of Service req:#855595 [C]     2017-02-23
#855602 src:libnids libnids: undefined reference to `before' after being rebuilt / on mips64el     2017-02-22
#855609 pencil2d pencil2d should not be in testing rm:#854268 [M]     2017-02-20
#855615 src:tachyon tachyon: not binNMU safe unblock     2017-02-24
#855628 src:soundmanager2 soundmanager2: Contains minified JavaScript and prebuilt SWF files age/5 unblock     2017-02-20
#855671 src:chaussette chaussette: FTBFS: ConnectionError: HTTPConnectionPool(host='localhost', port=8080): Max retries exceeded with url: /     2017-02-21
#855689 jython jython.jar does not provide a Class-Path age/5 unblock     2017-02-22
#855705 munin munin: CVE-2017-6188: munin-cgi-graph local file write vulnerability     2017-02-24
#855788 needrestart-session needrestart-dbus-session: Failed to setup environment correctly     2017-02-21
#855791 src:qemu qemu: CVE-2017-2620: cirrus_bitblt_cputovideo does not check if memory region is safe     2017-02-21
#855843 gtranscribe gtranscribe: fails to load audio file age/5 unblock     2017-02-22
#855846 repo repo: requires software outside of the distribution to function unblock     2017-02-25
#855877 python3-django-celery python3-django-celery: management commands broken with Django 1.10 age/5 unblock     2017-02-23
#855881 src:freecontact freecontact: FTBFS in stretch (devlibs error) age/2 unblock     2017-02-23
#855895 lvm2 lvm2: lvchange while raid1 conversion active causes instant and serious loss of whole device block-udeb     2017-02-23
#855906 src:golang-codegangsta-cli golang-codegangsta-cli: FTBFS: FAIL: TestCommandYamlFileTestDefaultValueFileWins (0.00s) helpers_test.go:10: Expected 15 (type int) - Got 7 (type int)     2017-02-23
#855912 debconf db_purge: exits with error code 8 when using deluser in the same postinst     2017-02-23
#855920 src:fail2ban fail2ban: FTBFS: Test failures     2017-02-25
#855925 src:sugar-irc-activity sugar-irc-activity: FTBFS: unsatisfiable build-dependencies: python-sugar-0.88, python-sugar-toolkit-0.88     2017-02-23
#855929 src:mclibs mclibs: FTBFS: Test failures     2017-02-23
#855930 src:latex-make latex-make: FTBFS: dh_auto_test: make -j1 check VERBOSE=1 returned exit code 2     2017-02-25
#855931 src:ruby-eventmachine ruby-eventmachine: FTBFS: E: Build killed with signal TERM after 150 minutes of inactivity     2017-02-23
#855932 src:sugar-physics-activity sugar-physics-activity: FTBFS: unsatisfiable build-dependencies: python-sugar-0.88, python-sugar-toolkit-0.88     2017-02-23
#855933 src:mod-gnutls mod-gnutls: FTBFS: Test failures     2017-02-23
#855943 src:shadow shadow: CVE-2017-2616: Sending SIGKILL to other processes with root privileges via su age/2 unblock     2017-02-24
#855951 src:libsecret libsecret FTBFS with test failures on many architectures     2017-02-23
#855962 acme-tiny acme-tiny: fail to parse openssl 1.1 CSR output     2017-02-23
#856002 sddm sddm: only shows white screen req:#855624 [C]     2017-02-24
#856004 khtml khtml: please build-depen on libssl1.0-dev for Stretch     2017-02-25
#856018 srst2 Does not start age/2 unblock     2017-02-24
#856023 src:zeromq3 Package is built without OpenPGM support age/5 unblock req:#856121     2017-02-24
#856024 molly-guard molly-guard: causes failure to update systemd-sysv     2017-02-25
#856036 vino screen sharing is not working and vino is segfaulting when started manually     2017-02-24
#856039 xserver-xorg-core xserver-xorg-core: no keyboard and no mouse block-udeb     2017-02-24
#856064 libdbd-mysql-perl libdbd-mysql-perl: reads of floats currupted as 0     2017-02-25
#856114 src:wolfssl wolfssl: CVE-2017-6076     2017-02-25
#856117 src:tnef tnef: CVE-2017-6307 CVE-2017-6308 CVE-2017-6309 CVE-2017-6310     2017-02-25
#856133 src:shiboken shiboken FTBFS on i386/armel/armhf: other_collector_external_operator test failed     2017-02-25
#856134 src:plotutils plotutils FTBFS on i386: spline.test fails     2017-02-25
#856135 src:gegl gegl FTBFS on arm64: gegl-tester segfault     2017-02-25
#856146 webcamoid broken: missing dependencies     2017-02-25

Generated in 0.745 seconds.

select id, bugs.package, bugs.source, severity, title, last_modified, affects_stable, affects_testing, affects_unstable, affects_experimental from bugs 
where id in (select id from bugs_rt_affects_testing) 
and not (id in (select id from bugs_merged_with where id > merged_with)) 
AND (severity >= 'serious')
order by id asc