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