[pgpool-general: 3192] Re: "kind does not match" after failover

[Tatsuo Ishii]

Sorry for the inconvenience. It seems someone forgot to put the
package for pgpool-II 3.3.4+PostgreSQL 9.2. I will take care of it as
soon as possible.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> We had a similar issue with a 2 node pgpool cluster today. I'd like to upgrade to pgpool 3.3.4, but there are no packages built for Postgresql 9.2. Is this something that could be built and put on the site?
> 
> On 09/23/2014 08:38 PM, Tatsuo Ishii wrote:
>> Can you try 3.3.4? It fixed similar issue.
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>
>> > Hi
>> >
>> > We are using pgpool-II 3.3.3 with 4 nodes of Postgres 9.3.
>> > At some point today 2 of the 4 nodes had errors and pgpool did a successful
>> > failover.
>> > When the 3rd node had errors pgpool also reported a successful failover but
>> > clients could not create connections. For a few hours the pgpool log
>> > contained such messages:
>> >
>> > 2014-09-23 03:03:15 ERROR: pid 13408: pool_read_kind: kind does not match
>> > between master(0) slot[0] (52)
>> >
>> > And at the same time the last db node had those messages:
>> >
>> > db_here 2014-09-23 03:15:47 PDT [22250][user_here]: [1-1] LOG:  could not
>> > receive data from client: Connection reset by peer
>> >
>> > Any idea what can cause this behavior?
>> >
>> > Thanks,
>> > Yaron
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
> 
> -- 
> Ryan DeShone
>