Problem after confluence upgrade

Thomas April 12, 2019

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

0 votes
Kurt Klinner
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 14, 2019
Thomas April 14, 2019

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. :(

Kurt Klinner
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 14, 2019

@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

Thomas April 14, 2019

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.

Kurt Klinner
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 20, 2019

@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

Kurt Klinner
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 20, 2019

@Thomas Kathriner 

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

Thomas April 22, 2019

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) 

Kurt Klinner
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 23, 2019

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events