Domain backup fails with error: "DNS zone id is not found in dns_zone"

Refers to:

  • Plesk 11.0 for Windows
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Created:

2016-11-16 13:07:29 UTC

Modified:

2016-12-21 20:00:19 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Domain backup fails with error: "DNS zone id is not found in dns_zone"

Symptoms

Plesk backups fails the error:

    Error: domain "domain.tld" 
Unable to create dump
Error: domain "domain.tld"
Broken referencial integrity: DNS zone id 219 is not found in dns_zone

Cause

The record for domain is mising from psa.dns_zone table:

    # plesk db

mysql> select * from dns_zone where id=219;
Empty set (0.00 sec)

Resolution

1) Backup Plesk databases before any changes:

    mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > ~/psa_`date +%F_%H.%M`.sql

2) Access to Plesk database and add dns_zone for domain in dns_zone table:

    mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa

mysql> INSERT INTO `dns_zone` VALUES (219,'domain.tld','domain.tld',0,'true','true','test@domain.tld','master',86400,86400,10800,3600,3600,3600,604800,86400,10800,3600,'UNIXTIMESTAMP','1389108685')
Query OK, 1 row affected (0.30 sec)
Have more questions? Submit a request
Please sign in to leave a comment.