<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi all,<br>
<br>
I'm just experimenting with an own database schema. all works fine,
but during a zone-transfer it stops with these log messages.<br>
<br>
The normal <span class="term">insert-record-query is "</span><span
class="command"><strong> </strong></span><span class="command"><strong><span
class="command"><strong> insert into records
(content,ttl,prio,type,domain_id,name) values
('%s',%d,%d,'%s',%d,'%s') </strong></span>"</strong></span><br>
<br>
But what query should be "<tt>insert into records
(type,domain_id,name) values (null,'6',E'000.003.example.com')"?<br>
<br>
In the source zone I can't find any data what should lead to this
record...<br>
<br>
Other zones are transferred without problems.<br>
<br>
</tt><br>
<tt>Apr 28 14:36:39 Command: insert into records
(type,domain_id,name) values (null,'6',E'000.003.example.com')</tt><tt><br>
</tt><tt>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</tt><tt><br>
</tt><tt>Apr 28 14:36:39 Aborting possible open transaction for
domain 'example.com' AXFR</tt><tt><br>
</tt><tt>Apr 28 14:36:39 Command: rollback</tt><br>
<br>
Bye<br>
Daniel<br>
<br>
<br>
</body>
</html>