JIRA Agile upgrade fail due to parse error

Related content

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

While upgrading JIRA Agile the following appears in the atlassian-jira.log:

2013-06-14 21:01:06,227 main INFO      [com.atlassian.greenhopper.upgrade] =========================================
2013-06-14 21:01:06,227 main INFO      [com.atlassian.greenhopper.upgrade] Starting upgrade task (buildNumber=15) : Migrating Sprint data from PropertySets back into AO
2013-06-14 21:01:09,096 main ERROR      [net.java.ao.sql] Exception executing SQL update <ALTER TABLE public."AO_60DB71_COLUMNSTATUS" ALTER COLUMN "COLUMN_ID" TYPE BIGINT>
org.postgresql.util.PSQLException: ERROR:  parser: parse error at or near "TYPE" at character 70

Cause

This error is caused by JIRA running on unsupported database server or database version. See our Supported Platforms.

Resolution

  1. Rollback JIRA to a point prior the upgrade

  2. Move JIRA to a supported database server or upgrade the current one to a supported version

  3. Upgrade JIRA Agile
Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article

Related content

Powered by Confluence and Scroll Viewport.