System Error occurs when we click on the Cloud Migration Assistant

[Sunil kumar]

While opening the confluence server migration Assistant the below error.

##############################################################

Oops - an error has occurred

 System Error

A system error has occurred — our apologies!

For immediate troubleshooting, consult our knowledge base for a solution.

If you would like to receive support from Atlassian's support team, ask your Confluence administrator to create a support issue on Atlassian's support system with the following information:

1. a description of your problem and what you were doing at the time it occurred
2. a copy of the error and system information found below
3. a copy of the application logs (if possible).

Your Confluence administrator can use the support request form to create a support ticket which will include this information.

We will respond as promptly as possible.
Thank you!

Return to site homepage…

Cause

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:223)

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.LockException: Could not acquire change log lock. Currently locked by 172.31.214.58 (172.31.214.58) since 1/23/20 3:17 PM
    at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:230)

[Sevag Keoshgerian]

Hi @Sunil kumar 

Can you attach a screenshot of the page with the problem. It sounds similar to a problem I came across and the way that I fixed it was through dropping a table from the DB.

Here are the steps:

1. Shutdown confluence server

2. Drop table mig_check_override from the database

3. Restart Confluence Server

[Sunil kumar]

Hi @Sevag Keoshgerian ,

Shared the attach screen shot for your reference.

[Fabio Racobaldo _Herzum_]

Hi @Sunil kumar ,

please could you provide us information about DB linked to your instance. This issue usually happens with H2 embedded database.

Take a look here https://community.atlassian.com/t5/Confluence-questions/Atlassian-Cloud-Migration-Assistance-is-giving-error-while/qaq-p/1196608

Fabio

[Sunil kumar]

Hi @Fabio Racobaldo _Herzum_ ,

Please find the below details of the DB linked - 

Database name - PostgreSQL
Database version - 9.6.23
Database Dialect - com.atlassian.confluence.impl.hibernate.dialect.PostgreSQLDialect
Database Driver Name - org.postgresql.Driver
Database Driver Version - 42.1.1
Database Connection URL - jdbc:postgresql://localhost:5432/confluence
Database Connection Transaction Isolation - Read committed
Database Latency - 1

[Sunil kumar]

@Fabio Racobaldo _Herzum_ , Did you get any chance to look in the issue , awating for your response.