Can't login after restoring a backup

Related content

  • No related content found

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

After restoring backup to upgrade JIRA, no one can login.

The following appears in the atlassian-jira.log during the upgrade:

2011-08-16 07:50:28,720 JiraImportTaskExecutionThread-1 INFO admin 469x52x1 1fkxwcc 10.1.2.247 /secure/admin/XmlRestore.jspa [atlassian.jira.upgrade.UpgradeManagerImpl] Performing Upgrade Task: Converting Users and Groups to new structure for Crowd Embedded.
2011-08-16 07:50:28,727 JiraImportTaskExecutionThread-1 WARN admin 469x52x1 1fkxwcc 10.1.2.247 /secure/admin/XmlRestore.jspa [jira.upgrade.tasks.UpgradeTask_Build602] Group not migrated. Group: xxx. Error: Duplicate entry 'xxx-1' for key 2
2011-08-16 07:50:28,734 JiraImportTaskExecutionThread-1 ERROR admin 469x52x1 1fkxwcc 10.1.2.247 /secure/admin/XmlRestore.jspa [atlassian.jira.upgrade.UpgradeManagerImpl] Errors during Upgrade Task: Converting Users and Groups to new structure for Crowd Embedded.
2011-08-16 07:50:28,735 JiraImportTaskExecutionThread-1 ERROR admin 469x52x1 1fkxwcc 10.1.2.247 /secure/admin/XmlRestore.jspa [atlassian.jira.upgrade.UpgradeManagerImpl] Errors occurred during upgrade:
2011-08-16 07:50:28,735 JiraImportTaskExecutionThread-1 ERROR admin 469x52x1 1fkxwcc 10.1.2.247 /secure/admin/XmlRestore.jspa [atlassian.jira.upgrade.UpgradeManagerImpl] Upgrade Error: JIRA is unable to migrate the User Group: 'xxx' because there is another group with the same name, that differs only by case.<br/>You need to resolve the duplicates before upgrading JIRA. Please see <a href="http://docs.atlassian.com/jira/docs-044/Upgrading+JIRA">Upgrading JIRA</a> for details.
...
___ Database Statistics ____________________

     Issues                                        : 1256
     Projects                                      : 24
     Custom Fields                                 : 8
     Workflows                                     : 1
     Users                                         : 0
     Groups                                        : 26
     Attachments                                   : 375
     Comments                                      : 2139

Cause

Upgrade fail due to duplicate group name which cause the import to stop migrating users to the new user management.

Resolution

  1. Rollback the database to the previous version

  2. Search for the duplicate group:

     SELECT * FROM groupbase WHERE groupname='xxx';
  3. Delete one of the duplicate group
  4. Restart JIRA
  5. Create a new backup
  6. Perform the XML import for upgrade
Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article

Related content

  • No related content found
Powered by Confluence and Scroll Viewport.