I have an issue when we are testing migrate Confluence from H2SQL to MySql ,version is 5.10.4

[taoya li]

Cause

org.apache.velocity.exception.MethodInvocationException: Invocation of method 'isShowSignUp' in class com.atlassian.confluence.user.actions.LoginAction threw exception java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.util.concurrent.CompletionException: net.sf.hibernate.LazyInitializationException: Exception initializing proxy: [com.atlassian.confluence.user.ConfluenceUserImpl#40e51abb52a4d7ee0152adae074e007d] at /login.vm[line 6, column 28]
    at org.apache.velocity.runtime.parser.node.ASTMethod.handleInvocationException(ASTMethod.java:337)

caused by: java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.util.concurrent.CompletionException: net.sf.hibernate.LazyInitializationException: Exception initializing proxy: [com.atlassian.confluence.user.ConfluenceUserImpl#40e51abb52a4d7ee0152adae074e007d]
    at com.atlassian.confluence.util.ReadOnlyLicenseCalculator.handleExecutionFailure(ReadOnlyLicenseCalculator.java:84)

caused by: java.util.concurrent.ExecutionException: java.util.concurrent.CompletionException: net.sf.hibernate.LazyInitializationException: Exception initializing proxy: [com.atlassian.confluence.user.ConfluenceUserImpl#40e51abb52a4d7ee0152adae074e007d]
    at java.util.concurrent.FutureTask.report(FutureTask.java:122)

caused by: java.util.concurrent.CompletionException: net.sf.hibernate.LazyInitializationException: Exception initializing proxy: [com.atlassian.confluence.user.ConfluenceUserImpl#40e51abb52a4d7ee0152adae074e007d]
    at java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:273)

caused by: net.sf.hibernate.LazyInitializationException: Exception initializing proxy: [com.atlassian.confluence.user.ConfluenceUserImpl#40e51abb52a4d7ee0152adae074e007d]
    at net.sf.hibernate.proxy.LazyInitializer.initializeWrapExceptions(LazyInitializer.java:64)

caused by: net.sf.hibernate.ObjectNotFoundException: No row with the given identifier exists: 40e51abb52a4d7ee0152adae074e007d, of class: com.atlassian.confluence.user.ConfluenceUserImpl
    at net.sf.hibernate.ObjectNotFoundException.throwIfNull(ObjectNotFoundException.java:24)

[Shannon S]

Hello Taoya,

This can be caused if the MySQL Database isn't set up exactly per this article:

• Database Setup for MySQL

Could you please review that article and make sure to create your database in MySQL using those requirements?

If you complete that and are still not able to proceed, can you please let me know what version of MySQL you're using and exactly what steps you have completed and what setp you're on when you receive the error.

Regards,

Shannon