Cloud Migration Assistant Error - Table Already Exists

CTCD Apps Manager September 21, 2021

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)

 

2 answers

0 votes
Rob Horan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 19, 2022

@CTCD Apps Manager would you mind sharing the outcome?

0 votes
Kishan Sharma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 23, 2021

You will need Atlassian team's help on this, please raise a support ticket to Atlassian Support.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events