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

[Larry Talley]

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)

...

[M Amine · Accepted solution]

Hi,

Just to answer this old question ==> Here is how to do it : link. It is also worth to read this. Mainly the solution is to delete all data in the table AO_60DB71_ISSUERANKING. 

Hope it helps

[Daniel Petzen]

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.

[Daniel Petzen]

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.

[Robin Garner]

I have the same issue.

[Dieter]

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