Re: [Postgres-xc-general] JDBC driver for 0.9.4

[Lionel F. <lio...@gm...>]

Hi Michael,

I believe this is the kind of query generated by BenchmarlSQL on the
"load data" stage; trying to load a 2-node cluster yesterday
(1gtm+coord+datanode, 1 datanode), only one is loaded, and the other
one complains saying "No GTM snapshot available" and thus not loading
anything. Table content is not accessible either from the second node.
I tried to switch the preferred_node and master node settings, to try
to force the writes on second node first, but without positive result.
However, a std psql query distributes the work properly when issued
through coordinator.

I'll try to revert today to the previous build (05/18) to see if
there's any behaviour difference.

Any clue appeciated ^^

Lionel Frachon

2011/5/26 Michael Paquier <mic...@gm...>:
> Btw, if I were you I'd avoid to use multiple-value INSERT with JDBC. Those
> are queries like:
> INSERT INTO table_ex VALUES (1),(2),(3),(4);
> I noticed today during tests that it wasn't working properly.
> However, single value INSERT and normal queries work fine.
> --
> Michael Paquier
> http://michael.otacoo.com
>