Greenhopper unavailable in new JIRA install; PluginUpgrader reports Upgrade failed attempting to migrate data from Labs ranking table...

I installed a new instance of JIRA just to demo Greenhopper, but, I have been unable to get Greenhopper to work. I get a banner on all JIRA pages GreenHopper is currently unavailable... and various exceptions thrown in the log, such as:

2011-10-28 13:27:15,768 main ERROR sal.core.upgrade.PluginUpgrader Upgrade failed: Attempting to migrate data from Labs ranking table to new ranking table, but new table already contains data.

com.atlassian.greenhopper.upgrade.UpgradeException: Attempting to migrate data from Labs ranking table to new ranking table, but new table already contains data.

at com.atlassian.greenhopper.upgrade.GhUpgradeTask012Dao.migrate(GhUpgradeTask012Dao.java:30)

at com.atlassian.greenhopper.upgrade.GhUpgradeTask012.performUpgrade(GhUpgradeTask012.java:35)

at com.atlassian.greenhopper.upgrade.AbstractGhUpgradeTask.doUpgrade(AbstractGhUpgradeTask.java:46)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

...

4 answers

0 votes
Dieter Community Champion Oct 28, 2011
To me this looks like the datasbase was not really empty when you restored the XML backup. Make sure ther exist no tables in the database when you restore your XML backup

I have the same issue.

I just encountered this problem as well. It's a problem with the Agile plugin upgrade. The Agile upgrade worked doing a 4.4->6.1 upgrade, but not 4.4->6.1.1.

It's a known problem and mentioned in the GreenHopper Knowledge database:

https://confluence.atlassian.com/display/GHKB/Attempting+to+migrate+data+from+Labs+ranking+table+to+new+ranking+table,+but+new+table+already+contains+data

Unfortunately, Postgres refused to allow me to remove the Active Objects (AO_*), so I had to bite the bullet and start over again. I'll try JIRA without Agile and then add the latest version of Agile from the plugin manager and hope for the best.

It would be intersting to hear if you managed to remove the active object tables and if that resolved it.

It would seem that my problem was that the Agile/GreenHopper plugin was interrupted during the upgrade. That cause all sorts of nasty side effects.

I restored everything and started from scratch (this was a UAT set-up). The Agile plugin upgrade happens in a background thread and took well over an hour in my case.

It all seems to work OK now, though.

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

890 views 5 18
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot