<HTML>
<HEAD><!-- Template generated by Exclaimer Mail Disclaimers on 10:10:23 Wednesday, 14 December 2016 -->
<STYLE type=text/css>P.45cf7f58-da4e-4644-a8ed-1ec24872cea7 {
MARGIN: 0cm 0cm 0pt
}
LI.45cf7f58-da4e-4644-a8ed-1ec24872cea7 {
MARGIN: 0cm 0cm 0pt
}
DIV.45cf7f58-da4e-4644-a8ed-1ec24872cea7 {
MARGIN: 0cm 0cm 0pt
}
TABLE.45cf7f58-da4e-4644-a8ed-1ec24872cea7Table {
MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!-- Template generated by Exclaimer Mail Disclaimers on 10:10:23 Wednesday, 14 December 2016 -->
<STYLE type=text/css>P.622cb9e3-4e7b-4b71-80f8-cd6b07677200 {
MARGIN: 0cm 0cm 0pt
}
LI.622cb9e3-4e7b-4b71-80f8-cd6b07677200 {
MARGIN: 0cm 0cm 0pt
}
DIV.622cb9e3-4e7b-4b71-80f8-cd6b07677200 {
MARGIN: 0cm 0cm 0pt
}
TABLE.622cb9e3-4e7b-4b71-80f8-cd6b07677200Table {
MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
page: Section1
}
</STYLE>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
</HEAD>
<BODY bgcolor="#FFFFFF" text="#000000">
<P class=45cf7f58-da4e-4644-a8ed-1ec24872cea7>
<P class=622cb9e3-4e7b-4b71-80f8-cd6b07677200>
Hi,<br />
<br />
Using 4.0.1 Authoritive server on 16.04 Ubuntu with MySQL backend.<br />
<br />
I have a couple of zones that the server is slave to and I am
getting some null records in the AXFR transfer, null records that
don't exist in the transfer data but are somehow being saved to the
database by powerdns. The master to slave replication works fine but
I can't help but feel these extra null records shoudn't exist.<br />
<br />
If I disallow storage of null records I get the following error on
the "content", "type" and "ttl" columns in the "records" table. <br />
<br />
<br />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<span style="color: rgb(92, 93, 94); font-family: "Source Sans
Pro", "Helvetica Neue", Helvetica, Arial,
sans-serif; font-size: 15px; font-style: normal;
font-variant-ligatures: normal; font-variant-caps: normal;
font-weight: normal; letter-spacing: normal; orphans: 2;
text-align: left; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); display: inline !important; float: none;">Unable to AXFR
zone 'changed.com.au' from remote '203.[removed]' (PDNSException):
GSQLBackend unable to feed empty non-terminal: Could not execute
mysql statement: insert into records
(type,domain_id,disabled,name,ordername,auth,change_date,content,ttl,prio)
values (null,?,0,?,?,?,NULL,NULL,NULL,NULL): Column 'type' cannot
be null</span><br />
<br />
<br />
Upon doing more investigation all the null records that it is
storing end up being version's of records that were stored correctly
but are missing data preceding the first "._", for example here are
the null records:<br />
<br />
Null records stored as a result of transfer
(id,domain_id,name,type,content,ttl,prio,change_date,disabled,ordername,auth):<br />
<br />
| 30588967 | 255 | _tcp.changed.com.au | NULL |
NULL | NULL | NULL | NULL | 0 | NULL | 1 |<br />
| 30588968 | 255 | _tls.changed.com.au | NULL |
NULL | NULL | NULL | NULL | 0 | NULL | 1 |<br />
| 30588969 | 255 | _domainkey.changed.com.au | NULL | NULL |
NULL | NULL | NULL | 0 | NULL | 1 |<br />
<br />
Correct records also stored as a result of the same zone transfer<br />
<br />
| 30588964 | 255 | _sipfederationtls._tcp.changed.com.au | SRV | 1
5061 sipfed.somthing.else.com | 3600 | 100 | NULL |
0 | NULL | 1 |<br />
| 30588963 | 255 | _sip._tls.changed.com.au | SRV | 1
443 sipdir.somthing.else.com | 3600 | 100 | NULL | 0
| NULL | 1 |<br />
| 30588947 | 255 | k1._domainkey.changed.com.au | CNAME |
dkim.somthing.net | 7200 | 0 | NULL | 0 |
NULL | 1 |<br />
<br />
I am assuming this is a bug for records that contain "._" or is this
somthing that should be happening?<br />
<br />
As a side note, when I check the domain via pdnsutil it returns 57
records, when there are actually 60 records in the database
including the null records, so it doesn't seem to break powerdns by
having them there.<br />
<br />
Kind Regards,<br />
James Watson<br />
<br />
</P>
<P class=622cb9e3-4e7b-4b71-80f8-cd6b07677200><span style="font-family:Helvetica; font-size:x-small; color: #7D7D7D; font-weight: bold; ">James Watson</span></P>
<P class=622cb9e3-4e7b-4b71-80f8-cd6b07677200> </P>
<P class=622cb9e3-4e7b-4b71-80f8-cd6b07677200><span style="font-family:Helvetica; font-size:xx-small; color: #A5A5A5; ">Technical Engineer</span><span style="font-family:Helvetica; font-size:xx-small; color: #A5A5A5; "></span></P>
<P class=622cb9e3-4e7b-4b71-80f8-cd6b07677200><span style="font-family:Helvetica; font-size:xx-small; color: #009CDA; font-weight: bold; ">Business Technology Group LTD</span></P>
<P class=622cb9e3-4e7b-4b71-80f8-cd6b07677200> </P>
<P class=622cb9e3-4e7b-4b71-80f8-cd6b07677200><span style="font-family:Helvetica; font-size:xx-small; color: #A5A5A5; font-style: italic; "></span></P>
<P class=622cb9e3-4e7b-4b71-80f8-cd6b07677200> </P>
<P class=622cb9e3-4e7b-4b71-80f8-cd6b07677200><span style="font-family:Helvetica; font-size:xx-small; color: #A5A5A5; "><span style="font-weight: bold; ">p: </span>+64 9 580 1374</span> <span style="font-family:Helvetica; font-size:xx-small; color: #A5A5A5; "><span style="font-family:Helvetica; font-size:xx-small; color: #A5A5A5; ">x9833</span></span></P>
<P class=622cb9e3-4e7b-4b71-80f8-cd6b07677200><span style="font-family:Helvetica; font-size:xx-small; color: #A5A5A5; "><span style="font-weight: bold; ">m: </span>+64274596684</span></P>
<P class=622cb9e3-4e7b-4b71-80f8-cd6b07677200><span style="font-family:Helvetica; font-size:xx-small; "><span style="font-family:Helvetica; font-size:xx-small; "><a href='James.Watson@btg.co.nz' title='Click to send email to James Watson' target=''><span style="font-family:Helvetica; font-size:xx-small; ">James.Watson@btg.co.nz</span></a></span></span></P>
<P class=622cb9e3-4e7b-4b71-80f8-cd6b07677200></P>
<P class=622cb9e3-4e7b-4b71-80f8-cd6b07677200></P>
<P></P>
<P></P>
<P></P></P>
<P class=45cf7f58-da4e-4644-a8ed-1ec24872cea7> </P>
<P class=45cf7f58-da4e-4644-a8ed-1ec24872cea7><IMG id=IMG1 border=0 src="cid:imageb72955.GIF@713bb315.4d8301f9" width=706 height=66 /></P>
<P class=45cf7f58-da4e-4644-a8ed-1ec24872cea7></P></FONT>
<P></P>
<P></P></BODY>
</HTML>