Hello,
I'm working on upgrading a Jira instance from version 7.13.13 to 8.5.8, and having some issues. We already have a PostgreSQL 9.6 DB with data, which we want to connect to, but after setup we're experiencing some errors on startup:
As of note, our current configuration worked fine on version 7.13.13
2020-10-07 10:10:51,151+0200 localhost-startStop-1 ERROR [c.a.jira.startup.ComponentContainerLauncher] A fatal error occurred during initialisation. JIRA has been locked. net.sf.ehcache.CacheException: java.lang.IllegalStateException: Unable to resolve component: interface com.atlassian.jira.cluster.ClusterManager at net.sf.ehcache.CacheManager.init(CacheManager.java:426)
...
Caused by: io.atlassian.util.concurrent.LazyReference$InitializationException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT NODE_STATE, TIMESTAMP, IP, CACHE_LISTENER_PORT, NODE_BUILD_NUMBER, NODE_VERSION FROM postgresql.clusternode WHERE NODE_ID=? (ERROR: relation "postgresql.clusternode" does not exist Position: 93) at io.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:156)
...
Caused by: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT NODE_STATE, TIMESTAMP, IP, CACHE_LISTENER_PORT, NODE_BUILD_NUMBER, NODE_VERSION FROM postgresql.clusternode WHERE NODE_ID=? (ERROR: relation "postgresql.clusternode" does not exist Position: 93) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByPrimaryKey(DefaultOfBizDelegator.java:343)
...
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT NODE_STATE, TIMESTAMP, IP, CACHE_LISTENER_PORT, NODE_BUILD_NUMBER, NODE_VERSION FROM postgresql.clusternode WHERE NODE_ID=? (ERROR: relation "postgresql.clusternode" does not exist Position: 93) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:533) ...
Caused by: org.postgresql.util.PSQLException: ERROR: relation "postgresql.clusternode" does not exist Position: 93 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2468)
...
2020-10-07 10:10:51,188+0200 localhost-startStop-1 INFO [c.a.jira.startup.DatabaseLauncher] Database transactions enabled: true 2020-10-07 10:10:51,189+0200 localhost-startStop-1 INFO [c.a.jira.startup.DatabaseLauncher] Using JIRA's default for database transaction isolation level: 2
2020-10-07 10:10:51,203+0200 localhost-startStop-1 WARN [c.a.jira.startup.DatabaseLauncher] JRADEV-23357: unable to select from the 'MovedIssueKey' entity.
2020-10-07 10:10:51,212+0200 localhost-startStop-1 ERROR [c.a.jira.startup.LauncherContextListener] Unable to start JIRA. java.lang.IllegalStateException: Need to rename the MOVED_ISSUE_KEY table, but there is existing data in it. Please contact Atlassian Support. at com.atlassian.jira.startup.DatabaseLauncher.cleanupDatabaseTableName(DatabaseLauncher.java:246)
...
