jira user attributes duplication

DIGIT CITnet

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;

returns

ID,user_id,directory_id,"attribute_name","attribute_value","lower_attribute_value"
7399929,1234,2,"login.count","39","39"
7399930,1234,2,"login.count","39","39"
7399923,1234,2,"login.currentFailedCount","0","0"
7399924,1234,2,"login.currentFailedCount","0","0"
5343116,1234,2,"login.lastFailedLoginMillis","1360315006292","1360315006292"
7399925,1234,2,"login.lastLoginMillis","1370423681199","1370423681199"
7399926,1234,2,"login.lastLoginMillis","1370423681201","1370423681201"
7399927,1234,2,"login.previousLoginMillis","1369815841774","1369815841774"
7399928,1234,2,"login.previousLoginMillis","1369815841774","1369815841774"
5343118,1234,2,"login.totalFailedCount","3","3"

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

Is-it a known bug?

bruno

DIGIT CITnet

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 ;-)

bruno