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 after confluence upgrade Edited

I get folowing errors after upgrading confluence.

 

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.DropSpaceGroupTablesUpgradeTask@4a0342c5 failed during the SCHEMA_UPGRADE phase due to: null

 

i have following logs in "/opt/atlassian/confluence/logs"
atlassian-synchrony-proxy.log
catalina.out host-manager.2019-04-12.log
manager.2019-04-12.log
catalina.2019-04-12.log
gc-2019-04-12_19-29-11.log.0.current localhost.2019-04-12.log
synchrony-proxy-watchdog.log

and in "/var/atlassian/application-data/confluence/logs"

https://de.files.fm/u/wqgvtr5r <-- download


atlassian-confluence.log
atlassian-diagnostics.log
atlassian-synchrony.log

where i can find more details?
i reinstall the db several time... im lost :(

1 answer

i try this one but it doesn't work:
#1072 - Key column 'SPACEGROUPID' doesn't exist in table

I add the new Logs - http://kathriner.com/atlassian-confluence.log
Still not running. :(

@Thomas Kathriner 

 

There is one error 

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'spacepermi0_.PERMALLUSERSSUBJECT' in 'field list'

pointing to permissions tables, could you check 

https://confluence.atlassian.com/confkb/unknown-column-error-when-upgrading-from-confluence-5-x-to-newer-versions-915476193.html 

 

From which to which version are you upgrading

 

Cheers

Kurt

I try this one too. Stil same Error... i Upload the new log - http://kathriner.com/atlassian-confluence-new.log.
i think it was Version 5.4 i have the file-backup not here.

@Thomas Kathriner 

Hi Thomas

so you have a valid license in place as well as the collation of the database is correct - right?

 

Cheers

Kurt

@Thomas Kathriner 

And just to double check, from which version to which version are you upgrading

i try to go back on the old version:

Detected tables with non-default collation. See https://confluence.atlassian.com/x/TABrFw

 

i get some errors if i try to change the collation:

 

ALTER TABLE `AO_950DC3_TC_CUSTOM_EV_TYPES` CHANGE `BELONG_SUB_CALENDAR_ID` `BELONG_SUB_CALENDAR_ID` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL

MySQL meldet: Dokumentation

#1025 - Error on rename of './bak_atlassian@002dconfluence/#sql-37a_d062' to './bak_atlassian@002dconfluence/AO_950DC3_TC_CUSTOM_EV_TYPES' (errno: 150) 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence Cloud

What's New in Confluence Cloud – June 2020 Edition

Ready for the monthly rollup of what happened in May for Confluence Cloud? Improved mobile login experience (& SSO) For those of you with the Confluence mobile app, we know the login experien...

27,643 views 41 90
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