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

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

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 ?

Thanks.

Kind regards

Lionel F.



2011/5/30 Michael Paquier <mic...@gm...>:
> Hi,
>
> I tested the benchmark with latest head code, and it looks to work on my
> side without crashing.
> Respecting what you said in your previous email and what is written in
> README.
> #Create database
> createdb test
> #Create tables
> ./runSQL.sh postgres.properties sqlTableCreates
> #Data generation
> ./loadData.sh postgres.properties numWarehouses 1
> #Index creation
> ./runSQL.sh postgres.properties sqlIndexCreates
> #To launch test terminal
> ./runBenchmark.sh postgres.properties
>
> With the following properties
> driver=org.postgresql.Driver
> conn=jdbc:postgresql://localhost:5432/test
> user=******
> password=*****
>
> I found in the logs some errors such as:
> LOG:  execute <unnamed>: SELECT c_discount, c_last, c_credit, w_tax  FROM
> customer, warehouse WHERE w_id = $1 AND w_id = c_w_id AND c_d_id = $2 AND
> c_id = $3
> DETAIL:  parameters: $1 = '1', $2 = '10', $3 = '1549'
> ERROR:  bind message supplies 3 parameters, but prepared statement ""
> requires 0
>
> But this is expected as XC does not yet manage multi-prepared queries and
> BenchmarkSQL looks to use it.

Yes, I've seen it and saw your warning; as you said, it should be
however sufficient to get some correct results regarding
perfs/scalability.

> Btw, this is enough to get some results.
>
> Also, I am wondering about this error you got:
> LOG:  could not create IPv6 socket: Address family not supported by protocol
> I am using here only IPv4 protocol.


> --
> Michael Paquier
> http://michael.otacoo.com
>