{"id":312,"date":"2008-09-24T10:33:55","date_gmt":"2008-09-24T08:33:55","guid":{"rendered":"http:\/\/www.lucas-nussbaum.net\/blog\/?p=312"},"modified":"2008-09-24T10:33:55","modified_gmt":"2008-09-24T08:33:55","slug":"cool-stats-about-debian-bugs","status":"publish","type":"post","link":"https:\/\/www.lucas-nussbaum.net\/blog\/?p=312","title":{"rendered":"Cool stats about Debian bugs"},"content":{"rendered":"

Now that bug #500000<\/a> has been reported, let’s have a look at all our other bugs, using UDD<\/a>.<\/p>\n

Number of archived bugs:<\/p>\n

select count(*) from archived_bugs;\r\n count  \r\n--------\r\n 402826<\/pre>\n
Number of unarchived bugs marked done:<\/p>\n
select count(*) from bugs where status = 'done';\r\n count \r\n-------\r\n  8267<\/pre>\n
Status of unarchived bugs (“pending” doesn’t mean “tagged pending” here):<\/p>\n
select status, count(*) from bugs group by status;\r\n    status     | count \r\n---------------+-------\r\n pending       | 53587\r\n pending-fixed |  1195\r\n forwarded     |  6778\r\n done          |  8267\r\n fixed         |   167<\/pre>\n
The sum isn’t even close to 500000. That’s because quite a lot of bugs disappeared:<\/p>\n
select id from bugs union select id from archived_bugs order by id limit 10;\r\n id  \r\n-----\r\n 563\r\n 660\r\n 710\r\n 725\r\n 740\r\n 773\r\n 775\r\n 783\r\n 817\r\n 819<\/pre>\n
Now, let’s look at our open bugs.
\nOldest open bugs:<\/p>\n
select id, package, title, arrival from bugs where status != 'done' order by id limit 10;\r\n  id  |    package     |                                   title                                    |       arrival       \r\n------+----------------+----------------------------------------------------------------------------+---------------------\r\n  825 | trn            | trn warning messages corrupt thread selector display                       | 1995-04-22 18:33:01\r\n 1555 | dselect        | dselect per-screen-half focus request                                      | 1995-10-06 15:48:04\r\n 2297 | xterm          | xterm: xterm sometimes gets mouse-paste and RETURN keypress in wrong order | 1996-02-07 21:33:01\r\n 2298 | trn            | trn bug with shell escaping                                                | 1996-02-07 21:48:01\r\n 3175 | xonix          | xonix colors bad for colorblind                                            | 1996-05-31 23:18:04\r\n 3180 | linuxdoc-tools | linuxdoc-sgml semantics and formatting problems                            | 1996-06-02 05:18:03\r\n 3251 | acct           | accounting file corruption                                                 | 1996-06-12 17:44:10\r\n 3773 | xless          | xless default window too thin and won't go away when asked nicely          | 1996-07-14 00:03:09\r\n 4073 | make           | make pattern rules delete intermediate files                               | 1996-08-08 20:18:01\r\n 4448 | dselect        | [PERF] dselect performance gripe (disk method doing dpkg -iGROEB)          | 1996-09-09 03:33:05<\/pre>\n
Breakdown by severity:<\/p>\n
select severity, count(*) from bugs where status != 'done' group by severity;\r\n severity  | count \r\n-----------+-------\r\n normal    | 27680\r\n important |  7606\r\n minor     |  6921\r\n wishlist  | 18898\r\n critical  |    29\r\n grave     |   209\r\n serious   |   384<\/pre>\n
Top 10 submitters for open bugs:<\/p>\n
select submitter, count(*) from bugs where status != 'done' group by submitter order by count desc limit 10;\r\nsubmitter                      | count \r\n----------------------------------------------------+-------\r\n Dan Jacobson                  |  1455\r\n martin f krafft                |   667\r\n Raphael Geissert                |   422\r\n Joey Hess                        |   392\r\n Marc Haber            |   368\r\n Julien Danjou                     |   342\r\n Josh Triplett                |   331\r\n Vincent Lefevre                |   296\r\n jidanni@jidanni.org                                |   260\r\n Justin Pryzby  |   245<\/pre>\n
Top bugs reporters ever:<\/p>\n
select submitter, count(*) from (select * from bugs union select * from archived_bugs) as all_bugs\r\ngroup by submitter order by count desc limit 10;\r\n                  submitter                   | count \r\n----------------------------------------------+-------\r\n Martin Michlmayr             |  4279\r\n Dan Jacobson            |  3652\r\n Daniel Schepler  |  3045\r\n Joey Hess                  |  2836\r\n Lucas Nussbaum     |  2701\r\n Andreas Jochens                |  2605\r\n Matthias Klose         |  2442\r\n Christian Perrier        |  2302\r\n James Troup                |  2198\r\n Matt Zimmerman               |  2027<\/pre>\n
You want more data? Connect to UDD (from master.d.o or alioth.d.o, more info here<\/a>), run your own queries, and post them with the results in the comments!<\/p>\n","protected":false},"excerpt":{"rendered":"
Now that bug #500000 has been reported, let’s have a look at all our other bugs, using UDD. Number of archived bugs: select count(*) from archived_bugs; count ——– 402826 Number of unarchived bugs marked done: select count(*) from bugs where status = ‘done’; count ——- 8267 Status of unarchived bugs (“pending” doesn’t mean “tagged pending” […]<\/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,7],"tags":[],"class_list":["post-312","post","type-post","status-publish","format-standard","hentry","category-planetdebian","category-planetubuntu","category-technology"],"_links":{"self":[{"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/312","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=312"}],"version-history":[{"count":0,"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/312\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lucas-nussbaum.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}