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

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

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?

Aaron