Re: Bind DLZ strange duplicate queries to DB
Rob Butler <[email protected]> Sat, 10 Sep 2016 17:43:41 +0000 (UTC)
| Newsgroups | gmane.network.dns.bind9.dlz |
|---|---|
| Message-ID | <[email protected]> |
--===============4543048701022378745==
Content-Type: multipart/alternative;
boundary="----=_Part_3001224_1849897995.1473529421223"
Content-Length: 6044
------=_Part_3001224_1849897995.1473529421223
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Send a copy of your DLZ config. =C2=A0Also, I had received=C2=A0your other =
email, but when I replied the email daemon couldn't send because it said th=
ere=C2=A0were no MX or A records for your domain. =C2=A0Maybe it was an int=
ermittent issue.
ThanksRob=20
On Thursday, September 8, 2016 4:50 AM, Job <[email protected]> =
wrote:
=20
=20
Hello,
we use Bind with DLZ, Postgres 8.4.8 as RDBMS support.
Everything works but, with DLZ query, i notice (in Postsgresql log), that B=
ind calls two times the same queries.
For example, to resolve with Bind-DLZ www.fiorino.it, it should make three =
queries (to descend until Top level domain):
www.fiorino.it
fiorino.it
it
Instead of this, it repeat the queries two times:
first time <2016-09-07 17:36:56 CEST>LOG:=C2=A0 duration: 0.965 ms=C2=A0 st=
atement: select 'www.fiorino.it' where function_cloud_view_orari('53', x.x.=
x.x, 'www.fiorino.it') !=3D '';
first time <2016-09-07 17:36:56 CEST>LOG:=C2=A0 duration: 0.359 ms=C2=A0 st=
atement: select 'fiorino.it' where function_cloud_view_orari('53', x.x.x.x,=
'fiorino.it') !=3D '';
first time <2016-09-07 17:36:56 CEST>LOG:=C2=A0 duration: 0.304 ms=C2=A0 st=
atement: select 'it' where function_cloud_view_orari('53', x.x.x.x, 'it') !=
=3D '';
second time <2016-09-07 17:36:56 CEST>LOG:=C2=A0 duration: 0.291 ms=C2=A0 s=
tatement: select 'www.fiorino.it' where function_cloud_view_orari('53', x.x=
.x.x, 'www.fiorino.it') !=3D '';
second time <2016-09-07 17:36:56 CEST>LOG:=C2=A0 duration: 0.291 ms=C2=A0 s=
tatement: select 'fiorino.it' where function_cloud_view_orari('53', x.x.x.x=
, 'fiorino.it') !=3D '';
second time <2016-09-07 17:36:56 CEST>LOG:=C2=A0 duration: 0.215 ms=C2=A0 s=
tatement: select 'it' where function_cloud_view_orari('53', x.x.x.x, 'it') =
!=3D '';
Can someone help me with?
Thank you!
Francesco
---------------------------------------------------------------------------=
---
_______________________________________________
Bind-dlz-testers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
=20
=20
------=_Part_3001224_1849897995.1473529421223
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<html><head></head><body><div style=3D"color:#000; background-color:#fff; f=
ont-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, =
sans-serif;font-size:16px"><div id=3D"yui_3_16_0_ym19_1_1473529025822_4119"=
><span id=3D"yui_3_16_0_ym19_1_1473529025822_4176">Send a copy of your DLZ =
config. Also, I had received your other email, but when I replie=
d the email daemon couldn't send because it said there were no MX or A=
records for your domain. Maybe it was an intermittent issue.</span><=
/div><div id=3D"yui_3_16_0_ym19_1_1473529025822_4119"><span><br></span></di=
v><div id=3D"yui_3_16_0_ym19_1_1473529025822_4119"><span>Thanks</span></div=
><div id=3D"yui_3_16_0_ym19_1_1473529025822_4119"><span>Rob</span></div> <d=
iv class=3D"qtdSeparateBR"><br><br></div><div class=3D"yahoo_quoted" style=
=3D"display: block;"> <div style=3D"font-family: HelveticaNeue, Helvetica N=
eue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div s=
tyle=3D"font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucid=
a Grande, sans-serif; font-size: 16px;"> <div dir=3D"ltr"><font size=3D"2" =
face=3D"Arial"> On Thursday, September 8, 2016 4:50 AM, Job <Job@collini=
consulting.it> wrote:<br></font></div> <blockquote style=3D"border-left:=
2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-lef=
t: 5px;"> <br><br> <div class=3D"y_msg_container">Hello,<br><br>we use Bind=
with DLZ, Postgres 8.4.8 as RDBMS support.<br><br>Everything works but, wi=
th DLZ query, i notice (in Postsgresql log), that Bind calls two times the =
same queries.<br><br>For example, to resolve with Bind-DLZ www.fiorino.it, =
it should make three queries (to descend until Top level domain):<br>www.fi=
orino.it<br>fiorino.it<br>it<br><br>Instead of this, it repeat the queries =
two times:<br><br>first time <2016-09-07 17:36:56 CEST>LOG: dur=
ation: 0.965 ms statement: select 'www.fiorino.it' where function_clo=
ud_view_orari('53', x.x.x.x, 'www.fiorino.it') !=3D '';<br>first time <2=
016-09-07 17:36:56 CEST>LOG: duration: 0.359 ms statement: s=
elect 'fiorino.it' where function_cloud_view_orari('53', x.x.x.x, 'fiorino.=
it') !=3D '';<br>first time <2016-09-07 17:36:56 CEST>LOG: dura=
tion: 0.304 ms statement: select 'it' where function_cloud_view_orari=
('53', x.x.x.x, 'it') !=3D '';<br>second time <2016-09-07 17:36:56 CEST&=
gt;LOG: duration: 0.291 ms statement: select 'www.fiorino.it' w=
here function_cloud_view_orari('53', x.x.x.x, 'www.fiorino.it') !=3D '';<br=
>second time <2016-09-07 17:36:56 CEST>LOG: duration: 0.291 ms&=
nbsp; statement: select 'fiorino.it' where function_cloud_view_orari('53', =
x.x.x.x, 'fiorino.it') !=3D '';<br>second time <2016-09-07 17:36:56 CEST=
>LOG: duration: 0.215 ms statement: select 'it' where functi=
on_cloud_view_orari('53', x.x.x.x, 'it') !=3D '';<br><br>Can someone help m=
e with?<br><br>Thank you!<br>Francesco<br>---------------------------------=
---------------------------------------------<br>__________________________=
_____________________<br>Bind-dlz-testers mailing list<br><a ymailto=3D"mai=
lto:[email protected]" href=3D"mailto:Bind-dlz-testers=
@lists.sourceforge.net">[email protected]</a><br><a hr=
ef=3D"https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers" target=
=3D"_blank">https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers</=
a><br><br><br></div> </blockquote> </div> </div> </div></div></body></html=
>
------=_Part_3001224_1849897995.1473529421223--
--===============4543048701022378745==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
------------------------------------------------------------------------------
--===============4543048701022378745==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
Bind-dlz-testers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
--===============4543048701022378745==--