java.sql.SQLException: Schema change failed on object
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
While accessing JIRA or Greenhopper, user gets the following error message and is not able to proceed further
The following appears in the atlassian-jira.log:
1
2
java.sql.SQLException: Schema change failed on object '[jiraschema].[AO_60DB71_COLUMN]'. Possibly due to active snapshot or other schema change activity.
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:47)Cause
Most likely there is something else running on the database because of which JIRA has problems reading the database.
Resolution
Please check the database and stop any other service (database replication) or application that is using the same database. It is also recommended to restart the database.
Was this helpful?