How do I remove a user with the name 'unassigned' from my system?

Sometime in the past, our administrators turned "allow unassigned issues" off. Time passed, but the people clamored for unassigned issues. In their short-sightedness, new administrators, instead of turning the setting back on, created an "Unassigned" user (with the username "unassigned").

Fast-forward and the Unassigned user has 1000s of issues assigned. A benevolent administrator is trying to return to allowing properly unassigned tickets. I was able to bulk edit and change the assignment. But, the Unassigned user's "username" is the same as the special username for tickets that are properly unassigned.

I cannot remove the Unassigned user because it appears, to JIRA, to perpetually have tickets assigned to it!


For anyone else dealing with the same:

I marked the Unassigned user "inactive" so it couldn't be assigned. I changed it's name to "nobody", which helped to see (in some searches) that it really wasn't used. I changed all projects where it was the default-assigned Project Lead to use unassigned properly.

2 answers

Hi Anthony,

Thanks for sharing this experience with us. Indeed a user cannot be removed when it still has issues created on his username, so it's possible that there is, still something locking it.

I suggest you to check on your database for this user (nobody) and see where it is still set, specially on the tables related to issues such as jiraissue.

Here is the Jira Database Schema:

PS: Instead of checking each table, creating a database dump and then analyzing it as text, should help on looking for this user in all tables at once.

I'm certain that the user has no more tickets assigned. I bulk changed 1000s of tickets today. The fake-unassigned user's profile still shows all of these tickets! I just assigned a new ticket to the built-in unassigned and this fake-unassigned user's ticket count increased!

The problem seems to be in the username (field) or the assignee (search field). It's literally "unassigned" for both my user and the built-in user that JIRA uses for unassigned tickets.

0 votes

Hello Anthony,

After running this bulk change, did you have the chance to run a full locked re-index?

Please run this and let us know if the indexing of the issues bulk-changed appears correct.

Thanks for the tip, Benito. I'm on an old JIRA and have to trigger the reindex manually, cross my fingers, and hope it comes back overnight :)

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,097 views 4 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you