[Pdns-users] please help with strange insert sql query during zone-transfer

Peter van Dijk peter.van.dijk at netherlabs.nl
Mon Apr 28 13:31:13 UTC 2014


Hello Daniel,

On 28 Apr 2014, at 15:08 , Daniel Funke <daniel at dhag.net> wrote:

> Apr 28 14:36:39 Command: insert into records (type,domain_id,name) values (null,'6',E'000.003.example.com')
> Apr 28 14:36:39 Unable to AXFR zone 'example.com' from remote '172.16.101.10' (AhuException): GSQLBackend unable to feed empty non-terminal: PostgreSQL failed to execute command: ERROR:  null value in column "fk_type" violates not-null constraint

This error is pretty clear - your schema does not allow NULL in the type column. You need to fix this.

Kind regards,
-- 
Peter van Dijk
Netherlabs Computer Consulting BV - http://www.netherlabs.nl/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 841 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20140428/ae12a5dd/attachment-0001.sig>


More information about the Pdns-users mailing list