[pgpool-general: 8827] Re: queries not redirecting to primary when "delay_threshold_by_time" is exceeded

[Tatsuo Ishii]

>> On Tue, Jun 6, 2023 at 12:40 AM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>>>
>>> > On Mon, Jun 5, 2023 at 9:11 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>>> >>
>>> >> > On Mon, Jun 5, 2023 at 6:05 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>>> >> >>
>>> >> >> >> > I will look into this.
>>> >> >> >>
>>> >> >> >> It turned out that delay_treshold_by_time is broken since it was introduced.
>>> >> >> >> I have fixed it and pushed to the git repository.
>>> >> >> >> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=6aebf24aa9a627f4c852e44f6407f17a34d50528
>>> >> >> >>
>>> >> >> >> Unfortunately there's no workaround of this for now. Please use
>>> >> >> >> delay_treshold instead if you like.
>>> >> >> >
>>> >> >> > Thanks for looking into this.
>>> >> >> > This is really impacting us a lot - Is it possible to have a 4.4.4
>>> >> >> > release with this fix?
>>> >> >>
>>> >> >> Yes, 4.4.4 will have the fix.
>>> >> >>
>>> >> >> > According to the site, next release is slated for August 17th, 2023
>>> >> >> > (more than two months away)
>>> >> >>
>>> >> >> Yes, that's our plan.
>>> >> >>
>>> >> >
>>> >> > What I meant to ask is - Is it possible to have a release sooner than that date?
>>> >>
>>> >> How do you install pgpool? If you can build pgpool from the source
>>> >> code, you could deploy pgpool with the fix today.
>>> >>
>>> >
>>> > We use official RPM packages from
>>> > https://www.pgpool.net/mediawiki/index.php/Yum_Repository
>>> > We have many customer installs of pgpool and, in most cases, packages
>>> > are updated as part of the change control process customers have.
>>> >
>>> > I do understand that releasing minor versions more frequently than
>>> > once per quarter would put more strain on maintainers though.
>>> > Would it be easier to release a patch release for 4.4.3? For example
>>> > 4.4.3-1 or similar that would include only fixes (no new features)....
>>> > If not, I understand and thank you once more for consideration.
>>>
>>> Pengbo, who is responsible for the release process of Pgpool-II, said
>>> that she maybe able to release 4.4.3-1 RPM packages *only* (with all
                                   ~~~~~~~4.4.3-2
>>> fixes for 4.4. including this, no new features). Is that useful for
>>> you?
>> 
>> Yes. That would be very helpful.
>> Thank you!
> 
> Ok, I will ask Peng Bo to prepare the RPM package.

4.4.3-2 RPM packages are out.

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp