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

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

Hi again,

I turned off connection pooling on coordinator (dunno why it sayed
on), raised the shared_buffers of coordinator, allowed 1000
connections and the error disappeared.
However, all data is still going on one node (and whatever I could
choose as primary datanode), with 40 warehouses... any specific syntax
to load balance warehouses over nodes ?

Lionel F.



2011/5/30 Lionel Frachon <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
>>>
>>
>