[Postgres-xl-bugs] postgres-xl9.2.0 - possible bug

Andrei Martsinchyk andrei.martsinchyk at gmail.com
Thu Jun 5 22:17:35 PDT 2014


Hi Rushi,

Thanks for your interest.
You did not configured nodes on the datanode.
Please login to the datanode and run
CREATE NODE coord1 WITH (TYPE = 'coordinator', PORT = 5432);
ALTER NODE datanode1 WITH (TYPE = 'datanode', PORT =15461);

Btw, to see any benefit of XL you should configure at least two datanodes.



2014-06-05 21:25 GMT+03:00 RUSHI KAW <rushi_life at yahoo.co.in>:

> Hi,
>
> I found a possible bug with postgres-xl when I try to insert values in a
> distributed table.
> I have installed pgxl-9.2 on Ubuntu 12.04.4. I tested it with 1
> coordinator, 1 gtm and 1 datanode.
> All these components are on single machine.
> I initialize the database as:
>
> initdb --noclean -D /home/result/`whoami`/pgsql/data_coord1 --nodename
> coord1
> initdb --noclean -D /home/result/`whoami`/pgsql/data_datanode1 --nodename
> datanode1
> initgtm -D /home/result/`whoami`/pgsql/data_gtm -Z gtm
>
> I start the servers as:
>
> gtm_ctl -Z gtm -D /home/result/`whoami`/pgsql/data_gtm -l
> /home/rushik/result/`whoami`/pgsql/gtm_logfile start
>
> pg_ctl -Z coordinator -o "-S 128  -c wal_writer_delay=10000ms -c
> enable_seqscan=off -c effective_cache_size=128kB " -D
> /home/result/`whoami`/pgsql/data_coord1 -l
> /home/result/`whoami`/pgsql/coord1_logfile start
>
> pg_ctl -Z datanode -o "-p 15461 -c pooler_port=7768 -c
> wal_writer_delay=10000ms -c enable_seqscan=off -c
> effective_cache_size=128kB -c synchronous_commit=off -c
> checkpoint_segments=128 -c checkpoint_timeout=30min" -D
> /home/result/`whoami`/pgsql/data_datanode1 -l
> /home/result/`whoami`/pgsql/datanode1_logfile start
>
> Before creating the nodes, I check the output of "select * from pgxc_node"
> on both coordinator and the datanode.
>
> On the coordinator: psql -p 5432 postgres
> 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
>
> On datanode: psql -p 15461 postgres
> psql (PGXL 9.2.0, based on PG 9.2.4 (Postgres-XL 9.2.0))
> Type "help" for help.
>
> postgres=# select * from pgxc_node;
>  node_name | node_type | node_port | node_host | nodeis_primary |
> nodeis_preferred |  node_id
>
> -----------+-----------+-----------+-----------+----------------+------------------+-----------
>  datanode1 | C         |      5432 | localhost | f              | f
>          | 888802358
>
> Then, back on coordinator, I create the node as: psql -p 5432 postgres
>
> postgres=# CREATE NODE datanode1 WITH (TYPE = 'datanode', PORT =15461);
> CREATE NODE
> postgres=# SELECT pgxc_pool_reload();
>  pgxc_pool_reload
> ------------------
>  t
> (1 row)
>
> 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         |     15461 | localhost | f              | f
>          |  888802358
>
> I create a table as:
> postgres=# create table temp (id int) distribute by hash(id);
> CREATE TABLE
> postgres=# insert into temp values(1);
> INSERT 0 0
>
> Could you please let me know if there something wrong with the way I have
> configured, some extra step that I have missed.
> Thanks.
>
> Regards,
> Rushi Kaw
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech
> _______________________________________________
> Postgres-xl-bugs mailing list
> Postgres-xl-bugs at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/postgres-xl-bugs
>
>


-- 
Andrei Martsinchyk

StormDB - http://www.stormdb.com
The Database Cloud
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-bugs-postgres-xl.org/attachments/20140606/0b65e8ad/attachment.htm>


More information about the postgres-xl-bugs mailing list