MIME-Version: 1.0
References: 
 <CAEy4EGWmgs3oQ2k-0rR3gvh3FQFnN9dajEtakBfxDJeyYiDBgA@mail.gmail.com>
 <20251130.102712.131456481338876013.ishii@postgresql.org>
 <CAEy4EGXPw9cU6C6TSCK1FODs0ZK3P3COmsoGU69UFzWeip4b_w@mail.gmail.com>
 <20251202.140205.427777414210613577.ishii@postgresql.org>
In-Reply-To: <20251202.140205.427777414210613577.ishii@postgresql.org>
From: zam bak <zam6ak@gmail.com>
Date: Tue, 2 Dec 2025 12:31:46 -0500
Message-ID: 
 <CAEy4EGXZpB6kx+XQ4SBPJybXKrZ0q5_z4JoSkSjxD9wb6jOJkQ@mail.gmail.com>
Subject: Re: "buffer overflow detected" when running SHOW POOL_STATUS
To: Tatsuo Ishii <ishii@postgresql.org>
Cc: pgpool-general@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CAEy4EGXZpB6kx%2BXQ4SBPJybXKrZ0q5_z4JoSkSjxD9wb6jOJkQ%40mail.gmail.com>
Precedence: bulk

On Tue, Dec 2, 2025 at 12:02=E2=80=AFAM Tatsuo Ishii <ishii@postgresql.org>=
 wrote:
>
> >> Unfortunately, I was not able to reproduce the issue on my Ubuntu 24
> >> and Rocky Linux 10.1 box (pgpool is compiled from source code).
> >> So there are some questions:
> >>
> >> - Is the issue occurred even when you execute other pgpool command?
> >>   (for example "show pool_processes")
> >
> > No. Only getting this issue when running SHOW POOL_STATUS
>
> I found a bug with SHOW POOL_STATUS (and pcp_pool_status). The bug
> broke the data segment used for the conversion from binary form of
> backend flag (in this case ALWAYS_PRIMARY. Other flag does not raise
> the issue) to string representation, which caused the buffer overflow
> issue.
>
> Attached is the patch to fix the issue.

Ishii-san

Thank you for finding the bug and fixing it...

I think this bug warrants a new patch release or a rebuild so we can
use the latest 4.6 in production...
Is it possible to release a new RPM build 4.6.4-2 or 4.6.5?

Regards
Z....


>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS K.K.
> English: http://www.sraoss.co.jp/index_en/
> Japanese:http://www.sraoss.co.jp
>