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
  • 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

  • >
  • >
  • >
  • >
  • >
  • >
  • >
  • >

Sort

Format

203 bugs found

bug# package title popcon modified
#727800 akonadi kmail: KMail goes bonkers following Qt update 19076 2014-10-30
#747637 akonadi-server akonadi-server: upgrade to akonadi-12-1-1 does not work so kmail too 19076 2014-08-19
#708781 autoconf2.64 GFDL license with invariant section 671 2014-02-07
#715204 automake automake: Doesn't use TESTS_ENVIRONMENT with parallel test 35983 2014-06-05
#758121 bibletime bibletime: New upstream release fixes display problem in jessie 311 2014-10-22
#714045 blcr-dkms blcr-dkms: blcr module is not built on kernel 3.9.1 5739 2014-10-09
#751767 blt libBLT changes SONAME without changing package name 22332 2014-08-11
#722912 libclutter-1.0-0 libclutter-1.0-0: apt does not find an upgrade path from wheezy to jessie: libcogl12 : Breaks: libclutter-1.0-0 (< 1.14) but 1.10.8-2 is to be installed 78107 2014-09-10
#761047 libcogl20 libcogl20: breaks upgrade from wheezy to jessie 69143 2014-09-10
#764437 console-setup console-setup hangs during install in jessie/wheezy on eeepc 1005ha 156126 2014-10-08
#765157 src:crystalspace crystalspace: FTBFS: make[2]: *** No rule to make target 'install_lib'. Stop. 43 2014-10-24
#760476 cups cups - crashes after reading tls stuff 143247 2014-10-29
#755343 src:dasher dasher: FTBFS: dasher_editor_external_atspi.cpp:69:75: error: invalid conversion from 'void (*)(const AtspiEvent*, void*) {aka void (*)(const _AtspiEvent*, void*)}' to 'AtspiEventListenerCB {aka void (*)(_AtspiEvent*, void*)}' [-fpermissive] 9342 2014-07-19
#709198 debconf debconf: should not use python in maintainer scripts 173967 2013-05-21
#747141 debhelper debhelper: dh_installdocs --link-doc forces source-version dependencies 47706 2014-10-03
#739989 src:debian-installer-utils debian-installer-utils: log-output change breaks speech synthesis 1 2014-08-22
#762061 dkms dkms should pull in the correct linux-headers package 42297 2014-09-20
#765567 docbook-xsl Please use non-recursive version 38183 2014-10-16
#762272 src:doxygen doxygen: segfaults when building efl (on ix86 amd amd64) 8435 2014-09-21
#766189 src:ecere-sdk ecere-sdk: FTBFS on powerpc 8 2014-10-23
#747054 eclipse FTBFS: package javax.servlet.http does not exist 7936 2014-07-22
#759847 src:eclipse eclipse: FTBFS: [javac] /«PKGBUILDDIR»/build/eclipse-3.8.1-src/plugins/org.eclipse.equinox.p2.director/src/org/eclipse/equinox/internal/p2/director/Projector.java:30: error: package org.sat4j.pb does not exist 7936 2014-09-14
#756179 efibootmgr grub-efi-amd64: Boot failure after upgrade to 2.02~beta2-11 6308 2014-10-14
#764386 libefivar0 libefivar0: Segmentation fault in vars_get_variable() (vars.c:165) 2632 2014-10-29
#762159 efl efl: segfault during build 3429 2014-09-20
#726593 egg egg: Emacs 24 support 51 2014-10-29
#766250 eject eject: [kfreebsd] fails to open cdrom tray 159680 2014-10-21
#738638 emacs23 emacs23: needs Breaks: vm-bonus-el (<< 35.8) 18106 2014-10-26
#566947 emacs23-nox emacs23-nox fails to install on loongson2f/Loongson3 18106 2014-10-26
#735998 src:emacs23 please build-depend on libtiff-dev, not libtiff4-dev 18106 2014-10-26
#699325 emacs24 emacs24: crashes in getenv.c just after starting it 4623 2014-10-14
#766397 emacs24 emacs/gnus: Uses s_client to for SSL. 4623 2014-10-27
#704953 epiphany-browser Crash recovery crashes everytime, cannot start anymore 19059 2014-10-29
#765838 evolution-data-server Evolution is not able to use TLSv1 or higher (only SSLv3) 73666 2014-10-28
#765812 evolution-data-server evolution-data-server: Crash with SQLite 3.8.7 due to missing xFetch definition 73666 2014-10-30
#764801 fence-agents CVE-2014-0104: fence-agents: no verification of remote SSL certificates 31 2014-10-11
#765156 src:flashproxy flashproxy: FTBFS: Tests failures 12 2014-10-28
#758973 fontconfig-config [fontconfig-config] Stop breaking user configuration in /etc/fonts/conf.d/ after every upgrade 151531 2014-09-12
#657281 fop src/java/org/apache/fop/pdf/ sRGB Color Space Profile.icm is non-free 9013 2014-04-06
#764814 freecad freecad downloads and executes code 1295 2014-10-24
#766114 fso-deviced fso-deviced: uninstallable in i386/amd64/armhf 62 2014-10-20
#764957 fso-gsmd fso-gsmd: FTBFS - Non-constant field initializerS not supported in this context 25 2014-10-12
#765380 src:gcc-4.8 don't ship gcc-4.8 with jessie 25718 2014-10-20
#765151 src:gdebi gdebi: FTBFS: Tests failures 74110 2014-10-13
#765771 gdm3 gdm3: Xorg.N.log is gone 65121 2014-10-25
#761001 gdm3 gdm3: No way to log in 65121 2014-10-29
#758183 gdm3 Autologin no longer works 65121 2014-10-26
#698375 gfs2-utils, redhat-cluster-suite gfs2-utils: fails to upgrade from wheezy: insserv: script gfs2-utils: service gfs2 already provided! 0 2014-10-22
#763314 gftp gftp does not work anymore in sid 4183 2014-10-16
#735336 git [1.8.4.1->1.8.4.2 regression] git: 'error Missing tree' when pushing to gerrit 72267 2014-08-01
#669292 gitweb gitweb: automatic configuration breaks with apache2 2.4 72267 2014-07-14
#762462 src:glassfish glassfish: Current version no longer supported upstream 898 2014-09-22
#766370 libc6 login[5797]: segfault at ip sp error 14 in librt-2.19.so 173766 2014-10-27
#759530 libc-bin libc-bin: ldconfig breaks a system 173766 2014-10-26
#765145 src:globus-simple-ca globus-simple-ca: FTBFS: Tests failures 9 2014-10-29
#755140 gnome-session Fails to shutdown or logout without gnome-shell 69811 2014-08-31
#663388 gnustep-back-common gnustep-back-common: unowned files after purge (policy 6.8, 10.8) violating FHS (policy 9.1) too 2068 2014-10-28
#764695 gnustep-back-common gnustep-back-common does not configure if no fonts with spaces in directory name are installed 2068 2014-10-28
#754825 libgnustep-gui0.24 libgnustep-gui0.24: Crashes when loading some XIBs 2127 2014-10-28
#755823 libgnustep-gui0.24 libgnustep-gui0.24: Crashes when loading a .gorm file 2127 2014-10-28
#755572 gnustep-make gnustep-make: Broken framework versioning support 14689 2014-10-26
#760735 libgnutls26 libgnutls26: [dummy bug] Must not be shipped in jessie 170494 2014-10-20
#763749 gphpedit gphpedit: FTBFS in current testing 399 2014-10-02
#708946 src:grub GFDL documentation with front and back cover 17017 2014-02-07
#764798 grub2-common grub2: Grub rescue shell with RAID 6 mdadm over 8 disks 167517 2014-10-23
#756253 grub-efi-amd64 Upgrade from 2.02~beta2-10 to 2.02~beta2-11 left grub unbootable 167517 2014-10-30
#765540 grub-pc missing symbol 167517 2014-10-20
#741464 grub-pc-bin grub-pc-bin: freezes after "terminal_input at_keyboard" 167517 2014-10-16
#745409 grub2 [grub2] Non free RFC 167517 2014-07-25
#761915 src:gst-plugins-base1.0 gst-plugins-base1.0: gir packages missing Depends against libraries 24298 2014-09-16
#761916 src:gstreamer0.10 gstreamer0.10: gir packages missing Depends against libraries 104127 2014-09-17
#761019 src:gstreamer1.0 gstreamer1.0: gir packages missing Depends against libraries 24396 2014-09-16
#762417 gtk-vnc vinagre: cannot connect - libgrypt error? 58802 2014-10-09
#763221 src:haskell-gtk3 haskell-gtk3: FTBFS: Couldn't match type `CInt' with `()' 19 2014-10-13
#717190 hdparm Leaves RAID sync speed set to 0 111459 2013-07-17
#765066 hhsuite hhsuite 2.0.16-2 conflicts with hhsuite-data 2.0.16-1 144 2014-10-30
#757547 hspell hspell: text of the AGPL license is missing 1478 2014-08-09
#761245 icedove icedove: STARTTLS regression: "connection to SMTP server was lost in the middle of the transaction" 22893 2014-10-25
#765961 iceweasel Iceweasel dies on Segmentation fault, in 64 bit linux 94841 2014-10-19
#703472 iceweasel iceweasel freezes in _MD_WaitUnixProcess after mailcap "test" command terminates 94841 2014-03-12
#748728 libuser, id-utils id-utils and libuser: error when trying to install together 0 2014-05-22
#764872 imagemagick convert +profile regression enters infinite loop exhausting memory 101160 2014-10-28
#753770 imagemagick-common imagemagick-common 6.8 breaks imagemagick 6.7 and perlmagick 101160 2014-10-28
#764730 dh-systemd dh_systemd_start: un-escapes - in unit/directory names 29942 2014-10-10
#616689 initramfs-tools Root-on-LVM setup fails often due to timing issues 172101 2014-10-08
#706877 insserv insserv: breaks dist-upgrade by installing before packages fix their init scripts 164941 2013-10-20
#764630 jarwrapper missing JNI multi-arch PATHs in jarwrapper 8931 2014-10-30
#759947 src:jruby jruby: FTBFS: [apt] E: Command line option 'd' [from -deprecation] is not known. 159 2014-10-13
#730130 k3b k3b gets no optical device found if udisks2 is not installed 16762 2014-10-26
#735261 kmail kmail2 randomly marks read messages as unread 15462 2014-01-20
#766349 kmail Kmail: Some times sign with S/MIME failed 15462 2014-10-22
#748743 kfreebsd-8 kfreebsd-8: triple fault on execve from 64-bit thread to 32-bit process 19 2014-05-20
#754237 src:kfreebsd-9 kfreebsd-9: SCTP kernel memory disclosures (CVE-2014-3953) 67 2014-10-21
#762372 kfreebsd-kernel-headers kfreebsd-kernel-headers: regressions make libgtop2 FTBFS 120 2014-09-29
#763211 src:libappindicator libappindicator: FTBFS: src/app-indicator.c:480: Error: AppIndicator: multiple "@arg1" parameters for identifier "AppIndicator::new-label": 17212 2014-09-28
#728955 src:libatomic-ops FTBFS on powerpc: FAIL: test_stack 189 2014-08-20
#759960 src:libcatalyst-engine-psgi-perl libcatalyst-engine-psgi-perl: FTBFS: dh_auto_test: make -j1 test returned exit code 2 30 2014-10-25
#764130 libdbi1 libdbi1: double-free in dbi_shutdown_r 17461 2014-10-28
#755404 libept1.4.12 libept1.4.12: /usr/lib/libept.so.1.0.5.4.12 is a dangling symlink 131007 2014-09-29
#745454 libgcrypt11 [libgcrypt11] Non free RFC 173149 2014-08-11
#737030 libgcrypt20 libgcrypt uses processor features not allowed for armhf (and i386?) 25048 2014-01-29
#745453 libgcrypt20 [libgcrypt20] Non free RFC 25048 2014-07-26
#761170 src:libgit2 libgit2: FTBFS on multiple architectures 6034 2014-10-29
#726370 src:libgphoto2 gphoto2: Nikon D300, Darktable hangs and Dolphin shows error code 150. 92203 2014-04-13
#762690 libhibernate-validator-java libhibernate-validator-java: affected by CVE-2014-3558 27 2014-09-24
#745844 libimobiledevice libimobiledevice-utils: Segfault with iphone 3GS on many utilities 68017 2014-09-24
#766353 libjpeg-progs [libjpeg-progs] Conflicts with libjpeg-turbo-progs 1:1.3.1-3 46547 2014-10-27
#749698 libmusicbrainz5 libmusicbrainz5 included non-free files. 69420 2014-05-29
#765424 libpam-mount libpam-mount: Fails to run mount: invalid option -- '-p' 663 2014-10-14
#682420 src:libpaper libpaper: "Multi-Arch: same" but postrm removes arch-independent configuration 127359 2014-06-08
#760733 src:libspring-java CVE-2014-3578: directory traversal 675 2014-09-08
#758516 libstruts1.2-java Struts 1.2 should not be shipped with jessie 413 2014-10-12
#766362 libvirt-daemon-system libvirt-daemon-system: fails to install 10880 2014-10-23
#750593 xsltproc xsltproc: bus error on some architectures 125525 2014-10-16
#764162 src:linux linux-image-3.16-2-kirkwood: [regression 3.14->3.16] file data corruption, via network 117855 2014-10-30
#727149 src:linux linux-image-3.10-3-amd64: Network adapter (Intel 82579V) hangs during TX, causing reset and undetected data corruption at the other side 117855 2014-09-13
#732300 logkeys logkeys: logfile is gibberish 135 2014-10-27
#749365 lucene2 lucene2: FTBFS - tests fail 71890 2014-09-11
#739166 lxsession lxsession: upcoming vala 0.14 removal 7865 2014-10-23
#740163 lxsession lxsession: lxlock/dm-tool lock is easily circumvented 7865 2014-10-23
#731489 lxsession lxsession: reboot and shutdown does not work (no proper systemd-logind support?) 7865 2014-10-23
#745835 lynx-cur lynx-cur: certificate revocation is not checked 24174 2014-04-26
#752610 lynx-cur lynx: Can connect to CVE-2014-0092 test site 24174 2014-06-29
#722265 mako mako contains some minified javascript librairies 60084 2014-02-06
#765822 src:mame src:mame: Please change build dependency to libjpeg-dev (libjpeg-turbo transition) 1131 2014-10-22
#765664 src:mariadb-5.5 mariadb-5.5: Multiple security fixes from October 2014 CPU could affect MariaDB 1469 2014-10-22
#759094 src:matplotlib matplotlib: Please update to use wxpython3.0 11532 2014-10-16
#725417 mbr mbr: install-mbr wipes the disk-id portion of the MBR, rendering Windows 7 unbootable 2953 2014-08-02
#766308 mdadm Fails to purge: /var/lib/dpkg/info/mdadm.postrm: 9: /usr/share/debconf/confmodule: DEBIAN_HAS_FRONTEND: parameter not set 18529 2014-10-22
#765823 src:mess src:mess: Please change build dependency to libjpeg-dev (libjpeg-turbo transition) 599 2014-10-19
#766241 gnome gnome: dist-upgrade on 20-Oct lost gnome pixbufs and several tweak settings reset 59843 2014-10-25
#765130 src:metview metview: FTBFS: PlotMod.h:47:28: fatal error: MagicsObserver.h: No such file or directory 24 2014-10-18
#764617 mini-buildd mini-buildd: Chroot build setup broken (since sbuild-0.63.3) 10 2014-10-26
#764595 mini-buildd mini-buildd: Can't GPG-verify changes files (since python-debian-0.1.23) 10 2014-10-26
#765120 src:monogame monogame: FTBFS: unsatisfiable build-dependency: monodevelop (< 4.0.12.) but 5.5.0.227-1 is to be installed 117 2014-10-13
#743483 src:mpm-itk apache2-mpm-itk: AssignUserID is ignored in favor of file ownership. 75 2014-07-13
#766359 gir1.2-mutter-3.0 gnome-shell: gdm shows a black screen when upgrading to 3.14.1-1 60935 2014-10-29
#765663 src:mysql-5.5 mysql-5.5: Multiple security fixes from October 2014 CPU 105422 2014-10-17
#766272 nautilus nautilus: "Files" fails to start nautilus window when using custom user-dirs.dirs 76665 2014-10-25
#756144 network-manager network-manager: DHCP client upgrade is handled poorly 87016 2014-10-13
#755202 network-manager network-manager: keeps creating and using new connection "eth0" that does not work 87016 2014-10-18
#765356 network-manager clobbers resolv.conf 87016 2014-10-14
#758229 nfacct nfacct: is priority important, depends on packages with priority extra 12573 2014-08-15
#622394 nfs-common nfs-common: breaks systemd - dependency cycle in require-start leads to removal of critical jobs 147175 2014-10-29
#764833 nifti2dicom nifti2dicom: FTBFS - cannot find -lQt5::Widgets 27 2014-10-26
#766484 nodejs FTBFS in a cowbuilder: Error: listen EADDRNOTAVAIL 5112 2014-10-23
#736825 opencv missing licenses in debian/copyright 18708 2014-01-27
#765037 src:openjdk-7 openjdk-7: apt tool is needed by reverse dependencies 36151 2014-10-23
#763681 openrc openrc: FTBFS[armel,armhf,ppc64el] 56 2014-10-26
#726661 openssh-server Does not permit login as root from version 1:6.2p2-6 173093 2014-09-28
#701814 os-prober os-prober: damages XFS exported via iSCSI but not mounted locally; potential data loss 153655 2013-11-06
#743853 libpango-1.0-0 libpango-1.0-0 : Breaks: libpango1.0-0 (< 1.32.5-2) but 1.30.0-1 is to be installed 135233 2014-07-30
#762638 src:perl missing source: Configure 173961 2014-10-06
#765119 src:php-config php-config: FTBFS: Tests failures 230 2014-10-13
#765164 src:php-event-dispatcher php-event-dispatcher: FTBFS: Tests failures 42 2014-10-13
#764885 php-htmlpurifier Security flaws in the current Debian version 189 2014-10-20
#765136 src:php-http-upload php-http-upload: FTBFS: Tests failures 135 2014-10-13
#766273 undertaker, picosat picosat and undertaker: error when trying to install together 0 2014-10-24
#760171 src:pillow [nip2] Non distibutable file: lena 88254 2014-09-30
#766462 plymouth with plymouth installed, I don't get any gettys on my VCs 3227 2014-10-28
#762790 src:powerpc-utils powerpc-utils: maintainer address bounces 692 2014-10-29
#764590 procps procps: fails to build from source in sid on amd64 173940 2014-10-26
#765300 src:pymvpa2 pymvpa2: download files during build (intersphinx) 88 2014-10-28
#751498 src:python-greenlet python-greenlet: FTBFS on arm* due to test failures 2869 2014-10-21
#765469 python3-tornado python3-tornado: get_secure_cookie get incorrect value by setting set_secure_cookie 2548 2014-10-15
#714346 src:python-tz python-tz: source for timezone data not included 16353 2014-02-06
#766261 virtualenv python-request-whl version 2.4.3 breaks pip and virtualenv 5250 2014-10-23
#762672 qt-at-spi qt-at-spi: when this package is installed, other programs fail to run 11227 2014-10-19
#765681 libqtgui4-perl libqtgui4-perl: QtGui4 module cannot be imported 7173 2014-10-17
#650386 reportbug reportbug: reports against src:binarypackagename 153601 2014-10-29
#766419 python-requests-whl python3-requests: Version 2.4 of python-requests / python3-requests breaks virtualenv. 8357 2014-10-23
#764845 root-system root-system: FTBFS - missing build dependency on globus-core 700 2014-10-24
#764133 librtmp-dev librtmp-dev misses dependency on libgnutls-dev and zlib1g-dev 108855 2014-10-05
#765113 src:ruby-webmock ruby-webmock: FTBFS: ERROR: Test "ruby2.1" failed 7 2014-10-29
#766187 runit runit: Fails to install runit after fresh install of jessie beta2 2151 2014-10-28
#567210 libsaxonb-java libsaxonb-java: doc-available always returns false without network 506 2014-06-29
#765118 src:scilab scilab: FTBFS: [javac] /«PKGBUILDDIR»/modules/scirenderer/src/org/scilab/forge/scirenderer/implementation/jogl/JoGLCanvas.java:23: error: cannot find symbol 2009 2014-10-13
#749833 scilab scilab: Scilab include non-free codes 2009 2014-06-11
#765147 src:seaborn seaborn: FTBFS: unsatisfiable build-dependency: python-matplotlib (< 1.2.0~) but 1.3.1-2 is to be installed 100 2014-10-13
#633730 src:seed FTBFS on mips: seed segfaults in doc/modules/readline/ 64545 2014-08-13
#712322 src:slib slib: FTBFS: manuals build fails against textinfo5 because some incompatibles changes wrt 4.13 and below (some warnings have turned into errors) 2482 2014-04-28
#765158 src:smuxi smuxi: FTBFS: build-dependency not installable: libmessagingmenu-cil-dev 246 2014-10-13
#764108 src:snort snort: build-dependency on libgnutls-dev 992 2014-10-06
#765017 spice-client-glib-usb-acl-helper SECURITY - normal users are allowed full access to USB devices per default 10787 2014-10-13
#722267 python-sqlalchemy contains minified version of jquery 7008 2014-08-16
#607969 sqlite sqlite: Still useful? 17188 2014-10-29
#760353 sssd-common sssd-common: Startup settings in /etc/default/sssd prevents service (re)start 500 2014-10-30
#689919 subversion subversion: includes a non-free file 41133 2013-09-04
#760402 synaptic synaptic: libc upgrade always failing in synaptic 82174 2014-09-19
#765870 systemd systemd-logind brings system to knees with RAM consumption 173436 2014-10-29
#756076 systemd-shim does not cleanup sessions when user logs out: No such interface 'org.freedesktop.systemd1.Scope' 3620 2014-09-28
#694986 initscripts flash-kernel: postinst modifies /etc/default/rcS 173936 2014-02-04
#757588 sysvinit-core sysvinit-core: installation fails when systemd is present 173936 2014-08-10
#764355 targetcli targetcli: Fails to load or save any config on Jessie 87 2014-10-07
#765677 taskcoach taskcoach: FTBFS - missing build dependency on cpio 152 2014-10-28
#766502 typo3-src TYPO3-CORE-SA-2014-002: Multiple Vulnerabilities in TYPO3 CMS 88 2014-10-23
#763260 src:uswsusp uswsusp: FTBFS: load.c:395:2: error: unknown type name 'gcry_ac_handle_t' 3926 2014-10-21
#766101 src:vala-0.24 Should not be released with jessie 592 2014-10-26
#764762 src:valabind Upcoming vala 0.24 removal 32 2014-10-25
#764596 vmdebootstrap vmdebootstrap should install kernel last 83 2014-10-25
#751511 xfslibs-dev xfslibs-dev: Incorrect licensing information in debian/copyright 12817 2014-07-13
#760377 xmlrpc-c missing license in debian/copyright 13043 2014-10-25
#763259 yade yade: FTBFS: I can't find file `Yade.tex' 316 2014-10-21

Generated in 0.751 seconds. Last data update: 2014-10-30T16:31:31+00:00 (0.1 hours ago)

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_merged_with where id > merged_with)) 
and (current_timestamp - interval '7 days' > arrival) 
AND (severity >= 'serious')
order by source asc