[Libreoffice-qa] Stats I plotted + Getting rid of bugs

[Florian Reisinger]

Hi!

I frequently proposed, that we should ping people: "Check it with latest 
version, or we leave the bug closed..."

So here the PDF: https://www.box.com/s/tj9r79uphr3ls26fv4lt (Made with 
MS Office 2010 because I had difficulties with LibreOffice)

IMHO we should ping every bug submitter with bugs on the following 
versions and ask the ones with "Unspecified" to set the versions field 
to the oldest version, where the bug occured.. (See query link):
https://bugs.freedesktop.org/buglist.cgi?bug_severity=blocker&bug_severity=critical&bug_severity=major&bug_severity=normal&bug_severity=minor&bug_severity=trivial&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=REOPENED&bug_status=NEEDINFO&list_id=156430&product=LibreOffice&query_format=advanced&version=unspecified&version=3.3.0%20Beta2&version=3.3.0%20Beta3&version=3.3.0%20RC1&version=3.3.0%20RC2&version=3.3.0%20RC3&version=3.3.0%20RC4&version=3.3.0%20release&version=3.3.1%20RC1&version=3.3.1%20release&version=3.3.2%20RC1&version=3.3.2%20RC2&version=3.3.2%20release&version=3.4.0%20Beta1&version=3.4.0%20Beta2&version=3.4.0%20Beta3&version=3.4.0%20Beta4&version=3.4.0%20Beta5&version=3.4.0%20RC1&version=3.3.3%20release&version=3.4.0%20release&version=3.4.1%20RC1&version=3.4.1%20RC2&version=3.4.1%20release&version=3.4%20Daily&version=Master%20old%20%20-3.6&version=3.4.2%20RC1&version=3.4.2%20RC2&version=3.4.2%20release&version=3.3.4%20release&version=3.4.3%20RC1&version=3.4.3%20release&version=3.4.4%20RC1&version=3.4.4%20release&version=3.5.0%20Beta0&version=3.5.0%20Beta1&version=3.4.5%20RC1&version=3.5.0%20Beta2&version=3.4.5%20release&version=3.5.0%20Beta3&version=3.5.0%20RC1&version=3.5.0%20RC2&version=3.5.1%20RC1&version=3.4.6%20release&version=3.5%20Daily&version=3.5.2%20RC1&version=3.5.3%20RC1&version=3.5.4%20RC1&version=3.6.0.0.alpha1&version=3.6.0.0.beta1&version=3.5.5.1%20rc&version=3.6.0.0.beta2&version=3.5.5.2%20rc&version=3.6.0.0.beta3&version=3.6.0.1%20rc&version=3.6.0.2%20rc&version=3.6.0.3%20rc&version=3.5.6.1%20rc&version=3.6.1.1%20rc&version=3.6.2.1%20rc&version=3.5.7.1%20rc&order=bug_id%20DESC&limit=0

All in all: 2790

or, the older ones: 
https://bugs.freedesktop.org/buglist.cgi?bug_severity=blocker&bug_severity=critical&bug_severity=major&bug_severity=normal&bug_severity=minor&bug_severity=trivial&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=REOPENED&bug_status=NEEDINFO&list_id=156429&product=LibreOffice&query_format=advanced&version=unspecified&version=3.3.0%20Beta3&version=3.3.0%20RC1&version=3.3.0%20RC2&version=3.3.0%20RC3&version=3.3.0%20RC4&version=3.3.0%20release&version=3.3.1%20RC1&version=3.3.1%20release&version=3.3.2%20RC1&version=3.3.2%20RC2&version=3.3.2%20release&version=3.4.0%20Beta1&version=3.4.0%20Beta2&version=3.4.0%20Beta3&version=3.4.0%20Beta4&version=3.4.0%20Beta5&version=3.4.0%20RC1&version=3.3.3%20release&version=3.4.0%20release&version=3.4.1%20RC1&version=3.4.1%20RC2&version=3.4.1%20release&version=3.4%20Daily&version=Master%20old%20%20-3.6&version=3.4.2%20RC1&version=3.4.2%20RC2&version=3.4.2%20release&version=3.3.4%20release&version=3.4.3%20RC1&version=3.4.3%20release&version=3.4.4%20RC1&version=3.4.4%20release&version=3.5.0%20Beta0&order=bug_id%20DESC&limit=0

All in all: 2138

Or, at least this ones: 
https://bugs.freedesktop.org/buglist.cgi?bug_severity=blocker&bug_severity=critical&bug_severity=major&bug_severity=normal&bug_severity=minor&bug_severity=trivial&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=REOPENED&bug_status=NEEDINFO&list_id=156428&product=LibreOffice&query_format=advanced&version=unspecified&version=3.3.0%20Beta3&version=3.3.0%20RC1&version=3.3.0%20RC2&version=3.3.0%20RC3&version=3.3.0%20RC4&version=3.3.0%20release&version=3.3.1%20RC1&version=3.3.1%20release&version=3.3.2%20RC1&version=3.3.2%20RC2&version=3.3.2%20release&version=3.4.0%20Beta1&version=3.4.0%20Beta2&version=3.4.0%20Beta3&version=3.4.0%20Beta4&version=3.4.0%20Beta5&version=3.4%20Daily&version=Master%20old%20%20-3.6&version=3.5.0%20Beta0&version=3.5.0%20Beta1&version=3.5.0%20Beta2&version=3.5.0%20Beta3&version=3.5%20Daily&version=3.6.0.0.alpha1&version=3.6.0.0.beta1&version=3.6.0.0.beta2&version=3.6.0.0.beta3&order=bug_id%20DESC&limit=0

All in all: 1258

Or at least (my favorite search): 
https://bugs.freedesktop.org/buglist.cgi?f1=days_elapsed&list_id=156433&o1=greaterthan&chfieldto=-6m&query_format=advanced&chfield=bug_status&chfieldfrom=2000-01-01&chfieldvalue=NEEDINFO&bug_status=NEEDINFO&v1=17&product=LibreOffice

Currently: 123

To cut it short: There are a lot of undead bugs @ bugzilla. IMHO the 
best thing would be the following: Take the top query (2790 bugs) and 
the bottom one (123 bugs) and change the state automatically every month 
to RESOLVED INVALID (or any other status) and comment a message that 
encourages people to do testing... ( with &limit=1 it should be possible 
to change "only" 500 per month...) One problem: Someone (or a ML) has to 
be in CC (I prefer a shared mailaccount, because you don't have double 
work, when dropping resolved things to Trash, but I know that's 
impossible :( ) So any ideas how to get these numbers down, or do you 
think these numbers are not important??

Yours

Florian