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
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
