Member since
02-18-2019
83
Posts
3
Kudos Received
0
Solutions
06-05-2022
10:50 PM
1 Kudo
@mszurap Thanks for your detailed explanation this certainly helps.
... View more
06-03-2022
12:04 AM
Hello, We are observing Impala CatalogException: Error refreshing metadata for table due to lock contention errors on our Cluster. Came across this article - https://community.cloudera.com/t5/Support-Questions/Impala-Error-updating-the-catalog-due-to-lock-contention/td-p/329310 upon checking the suggestions made by Cloudera Tech - load_catalog_in_background is already unchecked nor do we find any error for JVM Pause in Catalogue Logs Java Heap Size of Catalog Server in Bytes = 28G CDH 6.3.3 Would appreciate any help in understanding why this happens and ways to fix this.
... View more
Labels:
01-18-2022
01:16 AM
@ChrisGe Appericate your assistacne, I see the below in the logs, 10:04:02.026 PM INFO cc:494 T 00000000000000000000000000000000 P c8d59ba15dbb4578900f597bb48bd9e0 [term 68 FOLLOWER]: Starting pre-election with config: opid_index: -1 OBSOLETE_local: false peers { permanent_uuid: "865af50ae13e4cfabe5719b865d6716a" member_type: VOTER last_known_addr { host: "master1.com" port: 7051 } } peers { permanent_uuid: "c8d59ba15dbb4578900f597bb48ce9e0" member_type: VOTER last_known_addr { host: "master2.com" port: 7051 } } peers { permanent_uuid: "8be74245ecaf4b5baf18b24dbc730922" member_type: VOTER last_known_addr { host: "master3.com" port: 7051 } }
10:04:02.026 PM INFO cc:296
T 00000000000000000000000000000000 P c8d59ba15dbb4578900f597bb48bd9e0 [CANDIDATE]: Term 69 pre-election: Requested pre-vote from peers 865af50ae13e4cfabe5719b865d6716a (master1.com:7051), 8be74245ecaf4b5baf18b24dbc730922 (master3.com:7051)
10:04:02.028 PM INFO cc:310
T 00000000000000000000000000000000 P c8d59ba15dbb4578900f597bb48bd9e0 [CANDIDATE]: Term 69 pre-election: Election decided. Result: candidate lost. Election summary: received 3 responses out of 3 voters: 1 yes votes; 2 no votes. yes voters: c8d59ba15dbb4578900f597bb48bd9e0; no voters: 865af50ae13e4cfagh5719b865d6716a, 8be74245ecaf4b5baf18b24dbc730922
10:04:02.028 PM INFO cc:2592
T 00000000000000000000000000000000 P c8d59ba15dbb4578900f597bb48bd9e0 [term 68 FOLLOWER]: Leader pre-election lost for term 69. Reason: could not achieve majority Thanks
... View more
01-17-2022
10:43 PM
@ChrisGe Cannot attach ksck report due to company infosec policy. Regarding consensus matrix is the below you are looking for ?? All reported replicas are:
A = 865af50ae13e4cfagh5719b865d6716a
B = c8d59ba15dbb4578900f597bb48bd9e0
C = 8be74245ecaf4b5baf18b24dbc7318ea
The consensus matrix is:
Config source | Replicas | Current term | Config index | Committed?
---------------+--------------+--------------+--------------+------------
A | A* B C | 68 | -1 | Yes
B | A B C | 68 | -1 | Yes
C | A* B C | 68 | -1 | Yes
... View more
01-17-2022
02:27 AM
Hi, I am getting error when I run kudu ksck command Errors:
==================
Corruption: master consensus error: there are master consensus conflicts
FAILED
Runtime error: ksck discovered errors All 3 Masters & Tablet server are reported as healthy, Any assistance / pointer in fixing this error. Thanks
... View more
Labels:
10-13-2021
09:59 PM
Hello, Whenever we have maintenance activity of our DB or DB Hosts, we have to bring our cluster down, I want to avoid this and was wondering if there is a way by which we could provide an Oracle VIP / Scan IP so that if one instance of the database is down Hadoop applications (Hive, Hue, Oozie, CM, etc which use DB) could connect to another instance, thus avoiding downtime. Would like some guidance/information on this. CM /CDH 6.3.3 Thanks
... View more
10-12-2021
12:47 AM
Hi @ShankerSharma I am currently killing the query from Impala GUI, however, this becomes overkill when there are many queries in a state of exception. Was wondering if there could be a faster way to select all of such queries and kill them in one go.
... View more
10-05-2021
09:11 PM
Hello, We are seeing a few Impala queries running for more than 3 hours in Impala. Upon checking we found that the query is in exception state however on the Cloudera Impala GUI it still showing it as running. Would like to know if there is a way to kill such type of queries at Impala level. We have implemented Impala ACL and set the Queue Timeout to 5 minutes yet some queries keep running. Our applications connect to Impala via JDBC and we also have some users who use Hue to run queries. Any assistance/guidance is much appreciated.
... View more