there is no consistency in the errors please help out the kind mismatch keep rotating
2009-07-07 15:11:40 LOG: pid 5494: statement: BEGIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED 2009-07-07 15:11:40 LOG: pid 5494: statement: select * from zeitgist where keywords=E'youtube heeljob shoejob' 2009-07-07 15:11:40 ERROR: pid 5494: read_kind_from_backend: 1 th kind D does not match with master or majority connection kind C 2009-07-07 15:11:40 ERROR: pid 5494: kind mismatch among backends. Possible last query was: "select * from zeitgist where keywords=E'youtube heeljob shoejob'" kind details are: 0[C] 1[D] 2[C] 3[C] 2009-07-07 15:11:40 LOG: pid 5494: do_child: exits with status 1 due to error 2009-07-07 15:13:08 LOG: pid 4151: statement: COMMIT *2009-07-07 15:13:09 LOG: pid 4206: pool_read_message_length2: message length (17) in slot 2 does not match with slot 0(24)* *pg_hba.conf* in all 4 backends # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only host all all 216.129.22.0/24 trust host all all 216.129.22.11 255.255.255.255 trust local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust host all all 0.0.0.0/0 md5 this comes only periodically *2009-07-07 15:13:09 LOG: pid 4206: pool_read_message_length2: message length (17) in slot 2 does not match with slot 0(24)*
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
