From: Michael Paquier <michael@paquier.xyz>
To: Dilip Kumar <dilipbalaut@gmail.com>
Cc: lucasmarola@hotmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18945: Standby synchronization problem
Date: Tue, 3 Jun 2025 15:13:59 +0900
Message-ID: <aD6SpzOI765YM9E8@paquier.xyz> (raw)
In-Reply-To: <CAFiTN-u0kuSwypDDChK4Po+4hAtm8HO94EoNCtDwPvBGw7R3Tg@mail.gmail.com>
References: <18945-2d88edf94ef23a74@postgresql.org>
<CAFiTN-u0kuSwypDDChK4Po+4hAtm8HO94EoNCtDwPvBGw7R3Tg@mail.gmail.com>
On Mon, Jun 02, 2025 at 06:42:08PM +0530, Dilip Kumar wrote:
> it's difficult to pinpoint the exact problem with the information
> provided. However, a common scenario involves read-only queries on a
> standby database conflicting with the WAL apply process. And as a
> result of restarting the application it will terminate all the backend
> so you are not facing issues of conflict any more. You can check the
> value of 'max_standby_streaming_delay' as this will control how long
> the WAL apply process should wait in case of a conflict with the
> snapshot of the local queries.
Indeed, there could be a lot going on.
A sequence of commands to pinpoint an issue, with a precise
description of what has been done, would help. Their may be some
tools you are using, that help in the reproducibility. If you are
seeing a process being stuck, attaching gdb to the process that
matters, be it a WAL sender or the startup process, or something else,
can also provide useful hints that could help in determining if you
have hit an actual bug or not. Log contents could provide useful
hints, just be sure to trim any sensitive contents they may include
before posting or attaching anything here.
Three lines to describe your problem is not enough for one to
potentially understand what's going on in your system.
> If you have steps to reproduce/or more
> details on the exact scenario, then that would be helpful.
Right.
--
Michael
Attachments:
[application/pgp-signature] signature.asc (832B, ../aD6SpzOI765YM9E8@paquier.xyz/2-signature.asc)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: michael@paquier.xyz, dilipbalaut@gmail.com, lucasmarola@hotmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18945: Standby synchronization problem
In-Reply-To: <aD6SpzOI765YM9E8@paquier.xyz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox