Unable to create domain alias: "DNS record does not exist"

Created:

2016-11-16 13:16:00 UTC

Modified:

2017-08-16 15:45:46 UTC

2

Was this article helpful?


Have more questions?

Submit a request

Unable to create domain alias: "DNS record does not exist"

Applicable to:

  • Plesk 11.x for Linux

Symptoms

An attempt to create a domain alias in Parallels Plesk Panel (Plesk) 11 fails with this error:

DNS record does not exist

Cause

The problem is caused by a database inconsistency that is the result of an error in the product. The problem has been fixed in Parallels Plesk Panel 11.5.

Diagnostics

The resolution provided in this article can be applied only if the following SQL query performed in the psa database returns a non-empty set:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin psa -e "SELECT * FROM dns_refs WHERE templateRecordId NOT IN (SELECT id FROM dns_recs_t)"

Resolution

To solve the problem, remove DNS record references that point to non-existent DNS template records using the following SQL query:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin psa -e "DELETE FROM dns_refs WHERE templateRecordId NOT IN (SELECT id FROM dns_recs_t)"

This query will not alter DNS zones and no DNS records will be lost.

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