[Pgpool-general] Prepared statement does not exist

Nimesh Satam nimesh.satam at gmail.com
Tue Mar 17 07:46:04 UTC 2009


Hi,

We are using pgpool-II version 2.2 and postgres 8.3.3.

Can any body let us know why we get the following notes in the
database logs when we use pgpool.

u=postgres h=xx01.xxxx.xxxx.com ERROR:  prepared statement "S_2" already exists
u=postgres h=xx01.xxxx.xxxx.com ERROR:  prepared statement "S_3" does not exist
u=postgres h=xx01.xxxx.xxxx.com ERROR:  prepared statement "S_1" does not exist
u=postgres h=xx01.xxxx.xxxx.com ERROR:  prepared statement "S_4" does not exist

We dont see the below errors if we directly connect to the database.
Pgpool is used for load-balancing whiel slony is used for replication.
We see many such logs coming continuously. Can any body tell what can
be done to avoid them and what its impact is?

Regards,
Nimesh.


More information about the Pgpool-general mailing list