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 isn't replicating |
Date: | 2024-01-16 21:46:41 |
Message-ID: | CAA_1=90fAJOM-GMVRWuyUR9qYkwbZ55hBJ258-FuuXycTH5rGQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Errors from the Primary server
2024-01-15 00:01:06.166 CST [1428] ERROR: requested WAL segment
0000000100000002000000A2 has already been removed
2024-01-15 00:01:06.166 CST [1428] STATEMENT: START_REPLICATION 2/A2000000
TIMELINE 1
2024-01-15 00:01:11.158 CST [3472] ERROR: requested WAL segment
0000000100000002000000A2 has already been removed
2024-01-15 00:01:11.158 CST [3472] STATEMENT: START_REPLICATION 2/A2000000
TIMELINE 1
2024-01-15 00:01:11.158 CST [3472] LOG: could not receive data from
client: An existing connection was forcibly closed by the remote host.
2024-01-15 00:01:16.166 CST [664] ERROR: requested WAL segment
0000000100000002000000A2 has already been removed
2024-01-15 00:01:16.166 CST [664] STATEMENT: START_REPLICATION 2/A2000000
TIMELINE 1
2024-01-15 00:01:21.161 CST [2016] ERROR: requested WAL segment
0000000100000002000000A2 has already been removed
2024-01-15 00:01:21.161 CST [2016] STATEMENT: START_REPLICATION 2/A2000000
TIMELINE 1
2024-01-15 00:01:21.161 CST [2016] LOG: could not receive data from
client: An existing connection was forcibly closed by the remote host.
[repeat for 550000 lines]
----------------------------------------
Errors from the backup server
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]
What's my next step?
Thanks,
Brad.
From | Date | Subject | |
---|---|---|---|
Next Message | Brad White | 2024-01-16 21:52:52 | Re: replication isn't replicating |
Previous Message | Philip Semanchuk | 2024-01-16 21:33:58 | Re: Parameter value in RDS |