Shadow directory id in cwd_user database

[Vladimir Omelchenko]

Hello,

I am just curious if someone knows about the shadow directory which is not showing in the user directories section while I can see it in database and some users there are included in groups and are being shows in "Project Roles list" like inactive which is the correct behaviour but in Crowd these users were removed from all groups and must not be shown in JIRA, still I am able to "administer" this user in JIRA.

Selects are showing something like:

select * from cwd_user where directory_id=10000 and active=1 and user_name='test@test.com'\G
*************************** 1. row ***************************
ID: 12956
directory_id: 10000
user_name: test@test.com
lower_user_name: test@test.com
active: 1
created_date: 2011-11-18 15:51:42
updated_date: 2011-11-18 15:51:42
first_name: test
lower_first_name: test
last_name: test
lower_last_name: test
display_name: Atest
lower_display_name: test
email_address: test@test.com
lower_email_address: test@test.com
CREDENTIAL: nopass
1 row in set (0.00 sec)

select * from cwd_membership where directory_id=10000 and child_name='asavchenko@geeksforless.net' order by lower_child_name desc\

*************************** 1. row ***************************
ID: 13142
parent_id: 10218
child_id: 11956
membership_type: GROUP_USER
group_type: NULL
parent_name: jira-users
lower_parent_name: jira-users
child_name: test@test.com
lower_child_name: test@test.com
directory_id: 10000
*************************** 2. row ***************************
ID: 14982
parent_id: 10218
child_id: 12956
membership_type: GROUP_USER
group_type: NULL
parent_name: jira-users
lower_parent_name: jira-users
child_name: test@test.com
lower_child_name: test@test.com
directory_id: 10000
*************************** 3. row ***************************
ID: 15973
parent_id: 10310
child_id: 12956
membership_type: GROUP_USER
group_type: NULL
parent_name: confluence-users
lower_parent_name: confluence-users
child_name: test@test.com
lower_child_name: test@test.com
directory_id: 10000
*************************** 4. row ***************************
ID: 16056
parent_id: 10217
child_id: 12956
membership_type: GROUP_USER
group_type: NULL
parent_name: jira-QA
lower_parent_name: jira-qa
child_name: test@test.com
lower_child_name: test@test.com
directory_id: 10000
4 rows in set (0.00 sec)

The main concern is that I have only two directories ids I am aware of 1 - JIRA local, 10100 - Crowd Directory.

Does anyone know if these records can be removed or maybe they are used by something?

Thank you in advance.

[Tiago Comasseto · Accepted solution]

Hi Vladimir,

There is a know bug with this description (https://jira.atlassian.com/browse/JRA-27437), it occurs when you delete an user directory and some orphan entries are kept into the database.

There is also this KB article that explain a known issue that those orphan entries can cause. You may follow the instructions at the resolution section of the KB and remove those entries.

I hope it helps

Cheers

[Vladimir Omelchenko]

Thank you, Tiago. I was able to remove the retired users using the KB Aricle that you have provided.