Hi,
We have setup pgpool 2 in master-slave mode (Postgres version 8.3.3, pgpool-II-2.1). We are also using the load balance mode of pgpool to balance the query. But when the Java application is trying to insert data the query fails and the error we get in the db log files is like “2009-03-07 15:02:50 PST [10711]: [33796-1] ERROR: prepared statement "S_5" already exists” What we get in the debug output of pgpool is as follows: 2009-03-07 15:02:50 ERROR: pid 4048: pool_process_query: 1 th kind E does not match with master connection kind 1 2009-03-07 15:02:50 LOG: pid 4048: do_child: exits with status 1 due to error All the queries are then failing giving the below errors: “: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.” This come s through the java exception logs. Can anybody highlight what’s going wrong here and what can be done to rectify it? Regards, Nimesh. _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
