nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Upgrading Confluence from 5.5 to latest version.

Artur Yasyulevich

Hello,

I have Conflunce 5.5 on Windows server(not cloud)with separate Apache 6(it is not in Conf directory) and MS SQL Server 2008 R2 data base. This configuration was inherited by me from previous admin without explanations. So i'm trying to understand myself how to upgrade Confluence. I tried to update it by installer to version 5.10.9 with updating DB to MS SQL 2014. I succeed DB update and it works with Confluence 5.5. But when I tried to update Confluence installer "shouts" for an error "Problems reading the installation directory". I think I should use manual installation(unzip). The questions are:

1) What should be the sequence of actions? During the upgrade, I need to update Java (6->8), Data Base (2008-> 2014), Apache (6-> 8) and Confluence itself. Or it is not critical?(We don't have test environment, that's why i'm asking). I read Atlassian upgrade manuals and still asking.

2) Is it good idea to upgrade from Conf 5.5 to 5.10.9, and then to 5.10.9->Latest version?

Or it is better to do 5.5->Latest version?

3) I thought that I have EAR/WAR distribution configuration because catalogs for Confluence, Apache are not in one place. Am I right?

4) How can I do future upgrades using installer if I have EAR/WAR distribution configuration(catalogs for Confluence, Apache are not in one place and installer don't see them I think)?

Every your idea and answer will help me!!!

Accepted answers

All comments

AnnWorley

Hi Artur,

It's great to hear you are upgrading!

If at all possible, please spin up a test environment for a trial run of this procedure. It could save unplanned downtime. Create a staging environment for upgrading Confluence

It is pretty easy to migrate from EAR/WAR. Long story short, extract the new Confluence archive, edit the confluence/WEB-INF/classes/confluence-init.properties to point at your existing home directory and then start Confluence. The new Tomcat will be bundled in the archive and will take the place of the Tomcat that Confluence is using now. There can be some customizations in your existing Tomcat - this article describes how to deal with those: How to migrate Confluence from an EAR or WAR Distribution to a Standalone version

1- For the sequence of actions, Install the Java upgrade, and upgrade SQL Server after you shut down Confluence 5.5 and before you start Confluence 6.7. That way while Confluence 5.5 is running it will be using supported platforms for 5.5 then when you start Confluence 6.7 it will be running on supported platforms for 6.7

If you use the installer for the upgrade, you won't even have to upgrade JAVA as the JAVA JRE is bundled with the installer.

2- Per our Upgrading Confluence doc there is no reason to upgrade to an intermediate version, from Confluence 5, upgrade directly to the latest version of Confluence 6. Please do review the upgrade doc because it has a lot of "before you start" info that could save you trouble later.

3 - The directories should be as described in Confluence Home and other important directories if you have a standalone install.

4- After you migrate off EAR/WAR (to be completed before the upgrade) the instance will be like any other and you can use the installer method.

I look forward to any follow up questions and wish you the best of luck with the upgrade.

Cheers,

Ann

Artur Yasyulevich

Hi Ann!

Thank you for your help!

Finally I found some time and successfully migrated to standalone version from EAR/WAR(lost some time to do customizations to Tomcat).

Looking forward to do update to 6.7.0 using installer.

When i'm done, i'll tell you.

AnnWorley

Thanks for keeping the forum in the loop as you traverse the upgrade course!

Artur Yasyulevich

For three days me and DB admin were trying to do the update. We:

1) Updated DB from MS SQL 2008->2014 SP2.

2) Changed the compatibility level of the database to SQL2014.

3) Changed collation to "SQL_Latin1_General_CP1_CS_AS"(tried different ways).

4) Pointed to bundled Java (build 1.8.0_162-b12).

5) Do the customization to Tomcat '.xml' files.

6) Start the confluence.

Finally, we always have an error on startup confluence web page settings(the text of error is below). Looks like the primary\candidate keys can't migrate to 2014 version or maybe when changing collation. Do you have idea what to do?

Artur Yasyulevich

Upgrade failed. Please consult the system logs for details. You will need to fix these problems, restore your database and confluence home directory to the pre upgrade state. Then retry the upgrade. Upgrade error message: Upgrade task com.atlassian.confluence.upgrade.upgradetask.attachmentceo.AttachmentToCeoConversionUpgradeTask@75245df6 failed during the SCHEMA_UPGRADE phase due to: StatementCallback; uncategorized SQLException for SQL [ALTER TABLE CONTENT add constraint c_prevver foreign key (PREVVER) references CONTENT(CONTENTID)]; SQL state [S0000]; error code [1776]; There are no primary or candidate keys in the referenced table 'CONTENT' that match the referencing column list in the foreign key 'c_prevver'.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: There are no primary or candidate keys in the referenced table 'CONTENT' that match the referencing column list in the foreign key 'c_prevver'.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

collation

confluence

server

migration

apache

update

windows

ms-sql