Jira installation rollback

[Gustavo Gómez]

Hi, we're testing our current JIRA installation in case the upgrade from 6.4.9 to 7.1 goes wrong. In our test environment, we can't rollback from 7.1 to 6.4.9 because the error in the attachment. Do you know why?Jira error.png

[Nic Brough -Adaptavist-]

Could you tell us what your "roll back" procedure is? 

Is it some form of "restore old system from a backup"?

[Gustavo Gómez]

We've followed the steps in:

https://confluence.atlassian.com/adminjiraserver071/rolling-back-a-jira-application-upgrade-802592268.html

Regards,

[Nic Brough -Adaptavist-]

So, you deleted all the newly upgraded stuff and restored everything from the backups?

[Gustavo Gómez]

Hi, we only replaced the two folders as the procedure says:

• The JIRA application Home Directory.
• The JIRA application Installation Directory.

Could you be more specific on the stuff you mentioned?

Regards,

[Nic Brough -Adaptavist-]

What about the database?  You needed to go back to the original data set as well

[Hugo Lopez]

Hi Nic,

Thank you for your support, as Gustavo says, we also restored the database and both directories in JIRA Server. The three of them were done at the same time, so that shouldn't be a problem. When we try to log in into JIRA we got this errors (you can see some of them in the screenshot):

org.apache.jasper.JasperException: An exception occurred processing JSP page /includes/decorators/aui-layout/head-resources.jsp at line 13

10:     HeaderFooterRendering headerAndFooter = ComponentAccessor.getComponent(HeaderFooterRendering.class);
11: 
12:     headerAndFooter.requireCommonResources();
13:     headerAndFooter.includeResources(out);
14: %>
15: <script type="text/javascript" src="<%=headerAndFooter.getKeyboardShortCutScript(request) %>"></script>
16: <%

Caused by: com.atlassian.cache.CacheException: com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.pyxis.greenhopper.jira]

Caused by: com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.pyxis.greenhopper.jira]

Caused by: java.lang.IllegalStateException: Could not find column 'LONG_QUERY' in previously parsed query!

Please, can you help us?

Thank you in advance.

Regards.

[Nic Brough -Adaptavist-]

That message suggests that the database is damaged - are you sure the restoration was from a valid backup of the 6.x system that was working before?  Did you drop all the tables before restoring it?