Member since
11-18-2020
5
Posts
1
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1401 | 10-09-2022 09:59 AM |
09-06-2023
03:04 AM
1 Kudo
After updating from CM 7.6.1 to CM 7.7.1, we are unable to connect the multiple PQS with the KNOX using the ODBC, Always getting the 500 error. But there is no issues when we are using the JDBC.
The cause of the issue is due to the topology change after the CM upgrade, for services such as HIVE and AVATICA.
--------------------------------------------------------------------------------------
from:
<value>enabled=true;maxFailoverAttempts=3;failoverSleep=1000;maxRetryAttempts=300;retrySleep=1000;</value>
to:
<value>enableStickySession=true;noFallback=true;enableLoadBalancing=true</value>
----------------------------------------------------------------------------------------
This is in order to support the Knox load balancer feature.
And we followed the below steps to revert the changes for existing cluster.
Knox --> Configuration --> Knox Gateway Advanced Configuration Snippet (Safety Valve) for conf/cdp-resources.xml
<name>providerConfigs:pam</name>
<value>role=ha#ha.name=HaProvider#ha.param.HIVE=enabled=true;maxFailoverAttempts=3;failoverSleep=1000;maxRetryAttempts=300;retrySleep=1000;#ha.param.AVATICA=enabled=true;maxFailoverAttempts=3;failoverSleep=1000;maxRetryAttempts=300;retrySleep=1000;</value>
Now the services are working, so far so good.
DISCLAIMER:
This article is contributed by an external user. The steps may not be verified by Cloudera and may not be applicable for all use cases and may be very specific to a particular distribution. Please follow with caution and at your own risk. If needed, raise a support case to get confirmation.
... View more
Labels:
12-12-2022
08:54 PM
Hi Hanzala, Thank you for raising concern in community. If the snapshot is moved then the info will not the show the below error:: -------------- Reading snapshot /var/lib/zookeeper/version-2/snapshot.6801207d537 There might some disk issue which cause the snapshot to be not end the file properly from the problematic zookeeper 1.move the ZK's Data Directory to backup Directory
2. Copy the transition logs and version-2/* from any running zookeeper to problematic zookeeper node
3. Then try starting problematic ZK node again And please update us the new log
... View more
11-05-2022
11:40 AM
You need to troubleshoot it below way. 1. execute the select query. Please check few sample data. 2. try to create table using 10 rows. 3. if it is okay, you have to check the rest of the data quality.
... View more
10-20-2022
10:41 PM
Hello @Khairul_Hasan We are marking the Post as Closed as we didn't hear from your side on our Update dated 2022-10-10. If your team have any concerns, Feel free to Update this Post. If your team adopted any other approach to resolve the issue, We would appreciate if your team can share the finer details for our wider community. Regards, Smarak
... View more
10-09-2022
08:07 PM
Thank you. I checked the status changed to hidden. Is delete sync not applied by usersync restart?
... View more