[Postgres-xc-general] coordinator deaths

[Roger M. <rog...@gm...>]

Hello,

I'm new to pg-xc, I'm just working on getting off the ground using pg-xc
1.0.1 as the back end for a new project.  I would've searched prior posts
for similar ones before posting, but I don't see any way to do that?

I'm using CentOS 6.3, I've used the "short version" installation to set up
a gtm, a single coordinator, and a single data node on my local host.  Here
are the contents of my pgxc_node table:

-bash-4.1$ psql -U postgres
psql (PGXC 1.0.1, based on PG 9.1.5)
Type "help" for help.
postgres=# select * from pgxc_node;
 node_name | node_type | node_port | node_host | nodeis_primary |
nodeis_preferred |  node_id
-----------+-----------+-----------+-----------+----------------+------------------+------------
 coord1    | C         |      5432 | localhost | f              | f
       | 1885696643
 datanode1 | D         |     15432 | localhost | t              | t
       |  888802358


The problem I'm having is that after maybe 60 to 90 seconds or so after
starting, the coordinator dies with a log message like

FATAL:  Can not register Coordinator on GTM

The gtm is definitely running, I can see it in the process list.  The only
changes to the default postgresql.conf's I've made is to specify the port
of 15432 for datanode1, and (as part of an effort to fix this problem)
uncomment the host ('localhost') and port (6666) of the gtm in all 3
postgresql.conf files.

Another thing I did to try to fix this was:

alter node datanode1 with (primary = true, preferred = true);

As you can see, that has affected the pgxc_node contents.  But that didn't
have any impact on this crashing behavior.

I tried starting using the method presented in the short version install to
start everything, and I also tried starting up like this:

gtm_ctl -Z gtm -D data_gtm -l gtm.log start
sleep 1
pg_ctl -Z coordinator -D data_coord1 -l coord1.log start
sleep 1
pg_ctl -Z datanode -D data_datanode1 -l datanode1.log start

..from the /usr/local/pgsql directory.  (I also tried specifying absolute
paths.)

I've tried using kill to clear everything out of the process table, I've
tried making sure the last shutdown was clean for everything, using pg_ctl
and gtm_ctl to shutdown, and then starting up fresh from having shutdown
cleanly.

SELinux is disabled, the local firewall is disabled.

Everything works for about 60 to 90 seconds, then the coordinator dies with
the message above.  Any help would be greatly appreciated,

Shavais