Re: [Postgres-xc-general] postgres-xc 0.9.5: Do not have a GTM snapshot available / Failed to get pooled connection

[David H. <dav...@me...>]

Op 09-07-11 04:13, Michael Paquier schreef:
> Hi
>
> On Fri, Jul 8, 2011 at 9:04 PM, David Hartveld
> <dav...@me... <mailto:dav...@me...>> wrote:
>
>     Hi all,
>
>     I'm experimenting a bit with postgres-xc 0.9.5 on debian squeeze,
>     with a build from the 0.9.5 sources. I think I've set up a cluster
>     with three hw systems, two nodes (data node/coordinator each) and a
>     gtm node, properly, following the installation manual.
>
>     However, the data nodes complain when they are started, every so
>     many seconds: "WARNING: Do not have a GTM snapshot available".
>
> This bug is related with autovacuum launcher which is not able to get a
> valid snapshot from GTM. I am studying this test case and may have a fix
> for that next week.

Is it a symptom of the nodes not being able to connect to the coordinators?

>
>     And when I connect to a coordinator and try to execute 'CREATE
>     DATABASE mydb;', I get the message: "ERROR: Failed to get pooled
>     connections". I've attached the configuration files that I am using
>     for coordinator and datanode (the difference between nodes 1 and 2
>     being only that pgxc_node_id is 1 and 2 respectively). The GTM is
>     started with "$GTM -x 628 -p 5000 -D $DATADIR -l $LOGFILE &".
>
> Your configuration files look OK.
> However, a datanode is a node that do not interact with other nodes
> through a connection pooling, so you do not need to set data_node_hosts,
> data_node_ports, pooler_port in its configuration file. num_data_nodes
> also in unnecessary
>
>
>     Any suggestions what I should do or try?
>
> Have you started your nodes with -i option so as they accept TCP-IP
> connections?

They already were, but I actually configured the wrong hostnames. I've 
now reconfigured with the correct IPs.

> As Lionel said, pg_hba.conf setting is full of traps. You should check
> that also.

"host all all samenet trust" should do the trick, I guess?

Thanks for your input!
David