Inconsistencies in Users_UserGroups can be generated if import groups from LDAP is active

• Type: Bug
• Status: Verified
• Resolution: Unresolved
• Affects Version/s: 6.2.5 CE GA6, 6.2.10 EE GA1, 6.2.X EE
• Fix Version/s: None
• Component/s: Application Security > LDAP, Core Infrastructure > Transaction Management
• Labels:
  • ee-6.2.x-only
  • ee-ts
• Fix Priority: 3

Steps to reproduce it:

1. Create a user in the LDAP
2. Create a group whose name is higher than 75 characters in the LDAP (use 200 characters when LPS-74808 is solved)
3. Associate that user to the previous created group in the LDAP.
4. Startup Liferay
5. Enable LDAP authentication
6. Login with the previous user
7. Logout
8. Login again with the previous user

Results:
You won't be able to login and the following query will return results (this indicates that an inconsistency was created):
{quote}select * from users_usergroups uug where uug.usergroupid not in (select usergroupid from usergroup);{quote}

Expected results:
You will be able to login and the previous results won't return records.