• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Migration error [ERROR] Failed to import backup dumps to target panel's repository

JuanjoSC

JuanjoSC

Basic Pleskian
Hi,

I'm trying to migrate from another server and I see this error in logs:

[ERROR] Failed to import backup dumps to target panel's repository
Cause: Failed to import backup XML: errcode must be '0' (no errors) or '116' (backup sign error).
Output of pmmcli utility:
<?xml version="1.0" encoding="UTF-8"?>
<response>
<errcode>152</errcode>
<errmsg>Unable to import file as dump: The file you are trying to upload is not a valid backup file</errmsg>
</response>

That is a critical error, migration was stopped.
Click to expand...

I'm using plesk 12.5 - CentOS 7 in a fresh instalation

The source server is plesk 12.5 with centos 6.7
 
<errcode>152</errcode>
Click to expand...

Code '152' means following:

# perror 152
MySQL error code 152: Cannot delete a parent row

I would suggest you check mysql logs. Looks like there is some kind of inconsistency or corrupted tables.
Also fixing possible database inconsistencies on both servers with

# plesk repair db

would be useful before starting migration.
 
Thanks, I repaired the inconsistencies in the databases, but the problem is the same:


<errcode>152</errcode>
<errmsg>Unable to import file as dump: The file you are trying to upload is not a valid backup file</errmsg>
 
It seems that the problem is the source. (I tried another target server)
This is an upgrade from Plesk 12.0
 
Hello! Most common reason of such issue is enabled mod_security on source Plesk server. It is a bug PMT-2318 and it is already fixed in Plesk Migrator 1.3.15. Could you please upgrade Plesk Migrator extension to 1.3.15 and try again? Please let me know, if it does not help.
 
Hi Aleksey,

You helped me in a previos thread and suggested that I install the plesk Migrator,
I installed Plesk migrator 1.3.15 today and it gives the same errors:

Migrating from a 11.5 server (Centos 5.3) to a new 12.5 server (Centos 6.7).

Code: 
[INFO] Restore security policy on Windows nodes
[ERROR] Failed to import backup dumps to target panel's repository
Cause: Failed to import backup XML: errcode must be '0' (no errors) or '116' (backup sign error).
Output of pmmcli utility:
<?xml version="1.0" encoding="UTF-8"?>
<response>
    <errcode>152</errcode>
    <errmsg>Unable to import file as dump: The file you are trying to upload is not a valid backup file</errmsg>
</response>

That is a critical error, migration was stopped.

As far as I'm aware, Mod_security isn't on the 11.5 source server. I tried the # plesk db repair and the destination DB is fine.

I'm stuck as this is happening on all domains I'm trying to migrate across.
 
Last edited:
Here's part of the debug log (1 of 2):

