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 |
_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users
