[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