Search Postgresql Archives

replication isn't replicating

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux