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

Created:

2016-11-16 12:53:36 UTC

Modified:

2017-04-24 12:08:26 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

Applicable to:

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

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.