Re: Postgres driver unable to find available connection after searching 30 times

--===============3695190791332687236==
Content-Type: multipart/alternative; boundary=14dae93411195b7b5204b74a960a

--14dae93411195b7b5204b74a960a
Content-Type: text/plain; charset=UTF-8

Thanks for your response Rob.

Upon checking connection to database when error occurs with the same
connection details been used by bind-sdb (dlz), everything is fine no
complains.

Setup:

I currently have 2 (local,external) views distributed on two servers both
connecting to replicated Postgresql 9.1 database through pgpool (for load
balancing). Each view I have assigned 1 connection so in total I accumulate
about 4 connections on db.

What are the recommended limits for bind-sdb using dlz on a server
averaging about 20 requests an hour?

2012/1/23 Rob Butler <[email protected]>

> In the driver you specify a DB connection limit.  If you have more DNS
> worker threads than DB connections it's possible for all the allowed
> connections to be in use and the next worker threads can't get one, even if
> there is plenty of overhead left on the DB server.
>
> It's also possible there is a problem connecting to the DB even though
> it's not overloaded.
>
> Rob
>
>   ------------------------------
> *From:* Kwasi Gyasi - Agyei <[email protected]>
> *To:* [email protected]
> *Sent:* Saturday, January 21, 2012 5:27 AM
> *Subject:* [Bind-dlz-testers] Postgres driver unable to find available
> connection after searching 30 times
>
>
> What is causing the issue?
>
> 21-Jan-2012 05:08:18.152 Postgres driver unable to find available
> connection after searching 30 times
> 21-Jan-2012 05:08:18.152 Postgres driver unable to return result set for
> findzone query
>
> I don't quite understand cause database is not overloaded.
> --
>
> Multimedia and Communication | Property | Entertainment
> Kwasi Owusu Gyasi - Agyei
>
> *cell*        (+27) (0) 76 466 4488
> *website *www.4things.co.za
> *email     *[email protected]
> *skype    *kwasi.gyasiagyei
> *role*        Developer.Designer.Software Architect
>
>
> ------------------------------------------------------------------------------
> Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2
> _______________________________________________
> Bind-dlz-testers mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
>
>
>
>
> ------------------------------------------------------------------------------
> Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2
> _______________________________________________
> Bind-dlz-testers mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
>
>


-- 

Multimedia and Communication | Property | Entertainment
Kwasi Owusu Gyasi - Agyei

*cell*        (+27) (0) 76 466 4488
*website *www.4things.co.za
*email     *[email protected]
*skype    *kwasi.gyasiagyei
*role*        Developer.Designer.Software Architect

--14dae93411195b7b5204b74a960a
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Thanks for your response Rob.<br><br>Upon checking connection to database w=
hen error occurs with the same connection details been used by bind-sdb (dl=
z), everything is fine no complains. <br><br>Setup: <br><br>I currently hav=
e 2 (local,external) views distributed on two servers both connecting to re=
plicated Postgresql 9.1 database through pgpool (for load balancing). Each =
view I have assigned 1 connection so in total I accumulate about 4 connecti=
ons on db. <br>
<br>What are the recommended limits for bind-sdb using dlz on a server aver=
aging about 20 requests an hour?<br><br><div class=3D"gmail_quote">2012/1/2=
3 Rob Butler <span dir=3D"ltr">&lt;<a href=3D"mailto:[email protected]">=
[email protected]</a>&gt;</span><br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div><div style=3D"font-size:12pt;font-famil=
y:times new roman,new york,times,serif"><div><span>In the driver you specif=
y a DB connection limit.=C2=A0 If you have more DNS worker threads than DB =
connections it&#39;s possible for all the allowed connections to be in use =
and the next worker threads can&#39;t get one, even if there is plenty of o=
verhead left on the DB server.<br>
</span></div><div><br><span></span></div><div><span>It&#39;s also possible =
there is a problem connecting to the DB even though it&#39;s not overloaded=
.</span></div><div><br></div><div>Rob<br><span></span></div><div><br><block=
quote style=3D"border-left:2px solid rgb(16,16,255);margin-left:5px;margin-=
top:5px;padding-left:5px">
  <div style=3D"font-family:times new roman,new york,times,serif;font-size:=
12pt"> <div style=3D"font-family:times new roman,new york,times,serif;font-=
size:12pt"> <div dir=3D"ltr"> <font face=3D"Arial"> <hr size=3D"1">  <b><sp=
an style=3D"font-weight:bold">From:</span></b> Kwasi Gyasi - Agyei &lt;<a h=
ref=3D"mailto:[email protected]" target=3D"_blank">kwasi.gyasi=
[email protected]</a>&gt;<br>
 <b><span style=3D"font-weight:bold">To:</span></b> <a href=3D"mailto:bind-=
[email protected]" target=3D"_blank">bind-dlz-testers@lists=
.sourceforge.net</a> <br> <b><span style=3D"font-weight:bold">Sent:</span><=
/b> Saturday, January 21, 2012 5:27 AM<br>
 <b><span style=3D"font-weight:bold">Subject:</span></b> [Bind-dlz-testers]=
 Postgres driver unable to find available connection after searching 30 tim=
