Stuck when restoring a 1GB zipped xml backup

[Hendrik Meiffert]

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.

[Peter Van de Voorde]

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 ?

[Hendrik Meiffert]

yes. it is version 5.2.3

[Peter Van de Voorde]

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

[Hendrik Meiffert]

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.

[Peter Van de Voorde]

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