[Postgres-xl-general] DATA LOSS : frequent failures while INSERTing data, returning 0 0

Samba saasira at gmail.com
Thu Sep 15 11:32:33 PDT 2016


Hi,

i created 2 datanode, one coordinator, one gtm setup on local machine, as
explain in the ShortVesion page of pgxl documentation, and everything
seemed working fine until i started inserting different data into some
tables.

INSERT works fine sometimes, returning 0 1 or 0 2, but fails sometimes with
0 0 due to which the data gets lost.

i would like to know, first, what this  0,1 and 0,2 mean after INSERTing
the records?

then would need to understand why some records are failing to make it to
storage, while others are perfectly being saved.

i also confirmed that the data is getting distributed by hash function
between the two nodes, evenly - so am pretty sure that both the datanodes
are up & running and recognise each other, and so does coordinator node.


could you please tell me if this is due to any misconfiguration or how to
find where the issue is and how to fix it?

Thanks & Regards,
Samba
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20160916/493b44ec/attachment.htm>


More information about the postgres-xl-general mailing list