Stuck when restoring a 1GB zipped xml backup

I am about to migrate from Ubuntu and MySQL DB to a Windows SQL Server machine. I want to achieve this using an xml backup.

I installed a fresh Confluence on Windows and when I am propted for the backup to restore the progress bar fastly moves to 15% progress and then stucks. I kept the process running over the night with no further success. So I clicked back in the browser and see that actually something was done and I see the login prompt of Confluence. But using my account I can't login.

A quick check on database shows that some data was restored but the table dbo.users remains empty. I tried to insert a user and used md5 hash for a password, but it seems to be some different encryption, since I still couldn't login.

I uninstalled Confluence and started from scratch, creating a blank Setup. Now I used the User Interface for the restore, this time the progress bar stuck at 12% with the same result. dbo.users is empty and I can't login with any user.

Is there something that I am missing? For db connection I am using the "direct JDBC connection" also of course I changed the isolation level to the required one.

I would like to use this approach and not a third party tool or a migration space by space.

Any help is very appreciated!

Thanks in advance

EDIT: attached warning from log, full log in the end.

2015-06-24 12:40:41,389 WARN [http-8090-3] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml4666541768912769745tmp to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml. Falling back to non-atomic overwrite.
 -- referer: http://localhost:8090/setup/setup-restore-start.action | url: /setup/setup-restore.action | userName: anonymous | action: setup-restore

 

 

2015-06-24 12:05:01,159 INFO [main] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 5.2.3 [build 4394 based on commit hash a32f094df7825f58c6a417309475c6c954804a27]
2015-06-24 12:05:03,737 WARN [main] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml8990587825128513218tmp to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml. Falling back to non-atomic overwrite.
2015-06-24 12:05:04,112 INFO [main] [atlassian.plugin.manager.DefaultPluginManager] init Initialising the plugin system
2015-06-24 12:05:09,503 INFO [main] [atlassian.plugin.manager.DefaultPluginManager] init Plugin system started in 0:00:05.391
2015-06-24 12:05:10,472 INFO [main] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve
2015-06-24 12:07:08,595 WARN [http-8090-1] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml8206326959971351343tmp to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml. Falling back to non-atomic overwrite.
 -- url: /setup/setuplicense.action;jsessionid=DCFFB4C7E8BE415973A10CAE2A1EEA0A | userName: anonymous
2015-06-24 12:11:20,311 WARN [http-8090-4] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml5304785824451900560tmp to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml. Falling back to non-atomic overwrite.
 -- referer: http://localhost:8090/setup/setuplicense.action | url: /setup/dosetuplicense.action | userName: anonymous | action: dosetuplicense
2015-06-24 12:11:20,327 WARN [http-8090-4] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml7848306943931138035tmp to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml. Falling back to non-atomic overwrite.
 -- referer: http://localhost:8090/setup/setuplicense.action | url: /setup/dosetuplicense.action | userName: anonymous | action: dosetuplicense
2015-06-24 12:11:20,343 WARN [http-8090-4] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml4542509801979307389tmp to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml. Falling back to non-atomic overwrite.
 -- referer: http://localhost:8090/setup/setuplicense.action | url: /setup/dosetuplicense.action | userName: anonymous | action: dosetuplicense
2015-06-24 12:11:20,343 WARN [http-8090-4] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml3188576805012502735tmp to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml. Falling back to non-atomic overwrite.
 -- referer: http://localhost:8090/setup/setuplicense.action | url: /setup/dosetuplicense.action | userName: anonymous | action: dosetuplicense
