[Pgpool-general] Problem with pgpool master-slave mode

[Nimesh Satam]

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.