es<br> </font> </div><div><div class=3D"h5"> <br>
<div><br>What is causing the issue?<br><br>21-Jan-2012 05:08:18.152 Postgre=
s driver unable to find available connection after searching 30 times<br>21=
-Jan-2012 05:08:18.152 Postgres driver unable to return result set for find=
zone query<br>

<br clear=3D"all">I don&#39;t quite understand cause database is not overlo=
aded.<br>-- <br><img src=3D""><br><font style=3D"color:rgb(153,153,153)" si=
ze=3D"1">Multimedia and Communication | Property | Entertainment</font><br>
<span style=3D"color:rgb(102,102,102)">Kwasi Owusu Gyasi - Agyei</span><br>
<br><b style>cell</b>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <span style=
=3D"color:rgb(102,102,102)"><a href=3D"tel:%28%2B27%29%20%280%29%2076%20466=
%204488" value=3D"+27764664488" target=3D"_blank">(+27) (0) 76 466 4488</a>=
</span><br><b style>website </b><span style=3D"color:rgb(51,51,51)"><a rel=
=3D"nofollow" href=3D"http://www.4things.co.za" target=3D"_blank">www.4thin=
gs.co.za</a></span><br>

<b style>email=C2=A0=C2=A0=C2=A0=C2=A0 </b><span style=3D"color:rgb(102,102=
,102)"><a rel=3D"nofollow" href=3D"mailto:[email protected]" t=
arget=3D"_blank">[email protected]</a></span><br><b style>skyp=
e=C2=A0=C2=A0=C2=A0 </b><span style=3D"color:rgb(102,102,102)">kwasi.gyasia=
gyei</span><br>

<b style>role</b>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <span style=3D"=
color:rgb(102,102,102)">Developer.Designer.Software Architect</span><br>
</div><br></div></div>-----------------------------------------------------=
-------------------------<br>Try before you buy =3D See our experts in acti=
on!<br>The most comprehensive online learning library for Microsoft develop=
ers<br>
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,<br=
>Metro Style Apps, more. Free future releases when you subscribe now!<br><a=
 href=3D"http://p.sf.net/sfu/learndevnow-dev2" target=3D"_blank">http://p.s=
f.net/sfu/learndevnow-dev2</a><br>
_______________________________________________<br>Bind-dlz-testers mailing=
 list<br><a href=3D"mailto:[email protected]" target=
=3D"_blank">[email protected]</a><br><a href=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> </div> </blockquote></div>   </div></div><br>--------------=
----------------------------------------------------------------<br>
Try before you buy =3D See our experts in action!<br>
The most comprehensive online learning library for Microsoft developers<br>
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,<br=
>
Metro Style Apps, more. Free future releases when you subscribe now!<br>
<a href=3D"http://p.sf.net/sfu/learndevnow-dev2" target=3D"_blank">http://p=
.sf.net/sfu/learndevnow-dev2</a><br>_______________________________________=
________<br>
Bind-dlz-testers mailing list<br>
<a href=3D"mailto:[email protected]">Bind-dlz-testers@=
lists.sourceforge.net</a><br>
<a href=3D"https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers" t=
arget=3D"_blank">https://lists.sourceforge.net/lists/listinfo/bind-dlz-test=
ers</a><br>
<br></blockquote></div><br><br clear=3D"all"><br>-- <br><img src=3D"http://=
4things.co.za/assets/logo.gif"><br><font style=3D"color:rgb(153,153,153)" s=
ize=3D"1">Multimedia and Communication | Property | Entertainment</font><br=
><span style=3D"color:rgb(102,102,102)">Kwasi Owusu Gyasi - Agyei</span><br=
>

<br><b style=3D"color:rgb(0,0,0)">cell</b>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 <span style=3D"color:rgb(102,102,102)">(+27) (0) 76 466 4488</spa=
n><br><b style=3D"color:rgb(0,0,0)">website </b><span style=3D"color:rgb(51=
,51,51)"><a href=3D"http://www.4things.co.za" target=3D"_blank">www.4things=
.co.za</a></span><br>
<b style=3D"color:rgb(0,0,0)">email=C2=A0=C2=A0=C2=A0=C2=A0 </b><span style=
=3D"color:rgb(102,102,102)"><a href=3D"mailto:[email protected]=
a" target=3D"_blank">[email protected]</a></span><br><b style=
=3D"color:rgb(0,0,0)">skype=C2=A0=C2=A0=C2=A0 </b><span style=3D"color:rgb(=
102,102,102)">kwasi.gyasiagyei</span><br>
<b style=3D"color:rgb(0,0,0)">role</b>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0 <span style=3D"color:rgb(102,102,102)">Developer.Designer.Software A=
rchitect</span><br>

--14dae93411195b7b5204b74a960a--


--===============3695190791332687236==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
--===============3695190791332687236==
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

--===============3695190791332687236==--