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!
0 bugs found
| bug# | tags | releases | package | title | popcon | hints | missing builds in unstable | deferred | RT | last upload to unstable | modified |
|---|
Generated in 0.659 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(key_packages.reason, '') as whykey, 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 key_packages on (bugs.source = key_packages.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) 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 not (id in (select id from deferred_closes))
and not (id in (select id from bugs_merged_with where id > merged_with))
and not (status = 'done')
and id in (select id from bugs_usertags where email='release.debian.org@packages.debian.org' and tag='bullseye-is-blocker')
AND (severity >= 'serious')
order by id asc