[Pdns-users] Getting AXFR but not updating database.

[Joris Dobbelsteen]

I guess your access rights are OK, since its only one domain.

Is the database transaction without error? MySQL is really a troublesome 
thing, as it will silently ignore quite a few things that are actually 
errors.

PostGreSQL can be configured to log any (such) errors to syslog, so you 
can verify this is the case. Don't know for MySQL, as I personally 
attempt to avoid it.

The other simple option is logging on to the database *as the user used 
by PowerDNS* and attempt the queries yourself. This would give you some 
idea.
Easier would be to grab the transmitted queries from the wire. This can 
be done quite easily if your database & powerdns are on different 
systems. Its hard if they are on the same box, as the TCP/IP stack can 
use internal short-cuts.

Replicating the issue on a test system is easier, since it ensures the 
problem is (easily) reproducible and you can get rid of most 
uninteresting events that happen on production. This can save you from a 
lot of log reading.

To get better support from the community:
* Provide you PowerDNS version (essential!)
* Provide you database server & version

- Joris

Tyler Hall wrote, On 07-11-08 21:02:
> Has anyone seen this before?
> 
> We're sending notifies, they grab the zone, but never update the 
> database.... Only for this domain.
> 
> --
> 
> Nov  6 13:06:02 ns2 pdns[21912]: Received valid NOTIFY for 
> 1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa (id=98500) from master 83.16.194.42 
> <http://83.16.194.42>: 2008110604 > 2008080902
> Nov  6 13:06:02 ns2 pdns[21912]: AXFR started for 
> '1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa', transaction started
> Nov  6 13:06:02 ns2 pdns[21912]: AXFR done for 
> '1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa', zone committed
> Nov  6 13:06:17 ns2 pdns[21912]: Received valid NOTIFY for 
> 1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa (id=98500) from master 83.16.194.42 
> <http://83.16.194.42>: 2008110604 > 2008080902
> Nov  6 13:06:18 ns2 pdns[21912]: AXFR started for 
> '1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa', transaction started
> Nov  6 13:06:18 ns2 pdns[21912]: AXFR done for 
> '1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa', zone committed
> Nov  6 13:06:32 ns2 pdns[21912]: Received valid NOTIFY for 
> 1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa (id=98500) from master 83.16.194.42 
> <http://83.16.194.42>: 2008110604 > 2008080902
> Nov  6 13:06:38 ns2 pdns[21912]: AXFR started for 
> '1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa', transaction started
> Nov  6 13:06:38 ns2 pdns[21912]: AXFR done for 
> '1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa', zone committed
> Nov  6 15:25:55 ns2 pdns[21912]: Received valid NOTIFY for 
> 1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa (id=98500) from master 83.16.194.42 
> <http://83.16.194.42>: 2008110605 > 2008080902
> Nov  6 15:25:56 ns2 pdns[21912]: AXFR started for 
> '1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa', transaction started
> Nov  6 15:25:56 ns2 pdns[21912]: AXFR done for 
> '1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa', zone committed
> Nov  6 15:26:10 ns2 pdns[21912]: Received valid NOTIFY for 
> 1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa (id=98500) from master 83.16.194.42 
> <http://83.16.194.42>: 2008110605 > 2008080902
> Nov  6 15:26:11 ns2 pdns[21912]: AXFR started for 
> '1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa', transaction started
> Nov  6 15:26:11 ns2 pdns[21912]: AXFR done for 
> '1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa', zone committed
> Nov  6 15:26:25 ns2 pdns[21912]: Received valid NOTIFY for 
> 1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa (id=98500) from master 83.16.194.42 
> <http://83.16.194.42>: 2008110605 > 2008080902
> Nov  6 15:26:26 ns2 pdns[21912]: AXFR started for 
> '1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa', transaction started
> Nov  6 15:26:26 ns2 pdns[21912]: AXFR done for 
> '1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa', zone committed
> 
> 
> mysql> select * from records where domain_id='98500';
> +---------+-----------+--------------------------------------------------------------------------+------+-----------------------------------------------------------------+--------+------+-------------+
> | id      | domain_id | 
> name                                                                     
> | type | content                                                         
> | ttl    | prio | change_date |
> +---------+-----------+--------------------------------------------------------------------------+------+-----------------------------------------------------------------+--------+------+-------------+
> | 9590556 |     98500 | 
> 1.7.9.9.0.7.4.0.1.0.0.2.ip6.arpa                                         
> | SOA  | bema.one.pl pj.bema.one.pl 
> 2008080902 10800 180 2419200 86400 |  86400 
> |    0 |        NULL |