Error on Jira startup after upgrade

[darmananzas]

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) 
...  

[Daniel Ebers]

Hi darmananzas,

welcome to the Atlassian Community!

Could you please state if this is a data center installation of Jira or Jira server? What me worries the most are messages that relations are not existing. Either they got lost somehow or the permissions for the database user you are trying to access them are not correct.

In case you can outline a bit more in detail how you are upgrading actually from version 7 to version 8 someone from Community could maybe a more elaborate on root causes and how to fix them.

Cheers,
Daniel