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

Bugs search

Useful queries



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 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 sid
  • different versions in jessie 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 unblock hint
  • key packages
  • pseudo packages
  • packages marked for autoremoval
  • closed in packages in new
  • newer than days
  • modified in the last days

Bug types

Additional fields



183 bugs found

bug# tags package title hints deferred RT modified
#616689   initramfs-tools Root-on-LVM setup fails often due to timing issues       2015-01-18
#683757   bamfdaemon bamfdaemon: unowned directory after purge: /usr/share/applications/       2015-01-25
#689266   grub-pc grub-pc: graphics mode sends VGA signal out of range on ATI Rage 128 Pro Ultra TR block-udeb unblock unblock-udeb req:#773224 [d-i|M]       2015-01-23
#692956 [+]   libqt4-ruby1.8 libqt4-ruby1.8: leaves diversion after upgrade from squeeze unblock       2015-01-25
#717190 [+]   hdparm Leaves RAID sync speed set to 0 block-udeb       2014-11-16
#725284 [+]   hdparm hdparm + systemd: Configuration not restored after resume block-udeb       2014-12-22
#725417 [u]   mbr mbr: install-mbr wipes the disk-id portion of the MBR, rendering Windows 7 unbootable block-udeb       2015-01-18
#728365 [+|u]   rhn-client-tools python-rhn: Running rhn_reg fails with a TypeError exception. unblock       2015-01-24
#729800 [jes|+|sid]   initramfs-tools Packages including /usr/sbin/update-initramfs must Provide and Conflict with linux-initramfs-tool       2014-10-04
#731583 [C|U|+]   sudo Compares hostname no longer using FQDN req:#773319 [M]       2015-01-19
#734517   brasero brasero: suggest brasero-cdrkit       2015-01-22
#739676 [jes|+|sid]   systemd systemd-user PAM config breaks some libpam-* modules block-udeb unblock unblock-udeb       2015-01-21
#740998 [ipv6]   rdnssd NetworkManager and rdnssd do not play well together block-udeb       2015-01-25
#741464   grub-pc-bin grub-pc-bin: freezes after "terminal_input at_keyboard" block-udeb unblock unblock-udeb req:#773224 [d-i|M]       2014-12-18
#742048 [+]   systemd systemd-remount-fs.service fails for split-usr block-udeb unblock unblock-udeb       2015-01-21
#747863 [+]   nut-client systemd service fails by default and causes package install failure unblock       2015-01-24
#748657 [+]   make-dfsg make-dfsg failed to run test: work/misc/ unblock       2015-01-21
#749833   scilab scilab: Scilab include non-free codes       2014-12-18
#750521 [H|jes|sid|u]   pinentry-gtk2 scim-gtk-immodule breaks pinentry-gtk2 and impairs gnome-keyring       2015-01-01
#754907 [jes|sid]   tracker-extract tracker-extract: Spams system logs     jessie-is-blocker   2015-01-07
#755202   network-manager network-manager: keeps creating and using new connection "eth0" that does not work       2015-01-25
#755834 [C|H]   isc-dhcp-server Fails to install if interface list is empty block-udeb       2015-01-22
#756233   libtbb2 libtbb2 for i386 is miscompiled, it contains the cmov instruction req:#775506 remove:#775263 [M]       2015-01-16
#756253   grub-efi-amd64 Upgrade from 2.02~beta2-10 to 2.02~beta2-11 left grub unbootable block-udeb unblock unblock-udeb req:#773224 [d-i|M]       2015-01-21
#759094 [jes|sid]   src:matplotlib matplotlib: Please update to use wxpython3.0 req:#767781 [M]       2014-11-09
#759361   freerdp-x11 freerdp-x11: Segfaults on too-long command line with old-style options       2015-01-16
#759530   libc-bin libc-bin: ldconfig breaks a system block-udeb     jessie-is-blocker   2015-01-10
#760385 [U|S|u]   libv8-3.14 nodejs: CVE-2014-5256       2014-12-21
#760733 [S]   src:libspring-java CVE-2014-3578: directory traversal req:#772468 [M]       2014-12-03
#761815 [+]   partman-target installation adds entries for USB media to /etc/fstab which confuse udisks block-udeb       2015-01-25
#762690 [S]   libhibernate-validator-java libhibernate-validator-java: affected by CVE-2014-3558 req:#771772 [M]       2014-11-20
#764162   src:linux linux-image-3.16-2-kirkwood: [regression 3.14->3.16] file data corruption, via network block-udeb       2015-01-16
#765722 [+|S]   libxml2 CVE-2014-3660 libxml2 billion laugh variant age/2       2014-11-08
#766462   plymouth with plymouth installed, and both GDM and KDM enabled, I don't get any gettys on my VCs       2014-12-19
#766560   banshee banshee: Banshee freezes for 2-3 minutes during startup/searching/browsing after recent libsqlite3-0 update unblock       2015-01-23
#767019   xscreensaver xscreensaver: postinst overwrites /etc/X11/app-defaults/XScreenSaver without asking       2014-12-20
#767028   ovirt-guest-agent ovirt-guest-agent: doesn't work on hosts       2015-01-21
#767423 [M]   tracker-extract tracker-extract SIGSEGV       2014-12-13
#767433 [U|S]   binutils binutils: libbfd (strings, objdump, nm, etc): CVE-2014-8484 and CVE-2014-8485: code injection       2014-12-31
#767659   libpoppler-glib8 evince 3.14.1-1 gets undefined symbol with libpoppler46:i386 earlier than 0.26.5-2       2015-01-18
#768189   macchanger should not automatically change MAC (w/o user consent) unblock       2015-01-17
#768620   avahi-daemon avahi-daemon.service fails to stop during upgrade       2015-01-02
#768731 [jes|sid]   src:matplotlib matplotlib: FTBFS in jessie: build-dependency not installable: python-wxgtk2.8 req:#767781 [M]       2014-11-09
#768897   partman-lvm quietly very aggressive WRT existing LVM-typed partitions block-udeb       2015-01-18
#768945 [U|+|S|u]   src:busybox busybox lzo implementation suffers from CVE-2014-4607 flaw block-udeb req:#771208 [M]       2014-11-11
#769078   src:python2.7 python2.7: Uses literal pkgname in dpkg-query call       2014-11-20
#769106 [M]   src:python-defaults python2.7-minimal: fails to upgrade from 'wheezy': python or pycompile not found in public_modules.rtinstall hook.       2015-01-04
#769797   src:gnat-4.9 gnat-4.9: FTBFS: Needs update for gcc-4.9-4.9.2       2015-01-21
#769941 [R]   libgstreamer-plugins-base1.0-0 libgstreamer-plugins-base1.0-0: Iceweasel crashes with "gst_app_src_set_size: assertion 'GST_IS_APP_SRC (appsrc)' failed"       2015-01-21
#770008 [F]   calendar-google-provider calendar-google-provider: Can no longer connect to Google calendars       2015-01-25
#770009 [C]   imagemagick Imagemagick FTBFS on mips on mips-aql-* not on ball req:#773865 [M]       2015-01-10
#770130   gnome-shell gnome-shell: Oh no! Something has gone wrong. (Fujitsu ST4121)       2014-11-26
#770492 [S]   src:linux linux-image-3.16.0-4-686-pae: chown removes security.capability xattr on other users' files (CVE-2015-1350) block-udeb       2015-01-24
#770871   modemmanager modemmanager: ModemManager does not start automatically       2015-01-21
#771428   apt apt tries to configure dbus before libdbus-1-3, fails to upgrade       2015-01-25
#771671   kexec-tools /sbin/kexec: Unable to load kdump kernel on i386 block-udeb       2014-12-15
#771871   netscript-2.4 netscript: fails to install due to insserv rejecting the script header: There is a loop between service networking and netscript if started req:#774519 [M]       2015-01-19
#771891   evolution [evolution] IMAP messages fail to download until deleting cache       2014-12-03
#772365 [+]   simpleburn simpleburn: bashism in /bin/sh script req:#774428 [M|+]       2015-01-02
#772410   scilab scilab: bashism in /bin/sh script       2015-01-25
#772898 [C]   win32-loader win32-loader testing and newer fails with TRANSLATE error block-udeb       2014-12-17
#773029 [+]   groonga-server-common groonga-server-common: purging deletes conffiles owned by other packages: /etc/groonga/{groonga.conf, synonyms.tsv}       2015-01-21
#773233   src:linux linux: Packaging is not correctly enforcing ABI block-udeb       2015-01-16
#773354 [jes|sid]   util-linux please add breaks: live-tools (<< 4.0.1-1) block-udeb unblock unblock-udeb       2015-01-09
#773586   phoneuid phoneuid: doesn't start or crashes during startup - probably due to problem in phonefsod       2014-12-20
#773623 [S]   libv8-3.14 nodejs: CVE-2014-7192       2014-12-21
#773671 [S]   src:libv8-3.14 libv8-3.14: multiple security issues       2014-12-29
#773751 [C|U|jes|+|S|sid|u]   fex race condition between fur and fex_cleanup       2015-01-20
#773772 [+]   netscript-2.4 netscript-2.4: Interace names with '-' in them cannot be set up, and network configuration fails. req:#774519 [M]       2015-01-04
#773806 [M]   libdb5.3-java libdb5.3-java: Pre-installation script fails unblock       2015-01-07
#773834 [S]   imagemagick [imagemagick] Huge security queue req:#773865 [M]       2014-12-24
#774090 [S|u]   emacs24 emacs24: CVE-2014-9483: a left-click in Emacs sometimes modifies the PRIMARY selection       2015-01-04
#774257 [jes|sid]   gnome-control-center Configuring a printer does not work without system-config-printer       2015-01-06
#774328   ctdb ctdb: Failed to start ctdb.service: Unit ctdb.service failed to load: No such file or directory.       2015-01-16
#774329 [M|R]   libvirt-bin libvirt-bin: Doesn't gracefully shutdown guests on upgrade restart unblock       2015-01-25
#774335 [C|U|+|u]   systemd-sysv Provides: in SysV init scripts are not handled correctly, leading to wrong orderings block-udeb unblock unblock-udeb       2015-01-21
#774363   gnome gnome crashes/freezes seemingly random       2015-01-01
#774437   ovirt-guest-agent ovirt-guest-agent: fails in preinst due to hardcoded uid and gid values       2015-01-16
#774607 [H]   gitweb gitweb breaks apache upgrade       2015-01-08
#774678   ykneomgr ykneomgr: Missing dependency on pcscd unblock       2015-01-19
#774725 [+|S]   libmspack0 libmspack: CHM decompression: division by zero unblock       2015-01-13
#774726 [+|S]   libmspack0 libmspack: CHM decompression: pointer arithmetic overflow unblock       2015-01-13
#774748 [S]   ruby-redcloth ruby-redcloth: CVE-2012-6684       2015-01-09
#774780   sound-juicer sound-juicer: Refuses to start: “The plugin necessary for file access was not found”       2015-01-07
#774794   dpkg dpkg: Add breaks for new trigger cycles       2015-01-19
#774795 [jes|sid]   mysql-server-5.5 php5, mysql-server-5.5: php5 FTBFS on ppc64el due to mysql assertion failure "InnoDB: Failing assertion: node->n_pending == 0"       2015-01-09
#774844   perl xfonts-traditional: fails to upgrade from 'wheezy': Can't locate File/ in @INC unblock       2015-01-25
#774847   python2.7-minimal python2.7-minimal: fails to upgrade from 'wheezy': python or pycompile not found in public_modules.rtinstall hook.       2015-01-21
#774854   fex fex: fails to install: subprocess installed post-installation script returned error exit status 1       2015-01-20
#774862   ciderwebmail ciderwebmail: unhandled symlink to directory conversion: /usr/share/ciderwebmail/root/static/images/mimeicons unblock       2015-01-21
#774867 [+]   lirc-x lirc-x: unhandled symlink to directory conversion: /usr/share/doc/PACKAGE       2015-01-19
#774873 [jes|sid]   openjdk-7-jre-headless Circular dependency in java-headless packages       2015-01-19
#774874   maradns maradns: prompting due to modified conffiles which were not modified by the user: /etc/maradns/mararc       2015-01-08
#774889   gdm3 gdm3: fails to upgrade squeeze -> wheezy -> jessie - trying to overwrite /usr/share/gdm/BuiltInSessions/default.desktop       2015-01-20
#774915   live-tools live-tools: fails to upgrade from 'wheezy': dpkg-divert: error: rename involves overwriting `/usr/bin/uptime' with different file       2015-01-19
#774918 [+]   cups-pdf cups-pdf: copyright file missing after upgrade (policy 12.5)       2015-01-23
#775005   macchanger [macchanger] MAC randomization doesn't generate a random MAC unblock       2015-01-16
#775041 [+]   samba samba: add Breaks: qtsmbstatus-server (<< 2.2.1-3~)       2015-01-10
#775044 [+]   src:openjdk-7 openjdk-7: FTBFS: java.lang.RuntimeException: time is more than 10 years from present: 1104530400000       2015-01-25
#775052 [whe-i]   qmail-run qmail-run: postinst uses /usr/share/doc content (Policy 12.3): /usr/share/doc/qmail-run/examples/aliases       2015-01-10
#775053 [+|squ-i|whe-i]   debbugs debbugs: postinst uses /usr/share/doc content (Policy 12.3): /usr/share/doc/debbugs/examples/config       2015-01-18
#775062 [jes|+|sid]   grok grok doesn't grok group name ('group name must start with a non-digit')       2015-01-24
#775065 [jes|sid]   systemd dpkg --configure -a results in "Hangup" after first package block-udeb unblock unblock-udeb       2015-01-15
#775067 [+|u]   systemd systemd: journald doesn't forward messages to syslog w/o CAP_SYS_ADMIN (LXC) block-udeb unblock unblock-udeb       2015-01-21
#775114 [+|P]   libkdeui5 [libkdeui5] KRecursiveFilterProxyModel: The model was not working properly req:#775745 []       2015-01-22
#775124   dpkg dpkg-statoverride with unknown group breaks any subsequent package installation       2015-01-12
#775136   debian-installer sources.list.udeb generator doesn't consider Dir::Etc::SourceList unblock urgent       2015-01-25
#775147   emscripten emscripten: does not work at all with optimization enabled       2015-01-12
#775235   gnome-shell Repeatable failure to start on i386 running under kvm       2015-01-20
#775276 [U|S|u]   condor condor: CVE-2014-8126 req:#775521 []       2015-01-21
#775313 [C|+]   debsums debsums -c don't report all changed files unblock       2015-01-25
#775356 [C|ipv6|+]   resolvconf resolvconf: bashisms in /etc/dhcp/dhclient-enter-hooks.d/resolvconf: shopt and [[ ... ]]       2015-01-23
#775375 [U|+|S|u]   src:python-django python-django: CVE-2015-0219 CVE-2015-0220 CVE-2015-0221 CVE-2015-0222 req:#776204req:#775892 []       2015-01-23
#775390 [+]   php-elisp php-elisp: fails to upgrade lenny -> squeeze -> wheezy -> jessie unblock       2015-01-25
#775395 [d-i]   partman-zfs partman-zfs in d-i jessie image does not create grub-compatible /boot ZFS mirror block-udeb       2015-01-15
#775417   inn2-lfs inn2-lfs: copyright file missing after upgrade (policy 12.5)       2015-01-15
#775418 [+]   pcmanfm-dbg pcmanfm-dbg: copyright file missing after upgrade (policy 12.5) unblock req:#776201 []       2015-01-24
#775439 [U|jes|+|u]   winetricks winetricks: vcrun2013 not installable (sha1sum mismatch)       2015-01-23
#775541 [jes|sid]   nfs-common NFS mounts from /etc/fstab do not work       2015-01-17
#775564   emacs24 emacs24: emacs fails to byte-compile apel and org-mode       2015-01-24
#775583 [+]   lvm2 New initramfs-tools boot script needed to activate VG needed only for /usr block-udeb       2015-01-17
#775588   src:darcs darcs: Missing copyright information       2015-01-18
#775589   src:tellico tellico: Missing copyright information       2015-01-17
#775609 [u]   python3-exif Python3 packaging of exifread 1.4.2 doesn't actually read exif tags req:#776249 []       2015-01-25
#775616 [U|jes|+|sid|u]   src:kwave kwave: FTBFS in jessie: help_fr.docbook:292: parser error : Entity 'url_svn_instructions' not defined       2015-01-21
#775617 [C|jes|sid|u]   src:libdate-calc-xs-perl libdate-calc-xs-perl: FTBFS in jessie: Tests failures       2015-01-18
#775619 [C|jes|sid]   src:seaborn seaborn: FTBFS in jessie: Tests failures       2015-01-18
#775622 [jes|sid|R]   src:lua-rings lua-rings: FTBFS in jessie: Tests failures unblock       2015-01-18
#775623 [jes|sid]   src:golang-go-xdg golang-go-xdg: FTBFS in jessie: dh_auto_test: go test -v returned exit code 1       2015-01-18
#775624 [jes|+|sid]   src:procps procps: FTBFS in jessie: dh_auto_test: make -j1 check returned exit code 2       2015-01-24
#775625 [jes|sid|R]   src:symfony symfony: FTBFS in jessie: Tests failures unblock       2015-01-21
#775627 [jes|sid]   src:node-tap node-tap: FTBFS in jessie: Tests failures       2015-01-18
#775628 [C|jes|sid|u]   src:libdate-calc-perl libdate-calc-perl: FTBFS in jessie: Tests failures       2015-01-18
#775630 [jes|sid]   src:mysql-5.5 mysql-5.5: FTBFS in jessie: make[4]: *** [CMakeFiles/abi_check] Error 1       2015-01-18
#775631 [jes|sid]   src:ruby-pygments.rb ruby-pygments.rb: FTBFS in jessie: ERROR: Test "ruby2.1" failed: Running tests for ruby2.1 using debian/ruby-tests.rb...       2015-01-18
#775632 [C|jes|sid|u]   src:libdate-pcalc-perl libdate-pcalc-perl: FTBFS in jessie: Tests failures       2015-01-18
#775635 [jes|sid]   src:chiark-tcl chiark-tcl: FTBFS in jessie: build-dependency not installable: tcl8.4-dev unblock       2015-01-24
#775636 [jes|sid]   src:horizon horizon: FTBFS in jessie: Tests failures unblock       2015-01-21
#775637 [jes|sid]   src:openstack-trove openstack-trove: FTBFS in jessie: Tests failures req:#775288 []       2015-01-22
#775638 [C|jes|sid]   geoip-database IPv6 database is corrupt       2015-01-25
#775640 [C|jes|sid]   src:libarchive-zip-perl libarchive-zip-perl: FTBFS in jessie: Tests failures       2015-01-18
#775642 [jes|sid]   src:stressapptest stressapptest: FTBFS in jessie: configure: error: i586 is not supported! Try x86_64, i686, powerpc, or armv7a unblock       2015-01-21
#775643 [jes|sid]   src:pymvpa pymvpa: FTBFS in jessie: tests failed       2015-01-18
#775644 [jes|sid]   src:check-postgres check-postgres: FTBFS in jessie: Tests failures       2015-01-18
#775662 [S]   src:oss4 oss4: Insufficient validation of USB device descriptors       2015-01-18
#775682 [+|S|u]   websvn websvn: CVE-2013-6892: arbitrary file access when downloads enabled for users with commit access req:#776200 []       2015-01-25
#775689 [d-i]   src:unetbootin Do NOT use unetbootin for Debian CD images       2015-01-22
#775691 [U|+|S]   src:matplotlib matplotlib: CVE-2013-1424: printf buffer overrun req:#767781 [M]       2015-01-19
#775715 [S]   libv8-3.14 libv8-3.14: limiting security support       2015-01-19
#775725   dh-make-perl dh-make-perl requires YAML::XS, which is not installed unblock       2015-01-21
#775730   iceweasel iceweasel: unhandled symlink to directory conversion: /usr/lib/iceweasel/defaults       2015-01-19
#775733   xemacs21-gnome-mule, xemacs21-gnome-nomule, xemacs21-gnome-mule-canna-wnn xemacs21-gnome-*: hangs during upgrade from squeeze -> wheezy -> jessie unblock       2015-01-19
#775776 [U|+|S|u]   src:polarssl polarssl: CVE-2015-1182: Remote attack using crafted certificates       2015-01-25
#775785 [u]   trac-mercurial trac-mercurial: Internal error when viewing Trac source browser       2015-01-20
#775795 [C|u]   puppet puppet: Service's debian provider assumes SysV init       2015-01-21
#775843 [S]   node-serve-static node-serve-static: CVE-2015-1164       2015-01-20
#775851 [C|jes|sid]   geoip-bin geoip-generator produces faulty v6/city database       2015-01-20
#775866 [S]   src:vlc vlc: multiple vulnerabilities unblock       2015-01-21
#775871   torbrowser-launcher torbrowser-launcher: TorBrowser Bundle signing key changed req:#775921 []       2015-01-24
#775873 [S]   patch patch: directory traversal via file rename       2015-01-24
#775877 [u]   gnome-session gnome-session: No mouse pointer after login       2015-01-21
#775878   libmono-corlib4.5-cil libmono-corlib4.5-cil: circular dependencies cause failures in some upgrade scenarios       2015-01-21
#775881 [U|+|S|u]   src:mysql-5.5 mysql-5.5: Multiple security fixes from January 2015 CPU       2015-01-22
#775882 [S]   src:mariadb-10.0 mariadb-10.0: affected by CVEs of the Oracle Patch Update for January 2015?       2015-01-23
#775888 [+|S]   virtualbox virtualbox: CVE-2014-6588 CVE-2014-6589 CVE-2014-6590 CVE-2014-6595 CVE-2015-0418 CVE-2015-0427       2015-01-22
#775896   libdumbnet-dev libdumbnet-dev: copyright file missing after upgrade (policy 12.5)       2015-01-21
#775913 [U|+|S|u]   src:vala-0.26 vala-0.26: CVE-2014-8154: Heap-buffer overflow in vala-gstreamer bindings at Gst.MapInfo()       2015-01-21
#775953 [M]   openntpd openntpd if-up.d hook can cause system boot to hang indefinitely       2015-01-22
#775970 [+|S|u]   src:jasper jasper: CVE-2014-8157 CVE-2014-8158       2015-01-25
#776007 [+|P|S]   src:xymon buffer overrun in acknowledge.c(gi) req:#776009 []       2015-01-22
#776065 [U|S|u]   src:libvirt CVE-2015-0236 - sensitive information disclosure unblock       2015-01-23
#776094   dovecot-imapd dovecot-imapd: corrupts mailbox after trying to retrieve it       2015-01-23
#776131   src:gridengine gridengine: Should gridengine be removed from jessie?       2015-01-24
#776135 [U|S|u]   wireshark wireshark: Multiple security issues in 1.12.2 and prior versions unblock       2015-01-25
#776136 [U]   wireshark wireshark: Crashes when filter string is edited on Broadway unblock       2015-01-24
#776137   sudo sudo: fails to switch between sudo and sudo-ldap: chown: cannot access '/etc/sudoers': No such file or directory req:#773319 [M]       2015-01-24
#776145 [jes|+|sid]   libglib2.0-cil GLib-CRITICAL spam on STDERR       2015-01-25
#776185 [S|u]   src:tiff tiff: CVE-2014-8127 CVE-2014-8128 CVE-2014-8129 CVE-2014-8130       2015-01-25
#776191   vim-common vim-common: xxd license is not documented in debian/copyright file       2015-01-25
#776246 [S|u]   librsync1 MD4 collision/preimage attacks (CVE-2014-8242)       2015-01-25
#776250   compiz-fusion-bcop Should not be part of jessie rm:#776252 []       2015-01-25
#776251   ack-grep ack-grep fails to install due to diversion problem       2015-01-26
#776253 [+]   wv dependency on libwv-1.2-4 too weak       2015-01-25

Generated in 0.917 seconds. Last data update: 2015-01-26T06:01:36+00:00 (0.3 hours ago)

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