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

[Daniel Funke]

Hi Peter,

thank you for your quick response. I know I could change my shema to 
allow null in the type column, but I'm interested to find out, what kind 
of zone data in the source zone could cause this entry and why I cant 
find the used query statement in any documentation.

Am 28.04.2014 15:31, schrieb Peter van Dijk:
> 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,
>
>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20140428/df121d5b/attachment-0001.html>