We recently had an issue where our LDAP directory simply disappeared from Jira. When we added it back, all of the users federated through it were left with usernames of "username#1" rather than "username".
Before LDAP directory deletion:
jira=# select * from app_user where user_key = 'username';
id | user_key | lower_user_name
-------+----------+-----------------
10000 | username | username
After LDAP directory deletion and recreation:
jira=# select * from app_user where user_key = 'username';
id | user_key | lower_user_name
-------+----------+-----------------
10000 | username | username#1
This has left all Jira issues, watchers, comments, etc. attributed to the "username#1" user, which is now an invalid Jira user. Has anyone experienced anything similar to this and if so, what was the fix?
Thanks!