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

Wed Feb 28 08:28:25 JST 2018

Geat. I added this to the Pgpool-II FAQ:

https://pgpool.net/mediawiki/index.php/FAQ#Where_can_I_get_Debian_packages_for_Pgpool-II.3F

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

> 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
> 