Migration fails: SQLSTATE[HY000] [2002] Connection refused

Created:

2016-12-21 22:05:26 UTC

Modified:

2017-08-09 12:29:30 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Migration fails: SQLSTATE[HY000] [2002] Connection refused

Issue Symptoms

  1. During the migration process Plesk shows the following error on the current migration's page:

    Internal error ;-P ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] Connection refused (Abstract.php:144)
    
  2. When the migration is finished, in [Details] the following can be found:

    [Migration] Failed to copy content of database 'db_example' Migration tools tried to perform operation in 3 attempts.
    ----------------------------------------------------------------------------
    Attempt #1 failed with the following error: Command execution failed on the local server with non-zero exit code. command: mysql --defaults-file=/usr/local/psa/var/modules/panel-migrator/sessions/20161221153145/target-server/my_localhost_db_example.cnf -h localhost -P 3306 -uadmin db_example < /usr/local/psa/var/modules/panel-migrator/sessions/20161221153145/target-server/db-dumps/db_example.sql exit code: 1 stdout: stderr: ERROR 2013 (HY000) at line 823: Lost connection to MySQL server during query

Conditions

Insufficient RAM on the destination server.

Resolution

Increase RAM on the destination server at least to 3Gb and re-sync the migrated subscription:

Have more questions? Submit a request
Please sign in to leave a comment.