Problems encountered during the upgrade from version 5.7.4 to version 6.12.2

[刘祥亮]

Cannot create space after successfully upgrading to the new version. Please see the screenshot for the error message. Front-end interface display: An unknown server error was encountered The background log information is: WARN [http-nio-8090-exec-4] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback.    ->[PluginReadWriteTx]: PROPAGATION_REQUIRED, ISOLATION_DEFAULT (Session #2038698970)   -- referer: http://10.26.10.20:8090/ | url: /rest/create-dialog/1.0/space-blueprint/dialog/web-items | traceId: d6965a9d14437657 | userName: admin_local Please help the community gods to help me, paying users from China

[Sid]

It seems to be caused by corrupted data in some template tables.

Solution:

1. Backup database 
2. Shutdown Confluence
3. Delete tables:

DROP TABLE "AO_54C900_SPACE_BLUEPRINT_AO";
DROP TABLE "AO_54C900_C_TEMPLATE_REF";
DROP TABLE "AO_54C900_CONTENT_BLUEPRINT_AO"; 

4. Clean plugin cache: https://confluence.atlassian.com/confkb/how-to-clear-confluence-plugins-cache-297664846.html 

Restart Confluence.

Make sure you take the backups to restore back if required

[刘祥亮]

 https://confluence.atlassian.com/confkb/how-to-clear-confluence-plugins-cache-297664846.html 

This URL is missing

[Sid]

https://confluence.atlassian.com/confkb/how-to-clear-confluence-plugins-cache-297664846.html