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

Aaron Jackson ajackson at revionics.com
Thu Sep 18 21:52:24 PDT 2014

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.

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<mailto: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?


Slashdot TV.  Video for Nerds.  Stuff that Matters.
Postgres-xl-general mailing list
Postgres-xl-general at lists.sourceforge.net<mailto:Postgres-xl-general at lists.sourceforge.net>

Mason Sharp

TransLattice - http://www.translattice.com<http://www.translattice.com/>
Clustered and Distributed Database Solutions
Postgres-XL Support

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-general-postgres-xl.org/attachments/20140919/65e58f51/attachment.htm>

More information about the postgres-xl-general mailing list