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

Reply via email to