[pgpool-general: 4481] Re: kind does not match between master(0) slot[0] (52)

[Muhammad Usama]

Hi

The most probable cause of this error is the difference in PostgreSQL
backend node configurations. More specifically check the pg_hba.conf
entries of all PostgreSQL nodes and the client_min_message
configuration value of all PostgreSQL backend nodes must be same.

Thanks
Best regards
Muhammad Usama



On Mon, Feb 22, 2016 at 9:21 PM, Ziyun Audrey Wang
<ziyun.wang at ericsson.com> wrote:
> Hello
>
> It's being a while we didn't hear from you since we have sent out the log files you have requested.
>
> I am wondering what the status of this issue is.
>
> By checking the
> http://www.pgpool.net/mantisbt/view.php?id=126
>
> It seems still in assigned status.
>
> We have experienced this issue again in our LAB, we would like to know if you will have any fix soon in which release.
>
> Thanks a lot!
>
> Best Regards
>
> Audrey
>
>
>
>
> -----Original Message-----
> From: Ziyun Audrey Wang
> Sent: November-13-15 1:13 PM
> To: Tatsuo Ishii
> Cc: pgpool-general at pgpool.net; Nabil Khoury
> Subject: RE: [pgpool-general: 4191] kind does not match between master(0) slot[0] (52)
>
> File 5
>
> -----Original Message-----
> From: Ziyun Audrey Wang
> Sent: November-13-15 1:12 PM
> To: 'Tatsuo Ishii'
> Cc: 'pgpool-general at pgpool.net'; Nabil Khoury
> Subject: RE: [pgpool-general: 4191] kind does not match between master(0) slot[0] (52)
>
> File 4
>
> -----Original Message-----
> From: Ziyun Audrey Wang
> Sent: November-13-15 1:11 PM
> To: 'Tatsuo Ishii'
> Cc: 'pgpool-general at pgpool.net'; Nabil Khoury
> Subject: RE: [pgpool-general: 4191] kind does not match between master(0) slot[0] (52)
>
> Here is file 3
>
> -----Original Message-----
> From: Ziyun Audrey Wang
> Sent: November-13-15 1:11 PM
> To: 'Tatsuo Ishii'
> Cc: 'pgpool-general at pgpool.net'; Nabil Khoury
> Subject: RE: [pgpool-general: 4191] kind does not match between master(0) slot[0] (52)
>
> Here is file 2
>
> -----Original Message-----
> From: Ziyun Audrey Wang
> Sent: November-13-15 1:10 PM
> To: 'Tatsuo Ishii'
> Cc: 'pgpool-general at pgpool.net'; Nabil Khoury
> Subject: RE: [pgpool-general: 4191] kind does not match between master(0) slot[0] (52)
>
> Hello
>
> I am resending the log files. there are 5 files in 5 emails.
> Please let us know if you get them all.
>
> Here is the first one
>
> Thanks
> Audrey
>
>
> -----Original Message-----
> From: Ziyun Audrey Wang
> Sent: November-13-15 11:57 AM
> To: 'Tatsuo Ishii'
> Cc: pgpool-general at pgpool.net; Nabil Khoury
> Subject: RE: [pgpool-general: 4191] kind does not match between master(0) slot[0] (52)
>
> The file size is too big, I will split it into serveral small files.
>
> Audrey
>
> -----Original Message-----
> From: Tatsuo Ishii [mailto:ishii at postgresql.org]
> Sent: November-12-15 7:02 PM
> To: Ziyun Audrey Wang
> Cc: pgpool-general at pgpool.net; Nabil Khoury
> Subject: Re: [pgpool-general: 4191] kind does not match between master(0) slot[0] (52)
>
> I only find complains from Microsoft?
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
>> Hi,
>>
>> Please find attached log file
>>
>> Thanks!
>>
>> Audrey
>>
>> -----Original Message-----
>> From: Tatsuo Ishii [mailto:ishii at postgresql.org]
>> Sent: November-12-15 6:08 PM
>> To: Ziyun Audrey Wang
>> Cc: pgpool-general at pgpool.net; Nabil Khoury
>> Subject: Re: [pgpool-general: 4191] kind does not match between master(0) slot[0] (52)
>>
>>> Hi,
>>>
>>> Here is the info
>>>
>>> - OS: redhat 6.6
>>> - pgppool.conf (please see attached file)
>>> - stop the master db, the failover will trigger
>>
>> Can you please provide the pgpool log when you stop the master db?
>>
>>> Thanks a lot!
>>>
>>> Best Regards
>>> Audrey
>>>
>>>
>>> -----Original Message-----
>>> From: Tatsuo Ishii [mailto:ishii at postgresql.org]
>>> Sent: November-12-15 5:30 PM
>>> To: Ziyun Audrey Wang
>>> Cc: pgpool-general at pgpool.net; Nabil Khoury
>>> Subject: Re: [pgpool-general: 4191] kind does not match between master(0) slot[0] (52)
>>>
>>> Please share with us:
>>>
>>> - the OS
>>> - pgpool.conf
>>> - step to reproduce the prolem.
>>>
>>> Best regards,
>>> --
>>> Tatsuo Ishii
>>> SRA OSS, Inc. Japan
>>> English: http://www.sraoss.co.jp/index_en.php
>>> Japanese:http://www.sraoss.co.jp
>>>
>>>> Hi,
>>>>
>>>> Yes,
>>>>
>>>> We did re-produce the problem.
>>>>
>>>> Audrey
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: Tatsuo Ishii [mailto:ishii at postgresql.org]
>>>> Sent: November-12-15 4:46 PM
>>>> To: Ziyun Audrey Wang
>>>> Cc: pgpool-general at pgpool.net; Nabil Khoury
>>>> Subject: Re: [pgpool-general: 4191] kind does not match between master(0) slot[0] (52)
>>>>
>>>>> Hello
>>>>>
>>>>> We have
>>>>> # pgpool -version
>>>>>  pgpool-II version 3.4.2 (tataraboshi)
>>>>>
>>>>> we have pgpool with 4 DBs, one master and 3 slaves. When perform the failover testing, we got the following in our pgpool log:
>>>>>
>>>>> 2015-11-12 10:57:20: pid 6404: ERROR:  unable to read message kind
>>>>> 2015-11-12 10:57:20: pid 6404: DETAIL:  kind does not match between
>>>>> master(0) slot[0] (52)
>>>>>
>>>>> We searched bug tracker, see similar reported issue:
>>>>> http://www.pgpool.net/mantisbt/view.php?id=126
>>>>>
>>>>> We are wondering if you have any updates to this issue. In which release will have this fix?
>>>>
>>>> The report said he failed to reproduce the problem. Have you succeeded in finidng how to reproduce your problem?
>>>>
>>>> Best regards,
>>>> --
>>>> Tatsuo Ishii
>>>> SRA OSS, Inc. Japan
>>>> English: http://www.sraoss.co.jp/index_en.php
>>>> Japanese:http://www.sraoss.co.jp
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general