[pgpool-general: 2585] Re: pgpool with JDBC for load balancing

[Anupama Ramaswamy]

I did as you suggested. But no every update to the database fails with

"unnamed prepared statement does not exist"
Here is my setup.
I have host db1 running postgresql 9.1 (master)
host db2 running postgresql 9.1 (slave)
Postgres Streaming replication is setup between the 2 servers
Pgpool is running on a separate host pgp3 with 
load_balance_mode = on
master_slave_mode = on
master_slave_sub_mode = 'stream'
replication_mode = off
connection_cache=off

I have tried with 3.1.10, 3.2.7 and 3.3.2 all with same result.

I have attached my pgpool.conf and the debug logs I get for 3.1.10 and 3.3.2

Can you please help ?

Is there a minimal working java application (may be a test case ?) I can get that can demonstrate that pgpool works with jdbc drivers / load balancing and postgres streaming replication ?

Thanks for your help.




On Thursday, February 13, 2014 10:36 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:
 
Recently a bug which might be related to your report was found:

http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=35437fa5eada74e181a7940b4917ea6560a75ade

Please grab 3.3-stable head and try again.

http://git.postgresql.org/gitweb/?p=pgpool2.git;a=snapshot;h=8c065048a32fbcde04735add9db400b01d3d8710;sf=tgz

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


> Hello,
> 
> I have to setup pgpool for load balancing only and it has to work with an web application in Java.
> There are several posts on the net as well as mailing lists regarding the problems with this setup, yet nothing conclusive. All that I have tried so far has only led me to 
> 
> "unnamed prepared statement does not exist"
> 
> So my question is -
> 1) Is there a checklist of things that I need to do to get pgpool load balancing to work with simple JDBC connection with Postgres 9.1 in stream replication / hotstandby mode. 
> 2) Is there a anything test case or something that can demonstrate that pgpool indeed works with JDBC in load balancing mode.
> 
> I don't need any other capability of pgpool - no connection pool, replication, parallel query, nothing at all.
> 
> Regards,
> Anupama.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140216/f3d003f8/attachment-0001.html>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: pgpool-3.1.10-logs.txt
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140216/f3d003f8/attachment-0003.txt>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: pgpool-3.3.2-logs.txt
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140216/f3d003f8/attachment-0004.txt>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: pgpool-conf.txt
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140216/f3d003f8/attachment-0005.txt>