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

[Michael P. <mic...@gm...>]

On Mon, Jul 11, 2011 at 6:22 PM, David Hartveld
<dav...@me...>wrote:

> Op 09-07-11 04:13, Michael Paquier schreef:
>
>> Hi
>>
>> On Fri, Jul 8, 2011 at 9:04 PM, David Hartveld
>> <dav...@me... <mailto:david.hartveld@mendix.**com<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?
>
Snapshots and GXIDs are fed from GTM. So it is not directly related.
It is a problem with the internal process autovacuum is using to try to get
a snapshot from GTM, and is not related at all with your setting problems.


>
>
>
>>    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.

OK, that's cool if it works.

-- 
Michael Paquier
http://michael.otacoo.com