Re: [Pgpool-general] Order of Query Results

2010-08-06 Thread Sean Brown
On Thursday, August 05, 2010 06:26:46 pm Tatsuo Ishii wrote: Seems like pgpool issue. What I am wondering is this line: 2010-08-02 13:56:21 DEBUG: pid 19720: AsciiRow: len: 1 data: t This suggests that your DB application uses very old PostgreSQL protocol(call version 2 protocol),

Re: [Pgpool-general] Order of Query Results

2010-08-05 Thread Sean Brown
On Wednesday, August 04, 2010 07:43:40 pm Tatsuo Ishii wrote: Ok I have some more information. The cluster fell apart again yesterday. Again, there was nothing out of the ordinary in the postgresql logs leading upto the nodes falling out but this was logged in the pgpool log First node

Re: [Pgpool-general] Order of Query Results

2010-08-05 Thread Tatsuo Ishii
Seems like pgpool issue. What I am wondering is this line: 2010-08-02 13:56:21 DEBUG: pid 19720: AsciiRow: len: 1 data: t This suggests that your DB application uses very old PostgreSQL protocol(call version 2 protocol), implemented in PostgreSQL 7.3 or before. But you said your

Re: [Pgpool-general] Order of Query Results

2010-08-04 Thread Tatsuo Ishii
Ok I have some more information. The cluster fell apart again yesterday. Again, there was nothing out of the ordinary in the postgresql logs leading upto the nodes falling out but this was logged in the pgpool log First node fell out at 10:36am: 2010-08-02 10:36:47 DEBUG: pid 16699:

Re: [Pgpool-general] Order of Query Results

2010-08-03 Thread Sean Brown
On Wednesday, July 28, 2010 07:08:42 pm you wrote: Le 28/07/2010 17:16, Sean Brown a écrit : On Wednesday, July 28, 2010 10:56:27 am you wrote: Le 28/07/2010 16:50, Sean Brown a écrit : Does PgPool have an issue with the order of results from a query being returned in a different

Re: [Pgpool-general] Order of Query Results

2010-07-29 Thread Sean Brown
-Original Message- From: Tatsuo Ishii [mailto:is...@sraoss.co.jp] Sent: Wed 7/28/2010 7:08 PM To: guilla...@lelarge.info Cc: Sean Brown; pgpool-general@pgfoundry.org Subject: Re: [Pgpool-general] Order of Query Results Le 28/07/2010 17:16, Sean Brown a écrit : On Wednesday, July 28

Re: [Pgpool-general] Order of Query Results

2010-07-28 Thread Guillaume Lelarge
Le 28/07/2010 16:50, Sean Brown a écrit : Does PgPool have an issue with the order of results from a query being returned in a different order? With the ongoing issue of our cluster falling out, we just had one member fall out again and again, no error in PostgreSQLs log is recorded.

Re: [Pgpool-general] Order of Query Results

2010-07-28 Thread Guillaume Lelarge
Le 28/07/2010 17:16, Sean Brown a écrit : On Wednesday, July 28, 2010 10:56:27 am you wrote: Le 28/07/2010 16:50, Sean Brown a écrit : Does PgPool have an issue with the order of results from a query being returned in a different order? With the ongoing issue of our cluster falling out, we

Re: [Pgpool-general] Order of Query Results

2010-07-28 Thread Sean Brown
On Wednesday, July 28, 2010 10:56:27 am Guillaume Lelarge wrote: Le 28/07/2010 16:50, Sean Brown a écrit : Does PgPool have an issue with the order of results from a query being returned in a different order? With the ongoing issue of our cluster falling out, we just had one member

Re: [Pgpool-general] Order of Query Results

2010-07-28 Thread Tatsuo Ishii
Le 28/07/2010 17:16, Sean Brown a écrit : On Wednesday, July 28, 2010 10:56:27 am you wrote: Le 28/07/2010 16:50, Sean Brown a écrit : Does PgPool have an issue with the order of results from a query being returned in a different order? With the ongoing issue of our cluster falling