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

This widget could not be displayed.
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
This widget could not be displayed.

I have the same issue.

This widget could not be displayed.

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.

This widget could not be displayed.

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
Community showcase
Published Apr 22, 2018 in Jira Software

How-to setup a secured Jira Software 7.9.0 on Ubuntu 16.04.4 in less than 30 minutes

...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...

1,482 views 10 12
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