[Pgpool-general] Order of Query Results

[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. PgPool reports 
> the possible last query was:
> select * from carts where cart_id in (11835,11824,11819)
> 
> Specifically the error in PgPools log is:
> read_kind_from_backend: 1 th kind D does not match with master or majority 
> connection kind ^@
> 2010-07-28 10:21:23 ERROR: pid 28242: kind mismatch among backends. Possible 
> last query was: "select * from carts where cart_id in (11835,11824,11819)" 
> kind details are: 1[D]
> 
> If I run that query on the remaining node and on the one that just fell out, I 
> get the same 3 results, but the orders of the records are different.
> 

The query you show doesn't ask for a specific order (no "ORDER BY"
clause), so each backend can send the data in whatever order they "prefer".


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com