Code: 
+|2015-11-03_16:32:58,371|D|MT|core|||Call local command: /bin/sh -c '/usr/local/psa/admin/bin/pmmcli --import-file-as-dump'
+|2015-11-03_16:33:00,714|D|MT|core.workflow.runner.by_subscription|||Enter common action block
+|2015-11-03_16:33:00,714|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2015-11-03_16:33:00,714|D|MT|core.workflow.runner.by_subscription|||START: Get operation progress in current session
+|2015-11-03_16:33:00,714|D|MT|core.workflow.runner.by_subscription|||FINISH: Get operation progress in current session
+|2015-11-03_16:33:00,715|D|MT|core.workflow.runner.by_subscription|||Exit common action block
+|2015-11-03_16:33:00,897|D|MT|core|||Command stdout: <?xml version="1.0" encoding="UTF-8"?>
=|2015-11-03_16:33:00,897|D|MT|core|||<response>
=|2015-11-03_16:33:00,897|D|MT|core|||    <errcode>152</errcode>
=|2015-11-03_16:33:00,897|D|MT|core|||    <errmsg>Unable to import file as dump: The file you are trying to upload is not a valid backup file</errmsg>
=|2015-11-03_16:33:00,897|D|MT|core|||</response>
=|2015-11-03_16:33:00,897|D|MT|core|||
+|2015-11-03_16:33:00,898|D|MT|core|||Command stderr:
+|2015-11-03_16:33:00,898|D|MT|core|||Command exit code: 0
+|2015-11-03_16:33:00,898|D|MT|core.workflow.runner.by_subscription|||Exception:
=|Traceback (most recent call last):
=|  File "/usr/local/psa/admin/plib/modules/panel-migrator/backend/lib/python/parallels/core/workflow/runner/by_subscription.py", line 115, in _run_common_action_plain
=|    run()
=|  File "/usr/local/psa/admin/plib/modules/panel-migrator/backend/lib/python/parallels/core/workflow/runner/by_subscription.py", line 108, in run
=|    action.run(self._context)
=|  File "/usr/local/psa/admin/plib/modules/panel-migrator/backend/lib/python/parallels/core/actions/hosting_settings/import_backups.py", line 41, in run
=|    self._import_backup(global_context, backup, panel_target_server)
=|  File "/usr/local/psa/admin/plib/modules/panel-migrator/backend/lib/python/parallels/core/actions/hosting_settings/import_backups.py", line 69, in _import_backup
=|    additional_env_vars=global_context.target_panel_obj.get_import_dump_additional_env_vars(global_context)
=|  File "/usr/local/psa/admin/plib/modules/panel-migrator/backend/lib/python/parallels/core/utils/restore_hosting_utils.py", line 52, in import_backup
=|    raise Exception(messages.ERROR_FAILED_TO_IMPORT_DUMP % (import_result.raw_stdout))
=|Exception: Failed to import backup XML: errcode must be '0' (no errors) or '116' (backup sign error).
=|Output of pmmcli utility:
=|<?xml version="1.0" encoding="UTF-8"?>
=|<response>
=|    <errcode>152</errcode>
=|    <errmsg>Unable to import file as dump: The file you are trying to upload is not a valid backup file</errmsg>
=|</response>
=|
+|2015-11-03_16:33:00,899|D|MT|core.workflow.runner.by_subscription|||Execute shutdown action 'restore-apache-restart-interval'
+|2015-11-03_16:33:00,899|D|MT|core.workflow.runner.by_subscription|||Enter common action block
+|2015-11-03_16:33:00,899|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2015-11-03_16:33:00,899|I|MT|core.workflow.runner.by_subscription|||Restore Apache restart interval
+|2015-11-03_16:33:00,900|D|MT|plesk.actions.apache_restart_interval.restore|||Restore old Apache restart interval value
+|2015-11-03_16:33:00,900|D|MT|core|||Call local command: /bin/sh -c '/usr/local/psa/bin/server_pref -u -restart-apache 0'
+|2015-11-03_16:33:01,579|D|MT|core|||Command stdout: SUCCESS: Server preferences are successfully updated
=|2015-11-03_16:33:01,579|D|MT|core|||
+|2015-11-03_16:33:01,579|D|MT|core|||Command stderr:
+|2015-11-03_16:33:01,579|D|MT|core|||Command exit code: 0
+|2015-11-03_16:33:01,580|I|MT|plesk.actions.apache_restart_interval.restore|||Force Apache restart
+|2015-11-03_16:33:01,580|D|MT|core|||Call local command: /bin/sh -c '/usr/local/psa/admin/bin/websrvmng -r'
+|2015-11-03_16:33:04,510|D|MT|core|||Command stdout:
+|2015-11-03_16:33:04,511|D|MT|core|||Command stderr:
+|2015-11-03_16:33:04,511|D|MT|core|||Command exit code: 0
+|2015-11-03_16:33:04,511|D|MT|core.workflow.runner.by_subscription|||Exit common action block
+|2015-11-03_16:33:04,511|D|MT|core.workflow.runner.by_subscription|||Execute shutdown action 'restore-windows-security-policy'
+|2015-11-03_16:33:04,511|D|MT|core.workflow.runner.by_subscription|||Enter common action block
+|2015-11-03_16:33:04,511|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2015-11-03_16:33:04,511|I|MT|core.workflow.runner.by_subscription|||Restore security policy on Windows nodes
+|2015-11-03_16:33:04,511|D|MT|core.workflow.runner.by_subscription|||Exit common action block
+|2015-11-03_16:33:04,512|D|MT|core.workflow.runner.by_subscription|||Execute shutdown action 'cleanup'
+|2015-11-03_16:33:04,512|D|MT|core.workflow.runner.by_subscription|||Enter common action block
+|2015-11-03_16:33:04,512|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2015-11-03_16:33:04,512|D|MT|core.workflow.runner.by_subscription|||START: Uninstall migration agent files
+|2015-11-03_16:33:04,512|D|MT|core.workflow.runner.by_subscription|||FINISH: Uninstall migration agent files
+|2015-11-03_16:33:04,512|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2015-11-03_16:33:04,512|D|MT|core.workflow.runner.by_subscription|||START: Remove temporary SSH keys
+|2015-11-03_16:33:04,512|D|MT|core.workflow.runner.by_subscription|||FINISH: Remove temporary SSH keys
+|2015-11-03_16:33:04,512|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2015-11-03_16:33:04,513|D|MT|core.workflow.runner.by_subscription|||START: Close SSH connections
+|2015-11-03_16:33:04,513|D|MT|core.connections.ssh.connection_pool|||Closing SSH connection to the source server 'source' (217.174.254.200)
+|2015-11-03_16:33:04,513|D|MT|core.connections.ssh.server_connection.lazy_open|||Close SSH connection to the the source server 'source' (217.174.254.200)
+|2015-11-03_16:33:04,544|D|MT|core.workflow.runner.by_subscription|||FINISH: Close SSH connections
 
