Re: [Pgpool-general] Error in pgpool

2009-04-03 Thread Tatsuo Ishii
...@yahoo.co.uk Subject: Re: [Pgpool-general] Error in pgpool To: nimesh.sa...@gmail.com, Tatsuo Ishii is...@sraoss.co.jp Cc: pgpool-general@pgfoundry.org Date: Thursday, 26 March, 2009, 5:01 PM Hi Tatsuo, I'm using pgpool 2.2 in connection pool mode, and I see a similar problem

Re: [Pgpool-general] Error in pgpool

2009-04-03 Thread Glyn Astill
, Tatsuo Ishii is...@sraoss.co.jp wrote: From: Tatsuo Ishii is...@sraoss.co.jp Subject: Re: [Pgpool-general] Error in pgpool To: glynast...@yahoo.co.uk, nimesh.sa...@gmail.com, pgpool-general@pgfoundry.org Date: Friday, 3 April, 2009, 11:39 AM I have looked into this and found

Re: [Pgpool-general] Error in pgpool

2009-04-03 Thread Tatsuo Ishii
: From: Tatsuo Ishii is...@sraoss.co.jp Subject: Re: [Pgpool-general] Error in pgpool To: glynast...@yahoo.co.uk, nimesh.sa...@gmail.com, pgpool-general@pgfoundry.org Date: Friday, 3 April, 2009, 11:39 AM I have looked into this and found that it was actually caused by a bug

Re: [Pgpool-general] Error in pgpool

2009-04-03 Thread Glyn Astill
--- On Fri, 3/4/09, Tatsuo Ishii is...@sraoss.co.jp wrote: I'm trying to patch against the pgpool-II-2.2 source, either I'm either too much of a cretin to apply it or pool_proto_modules.c has other changes? The patch was against CVS HEAD. Could you try included new patch? It was

Re: [Pgpool-general] Error in pgpool

2009-03-29 Thread Tatsuo Ishii
--- On Thu, 26/3/09, Glyn Astill glynast...@yahoo.co.uk wrote: From: Glyn Astill glynast...@yahoo.co.uk Subject: Re: [Pgpool-general] Error in pgpool To: nimesh.sa...@gmail.com, Tatsuo Ishii is...@sraoss.co.jp Cc: pgpool-general@pgfoundry.org Date: Thursday, 26 March, 2009, 5:01 PM

Re: [Pgpool-general] Error in pgpool

2009-03-27 Thread Glyn Astill
connecting afterwards would use 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT' ? --- On Thu, 26/3/09, Glyn Astill glynast...@yahoo.co.uk wrote: From: Glyn Astill glynast...@yahoo.co.uk Subject: Re: [Pgpool-general] Error in pgpool To: nimesh.sa...@gmail.com, Tatsuo Ishii is...@sraoss.co.jp

Re: [Pgpool-general] Error in pgpool

2009-03-26 Thread Glyn Astill
not exist 2009-03-26 16:51:03 GMT [12164]: [2-1]: [user=rutrupe]: [host=192.168.1.98]: [db=SEE]:: STATEMENT: DEALLOCATE find_eq_f1_byindx_0_1 Any ideas? Thanks Glyn --- On Tue, 24/3/09, Tatsuo Ishii is...@sraoss.co.jp wrote: From: Tatsuo Ishii is...@sraoss.co.jp Subject: Re: [Pgpool-general

Re: [Pgpool-general] Error in pgpool

2009-03-24 Thread Nimesh Satam
Tatsuo, Here are the db and pgpool logs at the time of failure. (Pgpool finds the prepared statement S-4 on one server but fails to find one on the other server. As a result pgpool exits the child with Kind mis-match error) Let us know if this helps or you need further information. Db log on

Re: [Pgpool-general] Error in pgpool

2009-03-24 Thread Tatsuo Ishii
Thanks but I'm looking for the PostgreSQL *when* and *how* the prepared statement (in this case S_4) was created. Probably that can be found a little bit earlier in the PostgreSQL log. -- Tatsuo Ishii SRA OSS, Inc. Japan Tatsuo, Here are the db and pgpool logs at the time of failure. (Pgpool

Re: [Pgpool-general] Error in pgpool

2009-03-23 Thread Tatsuo Ishii
All We are facing problem with pgpool where the java application fails in certain situation I/o problem. When we see these problem we see in the db logs error statement like: ERROR: prepared statement S_3 does not exist. LOG: unexpected EOF on client connection We get the