Re: Postgres driver unable to find available connection after searching 30 times
Rob Butler <[email protected]> Tue, 31 Jan 2012 09:30:25 -0800 (PST)
| Newsgroups | gmane.network.dns.bind9.dlz |
|---|---|
| Message-ID | <[email protected]> |
--===============2465819150079104753== Content-Type: multipart/alternative; boundary="1754690083-1537950538-1328031025=:29034" --1754690083-1537950538-1328031025=:29034 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable How many threads is your instance of Bind running with?=0A=0ARob=0A=0A=0A= =0A=0A>________________________________=0A> From: Kwasi Gyasi - Agyei <kwas= [email protected]>=0A>To: Rob Butler <[email protected]>; bind-= [email protected] =0A>Sent: Friday, January 27, 2012 10:32 = PM=0A>Subject: Re: [Bind-dlz-testers] Postgres driver unable to find availa= ble connection after searching 30 times=0A> =0A>=0A>I still don't understan= d exactly how many connections bind-sdb needs to operate. =0A>=0A>I have in= creased connections to 4 for external DNS view and 4 for internal DNS view,= however it still complains about not been able to get connection from pool= ....=0A>=0A>ps -eLF | grep named-sdb returns 7, current bind-sdb configurat= ion creates 8 connections. =0A>=0A>=0A>On Tue, Jan 24, 2012 at 8:48 PM, Kwa= si Gyasi - Agyei <[email protected]> wrote:=0A>=0A>Thanks for = your response Rob.=0A>>=0A>>Upon checking connection to database when error= occurs with the same connection details been used by bind-sdb (dlz), every= thing is fine no complains. =0A>>=0A>>Setup: =0A>>=0A>>I currently have 2 (= local,external) views distributed on two servers both connecting to replica= ted Postgresql 9.1 database through pgpool (for load balancing). Each view = I have assigned 1 connection so in total I accumulate about 4 connections o= n db. =0A>>=0A>>What are the recommended limits for bind-sdb using dlz on a= server averaging about 20 requests an hour?=0A>>=0A>>=0A>>=0A>>2012/1/23 R= ob Butler <[email protected]>=0A>>=0A>>In the driver you specify a DB co= nnection limit.=A0 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 wor= ker threads can't get one, even if there is plenty of overhead left on the = DB server.=0A>>>=0A>>>=0A>>>=0A>>>It's also possible there is a problem con= necting to the DB even though it's not overloaded.=0A>>>=0A>>>=0A>>>Rob=0A>= >>=0A>>>=0A>>>=0A>>>=0A>>>>________________________________=0A>>>> From: Kw= asi Gyasi - Agyei <[email protected]>=0A>>>>To: bind-dlz-teste= [email protected] =0A>>>>Sent: Saturday, January 21, 2012 5:27 AM=0A= >>>>Subject: [Bind-dlz-testers] Postgres driver unable to find available co= nnection after searching 30 times=0A>>>> =0A>>>>=0A>>>>=0A>>>>=0A>>>>What i= s causing the issue?=0A>>>>=0A>>>>21-Jan-2012 05:08:18.152 Postgres driver = unable to find available connection after searching 30 times=0A>>>>21-Jan-2= 012 05:08:18.152 Postgres driver unable to return result set for findzone q= uery=0A>>>>=0A>>>>I don't quite understand cause database is not overloaded= .=0A>>>>-- =0A>>>>=0A>>>>Multimedia and Communication | Property | Entertai= nment=0A>>>>Kwasi Owusu Gyasi - Agyei=0A>>>>=0A>>>>cell=A0=A0=A0=A0=A0=A0= =A0 (+27) (0) 76 466 4488=0A>>>>website www.4things.co.za=0A>>>>email=A0=A0= =A0=A0 [email protected]=0A>>>>skype=A0=A0=A0 kwasi.gyasiagyei= =0A>>>>role=A0=A0=A0=A0=A0=A0=A0 Developer.Designer.Software Architect=0A>>= >>=0A>>>>------------------------------------------------------------------= ------------=0A>>>>Try before you buy =3D See our experts in action!=0A>>>>= The most comprehensive online learning library for Microsoft developers=0A>= >>>is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,= =0A>>>>Metro Style Apps, more. Free future releases when you subscribe now!= =0A>>>>http://p.sf.net/sfu/learndevnow-dev2=0A>>>>_________________________= ______________________=0A>>>>Bind-dlz-testers mailing list=0A>>>>Bind-dlz-t= [email protected]=0A>>>>https://lists.sourceforge.net/lists/list= info/bind-dlz-testers=0A>>>>=0A>>>>=0A>>>>=0A>>>---------------------------= ---------------------------------------------------=0A>>>Try before you buy= =3D See our experts in action!=0A>>>The most comprehensive online learning= library for Microsoft developers=0A>>>is just $99.99! Visual Studio, Share= Point, SQL - plus HTML5, CSS3, MVC3,=0A>>>Metro Style Apps, more. Free futu= re releases when you subscribe now!=0A>>>http://p.sf.net/sfu/learndevnow-de= v2=0A>>>_______________________________________________=0A>>>Bind-dlz-teste= rs mailing list=0A>>>[email protected]=0A>>>https://li= sts.sourceforge.net/lists/listinfo/bind-dlz-testers=0A>>>=0A>>>=0A>>=0A>>= =0A>>-- =0A>>=0A>>Multimedia and Communication | Property | Entertainment= =0A>>Kwasi Owusu Gyasi - Agyei=0A>>=0A>>cell=A0=A0=A0=A0=A0=A0=A0 (+27) (0)= 76 466 4488=0A>>website www.4things.co.za=0A>>email=A0=A0=A0=A0 kwasi.gyas= [email protected]=0A>>skype=A0=A0=A0 kwasi.gyasiagyei=0A>>role=A0=A0=A0= =A0=A0=A0=A0 Developer.Designer.Software Architect=0A>>=0A>=0A>=0A>-- =0A>= =0A>Multimedia and Communication | Property | Entertainment=0A>Kwasi Owusu = Gyasi - Agyei=0A>=0A>cell=A0=A0=A0=A0=A0=A0=A0 (+27) (0) 76 466 4488=0A>web= site www.4things.co.za=0A>email=A0=A0=A0=A0 [email protected]= =0A>skype=A0=A0=A0 kwasi.gyasiagyei=0A>role=A0=A0=A0=A0=A0=A0=A0 Developer.= Designer.Software Architect=0A>=0A>=0A> --1754690083-1537950538-1328031025=:29034 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable <html><body><div style=3D"color:#000; background-color:#fff; font-family:ti= mes new roman, new york, times, serif;font-size:12pt"><div><span>How many t= hreads is your instance of Bind running with?</span></div><div><br><span></= span></div><div><span>Rob<br></span></div><div><br><blockquote style=3D"bor= der-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; pa= dding-left: 5px;"> <div style=3D"font-family: times new roman, new york, t= imes, 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" size=3D"2"> <hr size=3D"1"> <b><span style=3D"font-weight:bold;">F= rom:</span></b> Kwasi Gyasi - Agyei <[email protected]><= br> <b><span style=3D"font-weight: bold;">To:</span></b> Rob Butler <cro= [email protected]>; [email protected] <br> <b><span= style=3D"font-weight: bold;">Sent:</span></b> Friday, January 27, 2012 10:= 32 PM<br> <b><span style=3D"font-weight: bold;">Subject:</span></b> Re: [Bind-dlz-te= sters] Postgres driver unable to find available connection after searching = 30 times<br> </font> </div> <br>=0A<div id=3D"yiv316977594">I still don't u= nderstand exactly how many connections bind-sdb needs to operate. <br><br>I= have increased connections to 4 for external DNS view and 4 for internal D= NS view, however it still complains about not been able to get connection f= rom pool....<br>=0A<br>ps -eLF | grep named-sdb returns 7, current bind-sdb= configuration creates 8 connections. <br><br><div class=3D"yiv316977594gma= il_quote">On Tue, Jan 24, 2012 at 8:48 PM, Kwasi Gyasi - Agyei <span dir=3D= "ltr"><<a rel=3D"nofollow" ymailto=3D"mailto:[email protected]= .za" target=3D"_blank" href=3D"mailto:[email protected]">kwasi= [email protected]</a>></span> wrote:<br>=0A<blockquote class=3D"= yiv316977594gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc so= lid;padding-left:1ex;">Thanks for your response Rob.<br><br>Upon checking c= onnection to database when error occurs with the same connection details be= en used by bind-sdb (dlz), everything is fine no complains. <br>=0A<br>Setu= p: <br><br>I currently have 2 (local,external) views distributed on two ser= vers both connecting to replicated Postgresql 9.1 database through pgpool (= for load balancing). Each view I have assigned 1 connection so in total I a= ccumulate about 4 connections on db. <br>=0A=0A<br>What are the recommended= limits for bind-sdb using dlz on a server averaging about 20 requests an h= our?<div class=3D"yiv316977594HOEnZb"><div class=3D"yiv316977594h5"><br><br= ><div class=3D"yiv316977594gmail_quote">2012/1/23 Rob Butler <span dir=3D"l= tr"><<a rel=3D"nofollow" ymailto=3D"mailto:[email protected]" target= =3D"_blank" href=3D"mailto:[email protected]">[email protected]</a>&g= t;</span><br>=0A=0A<blockquote class=3D"yiv316977594gmail_quote" style=3D"m= argin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div><div st= yle=3D"font-size:12pt;font-family:times new roman, new york, times, serif;"= ><div><span>In the driver you specify a DB connection limit. If you h= ave more DNS worker threads than DB connections it's possible for all the a= llowed 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.<br>=0A=0A</span>= </div><div><br><span></span></div><div><span>It's also possible there is a = problem connecting to the DB even though it's not overloaded.</span></div><= div><br></div><div>Rob<br><span></span></div><div><br><blockquote style=3D"= border-left:2px solid rgb(16,16,255);margin-left:5px;margin-top:5px;padding= -left:5px;">=0A=0A <div style=3D"font-family:times new roman, new york, ti= mes, 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><span style=3D"font-weight:bold;">From:</span></b> K= wasi Gyasi - Agyei <<a rel=3D"nofollow" ymailto=3D"mailto:kwasi.gyasiagy= [email protected]" target=3D"_blank" href=3D"mailto:kwasi.gyasiagyei@4things= .co.za">[email protected]</a>><br>=0A=0A <b><span style=3D"= font-weight:bold;">To:</span></b> <a rel=3D"nofollow" ymailto=3D"mailto:bin= [email protected]" target=3D"_blank" href=3D"mailto:bind-= [email protected]">[email protected]</= a> <br> <b><span style=3D"font-weight:bold;">Sent:</span></b> Saturday, Jan= uary 21, 2012 5:27 AM<br>=0A=0A <b><span style=3D"font-weight:bold;">Subjec= t:</span></b> [Bind-dlz-testers] Postgres driver unable to find available c= onnection after searching 30 times<br> </font> </div><div><div> <br>=0A<div= ><br>What is causing the issue?<br><br>21-Jan-2012 05:08:18.152 Postgres dr= iver 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 findzone= query<br>=0A=0A=0A<br clear=3D"all">I don't quite understand cause databas= e is not overloaded.<br>-- <br><img><br><font style=3D"color:rgb(153,153,15= 3);" size=3D"1">Multimedia and Communication | Property | Entertainment</fo= nt><br>=0A<span style=3D"color:rgb(102,102,102);">Kwasi Owusu Gyasi - Agyei= </span><br>=0A<br><b>cell</b> <sp= an style=3D"color:rgb(102,102,102);"><a rel=3D"nofollow">(+27) (0) 76 466 4= 488</a></span><br><b>website </b><span style=3D"color:rgb(51,51,51);"><a re= l=3D"nofollow" target=3D"_blank" href=3D"http://www.4things.co.za">www.4thi= ngs.co.za</a></span><br>=0A=0A=0A<b>email </b><span= style=3D"color:rgb(102,102,102);"><a rel=3D"nofollow" ymailto=3D"mailto:kw= [email protected]" target=3D"_blank" href=3D"mailto:kwasi.gyasia= [email protected]">[email protected]</a></span><br><b>skype&n= bsp; </b><span style=3D"color:rgb(102,102,102);">kwasi.gyasiagy= ei</span><br>=0A=0A=0A<b>role</b> = <span style=3D"color:rgb(102,102,102);">Developer.Designer.Software Archit= ect</span><br>=0A</div><br></div></div>------------------------------------= ------------------------------------------<br>Try before you buy =3D See ou= r experts in action!<br>The most comprehensive online learning library for = Microsoft developers<br>=0A=0Ais just $99.99! Visual Studio, SharePoint, SQ= L - plus HTML5, CSS3, MVC3,<br>Metro Style Apps, more. Free future releases= when you subscribe now!<br>http://p.sf.net/sfu/learndevnow-dev2<br>=0A=0A_= ______________________________________________<br>Bind-dlz-testers mailing = list<br><a rel=3D"nofollow" ymailto=3D"mailto:[email protected]= forge.net" target=3D"_blank" href=3D"mailto:[email protected]= rge.net">[email protected]</a><br><a rel=3D"nofollow" = target=3D"_blank" href=3D"https://lists.sourceforge.net/lists/listinfo/bind= -dlz-testers">https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers= </a><br>=0A=0A<br><br> </div> </div> </blockquote></div> </div></div><br>= ---------------------------------------------------------------------------= ---<br>=0ATry before you buy =3D See our experts in action!<br>=0AThe most = comprehensive online learning library for Microsoft developers<br>=0Ais jus= t $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,<br>=0AMe= tro Style Apps, more. Free future releases when you subscribe now!<br>=0A<a= rel=3D"nofollow" target=3D"_blank" href=3D"http://p.sf.net/sfu/learndevnow= -dev2">http://p.sf.net/sfu/learndevnow-dev2</a><br>________________________= _______________________<br>=0ABind-dlz-testers mailing list<br>=0A<a rel=3D= "nofollow" ymailto=3D"mailto:[email protected]" target= =3D"_blank" href=3D"mailto:[email protected]">Bind-dlz= [email protected]</a><br>=0A<a rel=3D"nofollow" target=3D"_bla= nk" href=3D"https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers">= https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers</a><br>=0A<br= ></blockquote></div><br><br clear=3D"all"><br>-- <br><img src=3D"http://4th= ings.co.za/assets/logo.gif"><br><font style=3D"color:rgb(153,153,153);" siz= e=3D"1">Multimedia and Communication | Property | Entertainment</font><br><= span style=3D"color:rgb(102,102,102);">Kwasi Owusu Gyasi - Agyei</span><br>= =0A=0A=0A<br><b style=3D"">cell</b> &nbs= p; <span style=3D"color:rgb(102,102,102);"><a rel=3D"nofollow">(+27) (0) 76= 466 4488</a></span><br><b style=3D"">website </b><span style=3D"color:rgb(= 51,51,51);"><a rel=3D"nofollow" target=3D"_blank" href=3D"http://www.4thing= s.co.za">www.4things.co.za</a></span><br>=0A=0A<b style=3D"">email &nb= sp; </b><span style=3D"color:rgb(102,102,102);"><a rel=3D"nofol= low" ymailto=3D"mailto:[email protected]" target=3D"_blank" hr= ef=3D"mailto:[email protected]">[email protected]= </a></span><br><b style=3D"">skype </b><span style=3D"col= or:rgb(102,102,102);">kwasi.gyasiagyei</span><br>=0A=0A<b style=3D"">role</= b> <span style=3D"color:rgb(102,1= 02,102);">Developer.Designer.Software Architect</span><br>=0A</div></div></= blockquote></div><br><br clear=3D"all"><br>-- <br><img src=3D"http://4thing= s.co.za/assets/logo.gif"><br><font style=3D"color:rgb(153,153,153);" size= =3D"1">Multimedia and Communication | Property | Entertainment</font><br>= =0A<span style=3D"color:rgb(102,102,102);">Kwasi Owusu Gyasi - Agyei</span>= <br>=0A<br><b style=3D"color:rgb(0,0,0);">cell</b> &= nbsp; <span style=3D"color:rgb(102,102,102);">(+27) (0) 76 466 = 4488</span><br><b style=3D"color:rgb(0,0,0);">website </b><span style=3D"co= lor:rgb(51,51,51);"><a rel=3D"nofollow" target=3D"_blank" href=3D"http://ww= w.4things.co.za">www.4things.co.za</a></span><br>=0A<b style=3D"color:rgb(0= ,0,0);">email </b><span style=3D"color:rgb(102,102,= 102);"><a rel=3D"nofollow" ymailto=3D"mailto:[email protected]= " target=3D"_blank" href=3D"mailto:[email protected]">kwasi.gy= [email protected]</a></span><br><b style=3D"color:rgb(0,0,0);">skype&n= bsp; </b><span style=3D"color:rgb(102,102,102);">kwasi.gyasiagy= ei</span><br>=0A<b style=3D"color:rgb(0,0,0);">role</b> &n= bsp; <span style=3D"color:rgb(102,102,102);">Developer.De= signer.Software Architect</span><br>=0A</div><br><br> </div> </div> </block= quote></div> </div></body></html> --1754690083-1537950538-1328031025=:29034-- --===============2465819150079104753== 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 --===============2465819150079104753== 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 --===============2465819150079104753==--