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: gitlab-foss@40e125820c96326e0aadd9457466b6be97142399
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
issue