Problem after confluence upgrade

[Thomas]

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

[Kurt Klinner]

@Thomas Kathriner 

Hi Thomas

can you check if you might hit

https://confluence.atlassian.com/confkb/upgrading-to-confluence-5-9-x-or-higher-version-fails-with-error-failed-during-the-schema_upgrade-phase-due-to-null-794212749.html

and see if the workaround solves your issue

Cheers

Kurt

[Thomas]

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]

@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]

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]

@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]

@Thomas Kathriner 

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

[Thomas]

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: 

#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]

@Thomas Kathriner 

Any chance that your tables are using MyISAM  instead of InnoDB?

https://confluence.atlassian.com/confkb/database-errors-when-using-mysql-and-myisam-tables-181537380.html