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

Mason Sharp msharp at translattice.com
Fri Sep 19 07:31:21 PDT 2014


On Fri, Sep 19, 2014 at 12:47 AM, Pavan Deolasee <pavan.deolasee at gmail.com>
wrote:

>
>
> On Fri, Sep 19, 2014 at 3:19 AM, 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?
>>
>>
> Do you see any networking issues here? But if restarting
> datanodes/coordinators resolve the error, then it looks unlikely.
>
> Does the cluster undergo any reconfiguration?
>
> Next time this happens, it might be worth trying to connect the datanode
> directly via psql (preferably from the coordinator node) and see if that
> works ok. I wonder if you might be hitting some limits such as open file
> descriptors on the datanode.
>
>
This is also a good point.

Check /etc/security/limits.conf, possibly increase the value for nofile.


-- 
Mason Sharp

TransLattice - http://www.translattice.com
Clustered and Distributed Database Solutions
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-general-postgres-xl.org/attachments/20140919/62a9db2e/attachment.htm>


More information about the postgres-xl-general mailing list