[Pgpool-general] Pgpool probelms
Tatsuo Ishii
ishii at sraoss.co.jp
Wed Jun 17 06:45:03 UTC 2009
If you are getting this with pgpool-II 2.2.2, please send a
self-contained test case if possible.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
> 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.
More information about the Pgpool-general
mailing list