How to deactivate the sonar user

SonarQube
1

HI Team
I have logged as admin and tried to deactivate the user from sonar Qube UI, but i got the below error
An error has occurred. Please contact your administrator

When i try using api url to deactivate as admin user. I saw below error from the log.
curl -k -X POST -v -u admin ‘https://URL/api/users/deactivate?login=XXXXX’

Caused by: org.postgresql.util.PSQLException: ERROR: Cannot run UPDATE or DELETE on table groups_users because it does not have primary key.
Hint: Add primary key to the table

Please help me resolve it

SONARQUBE: Version 6.7 (build 33306) - [LGPL v3]

2

Hi Sankar,

Version 6.7 is not supported anymore, and I would therefore recommend you to upgrade at least to 7.9 LTS, which is the current stable Long Term Support version. Aside of many new features, this version fixes several bugs since 6.7 that may be causing your problem. You may alternatively decide upgrading to 8.4.1, which is the latest version.

3

Hi Daniel,

Any other workaround in this version not to login back as sonar user instead of deactivate the User