|
From: Aaron J. <aja...@re...> - 2014-05-12 15:21:53
|
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
|