Hi Ken,
I just found your ticket from abut 4 years ago... Seems strange that
it's still a bug. We just ran a few tests and yep.. you were completely
correct, WKS records just piss off pdns something fierce.
I'll consolidate the test case down to something reasonable and submit a
bug report.
Gary
On 6/9/10 12:54 PM, Kenneth Marshall wrote:
Ah, I hit the same problem. WKS records are not supported by
PDNS. On top of that, they are not really useful and have not
been for quite a while. Try nuking them and your zone should
transfer fine.
Regards,
Ken
On Wed, Jun 09, 2010 at 11:43:27AM -0700, Gary Shaver wrote:
On 6/9/10 5:49 AM, Kenneth Marshall wrote:
another issue that I've run into was another slave zone. This had pdns
cycling every 2-3 seconds
Jun 7 00:48:44 ns1 pdns[10216]: Initiating transfer of 'axxxxxxxa.us'
from
remote '216.117.186.93'
Jun 7 00:48:45 ns1 pdns[10216]: AXFR started for 'axxxxxxxa.us',
transaction started
Jun 7 00:48:45 ns1 pdns[10216]: Communicator thread died because of
error:
Failed to execute mysql_query, perhaps connection died? Err=1: You have
an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near ''\\# 1007
ad10090a0600000240002000000000800000
0040000000000000000000000000000000' at line 1
Jun 7 00:48:46 ns1 pdns[16017]: Our pdns instance exited with code 0
Jun 7 00:48:46 ns1 pdns[16017]: Respawning
Jun 7 00:48:47 ns1 pdns[10258]: Guardian is launching an instance
Simply removing the zone puts everything back in a happy state, so It's
not
a timeout issue. Are there any debugging options that can be turned on
for
the mysql backend? I didn't find any referenced in the documentation and
increasing the loglevel doesn't give me any additional information.
I've pulled down the zone and besides the laundry list of different
record
types, it looks fine. I can sanitize it an post it if that would help.
The pdns version is the static .deb package from the main download page.
Any help is appreciated.
Thanks,
Gary
Hi Gary,
Try enabling the MySQL query logging to see what command is being
received by the backend. You can also bump the logging level on the
PDNS system to see if it gives you more information. Have you changed
any of the default queries? What is your PDNS configuration, including
the backend chosen? At 27 entries, you could post the entire zone but
if the problem is a weird character, sanitizing it will make the
information useless. I would try bumping the debugging levels first.
I cannot help much on the MySQL side since we use PostgreSQL as the
backend database.
I already tried both of those. Increasing the loglevel didn't yield any
additional information and query log didn't include the query, I suspect
due to it's failure.
I've attached the zone. I've changed the hostnames and ip's. The remainder
of the zone is untouched.
Gary
Regards,
Ken
--
Gary Shaver | Voice 510.580.4100, Fax 510.580.4151
Hurricane Electric | AS6939
Network Operations | http://www.he.net
_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users
--
Gary Shaver | Voice 510.580.4100, Fax 510.580.4151
Hurricane Electric | AS6939
Network Operations | http://www.he.net
;<<>> DiG 9.4.2-P2.1<<>> axxxxxxxx.us @10.117.186.93 AXFR
;; global options: printcmd
axxxxxxxx.us. 7200 IN SOA DD1.axxxxxxxx.us.
AtlDNS.Fxxxxxl.Com. 2010060736 1200 600 2419200 10800
axxxxxxxx.us. 7200 IN NS DD1.axxxxxxxx.us.
axxxxxxxx.us. 7200 IN NS NS1.SxxxxxP.US.
axxxxxxxx.us. 604800 IN AAAA 2fff:470:e056::
axxxxxxxx.us. 604800 IN AAAA 2fff:ad10:90a::
axxxxxxxx.us. 604800 IN A 192.168.9.10
axxxxxxxx.us. 604800 IN WKS 192.168.9.10 6 22 25 42 80 113
443 6667 8008
axxxxxxxx.us. 604800 IN WKS 192.168.9.10 17 22 25 42 80 443
8008
axxxxxxxx.us. 604800 IN MX 10 Mail.axxxxxxxx.us.
axxxxxxxx.us. 604800 IN MX 30 Mail.Rxxxxxxxt.US.
axxxxxxxx.us. 604800 IN MX 30 Mail2.Rxxxxxxxt.US.
axxxxxxxx.us. 604800 IN MX 40 ASPMX.L.Google.Com.
axxxxxxxx.us. 604800 IN MX 50 Alt1.ASPMX.L.Google.Com.
axxxxxxxx.us. 604800 IN MX 50 Alt2.ASPMX.L.Google.Com.
axxxxxxxx.us. 604800 IN MX 60 ASPMX2.GoogleMail.Com.
axxxxxxxx.us. 604800 IN MX 60 ASPMX3.GoogleMail.Com.
axxxxxxxx.us. 604800 IN MX 60 ASPMX4.GoogleMail.Com.
axxxxxxxx.us. 604800 IN MX 60 ASPMX5.GoogleMail.Com.
axxxxxxxx.us. 604800 IN MX 80
mxbackup1.junkemailfilter.com.
axxxxxxxx.us. 604800 IN MX 90
mxbackup2.junkemailfilter.com.
axxxxxxxx.us. 604800 IN TXT "v=spf1 mx ip6:2fff:470:e056::/48
ptr exists:%{i}.%{l}.%{o}._spf.%{d} -all exp=explain._spf.%{d}"
axxxxxxxx.us. 604800 IN RP Philip.axxxxxxxx.us.
Contact.axxxxxxxx.us.
*.axxxxxxxx.us. 604800 IN CNAME Axxxxxxxxa.US.
explain._spf.axxxxxxxx.us. 604800 IN TXT "%{s} - %{i} is not one of %{d}'s
designated mail servers.."
AO2.axxxxxxxx.us. 7200 IN A 10.37.196.55
AO2.axxxxxxxx.us. 7200 IN AAAA 2fff:470:8:198::53:2
AO2.axxxxxxxx.us. 7200 IN AAAA 2fff:ad10:90a::53
Ariel.axxxxxxxx.us. 604800 IN A 192.168.9.10
Ariel.axxxxxxxx.us. 604800 IN HINFO "PC-Intel-400MHz" "Ubuntu Linux"
Ariel.axxxxxxxx.us. 604800 IN MX 11 Ariel.axxxxxxxx.us.
Ariel.axxxxxxxx.us. 604800 IN TXT "v=spf2.0/pra mx a ptr -all"
Ariel.axxxxxxxx.us. 604800 IN TXT "v=spf1 include:axxxxxxxx.us
-all"
Ariel.axxxxxxxx.us. 604800 IN AAAA 2fff:470:e056:1:2::
Ariel.axxxxxxxx.us. 604800 IN AAAA 2fff:ad10:90a:1:2::
Ariel.axxxxxxxx.us. 604800 IN SSHFP 1 1
06725056467348BBFFF152EE2C1F99A0720FBC31
Ariel.axxxxxxxx.us. 604800 IN SSHFP 2 1
BB1451F9F40EA800AFF39BF55F3E6B4484544757
*.Ariel.axxxxxxxx.us. 604800 IN CNAME Ariel.Axxxxxxxxa.US.
_http._tcp.Ariel.axxxxxxxx.us. 604800 IN SRV 5 0 8080
www.Ariel.Axxxxxxxxa.US.
_www._tcp.Ariel.axxxxxxxx.us. 604800 IN SRV 5 0 8080
www.Ariel.Axxxxxxxxa.US.
IRC.Ariel.axxxxxxxx.us. 604800 IN CNAME IRC.Axxxxxxxxa.US.
DD1.axxxxxxxx.us. 7200 IN A 216.117.186.93
DD2.axxxxxxxx.us. 7200 IN A 10.111.175.42
Docs.axxxxxxxx.us. 604800 IN CNAME GHS.Google.Com.
IRC.axxxxxxxx.us. 86400 IN CNAME IRC.IPv6.FreeNode.Net.
Mail.axxxxxxxx.us. 604800 IN A 192.168.9.10
Mail.axxxxxxxx.us. 604800 IN AAAA 2fff:470:e056:1:7::1
Mail.axxxxxxxx.us. 604800 IN AAAA 2fff:ad10:90a:1:7::1
NS1.axxxxxxxx.us. 7200 IN A 192.168.9.10
NS1.axxxxxxxx.us. 7200 IN AAAA 2fff:470:8:198::53:1
NS1.axxxxxxxx.us. 7200 IN AAAA 2fff:ad10:90a::
Sebastian.axxxxxxxx.us. 604800 IN A 192.168.9.10
Sebastian.axxxxxxxx.us. 604800 IN AAAA 2fff:470:e056:1:4::
Sebastian.axxxxxxxx.us. 604800 IN AAAA 2fff:ad10:90a:1:4::
Sites.axxxxxxxx.us. 604800 IN CNAME GHS.Google.Com.
Start.axxxxxxxx.us. 604800 IN CNAME GHS.Google.Com.
www.axxxxxxxx.us. 604800 IN CNAME Axxxxxxxxa.US.
XN0.axxxxxxxx.us. 7200 IN A 10.234.42.1
XN1.axxxxxxxx.us. 7200 IN A 10.98.164.164
Z12.axxxxxxxx.us. 7200 IN A 10.62.64.46
Z15.axxxxxxxx.us. 7200 IN A 10.227.210.9
axxxxxxxx.us. 7200 IN SOA DD1.axxxxxxxx.us.
AtlDNS.Fxxxxxl.Com. 2010060736 1200 600 2419200 10800
;; Query time: 169 msec
;; SERVER: 10.117.186.93#53(216.117.186.93)
;; WHEN: Mon Jun 7 21:21:02 2010
!DSPAM:4c0ff17580781167711726!
--
Gary Shaver | Voice 510.580.4100, Fax 510.580.4151
Hurricane Electric | AS6939
Network Operations | http://www.he.net
_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users