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 _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general