Re: Postgres driver unable to find available connection after searching 30 times
Kwasi Gyasi - Agyei <[email protected]> Sat, 28 Jan 2012 05:32:14 +0200
| Newsgroups | gmane.network.dns.bind9.dlz |
|---|---|
| Message-ID | <CA+u6u_H8twmTQZmq0QzY96FQ7FGKvHqEK4+kMxrFhDPxWNFfyw@mail.gmail.com> |
--===============3368532824268429254== Content-Type: multipart/alternative; boundary=90e6ba6e902672b7a104b78e42b6 --90e6ba6e902672b7a104b78e42b6 Content-Type: text/plain; charset=UTF-8 I still don't understand exactly how many connections bind-sdb needs to operate. I have increased 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.... ps -eLF | grep named-sdb returns 7, current bind-sdb configuration creates 8 connections. On Tue, Jan 24, 2012 at 8:48 PM, Kwasi Gyasi - Agyei < [email protected]> wrote: > 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 > -- 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 --90e6ba6e902672b7a104b78e42b6 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I still don't understand exactly how many connections bind-sdb needs to= operate. <br><br>I have increased connections to 4 for external DNS view a= nd 4 for internal DNS view, however it still complains about not been able = to get connection from pool....<br> <br>ps -eLF | grep named-sdb returns 7, current bind-sdb configuration crea= tes 8 connections. <br><br><div class=3D"gmail_quote">On Tue, Jan 24, 2012 = at 8:48 PM, Kwasi Gyasi - Agyei <span dir=3D"ltr"><<a href=3D"mailto:kwa= [email protected]">[email protected]</a>></span> = wrote:<br> <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p= x #ccc solid;padding-left:1ex">Thanks for your response Rob.<br><br>Upon ch= ecking connection to database when error occurs with the same connection de= tails been used by bind-sdb (dlz), everything is fine no complains. <br> <br>Setup: <br><br>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 t= otal I accumulate about 4 connections on db. <br> <br>What are the recommended limits for bind-sdb using dlz on a server aver= aging about 20 requests an hour?<div class=3D"HOEnZb"><div class=3D"h5"><br= ><br><div class=3D"gmail_quote">2012/1/23 Rob Butler <span dir=3D"ltr"><= <a href=3D"mailto:[email protected]" target=3D"_blank">crodster2k@yahoo.= com</a>></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'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 o= verhead 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><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 <<a h= ref=3D"mailto:[email protected]" target=3D"_blank">kwasi.gyasi= [email protected]</a>><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> <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'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>cell</b>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <span style=3D"co= lor:rgb(102,102,102)"><a href=3D"tel:%28%2B27%29%20%280%29%2076%20466%20448= 8" value=3D"+27764664488" target=3D"_blank">(+27) (0) 76 466 4488</a></span= ><br><b>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.4things.co.za</a><= /span><br> <b>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]" target= =3D"_blank">[email protected]</a></span><br><b>skype=C2=A0=C2= =A0=C2=A0 </b><span style=3D"color:rgb(102,102,102)">kwasi.gyasiagyei</span= ><br> <b>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]" target=3D"_blank"= >[email protected]</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>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 href= =3D"http://www.4things.co.za" target=3D"_blank">www.4things.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 href=3D"mailto:[email protected]" target=3D"_blank">= [email protected]</a></span><br><b style>skype=C2=A0=C2=A0=C2= =A0 </b><span style=3D"color:rgb(102,102,102)">kwasi.gyasiagyei</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></div></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)" size=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> --90e6ba6e902672b7a104b78e42b6-- --===============3368532824268429254== 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 --===============3368532824268429254== 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 --===============3368532824268429254==--