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 vote
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 Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Sarah Schuster
Posted Mar 28, 2018 in Jira Software

Can a company’s culture make or break agile adoption?

Can a new-to-agile team survive and thrive in a non-agile culture? If so, what advice would you give to those trying to be agile in a non-agile culture? What's the key(s) to success? Share your thoug...

12,641 views 15 13
Join discussion

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