[Pgpool-general] Order of Query Results

[Sean Brown]

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 only other logs that look like errors are this in PgPool's log:
2010-07-28 10:21:23 LOG:   pid 28242: statement:  DISCARD ALL
2010-07-28 10:21:23 LOG:   pid 28242: pool_process_query: garbage data from 
frontend after receiving terminate message ignored