Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Problem with failed upgrade 7.1.1 to 7.11.1

I've attempted an upgrade of our on-prem install from 7.1.1 to 7.11.1 twice now, following the same steps we've used for years, per the usual upgrade article.

Everything goes fine, except once Tomcat's CPU usage has dropped down, when I attempt to access Confluence, it throws an error.

I've tried twice, with the usual roll-back process.  Our database is in a local MS SQL Express instance.

Any guidance or suggestions on this would be greatly appreciated.  I've looked at the logs and they're pretty verbose and I don't know what I'm looking for.

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.DenormalisedSpacePermissionsUpgradeTask@38e60c76 failed during the SCHEMA_UPGRADE phase due to: StatementCallback; bad SQL grammar [DROP TRIGGER IF EXISTS denormalised_space_permission_trigger]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'IF'.

 

1 answer

I see that someone going from 7.10.2 had a similar issue.  Like them we're a small shop with Starter.  I have rolled back for now.  Is the thought here that there's something wrong in the 7.11.1 code that's causing this?

For the record, upgrade to 7.10.2 worked fine.  So apparently there's something blocking some of us from going current.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.1.1
TAGS
Community showcase
Published in Confluence Cloud

Introducing Confluence Cloud for Microsoft Teams (Available for Preview!)

Hi Atlassian Community, Remote work has shifted how teams collaborate, and we’ve heard from many of you that Microsoft Teams has become mission critical to many of your workflows, from how you chat...

2,537 views 21 21
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you