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:

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.