[pgpool-general: 6028] Re: Fwd: INSERT statements sent to standby

[Tatsuo Ishii]

Thank you for confirimng it!
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

>  Issue solved with latest source (https://git.postgresql.org/
> gitweb/?p=pgpool2.git;a=snapshot;h=af4ea10d139a7471ee912140e5f44a
> 0d085bee44;sf=tgz)
> 
> Thanks for your work !
> 
> 2018-04-05 10:56 GMT+02:00 Tatsuo Ishii <ishii at sraoss.co.jp>:
> 
>> [Cc:ed to the list]
>>
>> > Hi guys thank you
>> >
>> > I confirm that downgrading to 3.7.1 solved the issue.
>> > I don't use the rpm, I download source from here :
>> > https://pgpool.net/mediawiki/index.php/Downloads
>> > I don't know how to fetch latest source, is it from the github repo ?
>>
>> We use standard PostgreSQL hosted git repository.
>> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=summary
>> You can do git clone it from the URLs on the page.
>>
>> You could fetch the source from github but since it's a mirro, up to 1
>> day delay is possible.
>>
>> BTW, I just commit/push the fix to the 3.7 stable tree:
>> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=
>> af4ea10d139a7471ee912140e5f44a0d085bee44
>>
>> So the latest Pgpool-II 3.7 source should have solved the issue you had.
>>
>> You can download a snapshot from following URL if you prefere to do it.
>> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=snapshot;h=
>> af4ea10d139a7471ee912140e5f44a0d085bee44;sf=tgz
>>
>> (that is the link shown
>> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=
>> shortlog;h=refs/heads/V3_7_STABLE
>> at the top line and the very right hand side link "snapshot".)
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>
>> > Cheers
>> >
>> > 2018-04-05 0:58 GMT+02:00 Tatsuo Ishii <ishii at sraoss.co.jp>:
>> >
>> >> > There is a bug on 3.7.2 related with that issue. The core team is
>> >> working on this. Could you try to downgrade your version with 3.7.1?
>> >>
>> >> Or upgrade the RPM if you are using the official RPM. The latest 3.7.2
>> RPM
>> >> includes the fix.
>> >>
>> >> Best regards,
>> >> --
>> >> Tatsuo Ishii
>> >> SRA OSS, Inc. Japan
>> >> English: http://www.sraoss.co.jp/index_en.php
>> >> Japanese:http://www.sraoss.co.jp
>> >>
>>