this keeps changing and causing errors The connection kind keeps changing how do we detect this - this is causing a major problem - how do we debug this
has any one encountered this behavior in pgpool-II parallel mode thanks 2009-07-07 14:28:23 LOG: pid 5582: statement: select * from zeitgist where keywords=E'megan foxx tattoos' 2009-07-07 14:28:23 ERROR: pid 5582: read_kind_from_backend: 3 th kind D does not match with master or majority connection kind C 2009-07-07 14:28:23 ERROR: pid 5582: kind mismatch among backends. Possible last query was: "select * from zeitgist where keywords=E'megan foxx tattoos'" kind details are: 0[C] 1[C] 2[C] 3[D] 2009-07-07 14:28:23 LOG: pid 5582: do_child: exits with status 1 due to error ot match with master or majority connection kind C 2009-07-07 14:35:46 ERROR: pid 19440: kind mismatch among backends. Possible last query was: "select * from zeitgist where keywords=E'hrvatski porno'" kind details are: 0[C] 1[C] 2[C] 3[D] 2009-07-07 14:35:46 LOG: pid 19440: do_child: exits with status 1 due to error 2009-07-07 14:29:27 LOG: pid 4859: statement: select * from zeitgist where keywords=E'niñas follando de edad 13' 2009-07-07 14:29:27 ERROR: pid 4859: read_kind_from_backend: 2 th kind D does not match with master or majority connection kind C 2009-07-07 14:29:27 ERROR: pid 4859: kind mismatch among backends. Possible last query was: "select * from zeitgist where keywords=E'niñas follando de edad 13'" kind details are: 0[C] 1[C] 2[D] 3[C] 2009-07-07 14:29:27 LOG: pid 4859: do_child: exits with status 1 due to error 2009-07-07 14:34:38 LOG: pid 19436: do_child: exits with status 1 due to error 2009-07-07 14:34:46 LOG: pid 19448: pool_read_message_length2: message length (17) in slot 2 does not match with slot 0(24) 2009-07-07 14:34:46 LOG: pid 19448: statement: SET DATESTYLE TO 'ISO' 2009-07-07 14:34:46 LOG: pid 19448: statement: SHOW client_encoding 2009-07-07 14:34:46 LOG: pid 19448: statement: SHOW default_transaction_isolation 2009-07-07 14:34:46 LOG: pid 19448: statement: BEGIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED 2009-07-07 14:34:46 LOG: pid 19448: statement: select * from zeitgist order by count desc limit 10 2009-07-07 14:34:46 ERROR: pid 19448: read_kind_from_backend: 2 th kind C does not match with master or majority connection kind D 2009-07-07 14:34:46 ERROR: pid 19448: kind mismatch among backends. Possible last query was: "select * from zeitgist order by count desc limit 10" kind details are: 0[D] 1[D] 2[C] 3[D] 2009-07-07 14:34:46 LOG: pid 19448: do_child: exits with status 1 due to error -- Bidegg worlds best auction site http://bidegg.com
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
