{"id":525,"date":"2010-08-02T17:40:06","date_gmt":"2010-08-02T15:40:06","guid":{"rendered":"http:\/\/www.lucas-nussbaum.net\/blog\/?p=525"},"modified":"2010-08-05T06:12:51","modified_gmt":"2010-08-05T04:12:51","slug":"ubuntu-bugs-with-patches-on-the-pts-and-the-qa-packages-overview","status":"publish","type":"post","link":"https:\/\/www.lucas-nussbaum.net\/blog\/?p=525","title":{"rendered":"Ubuntu bugs with patches on the PTS and the QA Packages Overview"},"content":{"rendered":"<p>Like the Debian BTS, Launchpad is full of open bugs with patches[1]. They have an ongoing effort called <a href=\"https:\/\/wiki.ubuntu.com\/OperationCleansweep\">Operation Cleansweep<\/a> whose goal is to get the number of bugs with patches to zero, by reviewing patches and forwarding them upstream or to Debian.<\/p>\n<p>Since it really makes sense to expose bugs with patches to the Debian maintainers, I&#8217;ve modified the Ubuntu box on the Packages Tracking System and the Ubuntu column on the QA Packages Overview (hidden by default for now) to include that information. You can see the result on <a href=\"http:\/\/packages.qa.debian.org\/d\/dpkg.html\">the dpkg PTS page<\/a> and <a href=\"http:\/\/qa.debian.org\/developer.php?login=debian-dpkg@lists.debian.org\">the debian-pkg@ packages overview page<\/a>.<\/p>\n<p>Many thanks to <a href=\"http:\/\/murraytwins.com\/blog\/\">Brian Murray<\/a> for making this possible on the Launchpad side.<\/p>\n<hr \/>\n<p>[1] Debian has 55115 open bugs affecting unstable, of which 4011 have a patch. Ubuntu has 76916 open bugs, of which 2207 have a patch. [Insert here disclaimer that this is not at all a judgement of value on the abilities of any distribution at triaging bugs, or at generating patches]<br \/>\nRelevant UDD queries:<\/p>\n<pre>select count(*) from bugs\r\nwhere affects_unstable and status = 'pending'\r\nand id in (select id from bugs_tags where tag ='patch');\r\n\r\nselect count(*) from bugs\r\nwhere affects_unstable and status = 'pending';\r\n\r\nselect count(distinct bugs.bug)\r\nfrom ubuntu_bugs_tasks tasks,ubuntu_bugs bugs\r\nwhere tasks.bug = bugs.bug\r\nand distro in ('', 'Ubuntu')\r\nand status not in ('Invalid', 'Fix Released', 'Won''t Fix')\r\nand bugs.patches is true;\r\n\r\nselect count(distinct bugs.bug)\r\nfrom ubuntu_bugs_tasks tasks,ubuntu_bugs bugs\r\nwhere tasks.bug = bugs.bug\r\nand distro in ('', 'Ubuntu')\r\nand status not in ('Invalid', 'Fix Released', 'Won''t Fix');<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Like the Debian BTS, Launchpad is full of open bugs with patches[1]. They have an ongoing effort called Operation Cleansweep whose goal is to get the number of bugs with patches to zero, by reviewing patches and forwarding them upstream or to Debian. Since it really makes sense to expose bugs with patches to the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"0","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,12],"tags":[],"class_list":["post-525","post","type-post","status-publish","format-standard","hentry","category-planetdebian","category-planetubuntu"],"_links":{"self":[{"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/525","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=525"}],"version-history":[{"count":4,"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/525\/revisions"}],"predecessor-version":[{"id":533,"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/525\/revisions\/533"}],"wp:attachment":[{"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}