[Pdns-users] Duplicate RRs in records table

Klaus Darilion klaus.mailinglists at pernau.at
Thu Jul 3 09:04:23 UTC 2014

Hi! We use PowerDNS 3.3.1 as slave with Postgresql DB as backend. Today
I found out that for some zones the whole zone is duplicated in the
records table (2 SOA records, ... every record is twice there). For one
zone we had all the records 6 times - thus a zone with 6 SOA records, ....

There is no manual intervention into the DB, only PowerDNS writes to the
records table when it transfers the zone from the master.

Does someone have an idea how this may be happen? E.g. can there be some
DB problems (slow DB, timeout, connection drops ...) where PowerDNS
inserts the records without prior deletion of the records?

For some zones the last transfer was in 2011, for some 2013, thus maybe
the problem was with some older PowerDNS version.


More information about the Pdns-users mailing list