here's the last section of the debug log
Code: 
+|2015-11-03_16:33:04,544|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2015-11-03_16:33:04,544|D|MT|core.workflow.runner.by_subscription|||START: Shutdown Windows rsync servers
+|2015-11-03_16:33:04,545|D|MT|core.workflow.runner.by_subscription|||FINISH: Shutdown Windows rsync servers
+|2015-11-03_16:33:04,545|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2015-11-03_16:33:04,545|D|MT|core.workflow.runner.by_subscription|||START: Stop remote Windows agents
+|2015-11-03_16:33:04,545|D|MT|core.workflow.runner.by_subscription|||FINISH: Stop remote Windows agents
+|2015-11-03_16:33:04,545|D|MT|core.workflow.runner.by_subscription|||Exit common action block
+|2015-11-03_16:33:04,545|D|MT|parallels|||Context:
=|2015-11-03_16:33:04,545|D|MT|parallels|||Traceback (most recent call last):
=|2015-11-03_16:33:04,545|D|MT|parallels|||  File "/usr/local/psa/admin/plib/modules/panel-migrator/backend/lib/python/parallels/core/cli/common_cli.py", line 50, in run
=|2015-11-03_16:33:04,545|D|MT|parallels|||    options.method(migrator.action_runner)
=|2015-11-03_16:33:04,545|D|MT|parallels|||  File "/usr/local/psa/admin/plib/modules/panel-migrator/backend/lib/python/parallels/core/cli/migration_cli.py", line 298, in <lambda>
=|2015-11-03_16:33:04,545|D|MT|parallels|||    lambda runner: runner.run_entry_point('transfer-accounts'),
=|2015-11-03_16:33:04,545|D|MT|parallels|||  File "/usr/local/psa/admin/plib/modules/panel-migrator/backend/lib/python/parallels/core/workflow/runner/base.py", line 35, in run_entry_point
=|2015-11-03_16:33:04,545|D|MT|parallels|||    self.run(entry_point)
=|2015-11-03_16:33:04,545|D|MT|parallels|||  File "/usr/local/psa/admin/plib/modules/panel-migrator/backend/lib/python/parallels/core/workflow/runner/by_subscription.py", line 61, in run
=|2015-11-03_16:33:04,545|D|MT|parallels|||    self._run_common_actions_tree(actions_tree)
=|2015-11-03_16:33:04,545|D|MT|parallels|||  File "/usr/local/psa/admin/plib/modules/panel-migrator/backend/lib/python/parallels/core/workflow/runner/by_subscription.py", line 85, in _run_common_actions_tree
=|2015-11-03_16:33:04,545|D|MT|parallels|||    self._run_common_actions_tree(action, action_path)
=|2015-11-03_16:33:04,545|D|MT|parallels|||  File "/usr/local/psa/admin/plib/modules/panel-migrator/backend/lib/python/parallels/core/workflow/runner/by_subscription.py", line 93, in _run_common_actions_tree
=|2015-11-03_16:33:04,545|D|MT|parallels|||    self._run_common_action_plain(action)
=|2015-11-03_16:33:04,545|D|MT|parallels|||  File "/usr/local/psa/admin/plib/modules/panel-migrator/backend/lib/python/parallels/core/workflow/runner/by_subscription.py", line 128, in _run_common_action_plain
=|2015-11-03_16:33:04,545|D|MT|parallels|||    raise MigrationError(full_failure_message)
=|2015-11-03_16:33:04,545|D|MT|parallels|||MigrationError: Failed to import backup dumps to target panel's repository
=|2015-11-03_16:33:04,545|D|MT|parallels|||Cause: Failed to import backup XML: errcode must be '0' (no errors) or '116' (backup sign error).
=|2015-11-03_16:33:04,545|D|MT|parallels|||Output of pmmcli utility:
=|2015-11-03_16:33:04,545|D|MT|parallels|||<?xml version="1.0" encoding="UTF-8"?>
=|2015-11-03_16:33:04,545|D|MT|parallels|||<response>
=|2015-11-03_16:33:04,545|D|MT|parallels|||    <errcode>152</errcode>
=|2015-11-03_16:33:04,545|D|MT|parallels|||    <errmsg>Unable to import file as dump: The file you are trying to upload is not a valid backup file</errmsg>
=|2015-11-03_16:33:04,545|D|MT|parallels|||</response>
=|2015-11-03_16:33:04,545|D|MT|parallels|||
=|2015-11-03_16:33:04,545|D|MT|parallels|||That is a critical error, migration was stopped.
+|2015-11-03_16:33:04,545|E|MT|parallels|||Failed to import backup dumps to target panel's repository
=|2015-11-03_16:33:04,545|E|MT|parallels|||Cause: Failed to import backup XML: errcode must be '0' (no errors) or '116' (backup sign error).
=|2015-11-03_16:33:04,545|E|MT|parallels|||Output of pmmcli utility:
=|2015-11-03_16:33:04,545|E|MT|parallels|||<?xml version="1.0" encoding="UTF-8"?>
=|2015-11-03_16:33:04,545|E|MT|parallels|||<response>
=|2015-11-03_16:33:04,545|E|MT|parallels|||    <errcode>152</errcode>
=|2015-11-03_16:33:04,545|E|MT|parallels|||    <errmsg>Unable to import file as dump: The file you are trying to upload is not a valid backup file</errmsg>
=|2015-11-03_16:33:04,545|E|MT|parallels|||</response>
=|2015-11-03_16:33:04,545|E|MT|parallels|||
=|2015-11-03_16:33:04,545|E|MT|parallels|||That is a critical error, migration was stopped.
+|2015-11-03_16:33:07,245|D|MT|core.workflow.runner.by_subscription|||Enter common action block
+|2015-11-03_16:33:07,245|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2015-11-03_16:33:07,245|D|MT|core.workflow.runner.by_subscription|||START: Get operation progress in current session
+|2015-11-03_16:33:07,268|D|MT|core.workflow.runner.by_subscription|||FINISH: Get operation progress in current session
+|2015-11-03_16:33:07,268|D|MT|core.workflow.runner.by_subscription|||Exit common action block
+|2015-11-03_16:33:27,935|D|MT|core.workflow.runner.by_subscription|||Enter common action block
+|2015-11-03_16:33:27,935|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2015-11-03_16:33:27,936|D|MT|core.workflow.runner.by_subscription|||START: Get operation progress in current session
+|2015-11-03_16:33:27,936|D|MT|core.workflow.runner.by_subscription|||FINISH: Get operation progress in current session
+|2015-11-03_16:33:27,936|D|MT|core.workflow.runner.by_subscription|||Exit common action block
 
