Can't login after restoring a backup
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
After restoring backup to upgrade JIRA, no one can login.
The following appears in the atlassian-jira.log during the upgrade:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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
Rollback the database to the previous version
Search for the duplicate group:
1SELECT * FROM groupbase WHERE groupname='xxx';Delete one of the duplicate group
Restart JIRA
Create a new backup
Perform the XML import for upgrade
Was this helpful?