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

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

Hello,

tried again with your compilations options, the datanodes connect
correctly to the gtm, and the coordinator aswell, but on loadData.sh,
only one node is loaded, whereas the 2 other ones complains

"STATEMENT:  COMMIT PREPARED 'T709'
ERROR:  prepared transaction with identifier "T711" does not exist
STATEMENT:  COMMIT PREPARED 'T711'
ERROR:  prepared transaction with identifier "T713" does not exist
STATEMENT:  COMMIT PREPARED 'T713'"

and the loader itself complains aswell

ERROR: Could not commit prepared transaction implicitely
  Elasped Time(ms): 0.86        Writing record 215000 of 500000

Looks like a lack of comm between them ?

Lionel F.



2011/5/30 Lionel Frachon <lio...@gm...>:
> Ok, testing your compile flags.
>
> On install, I'm adding an /etc/ld.so.conf.d/pgxc.conf file pointing to
> /usr/local/pgsql/lib, then doing an lddconfig to ensure the lib is
> enabled system-wide. Will add LD_LIBRARY_PATH in user env just to be
> sure (but I think it already works properly, as if I miss it, the
> server does not start...)
>
> Lionel F.
>
>
>
> 2011/5/30 Michael Paquier <mic...@gm...>:
>> Compilation looks to be correct, I myself use this one:
>> ./configure CFLAGS="-DPGXC -O2" --enable-depend --enable-debug
>> --disable-rpath --enable-cassert
>> but even if you define the flag before configure it works correctly.
>>
>> On Mon, May 30, 2011 at 4:52 PM, Lionel Frachon <lio...@gm...>
>> wrote:
>>>
>>> Hi Michael,
>>>
>>> thanks for your tests and involvment. The error on my side may be a
>>> compilation, installation or environment problem (at this point, I
>>> have no clues) , here are the CFLAGS I use :
>>>
>>> CFLAGS="-O2"
>>> and configure :
>>> "./configure --enable-debug --disable-rpath --enable-depend"
>>>
>>> I'm then packing with rpmbuild everything in /usr/local/pgsql. Is that
>>> a good method (apart from compiling directly on host)?
>>>
>>> Are there any env variable (like /etc/security/limits.conf tweaking,
>>> semaphores or whatever) I should be aware of ?
>>
>> LD_LIBRARY_PATH is an environment variable you should set to point to the
>> correct XC libraries.
>> It is the only thing that may mess up your settings I think.
>> --
>> Michael Paquier
>> http://michael.otacoo.com
>>
>