[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