Caused by: org.postgresql.util.PSQLException: ERROR: prepared
statement "S_18" does not exist
I guess this problem is a known bug which was fixed in 3.1.
- Fix bug which cannot use the cursors of JDBC driver on standby
node. The transaction commands come to be sent to all nodes by
this fix in master/slave mode(Kitagawa)
Does the error occur in 3.1?
Yes, it does occur in 3.1 -- that's the version I'm currently evaluating
/ testing.
If the error is caused by the bug, it should be solved by
setting load_balance_mode to off.
One of the main drivers for us to use pgpool is to distribute the load
for read transactions across our database nodes. If I turn off
load_balance, doesn't pgpool stop sending selects to standby nodes?
Regards,
-Bryan
_______________________________________________
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general