[Pdns-users] Multiple A records cause AXFR failure

[a b]

If I recall correctly, every backend has its own schema.
Unfortunately, this is not immediately obvious when one starts using pdns.
The good news is, the "oracle" backend gets some serious abuse, it's well tested, rock solid in its operation, and in my opinion, the schema is optimized for it.

You are also correct, missing TTL's is the solution.
________________________________________
From: pdns-users-bounces at mailman.powerdns.com [pdns-users-bounces at mailman.powerdns.com] on behalf of leen at consolejunkie.net [leen at consolejunkie.net]
Sent: Sunday, November 22, 2015 13:35
To: pdns-users at mailman.powerdns.com
Subject: Re: [Pdns-users] Multiple A records cause AXFR failure

Ahh, so it's Oracle, yeah I should have known from the SQL> prompt.

I didn't know the Oracle backend uses other table names, an euh..
interesting choice.

Never really looked at the Oracle backend code, so I had a quick look.

Maybe you don't have any TTLs (you didn't have them in the insert
query) ?

It seems that would trigger an error:
https://github.com/PowerDNS/pdns/blob/master/modules/oraclebackend/oraclebackend.cc#L999

Maybe add a check like the example ?:
https://github.com/PowerDNS/pdns/blob/master/modules/oraclebackend/schema.oracle.sql#L121

_______________________________________________
Pdns-users mailing list
Pdns-users at mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users