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

Bugs search

Useful queries for testing (forky)

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
  • tagged ftbfs
  • forwarded upstream
  • claimed bugs
  • fixed in deferred/delayed
  • packages not in main
  • packages not in bullseye
  • packages not in bookworm
  • packages not in trixie
  • packages not in forky
  • packages in base system
  • packages in standard installation
  • orphaned packages
  • merged bugs
  • marked as done
  • outdated binaries in bullseye
  • outdated binaries in bookworm
  • outdated binaries in trixie
  • outdated binaries in forky
  • outdated binaries in sid
  • different versions in forky and sid
  • newer in Ubuntu than in sid
  • RT tag for bullseye: ignore
  • RT tag for bullseye: will-remove
  • RT tag for bullseye: can-defer
  • RT tag for bullseye: is-blocker
  • RT tag for bullseye: no-auto-remove
  • RT tag for bullseye: pu
  • RT tag for bookworm: ignore
  • RT tag for bookworm: will-remove
  • RT tag for bookworm: can-defer
  • RT tag for bookworm: is-blocker
  • RT tag for bookworm: no-auto-remove
  • RT tag for bookworm: pu
  • RT tag for trixie: ignore
  • RT tag for trixie: will-remove
  • RT tag for trixie: can-defer
  • RT tag for trixie: is-blocker
  • RT tag for trixie: no-auto-remove
  • RT tag for trixie: pu
  • RT tag for forky: ignore
  • RT tag for forky: will-remove
  • RT tag for forky: can-defer
  • RT tag for forky: is-blocker
  • RT tag for forky: no-auto-remove
  • RT tag for forky: pu
  • RT unblock hint
  • RT blocked
  • RT permanently fails
  • RT too young
  • RT ready to migrate
  • key packages
  • pseudo packages
  • packages marked for autoremoval
  • closed in packages in new
  • newer than days
  • modified in the last days
  • blocking bug
  • usertag for user

Bugs or packages selection


  ignore:
  ignore:
  ignore:
 
 

Additional fields

Sort

Format

130 bugs found

