| From: | Brad White <b55white(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | replication not replicating |
| Date: | 2024-01-16 21:10:09 |
| Message-ID: | CAA_1=91azHpkzuNK6Z8uS1dL_xcF=PYyPTojY1DBB2NP8Fm_tA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Errors from the primary
2024-01-15 00:00:51.157 CST [2660] ERROR: requested WAL segment
0000000100000002000000A2 has already been removed
2024-01-15 00:00:51.157 CST [2660] STATEMENT: START_REPLICATION 2/A2000000
TIMELINE 1
2024-01-15 00:00:56.158 CST [492] ERROR: requested WAL segment
0000000100000002000000A2 has already been removed
2024-01-15 00:00:56.158 CST [492] STATEMENT: START_REPLICATION 2/A2000000
TIMELINE 1
2024-01-15 00:00:56.159 CST [492] LOG: could not receive data from client:
An existing connection was forcibly closed by the remote host.
2024-01-15 00:01:01.151 CST [3404] ERROR: requested WAL segment
0000000100000002000000A2 has already been removed
2024-01-15 00:01:01.151 CST [3404] STATEMENT: START_REPLICATION 2/A2000000
TIMELINE 1
2024-01-15 00:01:01.152 CST [3404] LOG: could not receive data from
client: An existing connection was forcibly closed by the remote host.
[repeat for 55000 lines]
--------------------------------------------------------
Errors from the hot backup at roughly the same time
2024-01-15 01:13:57.893 CST [2988] LOG: started streaming WAL from primary
at 2/A2000000 on timeline 1
2024-01-15 01:13:57.893 CST [2988] FATAL: could not receive data from WAL
stream: ERROR: requested WAL segment 0000000100000002000000A2 has already
been removed
2024-01-15 01:13:57.893 CST [1792] LOG: waiting for WAL to become
available at 2/A2002000
2024-01-15 01:14:02.884 CST [2552] LOG: started streaming WAL from primary
at 2/A2000000 on timeline 1
2024-01-15 01:14:02.884 CST [2552] FATAL: could not receive data from WAL
stream: ERROR: requested WAL segment 0000000100000002000000A2 has already
been removed
2024-01-15 01:14:02.884 CST [1792] LOG: waiting for WAL to become
available at 2/A2002000
[repeat for 49000 lines]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Atul Kumar | 2024-01-16 21:12:16 | Parameter value in RDS |
| Previous Message | Jim Nasby | 2024-01-16 21:03:33 | Re: Mimic ALIAS in Postgresql? |