Plesk DNS records are not propagated to slave nodes, SOA serial is zero

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux
  • Plesk 12.5 for Windows

Created:

2016-11-16 12:53:36 UTC

Modified:

2016-12-21 19:28:19 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk DNS records are not propagated to slave nodes, SOA serial is zero

Symptoms

DNS records records are not propagated to slave name servers from Plesk Master DNS

following errors can be found in /var/log/messages :

May 14 16:33:15 vps-odin-1 named[2346]: zone domain.tld/IN: zone serial (0) unchanged. zone may fail to transfer to slaves.
May 14 16:33:15 vps-odin-1 named[2346]: zone domain.tld/IN: loaded serial 0

Update of SOA serial using dns utility does not help:

# /usr/local/psa/bin/dns --update-soa domain.tld
SUCCESS: Updating SOA record for domain.tld
# dig +short -t SOA domain.tld @localhost
ns1.domain.tld. webmaster.domain.tld. 0 10800 3600 604800 10800

There is zero value for domain.tld in serial field in psa database:

mysql> select id,name,status,syncSoa,syncRecords,serial_format,serial,external_id from dns_zone;
+----+----------------------+--------+---------+-------------+---------------+------------+-------------+
| id | name | status | syncSoa | syncRecords | serial_format | serial | external_id |
+----+----------------------+--------+---------+-------------+---------------+------------+-------------+
| 1 | domain.tld | 0 | skip | true | UNIXTIMESTAMP | 1431591919 | |
| 2 | domain.tld | 0 | skip | skip | UNIXTIMESTAMP | 0 | |
| 8 | test.domain.tld | 1 | true | skip | UNIXTIMESTAMP | 1431430823 | |
+----+----------------------+--------+---------+-------------+---------------+------------+-------------+
3 rows in set (0.00 sec)
mysql> select id,name,dns_zone_id,status from domains where name like '%domain.tld%';
+----+----------------------+-------------+--------+
| id | name | dns_zone_id | status |
+----+----------------------+-------------+--------+
| 1 | domain.tld | 1 | 0 |
| 7 | test.domain.tld | 8 | 0 |
+----+----------------------+-------------+--------+
2 rows in set (0.00 sec)

Cause

Inconsistency in psa database, SOA serial has 0 value.
Bug #PPPM-2755 . It is fixed in Plesk Onyx.

Resolution

Upgrade to the latest Plesk version .

If upgrade is not possible, perform the following steps to fix the issue:

  1. Create Plesk Database backup

  2. Remove records with zero serial from dns_zone table from psa database:

    mysql> delete from dns_zone where serial = 0 and name ='domain.tld';
  3. Update SOA record using dns utility:
    For Plesk 12.5:

    #usr/local/psa/bin/dns --update-soa -soa-refresh domain.tld

    For Plesk 12 and earlier:

    # /usr/local/psa/bin/dns --update-soa domain.tld
Have more questions? Submit a request
Please sign in to leave a comment.