[Postgres-xl-general] ERROR: Write to replicated table returned different results from the Datanodes
Drako Kotipelto
drakoflames at hotmail.com
Tue Jan 10 08:29:26 PST 2017
Hi folks!
I have a cluster with this configuration:
PGXC monitor all
Running: gtm master
Running: coordinator master coord2
Running: coordinator master coord3
Running: coordinator master coord1
Running: datanode master dn1
Running: datanode master dn2
Running: datanode master dn0
PGXC
SO and Postgres XL Version:
CentOS Linux release 7.3.1611 (Core)
PostgreSQL 9.5.5 (Postgres-XL 9.5r1.4), 64-bit
But when I execute tutorial examples, the firts statement only insert 36 rows and second show this error:
ERROR: Write to replicated table returned different results from the Datanodes
I add the example:
postgres=# CREATE DATABASE mydb;
CREATE DATABASE
postgres=# \c mydb
You are now connected to database "mydb" as user "postgres".
mydb=# CREATE TABLE disttab(col1 int, col2 int, col3 text) DISTRIBUTE BY HASH(col1);
CREATE TABLE
mydb=# \d+ disttab
Table "public.disttab"
Column | Type | Modifiers | Storage | Stats target | Description
--------+---------+-----------+----------+--------------+-------------
col1 | integer | | plain | |
col2 | integer | | plain | |
col3 | text | | extended | |
Distribute By: HASH(col1)
Location Nodes: ALL DATANODES
mydb=# INSERT INTO disttab SELECT generate_series(1,100), generate_series(101, 200), 'foo';
INSERT 0 36
mydb=# CREATE TABLE repltab (col1 int, col2 int) DISTRIBUTE BY
mydb-# REPLICATION;
CREATE TABLE
mydb=# \d+ repltab
Table "public.repltab"
Column | Type | Modifiers | Storage | Stats target | Description
--------+---------+-----------+---------+--------------+-------------
col1 | integer | | plain | |
col2 | integer | | plain | |
Distribute By: REPLICATION
Location Nodes: ALL DATANODES
mydb=# INSERT INTO repltab SELECT generate_series(1,100), generate_series(101, 200);
ERROR: Write to replicated table returned different results from the Datanodes
mydb=# \q
Something missing in configuration or why happening that?
Another questions:
When a table is distributed, How does Postgres XL decide on which datanode will store the data?
Someone have a production environment tested with Postgres XL? I'm so interested in deploy it.
Best Regards.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20170110/97ba7271/attachment.htm>
More information about the postgres-xl-general
mailing list