JIRA Fails to Start due to Invalid Database Configuration
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
JIRA fails to start, either after configuring a database or improper shutdown. The following appears in the logs:
1
2
3
4
5
6
7
8
Caused by: java.lang.UnsupportedOperationException: Database is locked
at org.ofbiz.core.entity.LockedDatabaseGenericDelegator.findByAnd(LockedDatabaseGenericDelegator.java:168)
at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getKeys(OFBizPropertySet.java:87)
at com.opensymphony.module.propertyset.AbstractPropertySet.getKeys(AbstractPropertySet.java:292)
at com.atlassian.jira.propertyset.PropertySetCache.bulkLoad(PropertySetCache.java:301)
at com.atlassian.jira.propertyset.JiraCachingPropertySet.init(JiraCachingPropertySet.java:834)
at com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:45)
at com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:22)
Cause
There are multiple causes for this issue. If installing a new database, entityengine.xml may be configured incorrectly. Alternatively, in rarer circumstances, the database may require repair.
Resolution
JIRA is locked. See Archive "JIRA has been locked" error when starting Jira Server or Data Center.
Check
entityengine.xml. Refer to the database-specific guide from Connecting JIRA to a Database.If it's accurate, check your database vendor's guide on repairing tables. For example, see the MySQL guide for table repair.
Was this helpful?