| From: | Alexander Lakhin <exclusion(at)gmail(dot)com> |
|---|---|
| To: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Aleksander Alekseev <aleksander(at)timescale(dot)com> |
| Subject: | Re: BUG: Former primary node might stuck when started as a standby |
| Date: | 2026-02-12 19:00:00 |
| Message-ID: | cfd35cfb-3216-42b1-814b-cc658fd0f099@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Dear Kuroda-san,
09.02.2026 04:38, Hayato Kuroda (Fujitsu) wrote:
>
> Dear Alexander, Aleksander
>
> Is it enough that we can wait till all WALs are replayed before the promotion?
>
> Like attached.
>
>
Thank you for paying attention to this!
I tried to add
$primary->wait_for_replay_catchup($standby);
in my test (see attached), but that doesn't help -- it still fails as below:
iteration 61
# +++ tap check in src/test/recovery +++
t/099_change_roles.pl .. 1/? make: *** [Makefile:28: check] Terminated
src/test/recovery/tmp_check/log/099_change_roles_node1.log
2026-02-12 20:30:42.953 EET [2716149] LOG: new timeline 4 forked off current database system timeline 3 before current
recovery point 0/3025B48
Best regards,
Alexander
| Attachment | Content-Type | Size |
|---|---|---|
| 099_change_roles.pl | application/x-perl | 2.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2026-02-12 19:00:16 | Re: Add 64-bit XIDs into PostgreSQL 15 |
| Previous Message | Andres Freund | 2026-02-12 18:52:30 | Re: Add 64-bit XIDs into PostgreSQL 15 |