Confluence doesn't work after upgrading to 6.3.3

After upgrading Confluence from 5.8.5. to 6.3.3, I was able to start it, but I can't connect to it. It seems that the database scema was not updated during the installation as I see error messages in the log about missing columns and tables.

Please advise.

1 answer

0 votes
Ann Worley Atlassian Team Aug 21, 2017

I understand you are not able to connect to Confluence since upgrading, and you see errors in the logs referring to missing columns and tables.

Please let me know:

  • What method you used to upgrade. Did you use an archive file and point the confluence-init.properties file at the existing Confluence Home directory or did you use an executable and run the installer?
  • What OS are you using? Windows or Linux?
  • There should be an entry in the log to the effect of "Upgrade failed" with some cause, please see if you can find that error message.

If this is a production instance, I recommend restoring the database and Confluence Home directory from back-up, then trying the upgrade on a test instance.

The logs to check are:
<confluence_install>/logs/ (anything recent in this directory)
<confluence_home>/logs/atlassian-confluence.log
Note: The <confluence_home> directory is the path defined in the following file: <confluence_install>/confluence/WEB-INF/classes/confluence-init.properties

  • I used an executable.
  • Windows Server 2012 R2 Datacenter.
  • There are no "Upgrade failed" entries in any of the log files in both directories.

 

These are some of the errors I see in the log:

java.sql.SQLException: Invalid column name 'PERMALLUSERSSUBJECT'.

java.sql.SQLException: Invalid object name 'scheduler_clustered_jobs'

Ann Worley Atlassian Team Aug 21, 2017

I opened a support ticket in your name, to take a closer look. You should get the email from it any minute.

Ann Worley Atlassian Team Aug 22, 2017

Thanks for the logs, it turned out that you fixed the issue by applying an evaluation license. We found the error message in your logs that matched this article: Upgrade fails due to expired license

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 29, 2018 in New to Confluence

How to use Confluence Cloud for stakeholder management

Most of us don’t need much convincing that stakeholder management is important. It just makes sense that keeping everyone in-the-know on projects and assigning clearly defined roles is key to having ...

1,167 views 4 6
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