Re: Postgres driver unable to find available connection after searching 30 times
Rob Butler <[email protected]> Mon, 23 Jan 2012 13:19:06 -0800 (PST)
| Newsgroups | gmane.network.dns.bind9.dlz |
|---|---|
| Message-ID | <[email protected]> |
--===============3003961181095759593== Content-Type: multipart/alternative; boundary="1754690083-630122442-1327353546=:67784" --1754690083-630122442-1327353546=:67784 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable In the driver you specify a DB connection limit.=A0 If you have more DNS wo= rker threads than DB connections it's possible for all the allowed connecti= ons to be in use and the next worker threads can't get one, even if there i= s plenty of overhead left on the DB server.=0A=0A=0AIt's also possible ther= e is a problem connecting to the DB even though it's not overloaded.=0A=0AR= ob=0A=0A=0A=0A=0A>________________________________=0A> From: Kwasi Gyasi - = Agyei <[email protected]>=0A>To: [email protected]= forge.net =0A>Sent: Saturday, January 21, 2012 5:27 AM=0A>Subject: [Bind-dl= z-testers] Postgres driver unable to find available connection after search= ing 30 times=0A> =0A>=0A>=0A>What is causing the issue?=0A>=0A>21-Jan-2012 = 05:08:18.152 Postgres driver unable to find available connection after sear= ching 30 times=0A>21-Jan-2012 05:08:18.152 Postgres driver unable to return= result set for findzone query=0A>=0A>I don't quite understand cause databa= se is not overloaded.=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= [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>T= ry 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/learn= devnow-dev2=0A>_______________________________________________=0A>Bind-dlz-= testers mailing list=0A>[email protected]=0A>https://l= ists.sourceforge.net/lists/listinfo/bind-dlz-testers=0A>=0A>=0A> --1754690083-630122442-1327353546=:67784 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>In the dri= ver you specify a DB connection limit. If you have more DNS worker th= reads 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 plent= y of overhead left on the DB server.<br></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><s= pan></span></div><div><br><blockquote style=3D"border-left: 2px solid rgb(1= 6, 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: 1= 2pt;"> <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;">From:</span></b> Kwasi G= yasi - Agyei <[email protected]><br> <b><span style=3D"f= ont-weight: bold;">To:</span></b> [email protected] <b= r> <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 times<br> </font> </div> <br>=0A<div id=3D"yiv140086521= 3"><br>What is causing the issue?<br><br>21-Jan-2012 05:08:18.152 Postgres = driver unable to find available connection after searching 30 times<br>21-J= an-2012 05:08:18.152 Postgres driver unable to return result set for findzo= ne query<br>=0A<br clear=3D"all">I don't quite understand cause database is= not overloaded.<br>-- <br><img src=3D"http://4things.co.za/assets/logo.gif= "><br><font style=3D"color:rgb(153,153,153);" size=3D"1">Multimedia and Com= munication | Property | Entertainment</font><br>=0A<span style=3D"color:rgb= (102,102,102);">Kwasi Owusu Gyasi - Agyei</span><br>=0A<br><b style=3D"colo= r:rgb(0,0,0);">cell</b> <span sty= le=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"color:rgb(51,51,51);"><a rel= =3D"nofollow" target=3D"_blank" href=3D"http://www.4things.co.za">www.4thin= gs.co.za</a></span><br>=0A<b style=3D"color:rgb(0,0,0);">email &= nbsp; </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]">[email protected]</= a></span><br><b style=3D"color:rgb(0,0,0);">skype </b><sp= an style=3D"color:rgb(102,102,102);">kwasi.gyasiagyei</span><br>=0A<b style= =3D"color:rgb(0,0,0);">role</b> <= span style=3D"color:rgb(102,102,102);">Developer.Designer.Software Architec= t</span><br>=0A</div><br>--------------------------------------------------= ----------------------------<br>Try before you buy =3D See our experts in a= ction!<br>The most comprehensive online learning library for Microsoft deve= lopers<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 ymailto=3D"mailto:B= [email protected]" href=3D"mailto:Bind-dlz-testers@list= s.sourceforge.net">[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></body></html> --1754690083-630122442-1327353546=:67784-- --===============3003961181095759593== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline ------------------------------------------------------------------------------ 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 --===============3003961181095759593== 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 --===============3003961181095759593==--