bug# tags releases package title popcon hints claimed by deferred RT modified
#1017906 [H|u]   (STU)   src:librsvg librsvg: Contains generated files whose source is not necessarily the same version that's in main 179171       bookworm-can-defer trixie-can-defer   2023-02-16
#1036041   (STU)   src:grub2 upgrade-reports: Dell XPS 9550 fails to boot after bullseye to bookworm upgrade - grub/bios interaction bug? 273708       bookworm-can-defer trixie-can-defer   2023-05-22
#1084954 [M]   (STU)   src:llvm-toolchain-19 llvm-toolchain-*: assembly code seems to depend on build cpu capabilities 101451       trixie-can-defer   2025-04-13
#1102160 [M|R]   (STU)   grub-efi-amd64 upgrade-reports: Bookworm to Trixie [amd64][EFI] initramfs unpacking failed invalid magic at start of compressed archive 273708       trixie-can-defer   2025-06-14
#1099655 [H|M]   (STU)   kmod initramfs-tools 146 generates incorrect initramfs : does not boot, does not find root fs 275392       trixie-can-defer   2025-07-02
#1109158 []   (STU)   src:libsoup3 libsoup3: [metabug] several intermittent test failures resulting in flaky autopkgtests and FTBFS 122947 force-badtest       trixie-can-defer   2025-07-12
#1109509   (STUE)   gcc-offload-amdgcn gcc-offload-amdgcn: fails to dist-upgrade from bookworm to trixie 199347       trixie-can-defer   2025-07-19
#1089433 [for||+|P|sid|tri]   (STU)   src:shim shim-helpers-@arch@-signed: Supporting rootless builds by default 126793 block       trixie-can-defer   2025-08-11
#1108806 [for||sid|tri]   (STU)   src:commons-exec commons-exec: FTBFS randomly: autobuilder hangs 4591       trixie-can-defer   2025-08-11
#1108807 [for||sid|tri]   (STU)   src:gnome-keyring gnome-keyring: FTBFS randomly: 31/62 gnome-keyring:gkm::wrap-layer / login-hints 122420       trixie-can-defer   2025-08-11
#1111255 [for|sid]   (TU)   src:docbook-xsl docbook-xsl autopkg tests fail with libxml/libxslt from unstable 40058         2025-08-19
#1111585   (STU)   src:xen xen-hypervisor-4.20-amd64: Xserver fails to start after upgrade with matrox driver. 12920         2025-08-19
#806984 []   (STU)   src:debian-installer debian-installer: ftbfs because d-i needs network to build… 101       trixie-can-defer   2025-08-28
#1095028 [for||sid]   (TU)   xvfb xvfb: Race condition in xvfb-run 134470         2025-08-31
#1114078 [for||sid]   (TU)   src:cfortran cfortran: FTBFS: e2/e2.c:10:28: error: too many arguments to function 'easy_'; expected 0, have 2 1763         2025-09-05
#1113854 [M]   (TU)   gcc-14-x86-64-linux-gnu gcc-14-x86-64-linux-gnu: x86_64-linux-gnu-gcc-14 calls /usr/bin/as without dependency on binutils 103024         2025-09-08
#1097840 [exp|for|sid]   (TU)   src:samba samba: ftbfs with GCC-15 168370         2025-09-08
#1115130 [for||sid]   (TU)   src:libcommons-dbcp-java libcommons-dbcp-java: FTBFS: [ERROR] org.apache.commons.dbcp.TestDriverManagerConnectionFactory#testDriverManagerInit AssertionFailedError 1183         2025-09-13
#1115468 [for|sid]   (TU)   src:python-parameterized python-parameterized: autopkgtest needs update for new version of pytest: 'yield' keyword is allowed in fixtures, but not in tests 313         2025-09-17
#1095866 [u]   (STU)   llvm-19 llvm-toolchain-19: unsoundness/miscompilations on i386 101451       trixie-can-defer   2025-10-01
#1117121 [for|sid]   (TU)   src:db-defaults db5.3: should not be part of duke 8616         2025-10-03
#1118196 [for|sid]   (TU)   jetty9 jetty9 should not be in forky 2494         2025-10-16
#1039419 [for|sid]   (TU)   wide-dhcpv6 wide-dhcpv6: ships sysv-init script without systemd unit 220         2025-10-17
#1089432 [for||+|P|sid|tri]   (STU)   src:shim shim: Supporting rootless builds by default 126793 block       trixie-can-defer   2025-10-21
#1111277   (TU)   gnome-keyring gnome-keyring: Add NEWS entry that ssh-agent was dropped in favour of gcr4 122420         2025-10-22
#1112269   (TU)   fluidsynth fluidsynth: Fluidsynth Causes Distortion of Pipewire Audio 114754         2025-10-23
#1119680   (STU)   src:dns-root-data dns-root-data: autopkgtest regression: knot-resolver replaced by knot-resolver6? 149393         2025-10-30
#1119857 [for|sid]   (TU)   src:cfortran cfortran: autopkgtest failure in testing: too many arguments to function ‘v7_’; expected 0, have 1 1763         2025-11-01
#1119845 [for|sid]   (TU)   src:bash-completion bash-completion: autopkgtest failure in testing 265341         2025-11-03
#1120105   (TU)   libimobiledevice-1.0-6 libimobiledevice-1.0-6: locks parts of desktop 82496         2025-11-05
#1117393 [for||sid|tri]   (STU)   src:debian-installer-netboot-images FTBFS when apt is configured with *.sources instead of *.list 56         2025-11-17
#1102981 [for|+|sid]   (TU)   src:ruby3.3 ruby3.3: depend on libcrypt-dev explicitly 21838         2025-11-18
#1016790   (STU)   lldb, liblldb-dev lldb is not upgraded during dist-upgrade 9640       trixie-can-defer   2025-11-23
#1121307   (STU)   context lpdf-lmt.lmt:1681: attempt to perform bitwise operation on a nil value (local 'options') 4394         2025-11-30
#1081865 []   (STU)   src:gnome-keyring gnome-keyring: FTBFS: ERROR: test-import Invalid test number: /gnome2-store/import/pkcs12 - Gck-FATAL-WARNING: couldn't close session properly: The module has not been initialized 122420         2025-12-11
#967799 [for|sid|u|]   (TU)   src:vte vte: depends on deprecated GTK 2 1993         2025-12-13
#1120958   (TUē)   src:protobuf protobuf: FTBFS with gem2deb 2.2.6 91671         2025-12-21
#1123760   (TUE)   src:cryptsetup cryptsetup autopkgtest timeouts on amd64 since host switch 230558         2025-12-21
#1124098   (TU)   src:spirv-llvm-translator-19 spirv-llvm-translator-19: depends on llvm 19 992         2025-12-27
#1113414 [for||+|sid]   (TU)   src:pmdk pmdk: FTBFS with CMake 4 33342         2026-01-05
#1124783 [for|sid]   (TU)   src:x11-xkb-utils x11-xkb-utils: xkbcomp emitting errors: Could not resolve keysym 136541         2026-01-06
#1115113 [for|sid]   (TU)   src:zvbi zvbi: autopkgtest failure on amd64 with glibc 2.42 153870         2026-01-07
#967480 [for|sid|]   (TU)   src:gtk2-engines gtk2-engines: depends on deprecated GTK 2 23533         2026-01-07
#967286 [for|sid]   (TU)   src:cdebconf cdebconf: depends on deprecated GTK 2 273161         2026-01-08
#967441 [for|sid]   (TU)   src:gnome-themes-extra gnome-themes-extra: depends on deprecated GTK 2 104644         2026-01-08
#1035983 []   (STU)   src:libsoup3 libsoup3: intermittent test failures: Address already in use: AH00072: make_sock: could not bind to address 127.0.0.1:xxx 122947 force-badtest       trixie-can-defer   2026-01-10
#1083402 [U|for|sid]   (TU)   fontforge fonts-freefont: (build-)depends on deprecated module python3-pkg-resources 2102         2026-01-10
#1083766 [for|sid]   (TUē)   src:setuptools setuptools: (build-)depends on deprecated module python3-pkg-resources 181160         2026-01-13
#1114729 [M|S]   (STU)   apache2 apache2 delivers .php files uninterpreted in clear during apt dist-upgrade 114720         2026-01-19
#1126323   (STUē)   src:python-django python-django: flaky autopkgtest: several tests sometimes fail 2157 force-badtest         2026-01-24
#614497 [boo-i|bul-i|bus-i|jes-i|squ-i|str-i|tri-i|whe-i]   (STU)   doc-debian doc-debian: The OPL-licensed documents taken from Debian website are non-free 244442       buster-can-defer trixie-can-defer   2026-01-25
#1125017   (STU)   init-system-helpers init-system-helpers: "dpkg --purge tracker-extract" removes a symlink from package localsearch 273390 ignore-lintian         2026-02-04
#1127141 [for|sid]   (TU)   src:libassuan, src:wine libassuan: autopkgtest regression with wine/10.0~repack-12 0         2026-02-06
#1127144 [for|sid]   (TU)   src:gnupg2, src:wine gnupg2: autopkgtest regression on i386 with wine/10.0~repack-12 0         2026-02-06
#1127420   (TUē)   src:grpc grpc: ancient version outdated for years, open security issues for years 5487         2026-02-08
#1129318 [S|u]   (TU)   src:c3p0 c3p0: CVE-2026-27830 300         2026-02-28
#1130190 [for|sid]   (Tē)   src:rocm-hipamd src:rocm-hipamd: fails to migrate to testing for too long 9270       out-of-sync   2026-03-09
#1127763 [P]   (TU)   src:dh-python dh-python: regression in build of python packages 16373         2026-03-09
#1130186   (STUE)   src:jruby jruby fails autopkgtests with default OpenJDK 25 94         2026-03-11
#1130543 [for|sid]   (TU)   src:cross-toolchain-base-ports src:cross-toolchain-base*: please upgrade Build-Depends for new linux kernel 578         2026-03-12
#1130544 [for|sid]   (TU)   src:cross-toolchain-base src:cross-toolchain-base*: please upgrade Build-Depends for new linux kernel 1256         2026-03-12
#1131521 [for|sid]   (Tē)   src:rocr-runtime src:rocr-runtime: fails to migrate to testing for too long 11157       out-of-sync   2026-03-22
#1128079   (TU)   libgdk-pixbuf-2.0-0 uncoordinated transition causes other packages to break (e.g. volumeicon-alsa) 184476         2026-03-22
#1131712 [u]   (TU)   libsvn1 libsvn1: svn merge can yield unexpected changes in the WC and segfault due to null pointer dereference 20105         2026-03-23
#1111464   (TU)   libsframe-dev libsframe-dev has an undeclared file conflict 177531         2026-03-24
#1114412 [for||H|sid]   (TU)   src:tokyocabinet tokyocabinet: FTBFS: ................./tcttest: casket: 1464: (validation): error: 22: no record found 17959         2026-03-25
#1108557 [for||+|sid]   (TU)   src:bcel bcel: FTBFS with default Java 25 2637         2026-03-27
#1108576 [for||+|sid]   (TU)   src:libcommons-validator-java libcommons-validator-java: FTBFS with default Java 25 464         2026-03-27
#1108590 [for||+|P|sid]   (TU)   src:saaj saaj: FTBFS with default Java 25 183         2026-03-27
#1108593 [for||+|P|sid]   (TU)   src:wildfly-common wildfly-common: FTBFS with default Java 25 4         2026-03-27
#1132244   (STU)   debian-installer Beginner Question - problem building installer 101         2026-03-29
#988477 [u]   (STU)   src:xen xen-hypervisor-4.14-amd64: xen dmesg shows (XEN) AMD-Vi: IO_PAGE_FAULT on sata pci device 12920       bullseye-release-notes trixie-can-defer   2026-03-31
#1132375 [for|sid]   (TU)   src:spirv-llvm-translator-21 spirv-llvm-translator-21 upstream-testsuite still uses the old lit location only 251         2026-03-31
#1103089 [for||sid|tri]   (STU)   src:jnr-ffi jnr-ffi: FTBFS in testing/i386: dh_auto_test: error: /usr/lib/jvm/default-java/bin/java -noverify -cp /usr/share/maven/boot/plexus-classworlds-2.x.jar -Dmaven.home=/usr/share/maven -Dmaven.multiModuleProjectDirectory=/build/reproducible-path/jnr-ffi-2.2.15 -Dclassworlds.conf=/etc/maven/m2-debian.conf org.codehaus.plexus.classworlds.launcher.Launcher -s/etc/maven/settings-debian.xml -Ddebian.dir=/build/reproducible-path/jnr-ffi-2.2.15/debian -Dmaven.repo.local=/build/reproducible-path/jnr-ffi-2.2.15/debian/maven-repo --batch-mode test returned exit code 1 778       trixie-can-defer   2026-04-02
#1081014 []   (STU)   python3-zipp Should python3-zipp be dropped in Forky? 50962 remove:#1132805 [M]         2026-04-05
#1132819 []   (TU)   src:haskell-attoparsec haskell-attoparsec: flaky test t_iter 619         2026-04-06
#1133206   (TU)   qml6-module-snapd2, qml-module-snapd2 qml-module-snapd2 and qml6-module-snapd2 have an undeclared file conflict 23248         2026-04-11
#1133239   (TU)   xkb-data xkb-data has an undeclared file conflict on /usr/share/X11/xkb 272792         2026-04-11
#1133251   (TU)   liboffload-19 liboffload-19 has an undeclared file conflict on /usr/lib/llvm-19/lib/libomptarget.so.19.1 101451         2026-04-11
#1133260   (STU)   grub-cloud-arm64, grub-cloud-amd64 grub-cloud-amd64 and grub-cloud-arm64 have an undeclared file conflict on /etc/default/grub 541         2026-04-11
#1133237   (TUē)   libprrte-bin libprrte-bin has an undeclared file conflict 646         2026-04-12
#1130446   (TUē)   libprrte-bin libprrte-bin: conflict with pterm 646         2026-04-12
#1133761   (STU)   libnet1-dev libnet1-dev fails to coinstall 34310         2026-04-14
#1133795   (TU)   libext2fs-dev libext2fs-dev fails to coinstall 276547         2026-04-14
#1134288 [for||sid]   (TU)   src:junit5 junit5: FTBFS: method data in class org.opentest4j.reporting.events.core.CoreFactory cannot be applied to given types 282         2026-04-18
#1134306 [for||sid]   (TU)   src:python-babel python-babel: FTBFS: E babel.units.UnknownUnitError: concentr-portion-per-1e9 is not a known unit in cs_CZ 33294         2026-04-18
#1127624   (TU)   grub2-common grub2-common: upgrade yields inconsistent /usr/share/doc, breaking "dpkg -S" 273708         2026-04-19
#1134475 [for|sid]   (T)   src:nbd src:nbd: fails to migrate to testing for too long 453       out-of-sync   2026-04-20
#1123793   (TU)   bluez-obexd bluez-obexd: depends to Evolution libs breaks receiving files 135949         2026-04-23
#1134920 [S|u]   (STU)   src:ruby3.3 ruby3.3: CVE-2026-41316 21838         2026-04-25
#1135147 [for||sid]   (TU)   src:isa-support isa-support build depends on qemu-user that is no longer available on armhf/i386 40013         2026-04-28
#1114143 [exp|for||sid]   (TUE)   src:gst-plugins-base1.0 gst-plugins-base1.0: FTBFS: test_appsrc_blocked_on_caps:0: (after this point) Test timeout expired 144372         2026-04-29
#1135489 [for||sid]   (TU)   src:syslinux syslinux: FTBFS: /usr/include/efi/ia32/efisetjmp_arch.h:13:27: error: conflicting types for 'jmp_buf'; have 'struct <anonymous>[1]' 9464         2026-05-01
#1135498 [for||sid]   (TUē)   src:fmtlib fmtlib: FTBFS: TypeError("argument of type '_CascadingStyleSheet' is not iterable") 47121         2026-05-01
#1134183 [U|u]   (TU)   libgl1-mesa-dri libgl1-mesa-dri: asahi regression on 26.0.5 173117         2026-05-03
#1135849   (TU)   node-playwright node-playwright: playwright crashes at invocation 453         2026-05-06
#1136001 [S|u]   (STU)   src:openexr openexr: CVE-2026-42216 CVE-2026-42217 120823         2026-05-08
#1136618   (STU)   reportbug reportbug: Session crashing while suspended 251188         2026-05-13
#1131060 []   (TU)   src:ml-dtypes ml-dtypes: autopkgtest regression with NumPy 2.4 30         2026-05-15
#1098167 [for||+|sid]   (TU)   src:xserver-xorg-video-dummy xserver-xorg-video-dummy: ftbfs with GCC-15 2688         2026-05-23
#1137393 [for||sid]   (TU)   src:eclipse-platform eclipse-platform: FTBFS: [javac] /<<PKGBUILDDIR>>/resources/bundles/org.eclipse.core.resources/target/sources/org/eclipse/core/internal/resources/Workspace.java:1941: error: cannot find symbol 181         2026-05-23
#1137497 [for||sid]   (TU)   src:openjdk-25 openjdk-25: FTBFS with the nocheck build profile 6325         2026-05-24
#1121742   (STU)   dosfstools /usr/sbin/fsck.fat: Tie fsck.fat into /etc/alternatives 155605         2026-05-25
#1137794 [|u]   (TU)   src:tomcat10 tomcat10 build depends on cruft libtcnative-1 385         2026-05-27
#1138072 [S]   (TU)   clang-tools-21 clang-tools-21: Shared library hijacking via Implicit CWD in RUNPATH 7736 force-skiptest         2026-05-28
#1029996 [for|+|sid]   (TU)   openipmi openipmi: Please ship native systemd unit 8625         2026-06-02
#1137246   (STU)   gnupg gnupg encrypts the home directory when using --homedir argument 259421         2026-06-02
#1138720 [for||sid]   (TU)   src:node-playwright node-playwright: FTBFS: [ERROR] No matching export in "../../../../../../../usr/share/nodejs/rimraf/dist/esm/index.js" for import "default" 453         2026-06-02
#1138764   (STU)   libpsm2-2 libpsm2-2 uses AVX instructions on amd64 CPUs that don't support it 15756         2026-06-04
#1138809 [for|sid]   (T)   src:xsimd src:xsimd: fails to migrate to testing for too long 9158       out-of-sync   2026-06-04
#1119236 [for|sid]   (T)   src:edk2 src:edk2: fails to migrate to testing for too long 24403       out-of-sync   2026-06-04
#1139195 [for|sid]   (T)   src:node-xmldom src:node-xmldom: fails to migrate to testing for too long 375       out-of-sync   2026-06-07
#1139196 [for|sid]   (T)   src:numpy src:numpy: fails to migrate to testing for too long 48991       out-of-sync   2026-06-07
#1139446 [for||sid]   (T)   src:pygobject src:pygobject: fails to migrate to testing for too long: ftbfs on s390x 175236       out-of-sync   2026-06-09
#1139506 [for||sid]   (TU)   src:fontconfig fontconfig: FTBFS: LaTeX error 225397         2026-06-09
#1139510 [for||sid]   (TU)   src:libraw1394 libraw1394: FTBFS: LaTeX error 150368         2026-06-09
#1139517 [for||sid]   (TU)   src:opensp opensp: FTBFS: LaTeX error 10056         2026-06-09
#1139531 [for||sid]   (TU)   src:shared-mime-info shared-mime-info: FTBFS: LaTeX error 260470         2026-06-09
#1139271 [S]   (TU)   devscripts dcmd: Arbitrary code execution in `dcmd echo` 8915         2026-06-09
#1138816 [for||sid]   (TU)   src:nbclient nbclient: fails to build from source: testsuite failure 4296         2026-06-09
#1139807 [S|u]   (STU)   src:netty netty: CVE-2026-44892 CVE-2026-44890 CVE-2026-44250 CVE-2026-44249 755         2026-06-12
#1139914 [S|u]   (TU)   src:netty netty: CVE-2026-42577 CVE-2026-42578 CVE-2026-42579 CVE-2026-42580 CVE-2026-42581 CVE-2026-42582 CVE-2026-42583 CVE-2026-42584 CVE-2026-42585 CVE-2026-42586 CVE-2026-42587 CVE-2026-44893 CVE-2026-44894 CVE-2026-45416 CVE-2026-45536 CVE-2026-45673 CVE-2026-45674 CVE-2026-46340 CVE-2026-47244 CVE-2026-47691 CVE-2026-48006 CVE-2026-48043 CVE-2026-48059 CVE-2026-48748 CVE-2026-50009 CVE-2026-50010 CVE-2026-50011 CVE-2026-50020 CVE-2026-50560 755         2026-06-13
#1117120 [for|sid]   (TU)   src:db5.3 db5.3: should not be part of duke 137896         2026-06-18
#1136022 [S]   (ST)   src:jupyter-server jupyter-server: CVE-2025-61669 CVE-2026-40110 CVE-2026-35397 CVE-2026-40934 607         2026-06-23
#1131809   (STU)   src:dracut dracut: ppc64el autopkgtest are flaky and take 7 hours per run 136960         2026-06-30
#1135499 [for||sid]   (TUē)   src:imath imath: FTBFS: TypeError("argument of type '_CascadingStyleSheet' is not iterable") 86366         2026-07-03
#1139473 [for||sid]   (TU)   src:mariadb libdbd-mariadb-perl: FTBFS: error: 'Can't connect to local server through socket '/<<PKGBUILDDIR>>/t/tes' (2)' 115109         2026-07-08
#1139505 [for||sid]   (TU)   texlive-formats-extra gitmagic: FTBFS: LaTeX error 15743         2026-07-09
#1136400 [U|+]   (STU)   src:mimalloc mimalloc: riscv64: build-time MMU detection causes crashes on SV48 systems 7925         2026-07-09
#1133229   (T)   igt-gpu-tools-tests igt-gpu-tools-tests has an undeclared file conflict 4368         2026-07-12

Generated in 0.557 seconds.

select id, bugs.package, bugs.source, severity, title, last_modified, status, 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 deferred_closes)) 
and not (id in (select id from bugs_merged_with where id > merged_with)) 
and not (id in (select id from bugs_usertags where email='release.debian.org@packages.debian.org' and tag='bullseye-will-remove')) 
and not (id in (select id from bugs_usertags where email='release.debian.org@packages.debian.org' and tag='bullseye-can-defer')) 
and not (bugs.id in (select id from bugs_packages bp, testing_autoremovals ar where bp.source = ar.source)) 
and (current_timestamp - interval '30 days' > arrival) 
AND (severity >= 'serious')
order by last_modified asc