[Pgpool-general] the kind mismatch keep rotating
mobiledreamers at gmail.com
mobiledreamers at gmail.com
Tue Jul 7 22:13:46 UTC 2009
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)*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090707/d30d6cb6/attachment.html>
More information about the Pgpool-general
mailing list