Xwiki had db connection issue and created duplicate users with underscore

Dear Team,

We are using Xwiki 11.10.3 version on our Ubuntu 18.04 instance.

Note - This Xwiki instance was migrated from an older version using XAR import/export and was working fine. All the passwords were kept same as old instance and were never changed after the setup.

We had following errors -

2020-04-20 12:17:05,381  ERROR o.x.c.l.XWikiLDAPConfig        - Error parsing LDAP fields mapping attribute from configuration, got [=]
2020-04-20 12:17:05,384 ERROR o.x.c.l.XWikiLDAPConfig        - Error parsing LDAP fields mapping attribute from configuration, got [=]
2020-04-20 12:17:05,433 WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1045, SQLState: 28000
2020-04-20 12:17:05,433 ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki'@'localhost' (using password: YES)

The password was not changed but hibernate file somehow had a different password that we did not put. Which is weird for us.

Also this kind of led xwiki to create duplicate users with underscore for ex - “user.test” which should have been the actual user and the duplicated user “user.test_1” which it kind of created or registered in the absence of db connection.

Is it possible that because lack of sql it creates a local DB somewhere ?

ERROR o.x.c.l.XWikiLDAPConfig - Error parsing LDAP fields mapping attribute from configuration, got [=]
The above error was fixed by deleting empty fields in the field mappings table in LDAP.

For the moment Xwiki works fine and we resolved the issue but not sure what cause the hibernate file to have changed.

Thanks,

Best Regards,
Maharshi