On Thu, May 14, 2020 at 04:20:46PM +0300, Cristian Seres via Pdns-users wrote:
> Hi, > > one of three authoritative name servers (ns3) which uses authoritative > version 4.2.2 gives older serial number than the other two which use version > 4.1.13. > > MySQL sync is working properly and as far as I can see, databases are > identical. Also executing pdns-util increase-serial on the main server did > not correct the situation, the version 4.2.2 is still one step behind in > serial. > > All have default-soa-edit=INCEPTION-INCREMENT. The type if MASTER. I also > tried to comment out default-soa-edit on ns3, but after that, the serial was > two steps behind. AFAIK, if you are using native replication, the type of your zone should be native and not master. -Otto > > Is there a setting that can be used to fix this mismatch or is the only way > to upgrade all to 4.2.2 level? > > I have created a test zone on the servers. Here is some more information: > > # dig +short -t soa testxyz @ns1.contrasec.fi > ns1.contrasec.fi. domain.contrasec.fi. 2020051405 10800 3600 604800 3600 > # dig +short -t soa testxyz @ns3.contrasec.fi > ns1.contrasec.fi. domain.contrasec.fi. 2020051404 10800 3600 604800 3600 > > > ns1: > > # rpm -q pdns > pdns-4.1.13-1pdns.el7.x86_64 > > MariaDB [powerdns]> select * from domainmetadata where domain_id=265; > +-----+-----------+--------------+---------------------+ > | id | domain_id | kind | content | > +-----+-----------+--------------+---------------------+ > | 835 | 265 | SOA-EDIT-API | INCEPTION-INCREMENT | > +-----+-----------+--------------+---------------------+ > 1 row in set (0.00 sec) > > MariaDB [powerdns]> select * from records where domain_id=265; > +--------+-----------+---------+------+------------------------------------------------------------------------+-------+------+-------------+----------+-----------+------+ > | id | domain_id | name | type | content > | ttl | prio | change_date | disabled | ordername | auth | > +--------+-----------+---------+------+------------------------------------------------------------------------+-------+------+-------------+----------+-----------+------+ > | 439369 | 265 | testxyz | CAA | 0 issue "letsencrypt.org" > | 3600 | 0 | NULL | 0 | | 1 | > | 439370 | 265 | testxyz | CAA | 0 issuewild "letsencrypt.org" > | 3600 | 0 | NULL | 0 | | 1 | > | 439371 | 265 | testxyz | NS | ns1.contrasec.fi > | 86400 | 0 | NULL | 0 | | 1 | > | 439372 | 265 | testxyz | NS | ns2.contrasec.fi > | 86400 | 0 | NULL | 0 | | 1 | > | 439373 | 265 | testxyz | NS | ns3.contrasec.fi > | 86400 | 0 | NULL | 0 | | 1 | > | 439374 | 265 | testxyz | TXT | "v=spf1 -all" > | 3600 | 0 | NULL | 0 | | 1 | > | 439375 | 265 | testxyz | SOA | ns1.contrasec.fi domain.contrasec.fi > 2020051403 10800 3600 604800 3600 | 86400 | 0 | NULL | 0 | > | 1 | > +--------+-----------+---------+------+------------------------------------------------------------------------+-------+------+-------------+----------+-----------+------+ > 7 rows in set (0.00 sec) > > > > ns3: > > # rpm -q pdns > pdns-4.2.2-1pdns.el8.x86_64 > > MariaDB [powerdns]> select * from domainmetadata where domain_id=265; > +-----+-----------+--------------+---------------------+ > | id | domain_id | kind | content | > +-----+-----------+--------------+---------------------+ > | 835 | 265 | SOA-EDIT-API | INCEPTION-INCREMENT | > +-----+-----------+--------------+---------------------+ > 1 row in set (0.001 sec) > > MariaDB [powerdns]> select * from records where domain_id=265; > +--------+-----------+---------+------+------------------------------------------------------------------------+-------+------+-------------+----------+-----------+------+ > | id | domain_id | name | type | content > | ttl | prio | change_date | disabled | ordername | auth | > +--------+-----------+---------+------+------------------------------------------------------------------------+-------+------+-------------+----------+-----------+------+ > | 439369 | 265 | testxyz | CAA | 0 issue "letsencrypt.org" > | 3600 | 0 | NULL | 0 | | 1 | > | 439370 | 265 | testxyz | CAA | 0 issuewild "letsencrypt.org" > | 3600 | 0 | NULL | 0 | | 1 | > | 439371 | 265 | testxyz | NS | ns1.contrasec.fi > | 86400 | 0 | NULL | 0 | | 1 | > | 439372 | 265 | testxyz | NS | ns2.contrasec.fi > | 86400 | 0 | NULL | 0 | | 1 | > | 439373 | 265 | testxyz | NS | ns3.contrasec.fi > | 86400 | 0 | NULL | 0 | | 1 | > | 439374 | 265 | testxyz | TXT | "v=spf1 -all" > | 3600 | 0 | NULL | 0 | | 1 | > | 439375 | 265 | testxyz | SOA | ns1.contrasec.fi domain.contrasec.fi > 2020051403 10800 3600 604800 3600 | 86400 | 0 | NULL | 0 | > | 1 | > +--------+-----------+---------+------+------------------------------------------------------------------------+-------+------+-------------+----------+-----------+------+ > 7 rows in set (0.001 sec) > > > With best regards, > > -- > Cristian Seres > _______________________________________________ > Pdns-users mailing list > Pdns-users@mailman.powerdns.com > https://mailman.powerdns.com/mailman/listinfo/pdns-users _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users