[
https://issues.apache.org/jira/browse/KNOX-2634?focusedWorklogId=622765&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-622765
]
ASF GitHub Bot logged work on KNOX-2634:
----------------------------------------
Author: ASF GitHub Bot
Created on: 14/Jul/21 22:15
Start Date: 14/Jul/21 22:15
Worklog Time Spent: 10m
Work Description: moresandeep opened a new pull request #469:
URL: https://github.com/apache/knox/pull/469
## What changes were proposed in this pull request?
Add a way to turn off HA loadbalancing based on user agent.
This is done because some non-browser clients such as ODBC drivers do not
honor multiple SET-COOKIE headers in response body. This config is to work
around that issue.
This PR proposed a configuration in HA Provider called
`disableLoadBalancingForUserAgents` which takes a comma separated list of user
agents that should disable the HA loadbalancing ifeature.
Following is an example config
```
<provider>
<role>ha</role>
<name>HaProvider</name>
<enabled>true</enabled>
<param>
<name>HIVE</name>
<value>enableStickySession=true;enableLoadBalancing=true;enabled=true;maxFailoverAttempts=42;failoverSleep=50;maxRetryAttempts=1;disableLoadBalancingForUserAgents=Test
User Agent, Test User Agent2,Test User Agent3 ,Test User Agent4
;retrySleep=1000</value>
</param>
</provider>
```
Default value of
`disableLoadBalancingForUserAgents=ClouderaODBCDriverforApacheHive`
## How was this patch tested?
This patch was tested on a local cluster
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@knox.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 622765)
Remaining Estimate: 0h
Time Spent: 10m
> ODBC connection broken when HA Loadbalancing config is enabled
> --------------------------------------------------------------
>
> Key: KNOX-2634
> URL: https://issues.apache.org/jira/browse/KNOX-2634
> Project: Apache Knox
> Issue Type: Bug
> Components: Server
> Reporter: Sandeep More
> Assignee: Sandeep More
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> When connecting using ODBC Connection against Knox with HA Loadbalancing
> template get the error described below:
>
> ERROR [HY000] [Cloudera][Hardy] (35) Error from server: error code: '0' error
> message: 'Invalid OperationHandle: OperationHandle [opType=GET_TABLES,
> getHandleIdentifier()=1097ca76-1815-4f0c-9c09-67fa84d22e43]'.
> Details:
> DataSourceKind=Odbc
> DataSourcePath=dsn=HIVE
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
