[Pdns-users] API Bug(?) with Postgres backend when inserting rr containg dots

Peter van Dijk peter.van.dijk at powerdns.com
Wed Mar 17 14:48:39 UTC 2021

Hello Ferdinand,

On Tue, 2021-03-16 at 16:40 +0100, Ferdinand Goldmann via Pdns-users
> Mar 16 15:48:10 **** pdns[67880]: [webserver] 759b42ae-4c22-42be-a961-6b27805d9171 HTTP ISE for "/api/v1/servers/localhost/zones/ferdl.test.": Exception: GSQLBackend unable to insert empty non-terminal rr 'name.ferdl.test' in domain_id 86: Fatal error during query: insert into records (type,domain_id,disabled,name,ordername,auth,ttl,prio,content) values (null,$1,false,$2,$3,$4,null,null,null): ERROR:  null value in column "type" violates not-null constraint DETAIL:  Failing row contains (4835479, 86, name.ferdl.test, null, null, null, null, f, null, t).

There is no NOT NULL constraint on records.type in the pgsql schema we
ship and document. Can you see if you somehow got a constraint into
your schema some other way?

Kind regards,
Peter van Dijk
PowerDNS.COM BV - https://www.powerdns.com/

More information about the Pdns-users mailing list