[SERVER-30789] Unable to Initial Sync Big Database on non-Linux System due to mongod TCP Keepalive Constraint Created: 23/Aug/17 Updated: 09/Oct/17 Resolved: 13/Sep/17 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Replication |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | WenniZ | Assignee: | Ramon Fernandez Marina |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Operating System: | ALL |
| Participants: |
| Description |
|
We are initial syncing a big database (~70Gb) from a replica set member A to replica set member B. Both members are running mongod instance on Windows. Windows TCP connection interval is set to 30min. And from this post: Under these settings, we found we are not able to complete initial syncing, because: 1. We need more than 10 minutes to build index after the big database is copied from A to B. Please suggest. Log containing this error:
|
| Comments |
| Comment by Ramon Fernandez Marina [ 13/Sep/17 ] |
|
Apologies for the delay in the response. To the best of my understanding:
I'd recommend you check your values of KeepAliveTime and KeepAliveInterval to be sure, and lower KeepAliveTime if it's too large, but my my guess is that the clocks on these nodes you're trying to initial sync are diverging enough to cause the problem you're seeing, since we haven't had other users report socket timeouts due to large index builds after initial syncs. Please note that the SERVER project is for reporting bugs or feature suggestions for the MongoDB server. For MongoDB-related support discussion please post on the mongodb-user group or Stack Overflow with the mongodb tag, where your question will reach a larger audience. A question like this involving more discussion would be best posted on the mongodb-user group. See also our Technical Support page for additional support resources. Regards, |
| Comment by WenniZ [ 27/Aug/17 ] |
|
@ramon.fernandez |
| Comment by WenniZ [ 23/Aug/17 ] |
|
what version of MongoDB are you using? you mention Windows, can you please elaborate on the the exact version? is 70Gb the data size or the size on disk? |
| Comment by Ramon Fernandez Marina [ 23/Aug/17 ] |
We haven't heard of other users running into this issue so we would like to have a better understanding of what's happening and try to reproduce it on our end. Thanks, |