I assume this pre-check wouldn't cause the failiure...
Code: 
Backup files of MySQL database servers earlier than 5.1 (localhost:3306) might not be restored on MySQL 5.1.x because MySQL 5.1.x handles Unicode characters differently.
The following Apache modules are not installed on the destination server: mem_cache, file_cache. Please install and enable these modules to prevent possible problems.
 
Hello Paul_Daly! Could you please send me (privately) source server dump files, located on target Plesk server:

/usr/local/psa/var/modules/panel-migrator/sessions/<session_name>/plesk.backup.source.raw.tar
/usr/local/psa/var/modules/panel-migrator/sessions/<session_name>/plesk.backup.source.converted.tar

Where <session_name> - automatically generated name of migration session in format YYYYMMDDHHIISS, if you run migration via GUI, or just default "migration_session", if you run migration via CLI. Dump file name also may be a bit different: "source" suffix - is the name of section in configuration file, where source server settings was defined.

Then we can try to restore this dumps on our test environment and locate an issue.

Or you can try to do following:
  • Go to your target Plesk 12.5 panel
  • Open Tools & Settings / Backup Manager
  • Click Upload button
  • Choose this file to upload - plesk.backup.source.converted.tar (locates on target Plesk server, as noted above)
  • Check Upload backup files without a valid signature
  • Uncheck Use password protection
  • Click OK button
  • Wait while upload will be completed (error like "Unable to upload plesk.backup.pfu.converted.tar to the server storage: Unable to import file as dump: The file you are trying to upload is not a valid backup file" should be displayed)
  • Open just created item in list of backups
  • See actual error in Error log text area
If you done this, could you please post here an error?
 
You must log in or register to reply here.

Similar threads

G
Issue Plesk Migrator: Subscribers, Service Plans and Customers not properly transferred
Replies
12
Views
1K
Peter Debik
P
J
Issue mail import fails
Replies
1
Views
356
Peter Debik
P
W
Issue backup task error | Unable to save statistics. Error: DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
2
Views
859
Wolfgang Reidlinger
W
K
Issue Plesk Migrator - Obsidian 18.0.56 - Errors / unable to migrate
Replies
4
Views
2K
salvis
S
Z
Issue Backup error. Error: Failed to exec mysqldump: Exit code: 3
Replies
3
Views
3K
Peter Debik
P
Back
Top