Skip to content

Why does replication task fail with rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) even though both source and target endpoints are 100% successful?

0

2025-11-07T13:17:05 [TARGET_LOAD ]D: Target starts loading new table 'public'.'affiliate' (endpointshell.c:3253) 2025-11-07T13:17:08 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:11 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:15 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:18 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:21 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:24 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:27 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:30 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:33 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:38 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:41 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:45 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:48 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:51 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:54 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:17:57 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:18:00 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:18:03 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:18:08 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:18:11 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489) 2025-11-07T13:18:15 [IO ]D: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489)

Please note:

BOTH source and target endpoint tests are 100% successful, indicating that:

  • network connectivity is correct
  • RDS credentials are correct

What OTHER condition can cause these errors?

asked a year ago185 views

1 Answer
0

Based on the error logs showing "Server poll timeout. failed" messages, this appears to be a network connectivity issue despite the successful endpoint tests. This type of error typically indicates that the replication agent is unable to maintain a stable connection with the replication server.

Several conditions could cause these errors even when initial endpoint tests succeed:

  1. Intermittent network connectivity issues: While the initial connection tests may succeed, the actual replication process requires a sustained connection. Temporary network disruptions, latency spikes, or packet loss could cause these timeout errors.

  2. Network configuration problems: Security groups, network ACLs, route tables, or gateway configurations might allow initial connectivity tests to succeed but block sustained traffic patterns required for replication.

  3. Firewall or proxy interference: There might be firewalls, proxy servers, or SSL offloading rules that are intercepting or blocking the sustained connection needed for replication, even though they allow the initial connectivity test.

  4. SSL/TLS handshake issues: The initial connection might succeed, but there could be problems with maintaining the SSL/TLS connection over time.

  5. Resource constraints: The replication server might be experiencing high load or resource constraints, causing it to be unresponsive to the agent's requests.

To troubleshoot, you could:

answered a year ago

  • There are 11 rows involved - there are no resource constraints.

    Can anyone provide an example where this "Network configuration problems: Security groups, network ACLs, route tables, or gateway configurations might allow initial connectivity tests to succeed but block sustained traffic patterns required for replication." is a possibility. ACLs either work or they don't. SG's either work or they don't.

    Either the target and source tests are completely bogus or this advice is. Both cannot be sound

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.