[Postgres-xl-general] Failed to get pooled connection

Andrei Martsinchyk andrei.martsinchyk at gmail.com
Thu Sep 18 22:24:58 PDT 2014


max_connectiion should be greater on datanodes, because datanodes may
connect to each other. Try to set it to 1000. You may need even more,
depending on number of datanodes and complexity of your queries.

2014-09-19 7:52 GMT+03:00 Aaron Jackson <ajackson at revionics.com>:

>      max_connections on the coordinators is set to 100
> max_connections on the datanodes is set to 300 (3 coordinators x 100
> connections)
>
>  we shouldn't be getting anywhere near those limits with the # of people
> we're letting have access to this.
>
>  *Aaron*
>      ------------------------------
> *From:* Mason Sharp [msharp at translattice.com]
> *Sent:* Thursday, September 18, 2014 9:49 PM
> *To:* Aaron Jackson
> *Cc:* postgres-xl-general at lists.sourceforge.net
> *Subject:* Re: [Postgres-xl-general] Failed to get pooled connection
>
>   Hi Aaron,
>
> On Thu, Sep 18, 2014 at 4:49 PM, Aaron Jackson <ajackson at revionics.com>
> wrote:
>
>>      Occassionally, my servers will fail with the daunting "Failed to
>> get pooled connection" error message.  Usually, I will just restart (kick)
>> the datanodes and coordinators to resolve the issue.  But there's no
>> indicator about why it happens and it's frequency is so inconsistent that
>> its just a little unnerving to see it when it happens.
>>
>>  Any thoughts about the root cause of this?  Anything I can look into in
>> detail?
>>
> What is your current setting for max_connections on the nodes? Are you
> putting a high load against the cluster?
>
>  Anything in the log file on the datanodes that you are trying to connect
> to?
>
>
>
>>
>>  *Aaron*
>>
>>
>> ------------------------------------------------------------------------------
>> Slashdot TV.  Video for Nerds.  Stuff that Matters.
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Postgres-xl-general mailing list
>> Postgres-xl-general at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/postgres-xl-general
>>
>>
>
>
>  --
> Mason Sharp
>
> TransLattice - http://www.translattice.com
> Clustered and Distributed Database Solutions
> Postgres-XL Support
>
>
>
> ------------------------------------------------------------------------------
> Slashdot TV.  Video for Nerds.  Stuff that Matters.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xl-general mailing list
> Postgres-xl-general at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/postgres-xl-general
>
>


-- 
Andrei Martsinchyk

StormDB - http://www.stormdb.com
The Database Cloud
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-general-postgres-xl.org/attachments/20140919/914e2a16/attachment.htm>


More information about the postgres-xl-general mailing list