Re: [Postgres-xc-general] Failed to get pooled connections - overnight

[Aaron J. <aja...@re...>]

Yes,

All nodes were running fine.  However, I didn't account for the fact that I rebuilt the server to add PAM support.  When I did that, I reset autoconf and it built with my apparently braindead version of gcc-4.8.  So, the issue was resolved once I rebuilt with gcc-4.7 and redistributed the proper binary.

Thank, sorry for the goose chase.
________________________________
From: Pavan Deolasee [pav...@gm...]
Sent: Monday, May 12, 2014 11:22 AM
To: Aaron Jackson
Cc: pos...@li...
Subject: Re: [Postgres-xc-general] Failed to get pooled connections - overnight



Sent from my iPhone

On 12-May-2014, at 8:51 pm, Aaron Jackson <aja...@re...<mailto:aja...@re...>> wrote:

This morning I came in and connected to my coordinator.  I issued a query to count table A and this succeeded.  I then asked it to count table B and it failed with "Failed to get pooled connections" - I did an explain on both tables and this is what it told me..

explain select count(*) from tableA;

 Aggregate  (cost=2.50..2.51 rows=1 width=0)
   ->  Data Node Scan on "__REMOTE_GROUP_QUERY__"  (cost=0.00..0.00 rows=1000 width=0)
         Node/s: node_pgs01_1, node_pgs02_1, node_pgs03_1
(3 rows)

explain select count(*) from tableB;

 Aggregate  (cost=2.50..2.51 rows=1 width=0)
   ->  Data Node Scan on "__REMOTE_GROUP_QUERY__"  (cost=0.00..0.00 rows=1000 width=0)
         Node/s: node_pgs01_1, node_pgs01_1, node_pgs02_1, node_pgs01_1, node_pgs03_1, node_pgs01_1
(3 rows)

I've seen this twice now, so I figured that maybe the pool needed to be reloaded... so I issued pgxc_pool_reload() but that did not help.  Restarting the coordinator did not change anything, so it appears to be that the metadata for table B is bad?  No nodes have been added or removed since this table was created.

Any thoughts?


Did you check if all the nodes are running fine ?

Thanks,
Pavan

Aaron
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Postgres-xc-general mailing list
Pos...@li...<mailto:Pos...@li...>
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general