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.

Search Words

Unable to create the domain because a DNS record pointing to the host already exists

DNS exist

Unable to create domain

The DNS record already exists.

I cannot add a domain because dns error

slave dns not being synced with the primary dns

I cannot add domain it gives dns error

This DNS record already exists.

Remove webspace

DNS record already exists

DNS

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF