JIRA Has Been Locked: No enum constant com.atlassian.crowd.model.membership.MembershipType.GROUP USER
Symptoms
When trying to start JIRA, the homepage in the browser reports that JIRA has been locked.
The following appears in the atlassian-jira.log
:
No enum constant com.atlassian.crowd.model.membership.MembershipType.GROUP USER
Diagnosis
To diagnose if this is the issue affecting your JIRA, run the following query against your database:
SELECT DISTINCT membership_type FROM cwd_membership WHERE membership_type LIKE '% %';
This command must return an empty set. Substitute an underscore for a space in every membership_type returned.
Cause
This is caused by the use of an enumerator to store the membership values; the space is an invalid character in that position.
Resolution
Always back up your data before performing any modification to the database. If possible, try your modifications on a test server.
Substitute an underscore for a space in every membership_type returned in the previous query.