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

[Daniel Funke]

Hi all,

I'm just experimenting with an own database schema. all works fine, but 
during a zone-transfer it stops with these log messages.

The normal insert-record-query is "****insert into records 
(content,ttl,prio,type,domain_id,name) values ('%s',%d,%d,'%s',%d,'%s') *"*

But what query should be "insert into records (type,domain_id,name) 
values (null,'6',E'000.003.example.com')"?

In the source zone I can't find any data what should lead to this record...

Other zones are transferred without problems.


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
Apr 28 14:36:39 Aborting possible open transaction for domain 
'example.com' AXFR
Apr 28 14:36:39 Command: rollback

Bye
Daniel


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