[Pgpool-general] pgpool segfault

[Giordano Rinaldi]

Hi Tatsuo,

I prepared a test case:

1. Sql script to create the tables:
http://dl.dropbox.com/u/316988/pgpool2/script.ddl
2. Property file
http://dl.dropbox.com/u/316988/pgpool2/stresstest.properties (here you
define jdbc url string + usr/pwd)
3. Jar file: http://dl.dropbox.com/u/316988/pgpool2/JDBCStressTest.jar

To run the test case:


        java -jar JDBCStressTest.jar stresstest.properties


Our test needs postgis framework, if you want we can remove it from the
test case.

The java source file are here:
http://dl.dropbox.com/u/316988/pgpool2/StressTest_src.zip

Many thanks.

Giordano

On mar, 2011-04-12 at 18:47 +0900, Tatsuo Ishii wrote:

> > we are using the last version of pgpool2 ( 3.0.3) with two postgres,
> > (version 8.4) in replication_mode and load_balance_mode, to insert or to
> > query  we use java application with the last jdbc driver (9.0).
> > 
> > The problem raises randomly when the insert statements contains a field
> > of date type: the pgpool2 procecess crashes. We tried to insert the
> > value of date field using the current_date or now functions, to insert a
> > fixed date but after some inserts the pgpool2 process crashes. If we
> > remove from the insert the date field we have no problem (in this case
> > the date will be filled by a trigger).
> > 
> > Is there some limitation about the date field? If you want I can give
> > further informations to isolate this problem.
> 
> There should be no limitation. Please give me detailed info to
> reproduce the problem. A minimum test case is the best if possible.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110413/ef357e27/attachment.html>