Search Engine: Elastic

Article ID: 125590, created on May 22, 2015, last review on Sep 24, 2016

  • Applies to:
  • Plesk Automation 11.5

Symptoms

  1. When creating webspace the following error occurs:

    Unable to create the domain `example.com` because a DNS record pointing to the host example.com already exists.
    
  2. When creating domain the following error appears:

    This DNS record already exists.
    
  3. There is no such a domain on the Provider CP > Services > Websites or Provider CP > Services > DNS Zones page.

Cause

Webspace example.com was deleted incorrectly and some records still remain in the database.

Resolution

  1. Create backup of Plesk Automation (PA) databases according to this article.

  2. Check the Services > DNS Zones in PA Control Panel and delete records for the domain example.com.

  3. Go to psa datababase on PA Management node and find the id for the DNS zone example.com:

    # mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
    
    mysql> select id from dns_zone where name='example.com';
    +-----+
    | id  |
    +-----+
    | 274 |
    +-----+
    
  4. If dns_zone table does not contain any records check the dns_rec table:

    mysql> select id, dns_zone_id, displayHost, host from dns_recs where host like '%example%';
    +--------+------------+---------------------+---------------------+
    | id     | dns_zone_id| displayHost         | host                |
    +--------+------------+---------------------+---------------------+
    | 860104 |       274  | ipv4.example.com.   | ipv4.example.com.   |
    | 860105 |       274  | ftp.example.com.    | ftp.example.com.    |
    | 860106 |       274  | example.com.        | example.com.        |
    | 860108 |       274  | example.com.        | example.com.        |
    | 860110 |       274  | webmail.example.com.| webmail.example.com.|
    | 860111 |       274  | www.example.com.    | www.example.com.    |
    | 860112 |       274  | example.com.        | example.com.        |
    | 860113 |       274  | mail.example.com.   | mail.example.com.   |
    +--------+------------+---------------------+---------------------+
    
  5. Clean up corresponding rows in psa.dns_recs and psa.dns_zone tables:

    mysql> delete from dns_zone where id = '274';
    mysql> delete from dns_recs where dns_zone_id = '274';
    
  6. Restart failed task.

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF