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: [email protected] 
[[email protected]] on behalf of [email protected] 
[[email protected]]
Sent: Sunday, November 22, 2015 13:35
To: [email protected]
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
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users

_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users

Reply via email to