[Pdns-users] Slave zone just won't refresh....
Kenneth Marshall
ktm at rice.edu
Wed Jun 9 19:54:27 UTC 2010
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 at mailman.powerdns.com
>>> http://mailman.powerdns.com/mailman/listinfo/pdns-users
>>>
>>
>>
>> !DSPAM:4c0f8df3317271137924711!
>>
>
> --
> 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
More information about the Pdns-users
mailing list