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.

ソリューション

データベースの変更を行う場合は 必ず事前にバックアップを取得してください。可能な場合はテスト サーバーで変更を試すことをおすすめします。

  1. Shutdown JIRA instance;
  2. 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'
  3. Update the table propertystring with build number '589' using the following statement;

     UPDATE propertystring SET propertyvalue = '589' WHERE id = <ID_from_previous_query>
  4. Restart JIRA;

(info) 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.

最終更新日: 2016 年 2 月 26 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.