[pgpool-general: 5941] Re: PgPool 3.7.2 forwards write statements to Standby

Thomas Delacotte thomas.delacotte at fr.clara.net
Wed Feb 28 01:51:47 JST 2018 

Hi,

I had the exact same problem and found that postgresql apt repository 
only holds the most recent versions of packages. But fortunately, they 
maintain a "morgue" containing previous releases: 
http://atalia.postgresql.org/morgue/p/pgpool2/ (found it through the APT 
postgresql FAQ - really hard to find IMO)

This just saved me last week ;)

Thomas


On 27/02/2018 17:34, Mathias Buresch wrote:
> Damn it.. I cannot even downgrade to the old version because it seems 
> it is no more available in the repository 
> (https://apt.postgresql.org/pub/repos/apt/pool/main/p/pgpool2/)
>
> Is there a reason why only RedHat is available on your site and 
> Ubuntu/Debian packages are provided that worse?
>
> Mit herzlichen Grüßen
>
> Mathias Buresch
> Systems Engineer
> -- 
> mathias.buresch at de.clara.net <mailto:mathias.buresch at de.clara.net>
> Tel: +49 (69) 40 80 18 - 265
> Fax: +49 (69) 40 80 18 - 129
>
> Claranet GmbH
> Hanauer Landstraße 196
> 60314 Frankfurt
>
> Geschäftsführung Olaf Fischer
> Hrb 50381 AG Frankfurt am Main
> Vat-ID de 812918694
>
> http://www.claranet.de
>
>
>
>
>> On 27. Feb 2018, at 16:50, Mathias Buresch 
>> <mathias.buresch at de.clara.net <mailto:mathias.buresch at de.clara.net>> 
>> wrote:
>>
>> Ah ok.. Probably this is only working with building from source?? I 
>> have Ubuntu and working with the Debian packages.
>>
>> Mit herzlichen Grüßen
>>
>> Mathias Buresch
>> Systems Engineer
>> -- 
>> mathias.buresch at de.clara.net <mailto:mathias.buresch at de.clara.net>
>> Tel: +49 (69) 40 80 18 - 265
>> Fax: +49 (69) 40 80 18 - 129
>>
>> Claranet GmbH
>> Hanauer Landstraße 196
>> 60314 Frankfurt
>>
>> Geschäftsführung Olaf Fischer
>> Hrb 50381 AG Frankfurt am Main
>> Vat-ID de 812918694
>>
>> http://www.claranet.de
>>
>>
>>
>>
>>> On 27. Feb 2018, at 16:47, Mathias Buresch 
>>> <mathias.buresch at de.clara.net <mailto:mathias.buresch at de.clara.net>> 
>>> wrote:
>>>
>>> How to install the patch? It is not really working with “patch 
>>> <patchfile>”.
>>>
>>> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=patch;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04
>>> This is the content of the patch file, correct?
>>>
>>> Mit herzlichen Grüßen
>>>
>>> Mathias Buresch
>>> Systems Engineer
>>> -- 
>>> mathias.buresch at de.clara.net <mailto:mathias.buresch at de.clara.net>
>>> Tel: +49 (69) 40 80 18 - 265
>>> Fax: +49 (69) 40 80 18 - 129
>>>
>>> Claranet GmbH
>>> Hanauer Landstraße 196
>>> 60314 Frankfurt
>>>
>>> Geschäftsführung Olaf Fischer
>>> Hrb 50381 AG Frankfurt am Main
>>> Vat-ID de 812918694
>>>
>>> http://www.claranet.de <http://www.claranet.de/>
>>>
>>>
>>>
>>>
>>>> On 27. Feb 2018, at 16:08, Mathias Buresch 
>>>> <mathias.buresch at de.clara.net 
>>>> <mailto:mathias.buresch at de.clara.net>> wrote:
>>>>
>>>> In the moment I am trying to reproduce on another system and if the 
>>>> patch is gonna working. But already the failover did not work when 
>>>> updating only one node. Both postgresql are shown as standby.. none 
>>>> was set to master - this was working before.
>>>> A question to that and just nice to know - do you provide failover 
>>>> and whatever scripts? Because I have script for failover and 
>>>> promote and so on out of other websites because I didnt found any 
>>>> good script.
>>>>
>>>> Mit herzlichen Grüßen
>>>>
>>>> Mathias Buresch
>>>> Systems Engineer
>>>> -- 
>>>> mathias.buresch at de.clara.net <mailto:mathias.buresch at de.clara.net>
>>>> Tel: +49 (69) 40 80 18 - 265
>>>> Fax: +49 (69) 40 80 18 - 129
>>>>
>>>> Claranet GmbH
>>>> Hanauer Landstraße 196
>>>> 60314 Frankfurt
>>>>
>>>> Geschäftsführung Olaf Fischer
>>>> Hrb 50381 AG Frankfurt am Main
>>>> Vat-ID de 812918694
>>>>
>>>> http://www.claranet.de <http://www.claranet.de/>
>>>>
>>>>
>>>>
>>>>
>>>>> On 27. Feb 2018, at 15:20, Tatsuo Ishii <ishii at sraoss.co.jp 
>>>>> <mailto:ishii at sraoss.co.jp>> wrote:
>>>>>
>>>>> No. Only 3.7.2 is affected by [1] since it tried to fix a problem
>>>>> related to "ALWAYS_MASTER" which is new in 3.7.0.
>>>>>
>>>>> Best regards,
>>>>> --
>>>>> Tatsuo Ishii
>>>>> SRA OSS, Inc. Japan
>>>>> English: http://www.sraoss.co.jp/index_en.php
>>>>> Japanese:http://www.sraoss.co.jp
>>>>>
>>>>>> Will 3.6.9 and the other releases also have the same issue then 
>>>>>> or is this just a 3.7.2 problem?
>>>>>>
>>>>>>> On Feb 27, 2018, at 7:45 AM, Tatsuo Ishii <ishii at sraoss.co.jp 
>>>>>>> <mailto:ishii at sraoss.co.jp>> wrote:
>>>>>>>
>>>>>>> Not decided yet. I need to find a way to solve the original problem
>>>>>>> which was supposed to be solved by [1].
>>>>>>>
>>>>>>> Best regards,
>>>>>>> --
>>>>>>> Tatsuo Ishii
>>>>>>> SRA OSS, Inc. Japan
>>>>>>> English: http://www.sraoss.co.jp/index_en.php
>>>>>>> Japanese:http://www.sraoss.co.jp
>>>>>>>
>>>>>>>> Target date for 3.7.3?
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>> On Feb 27, 2018, at 7:26 AM, Tatsuo Ishii <ishii at sraoss.co.jp 
>>>>>>>>> <mailto:ishii at sraoss.co.jp>> wrote:
>>>>>>>>>
>>>>>>>>> Today I have just found a serious regression in 3.7.2: it does not
>>>>>>>>> work if the primary is other than node 0, sending write queries to
>>>>>>>>> node 0, which is the standby (In my testing, 3.7.2 does work 
>>>>>>>>> if the
>>>>>>>>> primary is node 0). I guess your primary is not node 0, right?
>>>>>>>>>
>>>>>>>>> The cause was this commit [1]:
>>>>>>>>> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=36517db60a829422d382debb7aa3256fac5da26d
>>>>>>>>>
>>>>>>>>> So I today reverted the commit [2]:
>>>>>>>>> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04
>>>>>>>>>
>>>>>>>>> Until 3.7.3 is released, you could:
>>>>>>>>>
>>>>>>>>> 1) Let node 0 to be the primary
>>>>>>>>>
>>>>>>>>> 2) down grade to 3.7.1
>>>>>>>>>
>>>>>>>>> 3) Apply the patch [2] to 3.7.2.
>>>>>>>>>
>>>>>>>>> Sorry for the inconvenience.
>>>>>>>>> --
>>>>>>>>> Tatsuo Ishii
>>>>>>>>> SRA OSS, Inc. Japan
>>>>>>>>> English: http://www.sraoss.co.jp/index_en.php
>>>>>>>>> Japanese:http://www.sraoss.co.jp
>>>>>>>>>
>>>>>>>>>> Hello,
>>>>>>>>>>
>>>>>>>>>> after updating the PgPool from 3.6.8 to 3.7.2 is is not 
>>>>>>>>>> working anymore.
>>>>>>>>>> The “show pool_nodes” is showing the primary and standby 
>>>>>>>>>> correctly but it sends “Update” and “Select update” and 
>>>>>>>>>> others to standby. The workaround now is that we have 
>>>>>>>>>> disabled the standby-Postgresql.
>>>>>>>>>>
>>>>>>>>>> Probably we will downgrade to the old version and check again.
>>>>>>>>>> In parallel I try to find out what the Release Notes are 
>>>>>>>>>> telling about that. Maybe you can tell me how I can debug and 
>>>>>>>>>> find out what is happening there??
>>>>>>>>>>
>>>>>>>>>> Mit herzlichen Grüßen
>>>>>>>>>>
>>>>>>>>>> Mathias Buresch
>>>>>>>>>> Systems Engineer
>>>>>>>>>> -- 
>>>>>>>>>> mathias.buresch at de.clara.net
>>>>>>>>>> Tel: +49 (69) 40 80 18 - 265
>>>>>>>>>> Fax: +49 (69) 40 80 18 - 129
>>>>>>>>>>
>>>>>>>>>> Claranet GmbH
>>>>>>>>>> Hanauer Landstraße 196
>>>>>>>>>> 60314 Frankfurt
>>>>>>>>>>
>>>>>>>>>> Geschäftsführung Olaf Fischer
>>>>>>>>>> Hrb 50381 AG Frankfurt am Main
>>>>>>>>>> Vat-ID de 812918694
>>>>>>>>>>
>>>>>>>>>> http://www.claranet.de
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> 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 <mailto:pgpool-general at pgpool.net>
>>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>>
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net <mailto: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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180227/0727f4fc/attachment-0001.html>

More information about the pgpool-general mailing list