Re: Postgres driver unable to find available connection after searching 30 times
Kwasi Gyasi - Agyei <[email protected]> Tue, 31 Jan 2012 21:20:44 +0200
| Newsgroups | gmane.network.dns.bind9.dlz |
|---|---|
| Message-ID | <CA+u6u_E-JSqcuDj659HoGiXi1GjicmXKfdkj8agS1iU=mXDvTw@mail.gmail.com> |
--===============6442401174076206527== Content-Type: multipart/alternative; boundary=90e6ba6e83780a15fd04b7d7dcc2 --90e6ba6e83780a15fd04b7d7dcc2 Content-Type: text/plain; charset=UTF-8 I eventually got it working, increased number of connections in both my external and internal view definitions to 4 on both bind servers. However it appears that only the one server actually answers to queries not sure if the load is automatically distributed 2012/1/31 Rob Butler <[email protected]> > How many threads is your instance of Bind running with? > > Rob > > ------------------------------ > *From:* Kwasi Gyasi - Agyei <[email protected]> > *To:* Rob Butler <[email protected]>; > [email protected] > *Sent:* Friday, January 27, 2012 10:32 PM > *Subject:* Re: [Bind-dlz-testers] Postgres driver unable to find > available connection after searching 30 times > > 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 > > > > > ------------------------------------------------------------------------------ > 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 > _______________________________________________ > 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 --90e6ba6e83780a15fd04b7d7dcc2 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I eventually got it working, increased number of connections in both my ext= ernal and internal view definitions to 4 on both bind servers. However it a= ppears that only the one server actually answers to queries not sure if the= load is automatically distributed<br> <br><div class=3D"gmail_quote">2012/1/31 Rob Butler <span dir=3D"ltr"><<= a href=3D"mailto:[email protected]">[email protected]</a>></span><= br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left= :1px #ccc solid;padding-left:1ex"> <div><div style=3D"font-size:12pt;font-family:times new roman,new york,time= s,serif"><div><span>How many threads is your instance of Bind running with?= </span></div><div><br><span></span></div><div><span>Rob<br></span></div><di= v> <br><blockquote style=3D"border-left:2px solid rgb(16,16,255);margin-left:5= px;margin-top:5px;padding-left:5px"> <div style=3D"font-family:times new r= oman,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"><div class=3D"im"> <hr size=3D"1"> = <b><span style=3D"font-weight:bold">From:</span></b> Kwasi Gyasi - Agyei &= lt;<a href=3D"mailto:[email protected]" target=3D"_blank">kwas= [email protected]</a>><br> </div><b><span style=3D"font-weight:bold">To:</span></b> Rob Butler <<a= href=3D"mailto:[email protected]" target=3D"_blank">[email protected]= m</a>>; <a href=3D"mailto:[email protected]" target= =3D"_blank">[email protected]</a> <br> <b><span style=3D"font-weight:bold">Sent:</span></b> Friday, January 27, 2= 012 10:32 PM<br> <b><span style=3D"font-weight:bold">Subject:</span></b> Re: [Bind-dlz-test= ers] Postgres driver unable to find available connection after searching 30= times<br> </font> </div><div><div class=3D"h5"> <br> <div>I still don't understand exactly how many connections bind-sdb nee= ds to operate. <br><br>I have increased connections to 4 for external DNS v= iew and 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>On Tue, Jan 24, 2012 at 8:48 PM, Kwasi Gyas= i - Agyei <span dir=3D"ltr"><<a rel=3D"nofollow" href=3D"mailto:kwasi.gy= [email protected]" target=3D"_blank">[email protected]</a= >></span> wrote:<br> <blockquote style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-l= eft:1ex">Thanks for your response Rob.<br><br>Upon checking connection to d= atabase when error occurs with the same connection details been used by bin= d-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><div><br><br><div>2012/1/23 Rob Butler= <span dir=3D"ltr"><<a rel=3D"nofollow" href=3D"mailto:crodster2k@yahoo.= com" target=3D"_blank">[email protected]</a>></span><br> <blockquote style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-l= eft:1ex"><div><div style=3D"font-size:12pt;font-family:times new roman,new = york,times,serif"><div><span>In the driver you specify a DB connection limi= t.=C2=A0 If you have more DNS worker threads than DB connections it's p= ossible for all the allowed connections to be in use and the next worker th= reads can't get one, even if there is plenty 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><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 r= el=3D"nofollow" href=3D"mailto:[email protected]" target=3D"_b= lank">[email protected]</a>><br> <b><span style=3D"font-weight:bold">To:</span></b> <a rel=3D"nofollow" hre= f=3D"mailto:[email protected]" target=3D"_blank">bind-= [email protected]</a> <br> <b><span style=3D"font-weight:bo= ld">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 rel=3D"nofollow">(+27) (0) 76 466 4488</a></span><= br><b>website </b><span style=3D"color:rgb(51,51,51)"><a rel=3D"nofollow" h= ref=3D"http://www.4things.co.za" target=3D"_blank">www.4things.co.za</a></s= pan><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 rel=3D"nofollow" href=3D"mailto:[email protected]= rge.net" target=3D"_blank">[email protected]</a><br><a= rel=3D"nofollow" href=3D"https://lists.sourceforge.net/lists/listinfo/bind= -dlz-testers" target=3D"_blank">https://lists.sourceforge.net/lists/listinf= o/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 rel=3D"nofollow" 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 rel=3D"nofollow" href=3D"mailto:[email protected]" = target=3D"_blank">[email protected]</a><br> <a rel=3D"nofollow" href=3D"https://lists.sourceforge.net/lists/listinfo/bi= nd-dlz-testers" target=3D"_blank">https://lists.sourceforge.net/lists/listi= nfo/bind-dlz-testers</a><br> <br></blockquote></div><br><br clear=3D"all"><br>-- <br><img src=3D""><br><= font style=3D"color:rgb(153,153,153)" size=3D"1">Multimedia and Communicati= on | Property | Entertainment</font><br><span style=3D"color:rgb(102,102,10= 2)">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 rel=3D"nofollow">(+27) (0) 76 466 4488</a></span><= br><b>website </b><span style=3D"color:rgb(51,51,51)"><a rel=3D"nofollow" h= ref=3D"http://www.4things.co.za" target=3D"_blank">www.4things.co.za</a></s= pan><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></div></blockquote></div><br><br clear=3D"all"><br>-- <br><img src=3D= ""><br><font style=3D"color:rgb(153,153,153)" size=3D"1">Multimedia and Com= munication | 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><br> </div></div></div> </div> </blockquote></div> </div></div>= <br>-----------------------------------------------------------------------= -------<br> Keep Your Developer Skills Current with LearnDevNow!<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-d2d" target=3D"_blank">http://p.= sf.net/sfu/learndevnow-d2d</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> --90e6ba6e83780a15fd04b7d7dcc2-- --===============6442401174076206527== 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 --===============6442401174076206527== 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 --===============6442401174076206527==--