[Postgres-xl-developers] synchronous replica

bryain pgdevuser at 163.com
Thu Aug 21 21:57:21 PDT 2014


Hi Mason Sharp,
I finished the cluster configuration.
the database cluster with 1 gtm, 2 gtm_proxy,2 coordinates and 2 datanodes(GTM in a separate physical server,and others 2 in a independent of a physical server).

exec "select * from pgxc_node" return 4 rows as blow:
 node_name | node_type | node_port | node_host | nodeis_primary | nodeis_preferred |   node_id  
-----------+-----------+-----------+-----------+----------------+------------------+-------------
 node1     | D         |     15432 | node1     | f              | f                |   888802358
 node2     | D         |     15432 | node2     | f              | f                |  -905831925
 coord1    | C         |      5432 | node1     | f              | f                |  1885696643
 coord2    | C         |      5432 | node2     | f              | f                | -1197102633

when I create database,
postgres=# create database test_xl;
return error msg:
LOG:  Will fall back to local snapshot for XID = 32138, source = 0, gxmin = 0, autovac launch = 0, autovac = 0, normProcMode = 0, postEnv = 1
ERROR:  node "coord1_9679" does not exist
STATEMENT:  SET global_session TO coord1_9679;
ERROR:  node "coord1_9679" does not exist
STATEMENT:  SET global_session TO coord1_9679;
CREATE DATABASE


atfer that,The database has been created.
create table for testing,
create table test1(id integer,name varchar(20));
CREATE TABLE
insert into test1 values(1,'a');
ERROR:  node "coord1_9755" does not exist
STATEMENT:  SET global_session TO coord1_9755;
INSERT 0 0
there is no data have be inserted.

Bulk insert data
test=# insert into test1 select generate_series(1,100),'test_xl';
ERROR:  node "coord1_9949" does not exist
STATEMENT:  SET global_session TO coord1_9949;
ERROR:  Invalid Datanode number
STATEMENT:  Remote Subplan
LOG:  Connection error Invalid Datanode number
STATEMENT:  insert into test1 select generate_series(1,100),'test_xl';
LOG:  Connection error Invalid Datanode number
STATEMENT:  insert into test1 select generate_series(1,100),'test_xl';
ERROR:  Invalid Datanode number
STATEMENT:  insert into test1 select generate_series(1,100),'test_xl';
ERROR:  Invalid Datanode number


Where is the usually reasons for this problem?thanks!



Regards,
bryain






At 2014-08-21 10:46:11, "Mason Sharp" <msharp at translattice.com> wrote:






On Thu, Aug 21, 2014 at 5:52 AM, bryain <pgdevuser at 163.com> wrote:

Hi all,
I have a new question,I create a database cluster with 1 gtm, 2 coordinates and 2 datanodes.And I create a database on one node(For example,at node1, /usr/local/pgsql/bin/createdb mytest),but an error when I login another node(psql: FATAL:  database "mytest" does not exist).Why isn't synchronous replica?




There is probably something still not quite right in the configuration. The message makes it sound like the other coordinator may think it is a stand-alone, and not part of the cluster. Please see this presentation to help:


http://www.slideshare.net/mason_s/postgres-xl-scaling



Please use the pgxc_ctl utility to configure the cluster. Also, there have been some bug fixes done for this utility, please use the latest code from the source code repository.


Thanks,




--

Mason Sharp

TransLattice - http://www.translattice.com
Distributed and Clustered Database Solutions


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-developers-postgres-xl.org/attachments/20140822/8c2f4e45/attachment.htm>


More information about the Postgres-xl-developers mailing list