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 vote
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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Tuesday in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

488 views 19 10
Join discussion

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