Cool stats about Debian bugs

September 24th, 2008 by lucas

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” here):

select status, count(*) from bugs group by status;
    status     | count 
---------------+-------
 pending       | 53587
 pending-fixed |  1195
 forwarded     |  6778
 done          |  8267
 fixed         |   167

The sum isn’t even close to 500000. That’s because quite a lot of bugs disappeared:

select id from bugs union select id from archived_bugs order by id limit 10;
 id  
-----
 563
 660
 710
 725
 740
 773
 775
 783
 817
 819

Now, let’s look at our open bugs.
Oldest open bugs:

select id, package, title, arrival from bugs where status != 'done' order by id limit 10;
  id  |    package     |                                   title                                    |       arrival       
------+----------------+----------------------------------------------------------------------------+---------------------
  825 | trn            | trn warning messages corrupt thread selector display                       | 1995-04-22 18:33:01
 1555 | dselect        | dselect per-screen-half focus request                                      | 1995-10-06 15:48:04
 2297 | xterm          | xterm: xterm sometimes gets mouse-paste and RETURN keypress in wrong order | 1996-02-07 21:33:01
 2298 | trn            | trn bug with shell escaping                                                | 1996-02-07 21:48:01
 3175 | xonix          | xonix colors bad for colorblind                                            | 1996-05-31 23:18:04
 3180 | linuxdoc-tools | linuxdoc-sgml semantics and formatting problems                            | 1996-06-02 05:18:03
 3251 | acct           | accounting file corruption                                                 | 1996-06-12 17:44:10
 3773 | xless          | xless default window too thin and won't go away when asked nicely          | 1996-07-14 00:03:09
 4073 | make           | make pattern rules delete intermediate files                               | 1996-08-08 20:18:01
 4448 | dselect        | [PERF] dselect performance gripe (disk method doing dpkg -iGROEB)          | 1996-09-09 03:33:05

Breakdown by severity:

select severity, count(*) from bugs where status != 'done' group by severity;
 severity  | count 
-----------+-------
 normal    | 27680
 important |  7606
 minor     |  6921
 wishlist  | 18898
 critical  |    29
 grave     |   209
 serious   |   384

Top 10 submitters for open bugs:

select submitter, count(*) from bugs where status != 'done' group by submitter order by count desc limit 10;
submitter                      | count 
----------------------------------------------------+-------
 Dan Jacobson                  |  1455
 martin f krafft                |   667
 Raphael Geissert                |   422
 Joey Hess                        |   392
 Marc Haber            |   368
 Julien Danjou                     |   342
 Josh Triplett                |   331
 Vincent Lefevre                |   296
 jidanni@jidanni.org                                |   260
 Justin Pryzby  |   245

Top bugs reporters ever:

select submitter, count(*) from (select * from bugs union select * from archived_bugs) as all_bugs
group by submitter order by count desc limit 10;
                  submitter                   | count 
----------------------------------------------+-------
 Martin Michlmayr             |  4279
 Dan Jacobson            |  3652
 Daniel Schepler  |  3045
 Joey Hess                  |  2836
 Lucas Nussbaum     |  2701
 Andreas Jochens                |  2605
 Matthias Klose         |  2442
 Christian Perrier        |  2302
 James Troup                |  2198
 Matt Zimmerman               |  2027

You want more data? Connect to UDD (from master.d.o or alioth.d.o, more info here), run your own queries, and post them with the results in the comments!

17 Responses to “Cool stats about Debian bugs”

  1. Lior Kaplan wrote on 09/24/08 at 11:36 am :

    About “Top 10 submitters for open bugs”: jidanni@jidanni.org belongs to Dan Jacobson, so he has much more bugs than seems to be.

  2. Vývojáři opravili 410 000 chyb z 500 000 (Debian-linux.cz) wrote on 10/9/08 at 12:59 pm :

    [...] 500000. V diskusi se mě jeden čtenář ptal, kolik z těchto chyb bylo opraveno. Lucas Nussbaum vydal statistiky, které se tímto problémem zabývají: Z půl milionu nahlášených problémů jich bylo [...]

  3. Linuxeando & familia - Debian llega al medio millón de bugs reportados wrote on 10/17/08 at 12:21 am :

    [...] Nussbaum ofrecie varias estadísticas interesantes. Entre ellos, el hecho de que de los 500,000 bugs, cerca de 410,000 han sido [...]

  4. Debian llega al medio millon de bugs reportados « La Casa de Tux wrote on 10/18/08 at 2:51 am :

    [...] Nussbaum ofrece varias estadísticas interesantes. Entre ellos, el hecho de que de los 500,000 bugs, cerca de 410,000 han sido [...]

  5. chhiwat choumicha 2011 wrote on 01/30/11 at 10:29 pm :

    Nice blog/really great job.thanks man for sharing

  6. fokaha wrote on 02/3/11 at 1:47 pm :

    Generally I don’t like to let my footprint on websites.but your post is really nice that I feel that I must thank you.Really great work

  7. adsense tricks wrote on 02/6/11 at 5:16 am :

    You have a great blog.I like the way you work.thanks for posting about this subject

  8. purificateur d'air wrote on 02/13/11 at 5:30 pm :

    I love your blog very much.you have a nice style.thanks for posting this article

  9. rwinamix wrote on 02/20/11 at 6:27 am :

    I like your topic .it is interesting for me.it provides nice infos so I’ bookmarked it.thank you for sharing this one

  10. rwinamix 2011 wrote on 02/27/11 at 3:05 pm :

    I really like your topic and appreciate your work.it is so interesting for me because it provides nice infos so I’ bookmarked it.thank you for sharing this topic

  11. clickbank products for free wrote on 03/6/11 at 1:32 pm :

    I am cb receipt.I feel very lucky to discover your blog.I really appreciate your hard work.thank you very much for posting about this.

  12. rwina wrote on 03/13/11 at 5:05 am :

    Great and very instructive post.thanksss for sharing this nice topic man

  13. Blackhat Marketing Tools wrote on 03/19/11 at 1:14 pm :

    I don’t quite understand what you mean exactly by implementing RSS. Could you go into detail about what you’re looking for?

  14. jersey shore season wrote on 03/27/11 at 12:01 pm :

    this one is a great story thanks for publishing

  15. 89 maroc wrote on 04/10/11 at 1:36 pm :

    I appreciate the work you do in this site.thanks for sharing this informative post

  16. chhiwate choumicha wrote on 04/12/11 at 9:57 pm :

    I find that your blog is really fantastic. Im very lucky to discover this site.great work and keep on posting

  17. adsense tricks wrote on 06/25/11 at 2:47 am :

    thanks admin
    nice blog great document!!!
    great effort thanks for sharing
    Medyum Niyazi