Hi,
I'm trying to move confluence to new server and DB according to this tutorial
https://confluence.atlassian.com/doc/migrating-to-another-database-148867.html
At the and of the import I have got an error
"Import failed. Check your server logs for more information. Transaction rolled back because it has been marked as rollback-only"
I have got this error with different Postres versions 9.6 and 11.1 and with Mariadb 10.2
Confluence version is 6.14.2
here the log output
2019-08-29 17:16:19,616 INFO [Long running task: Importing data] [confluence.event.listeners.ResetHiLoAfterImportListener] handleEvent Reset Hi/Lo ids in response to import event
2019-08-29 17:16:19,865 WARN [Long running task: Importing data] [activeobjects.confluence.backup.LoggingRestoreProgressMonitor] beginRestore Begin restoring Active Objects backup, adjust log level for com.atlassian.activeobjects.confluence.backup for more detailed logging.
-- url: /wiki/setup/longrunningtaskxml.action | referer: https://wiki.newinstance.com/wiki/setup/setup-restore-local.action | traceId: 85acda47e78716d4 | userName: anonymous | action: longrunningtaskxml
2019-08-29 17:16:29,817 WARN [Long running task: Importing data] [activeobjects.confluence.backup.LoggingRestoreProgressMonitor] endRestore Completed restoring Active Objects Backup.
-- url: /wiki/setup/longrunningtaskxml.action | referer: https://wiki.newinstance.com/wiki/setup/setup-restore-local.action | traceId: 85acda47e78716d4 | userName: anonymous | action: longrunningtaskxml
2019-08-29 17:16:57,984 ERROR [Long running task: Importing data] [atlassian.confluence.importexport.KeyInitPostImportTask] execute Problem when init Confluence key after a site import
-- url: /wiki/setup/longrunningtaskxml.action | referer: https://wiki.newinstance.com/wiki/setup/setup-restore-local.action | traceId: 85acda47e78716d4 | userName: anonymous | action: longrunningtaskxml
2019-08-29 17:16:58,346 WARN [Long running task: Importing data] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[com.atlassian.confluence.importexport.DefaultImportExportManager.performImport]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1173461382)
Showing 10 last transactions at this level out of 31 in total:
[null]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #689011852)
[null]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #444503902)
[null]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #1371767637)
[null]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #623468917)
[null]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #1149026693)
[null]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #1522388681)
[null]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #388434194)
[com.atlassian.confluence.impl.schedule.caesium.SchedulerClusteredJobDao.findByJobRunnerKey]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #741009785)
[com.atlassian.confluence.impl.schedule.caesium.SchedulerClusteredJobDao.refresh]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #1769371481)
[com.atlassian.confluence.impl.schedule.caesium.SchedulerClusteredJobDao.delete]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #1744350878)
-- url: /wiki/setup/longrunningtaskxml.action | referer: https://wiki.newinstance.com/wiki/setup/setup-restore-local.action | traceId: 85acda47e78716d4 | userName: anonymous | action: longrunningtaskxml
2019-08-29 17:16:58,349 ERROR [Long running task: Importing data] [springframework.transaction.interceptor.TransactionInterceptor] completeTransactionAfterThrowing Application exception overridden by commit exception
-- url: /wiki/setup/longrunningtaskxml.action | referer: https://wiki.newinstance.com/wiki/setup/setup-restore-local.action | traceId: 85acda47e78716d4 | userName: anonymous | action: longrunningtaskxml
com.atlassian.confluence.importexport.ImportExportException: java.lang.NullPointerException
at com.atlassian.confluence.importexport.KeyInitPostImportTask.execute(KeyInitPostImportTask.java:25)
at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:82)
at com.atlassian.confluence.importexport.DefaultImportExportManager.performImportInternal(DefaultImportExportManager.java:131)
at com.atlassian.confluence.importexport.DefaultImportExportManager.doPerformImport(DefaultImportExportManager.java:119)
at com.atlassian.confluence.importexport.DefaultImportExportManager.performImport(DefaultImportExportManager.java:114)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy236.performImport(Unknown Source)
at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.runInternal(ImportLongRunningTask.java:60)
at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:26)
at com.atlassian.confluence.util.longrunning.ManagedTask.run(ManagedTask.java:52)
at com.atlassian.confluence.impl.util.concurrent.ConfluenceExecutors$ThreadLocalContextTaskWrapper.lambda$wrap$1(ConfluenceExecutors.java:90)
at com.atlassian.confluence.vcache.VCacheRequestContextOperations.lambda$doInRequestContext$0(VCacheRequestContextOperations.java:50)
at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContextInternal(VCacheRequestContextManager.java:87)
at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContext(VCacheRequestContextManager.java:71)
at com.atlassian.confluence.vcache.VCacheRequestContextOperations.doInRequestContext(VCacheRequestContextOperations.java:49)
at com.atlassian.confluence.vcache.VCacheRequestContextOperations.lambda$withRequestContext$2(VCacheRequestContextOperations.java:66)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.NullPointerException
at java.security.MessageDigest.update(MessageDigest.java:335)
at java.security.MessageDigest.digest(MessageDigest.java:410)
at org.apache.commons.codec.digest.DigestUtils.md5(DigestUtils.java:351)
at org.apache.commons.codec.digest.DigestUtils.md5(DigestUtils.java:376)
at com.atlassian.confluence.security.trust.DefaultCurrentApplicationIdProvider.getAliasForSid(DefaultCurrentApplicationIdProvider.java:33)
at com.atlassian.confluence.security.trust.DefaultCurrentApplicationIdProvider.getCurrentApplicationId(DefaultCurrentApplicationIdProvider.java:28)
at com.atlassian.confluence.security.trust.DefaultTrustedApplicationsManager.getCurrentApplication(DefaultTrustedApplicationsManager.java:157)
at com.atlassian.confluence.security.trust.DefaultTrustedApplicationsManager.initConfluenceKey(DefaultTrustedApplicationsManager.java:167)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy266.initConfluenceKey(Unknown Source)
at com.atlassian.confluence.importexport.KeyInitPostImportTask.execute(KeyInitPostImportTask.java:22)
... 31 more
2019-08-29 17:16:58,350 ERROR [Long running task: Importing data] [confluence.importexport.actions.ImportLongRunningTask] runInternal Failure during import
-- url: /wiki/setup/longrunningtaskxml.action | referer: https://wiki.newinstance.com/wiki/setup/setup-restore-local.action | traceId: 85acda47e78716d4 | userName: anonymous | action: longrunningtaskxml
org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:728)
at sun.reflect.GeneratedMethodAccessor142.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy170.commit(Unknown Source)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:556)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:286)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy236.performImport(Unknown Source)
at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.runInternal(ImportLongRunningTask.java:60)
at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:26)
at com.atlassian.confluence.util.longrunning.ManagedTask.run(ManagedTask.java:52)
at com.atlassian.confluence.impl.util.concurrent.ConfluenceExecutors$ThreadLocalContextTaskWrapper.lambda$wrap$1(ConfluenceExecutors.java:90)
at com.atlassian.confluence.vcache.VCacheRequestContextOperations.lambda$doInRequestContext$0(VCacheRequestContextOperations.java:50)
at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContextInternal(VCacheRequestContextManager.java:87)
at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContext(VCacheRequestContextManager.java:71)
at com.atlassian.confluence.vcache.VCacheRequestContextOperations.doInRequestContext(VCacheRequestContextOperations.java:49)
at com.atlassian.confluence.vcache.VCacheRequestContextOperations.lambda$withRequestContext$2(VCacheRequestContextOperations.java:66)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
2019-08-29 17:16:58,351 WARN [Long running task: Importing data] [confluence.util.profiling.DefaultActivityMonitor] close Exceeded the threshold of 60000 ms: ActivitySnapshot{startTime=1567094919353, threadId=252, threadName='Long running task: Importing data', userId='', type='long-running-task', summary='Importing data'}
-- url: /wiki/setup/longrunningtaskxml.action | referer: https://wiki.newinstance.com/wiki/setup/setup-restore-local.action | traceId: 85acda47e78716d4 | userName: anonymous | action: longrunningtaskxml
2019-08-29 17:17:13,082 WARN [Caesium-1-1] [agent.service.version.MarketplaceVersionChecker] warn Failed to get plugin versions from Marketplace
-- url: /wiki/setup/longrunningtaskxml.action | referer: https://wiki.newinstance.com/wiki/setup/setup-restore-local.action | traceId: 85acda47e78716d4 | userName: anonymous | action: longrunningtaskxml
com.atlassian.marketplace.client.MpacException: org.apache.http.conn.ConnectTimeoutException: Connect to 10.8.0.20:8888 [/10.8.0.20] failed: connect timed out
at com.atlassian.marketplace.client.impl.CommonsHttpTransport$OperationsImpl.executeMethod(CommonsHttpTransport.java:384)
at com.atlassian.marketplace.client.impl.CommonsHttpTransport$OperationsImpl.get(CommonsHttpTransport.java:298)
at com.atlassian.marketplace.client.impl.CommonsHttpTransport.get(CommonsHttpTransport.java:112)
at com.atlassian.marketplace.client.impl.ApiHelper.getEntityInternal(ApiHelper.java:113)
at com.atlassian.marketplace.client.impl.ApiHelper.getEntity(ApiHelper.java:100)
at com.atlassian.marketplace.client.impl.DefaultMarketplaceClient.getRoot(DefaultMarketplaceClient.java:156)
at com.atlassian.marketplace.client.impl.DefaultMarketplaceClient.addons(DefaultMarketplaceClient.java:109)
at com.atlassian.migration.agent.service.version.MarketplaceVersionChecker.checkIfThereIsNewerVersion(MarketplaceVersionChecker.java:52)
at com.atlassian.migration.agent.service.version.DefaultPluginVersionManager.runJob(DefaultPluginVersionManager.java:157)
at com.atlassian.confluence.impl.schedule.caesium.JobRunnerWrapper.doRunJob(JobRunnerWrapper.java:120)
at com.atlassian.confluence.impl.schedule.caesium.JobRunnerWrapper.lambda$runJob$0(JobRunnerWrapper.java:91)
at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContextInternal(VCacheRequestContextManager.java:87)
at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContext(VCacheRequestContextManager.java:71)
at com.atlassian.confluence.impl.schedule.caesium.JobRunnerWrapper.runJob(JobRunnerWrapper.java:91)
at com.atlassian.scheduler.core.JobLauncher.runJob(JobLauncher.java:134)
at com.atlassian.scheduler.core.JobLauncher.launchAndBuildResponse(JobLauncher.java:106)
at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:90)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.launchJob(CaesiumSchedulerService.java:443)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeLocalJob(CaesiumSchedulerService.java:410)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeQueuedJob(CaesiumSchedulerService.java:388)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService$1.consume(CaesiumSchedulerService.java:285)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService$1.consume(CaesiumSchedulerService.java:282)
at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeJob(SchedulerQueueWorker.java:65)
at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeNextJob(SchedulerQueueWorker.java:59)
at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.run(SchedulerQueueWorker.java:34)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.http.conn.ConnectTimeoutException: Connect to 10.8.0.20:8888 [/10.8.0.20] failed: connect timed out
at org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:151)
at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:359)
at org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:389)
at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:237)
at org.apache.http.impl.client.cache.CachingExec.callBackend(CachingExec.java:592)
at org.apache.http.impl.client.cache.CachingExec.handleCacheMiss(CachingExec.java:356)
at org.apache.http.impl.client.cache.CachingExec.execute(CachingExec.java:275)
at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:185)
at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:89)
at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:111)
at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:185)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:108)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:56)
at com.atlassian.marketplace.client.impl.CommonsHttpTransport$OperationsImpl.executeMethod(CommonsHttpTransport.java:376)
... 25 more
Caused by: java.net.SocketTimeoutException: connect timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at org.apache.http.conn.socket.PlainConnectionSocketFactory.connectSocket(PlainConnectionSocketFactory.java:75)
at org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:142)
... 39 more
2019-08-29 17:17:13,085 WARN [Caesium-1-1] [impl.schedule.caesium.JobRunnerWrapper] runJob Scheduled job migration-plugin:plugin-version-checker#b7348a20-21c5-4696-a6dc-4dd366c5fbb0 completed unsuccessfully with response JobRunnerResponse[runOutcome=FAILED,message='Failed to check plugin version']
-- url: /wiki/setup/longrunningtaskxml.action | referer: https://wiki.newinstance.com/wiki/setup/setup-restore-local.action | traceId: 85acda47e78716d4 | userName: anonymous | action: longrunningtaskxml
