Our JIRA instance is connected to an LDAP server. For some reason we have duplicate users in the cwd_users table (one is asociated with the LDAP directory and the other with the Internal Directory). I tried deleting the Internal users by making the Internal Directory the primary but it won't allow me to delete it... I'm assuming because it shares the same username as the LDAP user which has Issues associated with it. What are the implications if I manually do a SQL delete to remove the internal users?
One side effect we've noticed thus far is if you go to edit an Issue that has the deleted user as the Reporter, Assignee, Watcher, etc., it will state that the user is no longer valid and you'll have to remove/update the user before you can save the changes to the Issue.
Given the fact that this is the same behavior that occurs when you simply delete a user from LDAP, we're willing to live with it. :)
I tried to delete manually some issues directly from the jira database, and i didn't have errors (after reindex).
I guess it could be the same for the cwd_users table.
If you try it, go back here to tell us if you crashed your jira or not :)
PS : I can advise you to make a dump of your database. If you destroy by deleting users manually, you will be able to import the previous data from this dump.
Good Day, Bad bad traffic, not sure why!!!! 1/2 hour commute took me 2 hours today 🤯 What helped me is that I kept browsing LinkedIn until...
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!
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