jira user attributes duplication

We use Jira 5.2.11 and Crowd 2.6.4. Jira delegates the user management to Crowd.

Our jira instance have duplicated records within the table cwd_user_attributes.

SELECT * FROM cwd_user_attributes WHERE user_id = 1234;



As you can see, we have multiple entries for some attributes!

Is-it a known bug?


5 answers

Hi Norman,

Thanks for your reply but in my case, it is something different.

Our jira contains 2 directory: the internal one and crowd.

SELECT DISTINCT directory_id FROM cwd_user_attributes;

returns 1 and 2 thus it is not linked with a deleted direcory :-(

Something else ;-)


Did you check for user names with a space at the end?

Your query does not look correct for detecting removed directories. Try this query if I am correct.

select * from cwd_user_attributes where directory_id not in (select id from cwd_directory);

Any results means you have deleled entries.

The join between cwd_user and cwd_user_attribute is done via the userid and not the username.

It's perhaps a good idea to have a constrain based on userid, directory_id and attribute_name

Understand, but we are not looking for missing users but missing directory records.

If you get back records then you have missing directory entries. If you do not get back records then you have users defined with multiple directories which could be a different problem.

select * from cwd_user_attributes where directory_id not in (select id from cwd_directory);

does not return any record.

Hmm, There are some issues with crowd creating duplicate entries but those issues require existing Jira users with the same name or users in multiple directories. Your ID values does not suggest that behavior.

The ID is the cwd_user_attribute primary key.

The problem is that we have more than one record for some attribute. For example, it is not good to have 2 'login.count' attributes for the same userid within the same directory_id.

Another interesting example shows 0 or 1 millisecond differences for the lastLoginMillis attribute:

"attribute_name"	"attribute_value"
"login.count"	"14"
"login.count"	"14"
"login.count"	"14"
"login.count"	"14"
"login.currentFailedCount"	"0"
"login.currentFailedCount"	"0"
"login.currentFailedCount"	"0"
"login.currentFailedCount"	"0"
"login.currentFailedCount"	"0"
"login.lastLoginMillis"	"1369910894581"
"login.lastLoginMillis"	"1369910894582"
"login.lastLoginMillis"	"1369910894582"
"login.lastLoginMillis"	"1369910894582"
"login.lastLoginMillis"	"1369910894583"
"login.previousLoginMillis"	"1369910894518"
"login.previousLoginMillis"	"1369910894518"
"login.previousLoginMillis"	"1369910894518"
"login.previousLoginMillis"	"1369910894518"

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,296 views 14 20
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot