Hi,
We planned to migrate our Confluence server to Cloud version and I tried to assess it via Cloud Migration tools. However when I access the link (Atlassian Cloud > Migration Assistant) I received system error caused by Table 'MIG_ANALYTICS_EVENT' already exists.
I already updated the tools into version 3.2.5
Following is the complete error:
org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getInitialState' in class com.atlassian.migration.agent.web.AppAction threw exception com.atlassian.util.concurrent.LazyReference$InitializationException: javax.persistence.PersistenceException: Failed to update database schema at /templates/app.vm[line 21, column 44]
at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:228)
caused by: com.atlassian.util.concurrent.LazyReference$InitializationException: javax.persistence.PersistenceException: Failed to update database schema
at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:149)
caused by: javax.persistence.PersistenceException: Failed to update database schema
at com.atlassian.migration.agent.store.jpa.impl.LiquibaseSchemaUpgrader.upgrade(LiquibaseSchemaUpgrader.java:35)
caused by: liquibase.exception.MigrationFailedException: Migration failed for change set META-INF/db-changelog/8-analytics-event.xml::8-analytics-event::MPT: Reason: liquibase.exception.DatabaseException: Table 'MIG_ANALYTICS_EVENT' already exists [Failed SQL: CREATE TABLE tdconfluencedb.MIG_ANALYTICS_EVENT (id VARCHAR(255) NOT NULL, eventTimestamp BIGINT NOT NULL, eventType VARCHAR(255) NOT NULL, event LONGTEXT NOT NULL, CONSTRAINT PK_MIG_ANALYTICS_EVENT PRIMARY KEY (id))]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)
caused by: liquibase.exception.DatabaseException: Table 'MIG_ANALYTICS_EVENT' already exists [Failed SQL: CREATE TABLE tdconfluencedb.MIG_ANALYTICS_EVENT (id VARCHAR(255) NOT NULL, eventTimestamp BIGINT NOT NULL, eventType VARCHAR(255) NOT NULL, event LONGTEXT NOT NULL, CONSTRAINT PK_MIG_ANALYTICS_EVENT PRIMARY KEY (id))]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)
caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'MIG_ANALYTICS_EVENT' already exists
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
@CTCD Apps Manager would you mind sharing the outcome?
You will need Atlassian team's help on this, please raise a support ticket to Atlassian Support.
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.