User and groups are not migrated to the new cwd tables upon upgrade
症状
While upgrading JIRA from a version prior 4.3 to a newer version, users and groups are not migrated to the new Crowd embedded tables (cwd_*) causing the login to fail.
No specific errors appear in the atlassian-jira.log
原因
The root cause of this issue is usually related to a previous failed upgrade and the database was not totally restored to the original state before the upgrade attempt.
ソリューション
データベースの変更を行う場合は 必ず事前にバックアップを取得してください。可能な場合はテスト サーバーで変更を試すことをおすすめします。
- Shutdown JIRA instance;
Execute this query and take note of the 'id' value;
SELECT * FROM propertyentry e, propertystring n WHERE e.id = n.id AND e.property_key = 'jira.version.patched'Update the table propertystring with build number '589' using the following statement;
UPDATE propertystring SET propertyvalue = '589' WHERE id = <ID_from_previous_query>- Jira を再起動します
If JIRA is integrated to LDAP, be sure that the osuser.xml file which contain the LDAP settings is located into '$JIRA_INSTALL/atlassian-jira/WEB-INF/classes' before restart the instance.