1052851 - add the ability to search by "assignee last login date"

Status: VERIFIED FIXED

(bugzilla.mozilla.org :: General, defect)

Description

[Dave Garrett]

Bug 444222 apparently got lost track of many years ago, yet for all that time it was still assigned to an account that hasn't been active since 2012-01-13. (based on Bugzilla profile info) It should be relatively easy to find other bugs like this.

I would like to request that all currently open bugs that have an assignee that has not been active for at least one year have their assignee reset to nobody and status changed from ASSIGNED to NEW or UNCONFIRMED if never confirmed. A QA contact reset might also be warranted. All applicable email notifications should still be sent.

Additionally, I would like to request that a list of these bugs be posted here so they can be triaged and closed, reassigned, or otherwise dealt with as needed.

Comment 1

[:glob ✱]

as different teams use bugzilla differently, making this sort of bulk change problematic and difficult to gain consensus on.  it's also a single-shot fix, and doesn't deal with this being an ongoing issue.


a better approach to this issue is to make it trivial to find any open bugs with an inactive assignee, enabling the component owners to update the bugs in bulk themselves.  morphing bug to indicate that.

Comment 2

[:glob ✱]

Attachment: 1052851_1.patch

Comment 3

[David Lawrence [:dkl]]

Comment on attachment 8472095 [details] [diff] [review]
1052851_1.patch

Review of attachment 8472095 [details] [diff] [review]:
-----------------------------------------------------------------

Nit (to fix on commit): I would prefer to change 'assignee_seen' to 'assignee_last_login' everywhere 
in the code as 'assignee_seen' makes me think "the last time the assignee saw the associated bug" where
in reality we are just looking at the last time a user accessed Bugzilla generally.

r=dkl

Comment 4

[David Lawrence [:dkl]]

(In reply to David Lawrence [:dkl] from comment #3)
> Comment on attachment 8472095 [details] [diff] [review]
> 1052851_1.patch
> 
> Review of attachment 8472095 [details] [diff] [review]:
> -----------------------------------------------------------------
> 
> Nit (to fix on commit): I would prefer to change 'assignee_seen' to
> 'assignee_last_login' everywhere 
> in the code as 'assignee_seen' makes me think "the last time the assignee
> saw the associated bug" where
> in reality we are just looking at the last time a user accessed Bugzilla
> generally.
> 
> r=dkl

Forgot to say:

Otherwise looks good and worked as expected. r=dkl

Comment 5

[:glob ✱]

To ssh://[e-mail]/webtools/bmo/bugzilla.git
   cdf7ace..747f1f1  master -> master

Comment 6

[:glob ✱]

this is now live.

here's a query which shows "Core" bugs where the assignee hasn't logged in to bugzilla this year: http://mzl.la/1AQRLpC

Comment 7

[Dave Garrett]

(In reply to Byron Jones ‹:glob› from comment #6)
> this is now live.
> 
> here's a query which shows "Core" bugs where the assignee hasn't logged in
> to bugzilla this year: http://mzl.la/1AQRLpC

It looks like it's counting the default assignees as users for the search. (e.g. bug 367833 is in that list, but its assignee is [e-mail]) This search really needs to filter out those default assignees.

Comment 8

[:glob ✱]

(In reply to Dave Garrett from comment #7)
> It looks like it's counting the default assignees as users for the search.
> (e.g. bug 367833 is in that list, but its assignee is [e-mail]) This
> search really needs to filter out those default assignees.

the default assignee for the xforms component is [e-mail], however excluding all .bugs users should help with those older bugs:

http://mzl.la/1wo3yuQ (currently returns 255 fewer bugs).

Comment 9

[Dave Garrett]

(In reply to Byron Jones ‹:glob› from comment #8)
> the default assignee for the xforms component is [e-mail], however
> excluding all .bugs users should help with those older bugs:
> 
> http://mzl.la/1wo3yuQ (currently returns 255 fewer bugs).

That's a notable improvement, thanks.

It looks like restricting the search to only assigned bugs gives a far more manageable list.

http://mzl.la/1qJPmgg (currently returns 449 bugs)

The ability to search for this is quite helpful to have, but it looks like some additional human work will be required to search through the bugs where people just dropped them because they were legitimately deprioritized and didn't mark it as such.

I think my initial suggestion of just mass changing them turns out to be not viable in light of this new information as lots of those just need to be closed out as obsolete. There's way more dropped assigned bugs in the system than I suspected.

In any case, this new feature appears to work as intended. Thanks. V. Fixed.