Migration or backup failed with error: Sys user ID is not found in sys_users

Created:

2016-11-16 12:47:55 UTC

Modified:

2017-04-24 11:34:26 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Migration or backup failed with error: Sys user ID is not found in sys_users

Applicable to:

  • Plesk 10.4 for Linux
  • Plesk 11.0 for Linux

Symptoms

While migrating accounts from old server using Plesk Migration Manager, the following error appears:

Broken referencial integrity: Sys user id 72 is not found in sys_users

Cause

Database inconsistency on the destination server.

Resolution

  1. Run database integrity checker:

    # /usr/local/psa/bin/sw-engine-pleskrun check_db_integrity-beta.php
  2. It reported the following result:

    List of records in [psa.ftp_users.sys_user_id] that miss a matching record in [psa.sys_users.id]
    72
  3. Dump current database state:

    # mysqldump  -uadmin -p` cat /etc/psa/.psa.shadow ` psa > /root/psa_KCS7893.sql
  4. Delete redundant record from " psa.ftp_users " table:

    # mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -e "delete from ftp_users where sys_user_id=72"

Additional information

#213391369 Plesk Database Inconsistency Checker (Beta).

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