Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

StorageLoader: add tcpKeepAlive=true to JDBC for long-running COPYs via NAT #2145

Closed
alexanderdean opened this issue Oct 27, 2015 · 1 comment
Assignees

Comments

@alexanderdean
Copy link
Member

Otherwise we get the dread:

An I/O error occured while sending to the backend

For people who find this in the future: don't forget to configure your client's kernel to use TCP keep-alive correctly too:

JDBC settings: https://jdbc.postgresql.org/documentation/head/connect.html

@alexanderdean alexanderdean self-assigned this Oct 27, 2015
@alexanderdean alexanderdean changed the title StorageLoader: add tcpKeepAlive=true; to JDBC for long-running COPYs via NAT StorageLoader: add tcpKeepAlive=true to JDBC for long-running COPYs via NAT Oct 27, 2015
@alexanderdean
Copy link
Member Author

Update: I'm not sure the TCP keep-alive settings in the kernel make a material difference...

chuwy pushed a commit to snowplow/snowplow-rdb-loader that referenced this issue Sep 5, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant