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

Bugs search

Useful queries for testing (trixie)

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 buster
  • packages not in bullseye
  • packages not in bookworm
  • packages not in trixie
  • packages in base system
  • packages in standard installation
  • orphaned packages
  • merged bugs
  • marked as done
  • outdated binaries in buster
  • outdated binaries in bullseye
  • outdated binaries in bookworm
  • outdated binaries in trixie
  • outdated binaries in sid
  • different versions in trixie and sid
  • newer in Ubuntu than in sid
  • RT tag for buster: ignore
  • RT tag for buster: will-remove
  • RT tag for buster: can-defer
  • RT tag for buster: is-blocker
  • RT tag for buster: no-auto-remove
  • RT tag for buster: pu
  • 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 unblock hint
  • RT blocked
  • 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

8 bugs found

bug# tags releases package title missing builds in unstable autoremoval deferred modified
#1042051 [exp||sid|tri]   (TUē)   src:sqlalchemy 1042051 sqlalchemy: FTBFS: Could not import extension sphinxcontrib.jquery (exception: No module named 'sphinxcontrib') -   2023-09-26
#1052747 [exp||sid|tri]   (TUē)   src:ortp 1052747 ortp: FTBFS: b64.h:293: error: unable to resolve link to 'b64::b64_encode2' for \link command (warning treated as error, aborting now) -   2023-10-19
#929685 [+]   (TU)   ca-certificates-java 929685 ca-certificates-java,default-jre-headless,openjdk-11-jre-headless: get rid of the circular dependency -   2023-12-03
#1064563   (TUē)   libstd-rust-1.70 1064563 libstd-rust-1.70 has an undeclared file conflict -   2024-03-04
#1000112 [U|+]   (TUē)   src:kjs 1000112 kjs: depends on obsolete pcre3 library -   2024-03-18
#1052841 []   (TUē)   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 -   2024-03-22
#1059068   (TUē)   libsvtav1enc1d1 1059068 apt: fails to resolve dependencies -   2024-03-23
#1068068 [|sid|tri]   (TU)   src:icmake, src:bobcat 1068068 Need rebootstrapping on armel and armhf -   2024-04-07

Generated in 6.418 seconds.

select id, bugs.package, bugs.source, severity, title, last_modified, status, affects_stable, affects_testing, affects_unstable, affects_experimental , coalesce(testing_autoremovals.removal_time, 0) as autormdate , coalesce(testing_autoremovals.removal_time, 1745884254) as autormtime , coalesce(mb, '-') as missingbuilds
from bugs  left join testing_autoremovals on (bugs.source = testing_autoremovals.source)  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) 
where id in (select id from bugs_rt_affects_testing) and id in (select id from bugs_rt_affects_unstable) 
and not (id in (select id from bugs_merged_with where id > merged_with)) 
and status = 'done' 
and (current_timestamp - interval '5 days' > last_modified) 
AND (severity >= 'serious')
order by last_modified asc