[Pdns-users] Slave zone just won't refresh....

[Kenneth Marshall]

On Tue, Jun 08, 2010 at 05:33:26PM -0700, Gary Shaver wrote:
>
> Before I pull much more hair out, I thought I'd toss this up to the list to 
> see if anyone has experienced this in the past (or has better google-foo 
> than I)
>
> I'm slaving a zone from 208.78.69.112, I'm able to pull the zone manually 
> using dig, but it does go a little slower than I would expect.  Pdns just 
> times out.. over and over... Is there a way to increase the timeout? or is 
> there something that I'm missing.
> The zone itself does not appear to be malformed.. the nameserver I'm 
> pulling from is just slow..
>
> ;; Query time: 5479 msec
> ;; SERVER: 208.78.69.112#53(208.78.69.112)
> ;; WHEN: Tue Jun  8 17:13:44 2010
> ;; XFR size: 27 records (messages 27, bytes 1748)
>
> ---- logs ----
>
> Jun  8 16:53:10 ns1 pdns[1725]: Error trying to retrieve/refresh 
> 'oxxxxxxxm.com': Timeout waiting for answer from 208.78.69.112
> Jun  8 16:54:11 ns1 pdns[1725]: Error trying to retrieve/refresh 
> 'oxxxxxxxm.com': Timeout waiting for answer from 208.78.69.112
> Jun  8 16:55:12 ns1 pdns[1725]: Error trying to retrieve/refresh 
> 'oxxxxxxxm.com': Timeout waiting for answer from 208.78.69.112
> Jun  8 16:56:13 ns1 pdns[1725]: Error trying to retrieve/refresh 
> 'oxxxxxxxm.com': Timeout waiting for answer from 208.78.69.112
> Jun  8 16:57:14 ns1 pdns[1725]: Error trying to retrieve/refresh 
> 'oxxxxxxxm.com': Timeout waiting for answer from 208.78.69.112
> Jun  8 16:58:15 ns1 pdns[1725]: Error trying to retrieve/refresh 
> 'oxxxxxxxm.com': Timeout waiting for answer from 208.78.69.112
> Jun  8 16:59:16 ns1 pdns[1725]: Error trying to retrieve/refresh 
> 'oxxxxxxxm.com': Timeout waiting for answer from 208.78.69.112
>
>
> 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.

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
>