[HIVE-24786] JDBC HttpClient should retry for idempotent and unsent http methods

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available
• Assignee: Prasanth Jayachandran Assign to me
• Reporter: Prasanth Jayachandran
• Created: 16/Feb/21 11:51
• Updated: 29/Nov/22 10:22
• Resolved: 18/Feb/21 15:00

Description

When hiveserver2 is behind multiple proxies there is possibility of "broken pipe", "connect timeout" and "read timeout" exceptions if one of the intermediate proxies or load balancers decided to reset the underlying tcp socket after idle timeout. When the connection is broken and when the query is submitted after idle timeout from beeline (or client) perspective the connection is open but http methods (POST/GET) fails with socket related exceptions. Since these methods are not sent to the server these are safe for client side retries. 

 

Also HIVE-12371 seems to apply the socket timeout only to binary transport. Same can be passed on to http client as well to avoid retry hang issues with infinite timeouts. 

Issue Links

• Is contained by: HIVE-26751 Bug Fixes and Improvements for 3.2.0 release
• relates to: HIVE-25203 HiveQueryResultSet and client operation are not expected to be closed twice
• relates to: HIVE-25509 CLIService.closeOperation should not fail if operation handle is not present
• links to: GitHub Pull Request #1983