2015-06-24 12:35:40,754 WARN [http-8090-4] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml8544274728512329020tmp to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml. Falling back to non-atomic overwrite.
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:35:40,770 INFO [http-8090-4] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2015-06-24 12:35:43,582 INFO [http-8090-4] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2015-06-24 12:35:48,911 ERROR [http-8090-4] [atlassian.confluence.plugin.PluginLoadersFactory] get Unable to load extra plugins from  specified in -Dconfluence.plugins.extra.bundled.locations. file not found or unreadable
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:35:52,536 WARN [http-8090-4] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory!
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:35:55,630 WARN [http-8090-4] [render.xhtml.migration.PageTemplateWikiToXhtmlSiteMigrator] calculateNumberOfMigrationThreads SQL Server detected so only one thread will be used in migration to avoid dead lock problems.
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:35:58,630 WARN [http-8090-4] [render.xhtml.migration.DefaultWikiToXhtmlSiteMigrator] calculateNumberOfMigrationThreads SQL Server detected so only one thread will be used in migration to avoid dead lock problems.
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:00,724 WARN [http-8090-4] [render.xhtml.migration.DefaultWikiToXhtmlSiteMigrator] calculateNumberOfMigrationThreads SQL Server detected so only one thread will be used in migration to avoid dead lock problems.
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:00,755 INFO [http-8090-4] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 19985 ms
2015-06-24 12:36:01,474 WARN [http-8090-4] [atlassian.config.bootstrap.DefaultAtlassianBootstrapManager] getDatabaseBuildNumber Unable to determine build number from database. If you are upgrading from a Confluence version prior to 2.3, this is expected: Invalid object name 'CONFVERSION'.
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:08,397 INFO [http-8090-4] [atlassian.plugin.manager.DefaultPluginManager] shutdown Shutting down the plugin system
2015-06-24 12:36:08,507 INFO [http-8090-4] [atlassian.plugin.manager.DefaultPluginManager] init Initialising the plugin system
2015-06-24 12:36:23,092 WARN [http-8090-4] [factory.transform.stage.ScanDescriptorForHostClassesStage] execute The plugin 'atlassian-universal-plugin-manager-plugin-2.12.2.jar' uses a package 'org.apache.commons.fileupload.servlet' that is also exported by the application.  It is highly recommended that the plugin use its own packages.
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:45,018 WARN [ThreadPoolAsyncTaskExecutor::Thread 19] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory!
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:47,362 WARN [ThreadPoolAsyncTaskExecutor::Thread 31] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory!
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:47,377 WARN [ThreadPoolAsyncTaskExecutor::Thread 31] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory!
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:47,377 WARN [ThreadPoolAsyncTaskExecutor::Thread 31] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory!
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:47,377 WARN [ThreadPoolAsyncTaskExecutor::Thread 31] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory!
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:47,393 WARN [ThreadPoolAsyncTaskExecutor::Thread 31] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory!
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:47,393 WARN [ThreadPoolAsyncTaskExecutor::Thread 31] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory!
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:47,393 WARN [ThreadPoolAsyncTaskExecutor::Thread 31] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory!
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:49,284 WARN [http-8090-4] [atlassian.soy.renderer.SoyResourceModuleDescriptor] enabled soy-resource is deprecated. Please convert com.atlassian.auiplugin:aui-experimental-soy-templates to a web-resource and/or a soy-function
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:49,299 WARN [http-8090-4] [atlassian.soy.renderer.SoyResourceModuleDescriptor] enabled soy-resource is deprecated. Please convert com.atlassian.auiplugin:aui-experimental-soy-templates-2 to a web-resource and/or a soy-function
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:49,299 WARN [http-8090-4] [atlassian.soy.renderer.SoyResourceModuleDescriptor] enabled soy-resource is deprecated. Please convert com.atlassian.auiplugin:aui-experimental-soy-templates-legacy1 to a web-resource and/or a soy-function
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:51,909 WARN [http-8090-4] [atlassian.soy.renderer.SoyResourceModuleDescriptor] enabled soy-resource is deprecated. Please convert com.atlassian.confluence.plugins.soy:soy-core-functions to a web-resource and/or a soy-function
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:36:57,081 INFO [http-8090-4] [atlassian.plugin.manager.DefaultPluginManager] init Plugin system started in 0:00:48.574
2015-06-24 12:36:59,472 WARN [http-8090-4] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml3785159861107515068tmp to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml. Falling back to non-atomic overwrite.
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:37:00,894 WARN [http-8090-4] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml811416303485522287tmp to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml. Falling back to non-atomic overwrite.
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
2015-06-24 12:37:01,816 WARN [http-8090-4] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml6823655108168399520tmp to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml. Falling back to non-atomic overwrite.
 -- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setuppaths.action | userName: anonymous | action: setuppaths
2015-06-24 12:40:41,355 INFO [Long running task: Importing data] [confluence.importexport.actions.ImportLongRunningTask] runInternal Beginning import by user null
2015-06-24 12:40:41,371 WARN [http-8090-3] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml3041462375025158924tmp to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml. Falling back to non-atomic overwrite.
 -- referer: http://localhost:8090/setup/setup-restore-start.action | url: /setup/setup-restore.action | userName: anonymous | action: setup-restore
2015-06-24 12:40:41,371 WARN [http-8090-3] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml8883520730701836136tmp to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml. Falling back to non-atomic overwrite.
 -- referer: http://localhost:8090/setup/setup-restore-start.action | url: /setup/setup-restore.action | userName: anonymous | action: setup-restore
2015-06-24 12:40:41,389 WARN [http-8090-3] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml4666541768912769745tmp to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml. Falling back to non-atomic overwrite.
 -- referer: http://localhost:8090/setup/setup-restore-start.action | url: /setup/setup-restore.action | userName: anonymous | action: setup-restore

 

EDIT

After waiting ages, I also received heap exceptions in the logs! I now increase the java memory in the registry and re-run the process.

 

5 answers

Hi Hendrik, Did you get any notifications in the atlassian-confluence.log file? This can be found in the home directory. Best regards, Peter

hey peter, thank you very much for that hint. Since I didn't receive any error I thought that I don't have any logs. I attached the logs to my question. I see one warning which is probably the root cause, but so far I don't have any idea why this happens.

Is the Confluence you are importing to the exact same version as the one you are exporting from?

yes. it is version 5.2.3

I can't really see anything wrong in your log file, could you take a look at the catalina.out in your confluence installation directory /logs ?

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Friday in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

253 views 11 10
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you