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

[Michael P. <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.
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