[Pdns-users] Mysql entries with type NULL when adding records with subdomain

[Christian Lox]

Hi.

We updated our authoritative servers finally to 5.0.
Now we notice a (strange?) behaviour….
All Pdns server use mysql as backend, but not mysql replication.
When adding an entry on the master like i.e. 
pdnsutil rrset add monfortedalba.de _token._dnswl.monfortedalba.de TXT „bla"
we find on the secondaries dbs (after notifying/AXFR) the following:

mysql> select * from records where domain_id = 23 and name like '%dnswl%';
+-------+-----------+--------------------------------+------+---------+------+------+----------+-----------+------+
| id    | domain_id | name                           | type | content | ttl  | prio | disabled | ordername | auth |
+-------+-----------+--------------------------------+------+---------+------+------+----------+-----------+------+
| 52228 |        23 | _token._dnswl.monfortedalba.de | TXT  | "test"  | 3600 |    0 |        0 | NULL      |    1 |
| 52229 |        23 | _dnswl.monfortedalba.de        | NULL | NULL    | NULL | NULL |        0 | NULL      |    1 |
+-------+-----------+--------------------------------+------+---------+------+------+----------+-----------+------+
2 rows in set (0.00 sec) 

On the master the databases only lists the added record:
mysql> select * from records where domain_id=28 and name like '%dnswl%';
+------+-----------+--------------------------------+------+---------+------+------+----------+-----------+------+
| id   | domain_id | name                           | type | content | ttl  | prio | disabled | ordername | auth |
+------+-----------+--------------------------------+------+---------+------+------+----------+-----------+------+
| 1783 |        28 | _token._dnswl.monfortedalba.de | TXT  | "test"  | 3600 |    0 |        0 | NULL      |    1 |
+------+-----------+--------------------------------+------+---------+------+------+----------+-----------+------+
1 row in set (0.00 sec)

Is this behaviour intended or is something misconfigured on our side?

Thanks for any hint,
Christian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20251026/e93deae0/attachment.htm>