[Postgres-xl-developers] Postgres XL and Npgsql: Coordinator Exception

Mason Sharp mason.sharp at gmail.com
Thu Apr 9 09:46:28 PDT 2015


On Wed, Apr 8, 2015 at 10:55 PM, Koichi Suzuki <koichi.dbms at gmail.com>
wrote:

> Was the configuration successful?   You can check pgxc_node catalog to
> see your cluster configuration.   Also, you can raise the message
> level to have more detailed info on the exception.
>
> If you are checking that a datanode is running, you can issue select
> statement directly to a datanode, which should work.   Also, to check
> connectivity from coordinator to datanode, you can use "EXECUTE
> DIRECT" statement to issue read sql statement to a datanode.
>
> Regards;
> ---
> Koichi Suzuki
>
>
> 2015-04-09 11:49 GMT+09:00 Jaaromy Zierse <jzierse at ghostery.com>:
> > I updated the data node directly simply as a test, since inserting via
> the coordinator is throwing the exception. I simply wanted to verify that
> the issue wasn't something to do with a connection problem with the server
> or something similar.
> >
> >
>

Also, does it work without this line?

@"SET TRANSACTION READ WRITE;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-developers-postgres-xl.org/attachments/20150409/5cdc7f76/attachment.htm>


More information about the Postgres-xl-developers mailing list