pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18945: Standby synchronization problem
3+ messages / 3 participants
[nested] [flat]
* BUG #18945: Standby synchronization problem
@ 2025-06-02 12:18 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: PG Bug reporting form @ 2025-06-02 12:18 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: lucasmarola@hotmail.com
The following bug has been logged on the website:
Bug reference: 18945
Logged by: lucas marola
Email address: lucasmarola@hotmail.com
PostgreSQL version: 16.8
Operating system: Red Hat Enterprise Linux release 9.5 (Plow)
Description:
Sometimes, the WAL application on the standby environment takes a long time
to complete. However, after restarting the application process, it returns
to normal.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #18945: Standby synchronization problem
@ 2025-06-02 13:12 Dilip Kumar <dilipbalaut@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: Dilip Kumar @ 2025-06-02 13:12 UTC (permalink / raw)
To: lucasmarola@hotmail.com; pgsql-bugs@lists.postgresql.org
On Mon, Jun 2, 2025 at 5:56 PM PG Bug reporting form
<noreply@postgresql.org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference: 18945
> Logged by: lucas marola
> Email address: lucasmarola@hotmail.com
> PostgreSQL version: 16.8
> Operating system: Red Hat Enterprise Linux release 9.5 (Plow)
> Description:
>
> Sometimes, the WAL application on the standby environment takes a long time
> to complete. However, after restarting the application process, it returns
> to normal.
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. If you have steps to reproduce/or more
details on the exact scenario, then that would be helpful.
--
Regards,
Dilip Kumar
Google
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #18945: Standby synchronization problem
@ 2025-06-03 06:13 Michael Paquier <michael@paquier.xyz>
parent: Dilip Kumar <dilipbalaut@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Michael Paquier @ 2025-06-03 06:13 UTC (permalink / raw)
To: Dilip Kumar <dilipbalaut@gmail.com>; +Cc: lucasmarola@hotmail.com; pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-06-03 06:13 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-06-02 12:18 BUG #18945: Standby synchronization problem PG Bug reporting form <noreply@postgresql.org>
2025-06-02 13:12 ` Dilip Kumar <dilipbalaut@gmail.com>
2025-06-03 06:13 ` Michael Paquier <michael@paquier.xyz>
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