Mysql entries with type NULL when adding records with subdomain
Christian Lox via Pdns-users <[email protected]> Sun, 26 Oct 2025 18:36:29 +0100
| Newsgroups | gmane.network.dns.powerdns.user |
|---|---|
| Message-ID | <6fb2c4d9.AVIAAIAOafwAAAAAAAAAA-O4SGkAAYCq-lkAAAAAAAvGpABo_lwr@mailjet.com> |
--===============4197360525080962631== Content-Type: multipart/alternative; boundary="Apple-Mail=_F2ACB2DF-BE33-4FCA-B22F-BF5AE955ABAE" --Apple-Mail=_F2ACB2DF-BE33-4FCA-B22F-BF5AE955ABAE Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Hi. We updated our authoritative servers finally to 5.0. Now we notice a (strange?) behaviour=E2=80=A6. All Pdns server use mysql as backend, but not mysql replication. When adding an entry on the master like i.e.=20 pdnsutil rrset add monfortedalba.de _token._dnswl.monfortedalba.de TXT =E2= =80=9Ebla" we find on the secondaries dbs (after notifying/AXFR) the following: mysql> select * from records where domain_id =3D 23 and name like '%dnswl%'= ; +-------+-----------+--------------------------------+------+---------+----= --+------+----------+-----------+------+ | id | domain_id | name | type | content | ttl= | prio | disabled | ordername | auth | +-------+-----------+--------------------------------+------+---------+----= --+------+----------+-----------+------+ | 52228 | 23 | _token._dnswl.monfortedalba.de | TXT | "test" | 360= 0 | 0 | 0 | NULL | 1 | | 52229 | 23 | _dnswl.monfortedalba.de | NULL | NULL | NUL= L | NULL | 0 | NULL | 1 | +-------+-----------+--------------------------------+------+---------+----= --+------+----------+-----------+------+ 2 rows in set (0.00 sec)=20 On the master the databases only lists the added record: mysql> select * from records where domain_id=3D28 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 = --Apple-Mail=_F2ACB2DF-BE33-4FCA-B22F-BF5AE955ABAE Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 <html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset= =3Dutf-8"></head><body style=3D"overflow-wrap: break-word; -webkit-nbsp-mod= e: space; line-break: after-white-space;">Hi.<div><br></div><div>We updated= our authoritative servers finally to 5.0.</div><div>Now we notice a (stran= ge?) behaviour=E2=80=A6.</div><div>All Pdns server use mysql as backend, bu= t not mysql replication.</div><div>When adding an entry on the master like = i.e. </div><div><p style=3D"margin: 0px; font-style: normal; font-vari= ant-caps: normal; font-width: normal; font-size: 11px; line-height: normal;= font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-varia= nt-alternates: normal; font-variant-ligatures: normal; font-variant-numeric= : normal; font-variant-east-asian: normal; font-variant-position: normal; f= ont-variant-emoji: normal; font-feature-settings: normal; font-optical-sizi= ng: auto; font-variation-settings: normal;"><span style=3D"font-variant-lig= atures: no-common-ligatures">pdnsutil rrset add monfortedalba.de _token._dn= swl.monfortedalba.de TXT =E2=80=9Ebla"</span></p><p style=3D"margin: 0px; f= ont-style: normal; font-variant-caps: normal; font-width: normal; line-heig= ht: normal; font-size-adjust: none; font-kerning: auto; font-variant-altern= ates: normal; font-variant-ligatures: normal; font-variant-numeric: normal;= font-variant-east-asian: normal; font-variant-position: normal; font-featu= re-settings: normal; font-optical-sizing: auto; font-variation-settings: no= rmal;">we find on the secondaries dbs (after notifying/AXFR) the following:= </p><p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal;= font-width: normal; line-height: normal; font-size-adjust: none; font-kern= ing: auto; font-variant-alternates: normal; font-variant-ligatures: normal;= font-variant-numeric: normal; font-variant-east-asian: normal; font-varian= t-position: normal; font-feature-settings: normal; font-optical-sizing: aut= o; font-variation-settings: normal;"><br></p><p style=3D"margin: 0px; font-= style: normal; font-variant-caps: normal; font-width: normal; font-size: 11= px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-k= erning: auto; font-variant-alternates: normal; font-variant-ligatures: norm= al; font-variant-numeric: normal; font-variant-east-asian: normal; font-var= iant-position: normal; font-variant-emoji: normal; font-feature-settings: n= ormal; font-optical-sizing: auto; font-variation-settings: normal;"><span s= tyle=3D"font-variant-ligatures: no-common-ligatures">mysql> select * fro= m records where domain_id =3D 23 and name like '%dnswl%';</span></p> <p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; fon= t-width: normal; font-size: 11px; line-height: normal; font-family: Menlo; = font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal= ; font-variant-ligatures: normal; font-variant-numeric: normal; font-varian= t-east-asian: normal; font-variant-position: normal; font-variant-emoji: no= rmal; font-feature-settings: normal; font-optical-sizing: auto; font-variat= ion-settings: normal;"><span style=3D"font-variant-ligatures: no-common-lig= atures">+-------+-----------+--------------------------------+------+------= ---+------+------+----------+-----------+------+</span></p> <p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; fon= t-width: normal; font-size: 11px; line-height: normal; font-family: Menlo; = font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal= ; font-variant-ligatures: normal; font-variant-numeric: normal; font-varian= t-east-asian: normal; font-variant-position: normal; font-variant-emoji: no= rmal; font-feature-settings: normal; font-optical-sizing: auto; font-variat= ion-settings: normal;"><span style=3D"font-variant-ligatures: no-common-lig= atures">| id | domain_id | name &n= bsp; | type | conte= nt | ttl | prio | disabled | ordername | auth |</span></p> <p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; fon= t-width: normal; font-size: 11px; line-height: normal; font-family: Menlo; = font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal= ; font-variant-ligatures: normal; font-variant-numeric: normal; font-varian= t-east-asian: normal; font-variant-position: normal; font-variant-emoji: no= rmal; font-feature-settings: normal; font-optical-sizing: auto; font-variat= ion-settings: normal;"><span style=3D"font-variant-ligatures: no-common-lig= atures">+-------+-----------+--------------------------------+------+------= ---+------+------+----------+-----------+------+</span></p> <p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; fon= t-width: normal; font-size: 11px; line-height: normal; font-family: Menlo; = font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal= ; font-variant-ligatures: normal; font-variant-numeric: normal; font-varian= t-east-asian: normal; font-variant-position: normal; font-variant-emoji: no= rmal; font-feature-settings: normal; font-optical-sizing: auto; font-variat= ion-settings: normal;"><span style=3D"font-variant-ligatures: no-common-lig= atures">| 52228 | 23 | _token._dnswl.monfortedal= ba.de | TXT | "test" | 3600 | 0 | &nb= sp; 0 | NULL | 1 |</span></p> <p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; fon= t-width: normal; font-size: 11px; line-height: normal; font-family: Menlo; = font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal= ; font-variant-ligatures: normal; font-variant-numeric: normal; font-varian= t-east-asian: normal; font-variant-position: normal; font-variant-emoji: no= rmal; font-feature-settings: normal; font-optical-sizing: auto; font-variat= ion-settings: normal;"><span style=3D"font-variant-ligatures: no-common-lig= atures">| 52229 | 23 | _dnswl.monfortedalba.de&n= bsp; | NULL | NULL | NULL | NULL | = 0 | NULL | 1 |</span>= </p> <p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; fon= t-width: normal; font-size: 11px; line-height: normal; font-family: Menlo; = font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal= ; font-variant-ligatures: normal; font-variant-numeric: normal; font-varian= t-east-asian: normal; font-variant-position: normal; font-variant-emoji: no= rmal; font-feature-settings: normal; font-optical-sizing: auto; font-variat= ion-settings: normal;"><span style=3D"font-variant-ligatures: no-common-lig= atures">+-------+-----------+--------------------------------+------+------= ---+------+------+----------+-----------+------+</span></p> <p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; fon= t-width: normal; line-height: normal; font-size-adjust: none; font-kerning:= auto; font-variant-alternates: normal; font-variant-ligatures: normal; fon= t-variant-numeric: normal; font-variant-east-asian: normal; font-variant-po= sition: normal; font-feature-settings: normal; font-optical-sizing: auto; f= ont-variation-settings: normal;"><span style=3D"font-family: Menlo; font-si= ze: 11px;">2 rows in set (0.00 sec)</span> </p><p style=3D"margin: 0px= ; font-style: normal; font-variant-caps: normal; font-width: normal; line-h= eight: normal; font-size-adjust: none; font-kerning: auto; font-variant-alt= ernates: normal; font-variant-ligatures: normal; font-variant-numeric: norm= al; font-variant-east-asian: normal; font-variant-position: normal; font-fe= ature-settings: normal; font-optical-sizing: auto; font-variation-settings:= normal;"><br></p><p style=3D"margin: 0px; font-style: normal; font-variant= -caps: normal; font-width: normal; line-height: normal; font-size-adjust: n= one; font-kerning: auto; font-variant-alternates: normal; font-variant-liga= tures: normal; font-variant-numeric: normal; font-variant-east-asian: norma= l; font-variant-position: normal; font-feature-settings: normal; font-optic= al-sizing: auto; font-variation-settings: normal;">On the master the databa= ses only lists the added record:</p><p style=3D"margin: 0px; font-style: no= rmal; font-variant-caps: normal; font-width: normal; font-size: 11px; line-= height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: a= uto; font-variant-alternates: normal; font-variant-ligatures: normal; font-= variant-numeric: normal; font-variant-east-asian: normal; font-variant-posi= tion: normal; font-variant-emoji: normal; font-feature-settings: normal; fo= nt-optical-sizing: auto; font-variation-settings: normal;"><span style=3D"f= ont-variant-ligatures: no-common-ligatures">mysql> select * from records= where domain_id=3D28 and name like '%dnswl%';</span></p><p style=3D"margin= : 0px; font-style: normal; font-variant-caps: normal; font-width: normal; f= ont-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust: = none; font-kerning: auto; font-variant-alternates: normal; font-variant-lig= atures: normal; font-variant-numeric: normal; font-variant-east-asian: norm= al; font-variant-position: normal; font-variant-emoji: normal; font-feature= -settings: normal; font-optical-sizing: auto; font-variation-settings: norm= al;"><span style=3D"font-variant-ligatures: no-common-ligatures">+------+--= ---------+--------------------------------+------+---------+------+------+-= ---------+-----------+------+</span></p><p style=3D"margin: 0px; font-style= : normal; font-variant-caps: normal; font-width: normal; font-size: 11px; l= ine-height: normal; font-family: Menlo; font-size-adjust: none; font-kernin= g: auto; font-variant-alternates: normal; font-variant-ligatures: normal; f= ont-variant-numeric: normal; font-variant-east-asian: normal; font-variant-= position: normal; font-variant-emoji: normal; font-feature-settings: normal= ; font-optical-sizing: auto; font-variation-settings: normal;"><span style= =3D"font-variant-ligatures: no-common-ligatures">| id | domain_id | = name = | type | content | ttl | prio | disabled | order= name | auth |</span></p><p style=3D"margin: 0px; font-style: normal; font-v= ariant-caps: normal; font-width: normal; font-size: 11px; line-height: norm= al; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-va= riant-alternates: normal; font-variant-ligatures: normal; font-variant-nume= ric: normal; font-variant-east-asian: normal; font-variant-position: normal= ; font-variant-emoji: normal; font-feature-settings: normal; font-optical-s= izing: auto; font-variation-settings: normal;"><span style=3D"font-variant-= ligatures: no-common-ligatures">+------+-----------+-----------------------= ---------+------+---------+------+------+----------+-----------+------+</sp= an></p><p style=3D"margin: 0px; font-style: normal; font-variant-caps: norm= al; font-width: normal; font-size: 11px; line-height: normal; font-family: = Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates:= normal; font-variant-ligatures: normal; font-variant-numeric: normal; font= -variant-east-asian: normal; font-variant-position: normal; font-variant-em= oji: normal; font-feature-settings: normal; font-optical-sizing: auto; font= -variation-settings: normal;"><span style=3D"font-variant-ligatures: no-com= mon-ligatures">| 1783 | 28 | _token._dnswl.monfo= rtedalba.de | TXT | "test" | 3600 | 0 | &nbs= p; 0 | NULL | 1 |</span></p>= <p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal; fon= t-width: normal; font-size: 11px; line-height: normal; font-family: Menlo; = font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal= ; font-variant-ligatures: normal; font-variant-numeric: normal; font-varian= t-east-asian: normal; font-variant-position: normal; font-variant-emoji: no= rmal; font-feature-settings: normal; font-optical-sizing: auto; font-variat= ion-settings: normal;"><span style=3D"font-variant-ligatures: no-common-lig= atures">+------+-----------+--------------------------------+------+-------= --+------+------+----------+-----------+------+</span></p><p style=3D"margi= n: 0px; font-style: normal; font-variant-caps: normal; font-width: normal; = font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust:= none; font-kerning: auto; font-variant-alternates: normal; font-variant-li= gatures: normal; font-variant-numeric: normal; font-variant-east-asian: nor= mal; font-variant-position: normal; font-variant-emoji: normal; font-featur= e-settings: normal; font-optical-sizing: auto; font-variation-settings: nor= mal;"><span style=3D"font-variant-ligatures: no-common-ligatures">1 row in = set (0.00 sec)</span></p><p style=3D"margin: 0px; font-style: normal; font-= variant-caps: normal; font-width: normal; font-size: 11px; line-height: nor= mal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-v= ariant-alternates: normal; font-variant-ligatures: normal; font-variant-num= eric: normal; font-variant-east-asian: normal; font-variant-position: norma= l; font-variant-emoji: normal; font-feature-settings: normal; font-optical-= sizing: auto; font-variation-settings: normal; min-height: 13px;"><span sty= le=3D"font-variant-ligatures: no-common-ligatures"></span><br></p><p style= =3D"margin: 0px; font-style: normal; font-variant-caps: normal; font-width:= normal; font-size: 11px; line-height: normal; font-family: Menlo; font-siz= e-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-v= ariant-ligatures: normal; font-variant-numeric: normal; font-variant-east-a= sian: normal; font-variant-position: normal; font-variant-emoji: normal; fo= nt-feature-settings: normal; font-optical-sizing: auto; font-variation-sett= ings: normal; min-height: 13px;"><span style=3D"font-family: Helvetica; fon= t-size: 12px;">Is this behaviour intended or is something misconfigured on = our side?</span></p><p style=3D"margin: 0px; font-style: normal; font-varia= nt-caps: normal; font-width: normal; font-size: 11px; line-height: normal; = font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-varian= t-alternates: normal; font-variant-ligatures: normal; font-variant-numeric:= normal; font-variant-east-asian: normal; font-variant-position: normal; fo= nt-variant-emoji: normal; font-feature-settings: normal; font-optical-sizin= g: auto; font-variation-settings: normal; min-height: 13px;"><span style=3D= "font-family: Helvetica; font-size: 12px;"><br></span></p><p style=3D"margi= n: 0px; font-style: normal; font-variant-caps: normal; font-width: normal; = font-size: 11px; line-height: normal; font-family: Menlo; font-size-adjust:= none; font-kerning: auto; font-variant-alternates: normal; font-variant-li= gatures: normal; font-variant-numeric: normal; font-variant-east-asian: nor= mal; font-variant-position: normal; font-variant-emoji: normal; font-featur= e-settings: normal; font-optical-sizing: auto; font-variation-settings: nor= mal; min-height: 13px;"><span style=3D"font-family: Helvetica; font-size: 1= 2px;">Thanks for any hint,</span></p><p style=3D"margin: 0px; font-style: n= ormal; font-variant-caps: normal; font-width: normal; font-size: 11px; line= -height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: = auto; font-variant-alternates: normal; font-variant-ligatures: normal; font= -variant-numeric: normal; font-variant-east-asian: normal; font-variant-pos= ition: normal; font-variant-emoji: normal; font-feature-settings: normal; f= ont-optical-sizing: auto; font-variation-settings: normal; min-height: 13px= ;"><span style=3D"font-family: Helvetica; font-size: 12px;">Christian</span= ></p><p style=3D"margin: 0px; font-style: normal; font-variant-caps: normal= ; font-width: normal; font-size: 11px; line-height: normal; font-family: Me= nlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: n= ormal; font-variant-ligatures: normal; font-variant-numeric: normal; font-v= ariant-east-asian: normal; font-variant-position: normal; font-variant-emoj= i: normal; font-feature-settings: normal; font-optical-sizing: auto; font-v= ariation-settings: normal; min-height: 13px;"><span style=3D"font-family: H= elvetica; font-size: 12px;"><br></span></p></div><br/><a style=3D"font-fami= ly: Arial, sans-serif;" href=3D"http://ygzy.mjt.lu/lnk/AVIAAIAOafwAAAAAAAAA= A-O4SGkAAYCq-lkAAAAAAAvGpABo_lwr4WmL3z86RoyvY7yK7ExQvgAL25s/0/rVFlGGY9Ck7wa= zkDkg6yLQ/aHR0cDovL3lnenkubWp0Lmx1Lw?b=3D1">​</a><a href=3D"http://yg= zy.mjt.lu/lnk/AVIAAIAOafwAAAAAAAAAA-O4SGkAAYCq-lkAAAAAAAvGpABo_lwr4WmL3z86R= oyvY7yK7ExQvgAL25s/0/rVFlGGY9Ck7wazkDkg6yLQ/aHR0cDovL3lnenkubWp0Lmx1Lw?b=3D= 3"> <img src=3D"http://ygzy.mjt.lu/oo/AVIAAIAOafwAAAAAAAAAA-O4SGkAAYCq-lkAAAAAA= AvGpABo_lwr4WmL3z86RoyvY7yK7ExQvgAL25s/cb66b978/e.gif" height=3D"1" width= =3D"1" alt=3D"" border=3D"0" style=3D"height:1px;width:1px;border:0;"/> </a></body></html>= --Apple-Mail=_F2ACB2DF-BE33-4FCA-B22F-BF5AE955ABAE-- --===============4197360525080962631== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Pdns-users mailing list [email protected] https://mailman.powerdns.com/mailman/listinfo/pdns-users --===============4197360525080962631==--