Confluence backup restore issue

[Yogesh Mude]

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)

[Gonchik Tsymzhitov]

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

[Johan Soetens _Dumblefy_]

Are the versions on both production and test identical (6.10.0)?

[Yogesh Mude]

Yes both r the same versions.

[Johan Soetens _Dumblefy_]

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).