[Pgpool-general] Pgpool probelms

[Nimesh Satam]

Hi,

We are using pgpool-II in Master-slave, Loadbalance mode and are facing
issues with the same. Can anybody lets us know what's going wrong here?

1) We are getting many entries in the database logs with following errors:
2009-06-16 21:42:47 PDT [11040]: [2486-1] ERROR:  prepared statement "S_2"
already exists
2009-06-16 21:43:04 PDT [11040]: [2535-1] ERROR:  prepared statement "S_3"
already exists
2009-06-16 21:43:48 PDT [11040]: [2546-1] ERROR:  prepared statement "S_4"
already exists
2009-06-16 21:43:49 PDT [11040]: [2564-1] ERROR:  prepared statement "S_5"
already exists
2009-06-16 21:44:49 PDT [11040]: [2576-1] ERROR:  prepared statement "S_6"
already exists

This causes the application to fail. {This was supposed to be fixed in 2.2.1
and later versions?}

2) We are seeing stuck queries when connecting through pgpool. ps U postgres
shows all the queries in bind state:
 5003 ?        Ss     0:52 postgres: ck rpro xxx.xx.xx.xx(52218) BIND
 5004 ?        Ss     0:28 postgres: ck rpro xxx.xx.xx.xx(52220) BIND
18961 ?        Ss     0:54 postgres: ck rpro xxx.xx.xx.xx(34508) BIND
18962 ?        Ss     0:39 postgres: ck rpro xxx.xx.xx.xx(34510) BIND

This queries are not performing any activity and seem to have hanged.

Both applications in question are Java applications and we are using the
postgres version 8.3.3

Any help here would be much appreciated.

Regards,
Nimesh.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090617/cdc3eabb/attachment.html>