[IGNITE-6835] ODBC driver should handle ungraceful tcp disconnects

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1
• Fix Version/s: 2.4
• Component/s: odbc
• Labels: odbc
• Assignee: Igor Sapego
• Reporter: Alexey Popov
• Created: 07/Nov/17 14:42
• Updated: 17/Nov/17 14:08
• Resolved: 14/Nov/17 13:09

Description

It is found that ungraceful TCP disconnect makes ODBC driver stuck at socket recv().
Ungraceful TCP disconnect could be caused:
1. Network failure (or new firewall rules)
2. Remote party shutdown (Half Closed Connection)

So, the proposal is:
setup socket options:
1) SO_KEEPALIVE enabled
2) TCP_KEEPIDLE to 60 sec. It is 2 hour by default
3) TCP_KEEPINTVL to 1 sec. It is 1 sec at Win and 75 sec at Linux by default.
4) send/receive buffers to some greater value (8k by default)

Issue Links

• links to: GitHub Pull Request #2997