Bugs search
Useful queries for testing (trixie)
- BSP view (bugs needing attention): Old bugs affecting sid and trixie, not RT-tagged and not marked for auto-removal
- Sponsor view: Affecting sid and trixie, not marked as done, tagged 'patch', not in delayed; those need a DD to review and sponsor an upload or remove the tag
- Cleaner view: Marked as done, no activity in the last 5 days, but still affecting sid and trixie; why is it still affecting unstable? fixed only in stable or experimental? missing binaries? cruft? wrong changelog?
- Release Team view: Fixed in sid, no activity in the last 5 days, but still not fixed in trixie. Help the fix migrate to trixie!
69 bugs found
bug# | tags | releases | package | title | popcon | hints | britney status | missing builds in unstable | why key pkg | autoremoval | deferred | RT | last upload to unstable | modified |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
# |
[sid|tri] | (T) | 🔑 src:hypercorn | 1057351 src:hypercorn: fails to migrate to testing for too long: new Dependency not in testing | 25 | build-depends | - | quart build-depends python3-hypercorn | out-of-sync | 2024-01-11 | 2023-12-03 | |||
# |
[sid|tri] | (T) | 🔑 src:terminado | 1060780 src:terminado: fails to migrate to testing for too long: autopkgtest regression | 3592 | autopkgtest 1064694 | - | jupyter-server build-depends python3-terminado | out-of-sync | 2023-12-14 | 2024-01-14 | |||
# |
(Tē) | 🔑 mesa-vdpau-drivers | 1059782 mesa-vdpau-drivers: Upgrade to 23.3.* breaks video rendering in tkinter | 150116 | build-depends | - | gtk+3.0 build-depends libegl1-mesa-dev | 2024-04-25 | 2024-02-01 | |||||
# |
(T) | 🔑 python3-ipywidgets | 1063908 node-jupyter-widgets-{base,base-manager,control}: ships files already in python3-widgetsnbextension | 3355 | autopkgtest missingbuild age 4/5 1065662 | all | matplotlib build-depends python3-ipywidgets | 2024-05-01 | 2024-02-23 | |||||
# |
(T) | 🔑 src:libreoffice | 1064776 bogusly redirects Bugs to debian-openoffice@lists.debian.org instead of the BTS | 105899 | force-badtest force-badtest force-badtest force-badtest | autopkgtest age 4/5 | - | gnome depends libreoffice-calc | 2024-05-02 | 2024-02-27 | ||||
# |
[sid|tri] | (T) | 🔑 src:glslang | 1065324 src:glslang: fails to migrate to testing for too long: unresolved RC bug and autopkgtest failure | 664 | autopkgtest 1062799 | - | ffmpeg build-depends glslang-dev | out-of-sync | 2024-04-17 | 2024-03-02 | |||
# |
[sid|tri] | (T) | 🔑 src:pytables | 1065412 src:pytables: fails to migrate to testing for too long: old s390x binary left around | 4908 | autopkgtest missingbuild build-depends | s390x | pandas build-depends python3-tables | out-of-sync | 2024-04-07 | 2024-03-04 | |||
# |
[⛺|+] | (T) | 🔑 src:tracker | 1061464 tracker FTBFS with nocheck profile: ../meson.build:99:26: ERROR: python3 is missing modules: gi | 63103 | force-badtest force-badtest | age 3/5 1068468 | - | gnome-core depends tracker | 2024-05-02 | 2024-03-08 | |||
# |
[⛺|sid|tri] | (T) | 🔑 src:pycryptodome | 1052336 src:pycryptodome: fails to migrate to testing for too long: FTBFS nearly everywhere | 31315 | missingbuild 1069534 | armel, mips64el | impacket build-depends python3-pycryptodome | out-of-sync | 2024-01-11 | 2024-03-09 | |||
# |
[⛺] | (T) | 🔑 src:cfengine3 | 1057420 cfengine3: FTBFS: dh_install: warning: cfengine3 missing files: debian/tmp/lib/systemd | 609 | missingbuild 1068665 | armel, armhf, riscv64 | debian-edu-config depends cfengine3 | 2024-03-12 | 2024-03-12 | ||||
# |
[⛺] | (T) | 🔑 src:webkit2gtk | 1066411 webkit2gtk: FTBFS due to several undefined references | 89143 | depends | - | libproxy build-depends libjavascriptcoregtk-4.1-dev | 2024-04-09 | 2024-03-14 | ||||
# |
[⛺|sid|tri] | (T) | 🔑 src:shaderc | 1058397 shaderc: FTBFS: SpirvIntrinsics.h:120:10: error: âvariantâ in namespace âstdâ does not name a template type | 222 | built-using | - | gst-plugins-bad1.0 build-depends glslc | 2024-03-17 | 2024-03-17 | ||||
# |
[⛺|sid|tri] | (T) | 🔑 src:nas | 1066237 nas: FTBFS: main.c:125:9: error: implicit declaration of function âyyparseâ [-Werror=implicit-function-declaration] | 109540 | missingbuild | mips64el | speech-dispatcher-audio-plugins depends libaudio2 | 2024-03-17 | 2024-03-17 | ||||
# |
[U|S|u] | (ST) | 🔑 src:openvswitch | 1063492 openvswitch: CVE-2023-3966: Invalid memory access in Geneve with HW offload | 858 | autopkgtest age 4/5 | - | netplan.io build-depends openvswitch-switch | 2024-05-02 | 2024-03-18 | ||||
# |
[U|+] | (T) | 🔑 src:kjs | 1000112 kjs: depends on obsolete pcre3 library | 31705 | autopkgtest age 1/5 | - | okular build-depends libkf5kjs-dev | 2024-05-04 | 2024-03-18 | ||||
# |
[⛺] | (T) | 🔑 src:kcontacts | 1052841 kcontacts: FTBFS: dh_auto_test: error: cd obj-x86_64-linux-gnu && make -j1 test ARGS\+=--verbose ARGS\+=-j1 returned exit code 2 | 32266 | age 1/5 | - | akonadiconsole build-depends libkf5contacts-dev | 2024-05-04 | 2024-03-22 | ||||
# |
[⛺|+] | (TE) | 🔑 src:scalapack | 1066328 scalapack: FTBFS: igsum2d_.c:154:7: error: implicit declaration of function âBI_imvcopyâ; did you mean âBI_zmvcopyâ? [-Werror=implicit-function-declaration] | 2475 | autopkgtest | - | petsc build-depends libscalapack-mpi-dev | 2024-03-30 | 2024-03-30 | ||||
# |
(T) | 🔑 libreoffice-writer-nogui | 1058653 libreoffice-writer-nogui: fails to convert ODT to PDF without libreoffice-core (libcuilo.so): Error: source file could not be loaded | 105899 | force-badtest force-badtest force-badtest force-badtest | autopkgtest age 4/5 | - | gnome depends libreoffice-calc | 2024-05-02 | 2024-04-06 | ||||
# |
[⛺|sid|tri] | (T) | 🔑 src:click | 1066308 click: FTBFS: clickpreload.c:422:16: error: implicit declaration of function â__fxstatâ; did you mean â__xstatâ? [-Werror=implicit-function-declaration] | 92 | autopkgtest | - | python-whey build-depends python3-click-package | 2024-03-20 | 2024-04-07 | ||||
# |
(T) | 🔑 bluez | 1060795 bluez: Troubles with bluetooth after upgrade from bookworm to testing (trixie): br-connection-unknown | 116945 | autopkgtest | - | brltty build-depends libbluetooth-dev | 2024-04-11 | 2024-04-11 | |||||
# |
[exp|⛺|sid|tri] | (T) | src:gap | 1068756 gap: FTBFS: failing tests | 854 | autopkgtest | - | 2024-05-24 | 2024-04-25 | 2024-04-11 | ||||
# |
[⛺] | (T) | 🔑 src:libreoffice | 1068609 libreoffice: FTBFS on arrmhf: testContentGnumeric assertion failed,- Expression: xServiceInfo->supportsService("com.sun.star.sheet.SpreadsheetDocument") | 105899 | force-badtest force-badtest force-badtest force-badtest | autopkgtest age 4/5 | - | gnome depends libreoffice-calc | 2024-05-02 | 2024-04-11 | |||
# |
[⛺] | (T) | 🔑 r-base-dev | 1066403 r-base-dev: missing dependency on libtirpc-dev | 6563 | autopkgtest | - | rpy2 build-depends r-base-dev | 2024-04-26 | 2024-04-11 | ||||
# |
[+] | (T) | camv-rnd | 1068811 camv-rnd: hardcoded librnd4 dependency | 55 | depends | - | 2024-05-25 | 2024-04-12 | 2024-04-12 | ||||
# |
[⛺|sid|tri] | (T) | 🔑 src:kalzium | 1057565 kalzium: FTBFS: linking error | 3059 | - | kdeedu depends kalzium | 2024-04-13 | 2024-04-14 | |||||
# |
[⛺] | (T) | src:zfs-linux | 1067088 zfs-linux: missing B-D: libtirpc-dev | 7377 | remove | reverseremoval | - | 2024-04-30 | 2024-04-15 | 2024-04-15 | |||
# |
[⛺|sid|tri] | (T) | 🔑 src:libxcb | 1064702 libxcb: FTBFS: KeyError: 'xcb_report_level_t' | 235513 | 1069408 | - | d-i | 2024-04-19 | 2024-04-19 | ||||
# |
[⛺] | (T) | 🔑 src:haskell-hourglass | 1068696 haskell-hourglass FTBFS on armel and armhf | 616 | PASS | - | haskell-tls build-depends libghc-hourglass-dev | 2024-04-19 | 2024-04-19 | ||||
# |
(T) | src:spectrwm | 1068203 spectrwm: hard-coded dependency on pre-t64 library | 78 | depends | - | 2024-05-06 | 2024-04-21 | 2024-04-21 | |||||
# |
[⛺|sid|tri] | (T) | src:r-cran-tmb | 1069364 r-cran-tmb: FTBFS on arm64: dpkg-gencontrol: error: parsing package 'r-cran-tmb' Depends field: r-api-4.0, r-base-core (>= ii r-base-core 4.3.3-3+b1 arm64 GNU R core of statistical computation and graphics system) , , , r-cran-matrix (>= 1.6-5-1), r-cran-matrix, r-cran-rcppeigen, | 389 | autopkgtest | - | 2024-06-03 | 2024-04-24 | 2024-04-24 | ||||
# |
[⛺|sid|tri] | (T) | src:r-cran-openmx | 1069388 r-cran-openmx: FTBFS on arm64: dpkg-gencontrol: error: parsing package 'r-cran-openmx' Depends field: r-api-4.0, r-base-core (>= ii r-base-core 4.3.3-3+b1 arm64 GNU R core of statistical computation and graphics system) , , , r-cran-digest, r-cran-mass, r-cran-matrix (>= 1.6-5-1), r-cran-rcpp, r-cran-rcppparallel, r-cran-lifecycle, r-cran-rcpp, r-cran-rcppeigen (>= 0.3.3.9.4), r-cran-rcppparallel, r-cran-stanheaders (>= 2.10.0.2), r-cran-bh (>= 1.69.0-1), r-cran-rpf (>= 0.45), r-cran-matrix, | 21 | depends | - | 2024-06-03 | 2024-04-24 | 2024-04-24 | ||||
# |
[⛺|sid|tri] | (T) | src:r-cran-irlba | 1069414 r-cran-irlba: FTBFS on arm64: dpkg-gencontrol: error: parsing package 'r-cran-irlba' Depends field: r-api-4.0, r-base-core (>= ii r-base-core 4.3.3-3+b1 arm64 GNU R core of statistical computation and graphics system) , , r-cran-matrix (>= 1.6-5-1), , r-cran-matrix, | 981 | depends | - | 2024-06-03 | 2024-04-24 | 2024-04-24 | ||||
# |
[⛺|sid|tri] | (T) | src:r-cran-seuratobject | 1069352 r-cran-seuratobject: FTBFS on arm64: dpkg-gencontrol: error: parsing package 'r-cran-seuratobject' Depends field: r-api-4.0, r-base-core (>= ii r-base-core 4.3.3-3+b1 arm64 GNU R core of statistical computation and graphics system) , , r-cran-sp (>= 1.5.0), r-cran-future, r-cran-future.apply, r-cran-matrix (>= 1.6-5-1), r-cran-progressr, r-cran-rcpp (>= 1.0.5), r-cran-rlang (>= 0.4.7), r-cran-spam, r-cran-lifecycle, r-cran-generics, r-cran-rcpp, r-cran-rcppeigen, | 37 | depends | - | 2024-06-03 | 2024-04-24 | 2024-04-24 | ||||
# |
[⛺|sid|tri] | (T) | src:sslh | 1069381 sslh: FTBFS on arm64: cat: /tmp/bZv3B_U_mJ/sslh.pid: No such file or directory | 219 | autopkgtest missingbuild | i386, mips64el, ppc64el | 2024-05-19 | 2024-04-26 | 2024-04-26 | ||||
# |
[⛺|sid|tri] | (T) | 🔑 src:pylint | 1066755 pylint: FTBFS: dh_auto_test: error: pybuild --test --test-pytest -i python{version} -p "3.12 3.11" returned exit code 13 | 4755 | autopkgtest implicit-deps | - | cloud-init build-depends pylint | 2024-04-27 | 2024-04-27 | ||||
# |
[⛺|sid|tri] | (T) | src:cbmc | 1069438 cbmc: FTBFS on armhf: make[4]: *** [Makefile:13: test] Error 1 | 24 | age 6/7 | - | 2024-05-19 | 2024-04-30 | 2024-04-29 | ||||
# |
[⛺|+|sid|tri] | (T) | src:rxtx | 1066703 rxtx: FTBFS: SerialImp.c:5453:23: error: implicit declaration of function âmajorâ [-Werror=implicit-function-declaration] | 4516 | autopkgtest missingbuild 1070417 | arm64, armel, armhf, mips64el, ppc64el, riscv64, s390x | 2024-05-31 | 2024-05-01 | 2024-05-01 | ||||
# |
[exp|⛺|+|sid|tri] | (Tē) | 🔑 src:lib2geom | 1051980 FTBFS on i386: angle-test/bezier-test fail | 13024 | age 4/5 | - | inkscape build-depends-arch lib2geom-dev | 2024-05-01 | 2024-05-01 | ||||
# |
[⛺|sid|tri] | (T) | src:waylandpp | 1070062 waylandpp: Missing build-depends libwayland-egl1-mesa | 1951 | age 4/5 | - | 2024-05-01 | 2024-05-01 | |||||
# |
[⛺] | (T) | 🔑 src:haskell-pandoc | 1070015 haskel-pandoc: FTBFS on armel: Couldn't match expected type: WriterState -> m a | 11047 | urgent | age 4/5 | - | pandoc build-depends libghc-pandoc-dev | 2024-05-01 | 2024-05-01 | |||
# |
[⛺|sid|tri] | (T) | src:python-zeep | 1070116 python-zeep: Build-depends on NBS libraries libxmlsec1 and libxmlsec1-openssl | 582 | age 4/5 | - | 2024-05-02 | 2024-05-02 | |||||
# |
[⛺] | (T) | src:prometheus-process-exporter | 1070053 prometheus-process-exporter: FTBFS: cannot use status.UIDs[1] (variable of type uint64) as string value in argument to strconv.ParseInt | 56 | built-using | - | 2024-05-02 | 2024-05-02 | |||||
# |
[⛺] | (TE) | src:netavark | 1069350 netavark: FTBFS: dh_auto_test: error: /usr/share/cargo/bin/cargo build returned exit code 101 | 3066 | age 3/5 | - | 2024-06-03 | 2024-05-02 | 2024-05-02 | ||||
# |
[⛺] | (T) | 🔑 src:mtd-utils | 1065956 mtd-utils: FTBFS on arm{el,hf}: FAIL mtdlib_test (exit status: 17) | 2603 | age 3/5 | - | flash-kernel depends mtd-utils | 2024-05-02 | 2024-05-02 | ||||
# |
(T) | 🔑 src:libayatana-appindicator | 1070246 libayatana-appindicator version of Debian package does not match the upstream version | 93609 | age 3/5 | riscv64 | network-manager-applet build-depends libayatana-appindicator3-dev | 2024-05-02 | 2024-05-02 | |||||
# |
[⛺] | (T) | dh-ada-library | 1068209 libgtkada: FTBFS on all: dh_ada_library: error: debian/tmp/usr/lib/x86_64-linux-gnu/ada/adalib/gtkada/*.ali are missing | 22 | depends | - | 2024-06-02 | 2024-05-02 | 2024-05-03 | ||||
# |
[u] | (T) | src:bibledit-cloud | 1070273 bibledit-cloud: The current version currently has partially broken javascript | 6 | age 3/5 | - | 2024-05-03 | 2024-05-03 | |||||
# |
[u] | (T) | src:bibledit | 1070274 bibledit: The current version currently has partially broken javascript | 35 | age 3/5 | - | 2024-05-03 | 2024-05-03 | |||||
# |
[exp|⛺|sid|tri] | (T) | 🔑 src:python-kubernetes | 1058350 python-kubernetes: FTBFS: make[1]: *** [debian/rules:17: override_dh_auto_test] Error 1 | 354 | age 3/5 | - | ceph-mgr-k8sevents depends python3-kubernetes | 2024-05-03 | 2024-05-03 | ||||
# |
[⛺] | (T) | src:python-pybedtools | 1068960 python-pybedtools: FTBFS: testsuite error: 14 failed, 491 passed, 2 deselected, 3 xfailed | 44 | age 2/5 | - | 2024-06-02 | 2024-05-03 | 2024-05-03 | ||||
# |
[boo|⛺|sid|tri|u] | (ST) | dm-writeboost-dkms | 1069878 dm-writeboost-dkms: kernel module fails to build for Linux 6.7.12: error: too few arguments to function âdm_ioâ | 8 | autopkgtest age 1/5 | - | 2024-06-09 | 2024-05-05 | 2024-05-04 | ||||
# |
[⛺|sid|tri] | (T) | src:lua-sec | 1069369 lua-sec: FTBFS on arm64: ld: cannot find -lz: No such file or directory | 1585 | age 2/5 | - | 2024-06-03 | 2024-05-04 | 2024-05-04 | ||||
# |
[C|+] | (ST) | src:libnet-frame-device-perl | 1070334 libnet-frame-device-perl needs network access during build | 44 | age 1/2 | - | 2024-05-04 | 2024-05-04 | |||||
# |
[⛺] | (T) | 🔑 src:gobject-introspection | 1066032 pygobject: FTBFS on armhf: time_t build test failure | 157973 | autopkgtest age 1/5 | - | pango1.0 build-depends gir1.2-cairo-1.0-dev provided by gir1.2-freedesktop-dev | 2024-05-04 | 2024-05-04 | ||||
# |
(T) | 🔑 gobject-introspection | 1066900 g-ir-compiler: generates incorrect typelib when cross-compiling with different type sizes | 157973 | autopkgtest age 1/5 | - | pango1.0 build-depends gir1.2-cairo-1.0-dev provided by gir1.2-freedesktop-dev | 2024-05-04 | 2024-05-04 | |||||
# |
[+|S|u] | (STE) | 🔑 src:ruby-rack | 1064516 ruby-rack: CVE-2024-26141 CVE-2024-25126 CVE-2024-26146 | 2807 | autopkgtest age 1/2 | - | thrift build-depends ruby-rack | 2024-05-04 | 2024-05-04 | ||||
# |
(TE) | 🔑 src:qt6-tools | 1061205 qt6-tools: Please upgrade to llvm-toolchain-18 | 2599 | autopkgtest age 1/5 | - | cppcheck-gui depends libqt6help6 | 2024-05-04 | 2024-05-04 | |||||
# |
(T) | openssh-client-ssh1 | 1070403 does not start because of an "OpenSSL version mismatch" | 265 | age 1/5 | - | 2024-05-04 | 2024-05-04 | ||||||
# |
(ST) | 🔑 php-composer-pcre | 1070423 php-composer-pcre: missing Breaks+Replaces: composer (<< 2.2) | 1735 | autopkgtest age 1/5 | - | composer build-depends php-composer-pcre | 2024-05-05 | 2024-05-05 | |||||
# |
(T) | 🔑 gcovr | 1070172 Built from wrong version (3.2 instead of 7.2) | 263 | age 0/5 | - | meson build-depends gcovr | 2024-05-05 | 2024-05-05 | |||||
# |
(T) | 🔑 bin86, elks-libc | 1070428 bin86,elks-libc: copyright file missing (policy 12.5) | 1132 | age 0/5 | - | mbr build-depends bin86 | 2024-05-05 | 2024-05-05 | |||||
# |
(T) | src:nginx | 1069997 nginx: NGX_MODULE_SIGNATURE has changed on 32-bit t64 architectures, but the ${nginx:abi} substvar has not | 22525 | autopkgtest age implicit-deps piuparts 0/5 | - | 2024-06-05 | 2024-05-05 | 2024-05-05 | |||||
# |
[+|sid|tri] | (T) | src:xneur | 999922 xneur: depends on obsolete pcre3 library | 53 | age 0/5 | - | 2024-06-04 | 2024-05-05 | 2024-05-05 | ||||
# |
[S|u] | (ST) | 🔑 src:gdcm | 1070387 gdcm: CVE-2024-25569 CVE-2024-22373 CVE-2024-22391 | 16419 | urgent | autopkgtest age 0/2 | - | opencv build-depends libgdcm-dev | 2024-05-05 | 2024-05-05 | |||
# |
[⛺] | (Tē) | src:dino-im | 1070457 dino-im: FTBFS: error: âstruct _gpgme_keyâ has no member named âsubkeys_length1â | 539 | age 0/5 | - | 2024-05-05 | 2024-05-05 | |||||
# |
[exp|⛺|sid|tri] | (T) | src:adns | 1065725 adns: FTBFS on arm{el,hf}: FAILED ./case-1stservbroken - WRONG OUTPUT - lines of syscall remaining 0 | 1340 | autopkgtest age 0/5 | - | 2024-06-04 | 2024-05-05 | 2024-05-05 | ||||
#1069482 | [⛺|sid|tri] | (T) | nginx | 1069482 libnginx-mod-http-lua: FTBFS on armhf: module "/usr/share/nginx/modules/ndk_http_module.so" is not binary compatible | 22525 | autopkgtest age implicit-deps piuparts 0/5 | - | 2024-06-05 | 2024-05-05 | 2024-05-06 | ||||
#1069437 | [⛺|sid|tri] | (T) | nginx | 1069437 libnginx-mod-http-set-misc: FTBFS on armhf: make: *** [debian/rules:6: binary] Error 25 | 22525 | autopkgtest age implicit-deps piuparts 0/5 | - | 2024-06-05 | 2024-05-05 | 2024-05-06 | ||||
#1069525 | [⛺|sid|tri] | (T) | nginx | 1069525 libnginx-mod-http-srcache-filter: FTBFS on armhf: make: *** [debian/rules:6: binary] Error 25 | 22525 | autopkgtest age implicit-deps piuparts 0/5 | - | 2024-06-05 | 2024-05-05 | 2024-05-06 |
Generated in 3.314 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, coalesce(testing_autoremovals.removal_time, 0) as autormdate , coalesce(testing_autoremovals.removal_time, 1746531112) as autormtime , coalesce(key_packages.reason, '') as whykey, coalesce(migration_excuses.migration_policy_verdict, '') as britney, migration_excuses.reason as excuse_reason, (migration_excuses.policy_info::json#>>'{age,current-age}')::int as currentage, (migration_excuses.policy_info::json#>>'{age,age-requirement}')::int as agerequirement, (array(select json_array_elements_text(migration_excuses.policy_info::json#>'{rc-bugs,unique-source-bugs}'))) as newbugs, migration_excuses.policy_info , coalesce(mb, '-') as missingbuilds, to_char(lastupload_s,'YYYY-MM-DD') as lastupload from bugs left join popcon_src on (bugs.source = popcon_src.source) left join testing_autoremovals on (bugs.source = testing_autoremovals.source) left join key_packages on (bugs.source = key_packages.source) left join migration_excuses on (bugs.source = migration_excuses.item_name) left join ( select string_agg(distinct(wannabuild.architecture),', ' order by wannabuild.architecture) mb, source from wannabuild where distribution='sid' and not vancouvered and notes='out-of-date' and state not in ('Installed') group by source ) as wb on (bugs.source = wb.source) left join ( select max(date) lastupload_s, s1.source from sources s1, upload_history uh where s1.source = uh.source and s1.version = uh.version and s1.release='sid' group by s1.source ) as lu on (bugs.source = lu.source) where id in (select id from bugs_rt_affects_testing) and id not in (select id from bugs_rt_affects_unstable) and not (id in (select id from bugs_merged_with where id > merged_with)) AND (severity >= 'serious') order by last_modified asc