Could not authenticate you from Ldapmain

Hello Team,

 One of the user is facing issue to login with below error.

Could not authenticate you from Ldapmain because “Pg::uniqueviolation: error: duplicate key value violates unique constraint “index user synced attributes metadata on user id” detail: key (user id)=(780) already exists. : insert into “user synced attributes metadata” (“user id”, “email synced”, “provider”) values (780, ‘t’, ‘ldapmain’) returning “id”“.

User was able to login till Jan 20th 2020. After that user went for vacation and 10 days back he tried to access gitlab instance to login with ldap login credentials. But it is not allowing to login with this error. Other users are able to login in the instance.

We checked database side also there is no duplicate id. select id,email,username,last_sign_in_at,last_activity_on from users where username like 'raushank-in'; id | email | username | last_sign_in_at | last_activity_on -----+---------------------+-------------+-------------------------------+------------------ 780 | xxxxxxx@xx.xxx.com | xxxxxxx-in | 2020-01-20 06:19:54.659237+00 | 2020-03-31 (1 row)

Any idea why only one user is getting problem? How can i fix this issue?

gitlab-rake gitlab:env:info

System information System: RedHatEnterpriseServer 6.10 Current User: git Using RVM: no Ruby Version: 2.3.6p384 Gem Version: 2.6.13 Bundler Version:1.13.7 Rake Version: 12.3.0 Redis Version: 3.2.11 Git Version: 2.14.3 Sidekiq Version:5.0.5 Go Version: unknown

GitLab information Version: 10.5.8 Revision: 40e12582 Directory: /opt/gitlab/embedded/service/gitlab-rails DB Adapter: postgresql URL: https://xxxxxxxx.xx.xxx.xxx.com HTTP Clone URL: https://xxxxxxxx.xx.xxx.xxx.com/some-group/some-project.git SSH Clone URL: git@xxxxxxx.xx.xxx.xxx.xxx:some-group/some-project.git Using LDAP: yes Using Omniauth: no

GitLab Shell Version: 6.0.3 Repository storage paths:

• default: /var/opt/gitlab/git-data/repositories Hooks: /opt/gitlab/embedded/service/gitlab-shell/hooks Git: /opt/gitlab/embedded/bin/git