[Pdns-users] Supermaster NOTIFY Restarts PowerDNS 3.1 (gmysql backend)

[nrnelson]

I am not certain that this is normal behavior for PowerDNS.  Everything seems
to work but it seems like something is wrong.

I have a Windows DNS server that I have configured to automatically notify
this particular PowerDNS server whenever a zone changes.  These are existing
domains on the Windows DNS server -- I just added the PowerDNS server's IP
to the notify list.  This is what happens in the PowerDNS log file when I
update the notify list for each zone on the Windows server:

Jun  1 14:30:07 dns01 pdns[6498]: Received NOTIFY for <DOMAIN_NAME> from
<SUPERMASTER_IP> for which we are not authoritative
Jun  1 14:30:07 dns01 pdns[6498]: Received NOTIFY for <DOMAIN_NAME> from
<SUPERMASTER_IP> for which we are not authoritative
Jun  1 14:30:08 dns01 pdns[6498]: Created new slave zone '<DOMAIN_NAME>'
from supermaster <SUPERMASTER_IP>, queued axfr
Jun  1 14:30:08 dns01 pdns[6498]: Initiating transfer of '<DOMAIN_NAME>'
from remote '<SUPERMASTER_IP>'
Jun  1 14:30:08 dns01 pdns[6498]: gmysql Connection successful
Jun  1 14:30:08 dns01 pdns[6498]: gmysql Connection successful
Jun  1 14:30:08 dns01 pdns[6498]: gmysql Connection successful
Jun  1 14:30:08 dns01 pdns[6498]: No serial for '<DOMAIN_NAME>' found - zone
is missing?
Jun  1 14:30:08 dns01 pdns[6498]: AXFR started for '<DOMAIN_NAME>',
transaction started
Jun  1 14:30:08 dns01 pdns[6498]: Exiting because communicator thread died
with error: Database error trying to insert new slave '<DOMAIN_NAME>':
Failed to execute mysql_query, perhaps connection died? Err=1: Duplicate
entry '<DOMAIN_NAME>' for key 'name_index'
Jun  1 14:30:08 dns01 pdns[6498]: AXFR done for '<DOMAIN_NAME>', zone
committed with serial number 2008041410
Jun  1 14:30:10 dns01 pdns[6495]: Our pdns instance exited with code 0
Jun  1 14:30:10 dns01 pdns[6495]: Respawning
Jun  1 14:30:11 dns01 pdns[6524]: Guardian is launching an instance
Jun  1 14:30:11 dns01 pdns[6524]: Reading random entropy from '/dev/urandom'
Jun  1 14:30:11 dns01 pdns[6524]: This is module gmysqlbackend.so reporting
Jun  1 14:30:11 dns01 pdns[6524]: This is a guarded instance of pdns
Jun  1 14:30:11 dns01 pdns[6524]: It is advised to bind to explicit
addresses with the --local-address option
Jun  1 14:30:11 dns01 pdns[6524]: UDP server bound to 0.0.0.0:53
Jun  1 14:30:11 dns01 pdns[6524]: TCP server bound to 0.0.0.0:53
Jun  1 14:30:11 dns01 pdns[6524]: PowerDNS 3.1 (C) 2001-2012 PowerDNS.COM BV
(May  4 2012, 13:04:27, gcc 4.4.6 20110731 (Red Hat 4.4.6-3)) starting up
Jun  1 14:30:11 dns01 pdns[6524]: PowerDNS comes with ABSOLUTELY NO
WARRANTY. This is free software, and you are welcome to redistribute it
according to the terms of the GPL version 2.
Jun  1 14:30:11 dns01 pdns[6524]: Set effective group id to 25
Jun  1 14:30:11 dns01 pdns[6524]: Set effective user id to 25
Jun  1 14:30:11 dns01 pdns[6524]: DNS Proxy launched, local port 55465,
remote 127.0.0.1:5300
Jun  1 14:30:11 dns01 pdns[6524]: Master/slave communicator launching
Jun  1 14:30:11 dns01 pdns[6524]: Creating backend connection for TCP
Jun  1 14:30:11 dns01 pdns[6524]: gmysql Connection successful
Jun  1 14:30:11 dns01 pdns[6524]: gmysql Connection successful
Jun  1 14:30:11 dns01 pdns[6524]: gmysql Connection successful
Jun  1 14:30:11 dns01 pdns[6524]: gmysql Connection successful
Jun  1 14:30:11 dns01 pdns[6524]: About to create 3 backend threads for UDP
Jun  1 14:30:11 dns01 pdns[6524]: gmysql Connection successful
Jun  1 14:30:11 dns01 pdns[6524]: gmysql Connection successful
Jun  1 14:30:11 dns01 pdns[6524]: No new unfresh slave domains, 0 queued for
AXFR already
Jun  1 14:30:11 dns01 pdns[6524]: gmysql Connection successful
Jun  1 14:30:11 dns01 pdns[6524]: gmysql Connection successful
Jun  1 14:30:11 dns01 pdns[6524]: gmysql Connection successful
Jun  1 14:30:11 dns01 pdns[6524]: gmysql Connection successful
Jun  1 14:30:11 dns01 pdns[6524]: Done launching threads, ready to
distribute questions

It does not matter which domain it is as this happens with every single
domain I've changed.  The supermaster DNS server's IP and name exists in my
supermasters MySQL table.  It seems to actually do a successful zone
transfer as my domains and records table have the proper information for
that domain in them.

Here's my pdns.conf:

config-dir=/etc/powerdns
daemon=yes
launch=gmysql
gmysql-socket=/var/lib/mysql/mysql.sock
gmysql-user=<DB_USERNAME>
gmysql-password=<DB_PASSWORD>
gmysql-dbname=pdns
loglevel=9
module-dir=/usr/lib64
recursor=127.0.0.1:5300
retrieval-threads=1
setgid=powerdns
setuid=powerdns
slave=yes
slave-cycle-interval=60
socket-dir=/var/run/pdns-server

I've tried switching gmysql-socket to gmysql-host=127.0.0.1 and also tried
retrieval-threads=1 as well as commented it out altogether.  The results are
always the same.  My PowerDNS is v3.1 from the packages provided by Kees
Monshouwer linked to in the PowerDNS 3.1 release notes. The server is CentOS
6.2 server running kernel 2.6.32-220.17.1.el6.x86_64.  These are the
PowerDNS and MySQL packages I have installed:

pdns-server-3.1-1.el6.MIND.x86_64
pdns-server-tools-3.1-1.el6.MIND.x86_64
pdns-server-backend-mysql-3.1-1.el6.MIND.x86_64
pdns-recursor-3.3-1.el6.MIND.x86_64
mysql-5.1.61-1.el6_2.1.x86_64
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
mysql-libs-5.1.61-1.el6_2.1.x86_64
mysql-server-5.1.61-1.el6_2.1.x86_64

Thanks,

Nathan
-- 
View this message in context: http://old.nabble.com/Supermaster-NOTIFY-Restarts-PowerDNS-3.1-%28gmysql-backend%29-tp33946784p33946784.html
Sent from the PowerDNS mailing list archive at Nabble.com.