Confluence backup restore issue

Question

Team,

We are using confluence v6.10.0 on production and we want to set up confluence test instance and tried to restore the prod confluence backup to new test instance and got the below error.

2018-12-31 17:24:06,024 ERROR [Long running task: Importing data] [confluence.importexport.actions.ImportLongRunningTask] runInternal Failure during import

-- url: /confluence/longrunningtaskxml.action | referer:  | traceId: 4e35f5669f826fca | userName: admin@edelweiss | action: longrunningtaskxml

org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is net.sf.hibernate.TransactionException: Unable to rollback against JDBC Connection

at org.springframework.orm.hibernate.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:532)

at com.atlassian.confluence.impl.hibernate.ConfluenceHibernateTransactionManager.doRollback(ConfluenceHibernateTransactionManager.java:81)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:853)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:830)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

Johan Soetens _Dumblefy_ · Answer

Hi,

have you verified the Troubleshooting hints from Restoring a Site ?

It’s possible that you don’t have enough storage during the actual import - it really uses lots extra - please verify it.

When you have a clean new test database, all data from XML backup will overwrite this database (license as well).

Gonchik Tsymzhitov · Answer

Hi!

1. Could you verify you DB is not corrupted?

2. Please, have a look this article which related to the your stacktrace

https://confluence.atlassian.com/confkb/unable-to-start-due-to-net-sf-hibernate-exception-genericjdbcexception-cannot-open-connection-128843899.html

3. Also, Ii will be good verify the JDBC pool https://confluence.atlassian.com/confkb/confluence-slows-and-times-out-during-periods-of-high-load-due-to-database-connection-pool-146407630.html

4. Also, it will be good if you provide more info about RDBMS (which DB are you using?).

5. Is it start after a few second?

Cheers,

Gonchik Tsymzhitov

Yogesh Mude_u145qk · Answer

Yes both r the same versions.