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

[Mike Koepke]

Target date for 3.7.3?



> On Feb 27, 2018, at 7:26 AM, Tatsuo Ishii <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