Hello there,
i try to upgrade our confluence from 3.2 to 3.5.17. i followed the instructions given by atlassian. unfortunatly confluence does not start after upgrade and i get this error in atlassian-log:
2019-09-18 15:49:34,376 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1 errors were encountered during upgrade:
2019-09-18 15:49:34,376 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1: StatementCallback; uncategorized SQLException for SQL [alter table BANDANA alter column BANDANACONTEXT varchar(255) not null]; SQL state [S1000]; error code [5074]; The index 'BANDANA_band_context_idx' is dependent on column 'BANDANACONTEXT'.; nested exception is java.sql.SQLException: The index 'BANDANA_band_context_idx' is dependent on column 'BANDANACONTEXT'.
2019-09-18 15:49:35,047 INFO [main] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve
2019-09-18 15:50:42,986 INFO [Thread-20] [atlassian.plugin.manager.DefaultPluginManager] shutdown Shutting down the plugin system
2019-09-18 15:50:43,065 INFO [Thread-20] [com.atlassian.confluence.lifecycle] contextDestroyed Stopping Confluence
Does anyone has a good idea?
Database is on an seperate SQL Database-server
Thanks for your help
Phillipp
Update:
we found out to drop indexes for the following entries.
DROP INDEX [BANDANA_band_context_idx] ON [dbo].[BANDANA]
GO
/****** Object: Index [BANDANA_band_key_idx] Script Date: 19.09.2019 13:25:53 ******/
DROP INDEX [BANDANA_band_key_idx] ON [dbo].[BANDANA]
then the confluence setup continues and stops with new error.
It seems to be a lot of entries where we have to change.
was there a change on sheme for mssql database?
exicsts maybe a script for changing the necassary items?
Best regards
phillipp
now confluence asks for changing a lot of DB-entries from bigint to numeric (0,19)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.