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

[Chris Pacejo]

Ya, I just hit this bug.  It happens when the lowest-numbered active
backend is not the master.  Check out pool_read_kind() in
auth/pool_auth.c; the logic in that case is totally broken.

On Mon, Feb 22, 2016 at 2:29 PM, Ziyun Audrey Wang
<ziyun.wang at ericsson.com> wrote:
> Hi,
>
> When we have the problem happening, there was no problem with the configuration. The restart the pgpool process could fix the issue. But we keep getting the error.
>
> We had communicated this issue in Nov. 2015, and we had sent the logs as requested.
>
> Audrey
>
>
> -----Original Message-----
> From: Muhammad Usama [mailto:m.usama at gmail.com]
> Sent: February-22-16 1:58 PM
> To: Ziyun Audrey Wang
> Cc: Tatsuo Ishii; Lisa Amos; Nabil Khoury; pgpool-general at pgpool.net
> Subject: Re: [pgpool-general: 4480] Re: kind does not match between master(0) slot[0] (52)
>
> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general