Member since
12-08-2016
26
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 4352 | 12-28-2016 03:35 AM |
06-18-2018
11:38 AM
Hi, Can you help me to see impala daemon backend(https://slaved:25000/queries) in json format specifically queries which are in "waiting to be closed" I browsed internet and found json variables like "num_waiting_queries", "in_flight_query", "state". I wish to learn where I can find the complete json information. There should be some url to access. Thanks.
... View more
Labels:
01-04-2018
09:59 AM
Hi there, I am browsing internet for information on CCP Data Engineer exam. Can I use R language/SparkR/R packages in CCP Data Engineer exam? I am good at dplyr kind of R packages but I am wondering whether Cloudera allow R usage in exam. I am confussed because cloudera did not mention about usage of R in CCP DE exam. Thanks.
... View more
Labels:
12-17-2017
09:02 PM
Hi, My cluster is Kerberos enabled and TLS level 3 configured. So, Do I need to disable Kerberos and TLS to upgrade CM and CDH to latest version ? Thanks.
... View more
Labels:
08-31-2017
07:25 AM
Hi, Did you fix the issue?
... View more
08-23-2017
12:39 AM
Hi, TLS is successful on all Hadoop Components including Hdfs and Yarn. Updated openssl to 1.1 and Java to 1.8_111. Thanks.
... View more
08-11-2017
04:47 AM
MainThread agent ERROR Heartbeating to :7180 failed.
Traceback (most recent call last):
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/cmf-5.9.0-py2.6.egg/cmf/agent.py", line 1346, in _send_heartbeat
self.max_cert_depth)
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/cmf-5.9.0-py2.6.egg/cmf/https.py", line 132, in __init__
self.conn.connect()
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/M2Crypto-0.21.1-py2.6-linux-x86_64.egg/M2Crypto/httpslib.py", line 50, in connect
self.sock.connect((self.host, self.port))
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/M2Crypto-0.21.1-py2.6-linux-x86_64.egg/M2Crypto/SSL/Connection.py", line 185, in connect
ret = self.connect_ssl()
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/M2Crypto-0.21.1-py2.6-linux-x86_64.egg/M2Crypto/SSL/Connection.py", line 178, in connect_ssl
return m2.ssl_connect(self.ssl)
SSLError: unknown protocol
... View more
08-11-2017
03:52 AM
Hi, I removed all keystore files and recreated but nothing works. I am using JDK 1.8_111 for self signed certificates. Now, cloudera-scm-agent log says SSLError: unknown protocol. All the machines have FQDN in following format master1.xx.org.in, slave1.xx.org.in. Firewall is off accross machines. I used fqdn for CN while creating keystore. Followed official guid but still not able make Level 1 TLS work. External HTTPS connections are working fine for web browsers(cloudera-admin UI,Namenode UI). Only internal https communication is not working(cloudera-agent hearbeat with server). MainThread agent ERROR Heartbeating to 172.23.45.21:7180 failed.
Traceback (most recent call last):
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/cmf-5.9.0-py2.6.egg/cmf/agent.py", line 1346, in _send_heartbeat
self.max_cert_depth)
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/cmf-5.9.0-py2.6.egg/cmf/https.py", line 132, in __init__
self.conn.connect()
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/M2Crypto-0.21.1-py2.6-linux-x86_64.egg/M2Crypto/httpslib.py", line 50, in connect
self.sock.connect((self.host, self.port))
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/M2Crypto-0.21.1-py2.6-linux-x86_64.egg/M2Crypto/SSL/Connection.py", line 185, in connect
ret = self.connect_ssl()
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/M2Crypto-0.21.1-py2.6-linux-x86_64.egg/M2Crypto/SSL/Connection.py", line 178, in connect_ssl
return m2.ssl_connect(self.ssl)
SSLError: unknown protocol I also tried configuring TLS for HDFS/YARN but Cloudera agent fail to communicate with Namenode, NodeManagers, DataNode web servers. It would be very helpfull if someone provide hints to me on this issue. Thanks.
... View more
08-10-2017
08:08 AM
Hello, I have a working CDH 5.9 test cluster. I want to configure level 1 TLS encryption for Cloudera manager using self signed certificate. I used the official guide. The problem is that Cloudera agent fails to communicate with CM server on 7182. I did import the cetrificate into the truststore, gave proper permisions and pointed the configuration to the truststore file, so I can't figure out what's wrong. If I look at agents log I can also see a "connection refused" errors: [10/Aug/2017 20:08:39 +0000] 55544 MainThread agent ERROR Heartbeating to 172.23.38.125:7182 failed.
Traceback (most recent call last):
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/cmf-5.9.0-py2.6.egg/cmf/agent.py", line 1346, in _send_heartbeat
self.max_cert_depth)
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/cmf-5.9.0-py2.6.egg/cmf/https.py", line 132, in __init__
self.conn.connect()
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/M2Crypto-0.21.1-py2.6-linux-x86_64.egg/M2Crypto/httpslib.py", line 50, in connect
self.sock.connect((self.host, self.port))
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/M2Crypto-0.21.1-py2.6-linux-x86_64.egg/M2Crypto/SSL/Connection.py", line 185, in connect
ret = self.connect_ssl()
File "/usr/lib64/cmf/agent/build/env/lib/python2.6/site-packages/M2Crypto-0.21.1-py2.6-linux-x86_64.egg/M2Crypto/SSL/Connection.py", line 178, in connect_ssl
return m2.ssl_connect(self.ssl)
SSLError: unknown group What am I doing wrong ? Are self signed certificates really supported ? I also updated openssl 1.0 to latest version 1.1. Thanks.
... View more
Labels:
06-05-2017
01:30 AM
Hi Everyone, I am reading the document on "Distcp between Secure Clusters in Distinct Kerberos Realms" from below webink. https://www.cloudera.com/documentation/enterprise/5-9-x/topics/cdh_admin_distcp_data_cluster_migrate.html I am not able to understand the HADOOP_CONF thing. what is exactly mean by "Set HADOOP_CONF to the Destination Cluster" ? Do we need to mention the desitnation cluster's file path? or do we need to give lib path?
... View more
Labels:
05-31-2017
03:20 AM
Hi Vini, Thank you for your response. After some R&D work the issue is solved through sqoop --query paramenter and Oozie cordinator. Now, things going as expected.
... View more
05-29-2017
04:52 AM
Hi, I am using oozie and sqooping the data from RDBMS on daily basis. I am doing research on following use case. 1. Importing data from RDBMS table in parquet format into HDFS. The import will be done on specific time on daily basis through oozie. sqoop incremental update, append, last-value is not working for me. After doing some research I understood that incremental update and etc, will not work for parquet file format. Now, I want use --query(on date cloumn of RDBMS table) in sqoop script and get the data on daily basis without using incremental, append type of methods. How can we change the dates in --query dynamically each time(every other day) the sqoop job is started. Can one sqoop code work for every day import jobs or do we need to create 10 jobs for 10 different days/dates. Is there anyother way for doing this? Any help is highly appreciated.
... View more
01-10-2017
09:11 PM
The issue is solved after restarting the posgresql
... View more
01-09-2017
08:53 AM
Please look into the below log message and help me to work on it. I copied error part of the log file due to the characters limit. [06/Jan/2017 14:31:45 +0530] decorators ERROR Error running <function execute at 0x7f9d08b56d70>
Traceback (most recent call last):
File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/decorators.py", line 81, in decorator
return func(*args, **kwargs)
File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/api.py", line 160, in execute
response = _execute_notebook(request, notebook, snippet)
File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/api.py", line 142, in _execute_notebook
raise ex
QueryError
[06/Jan/2017 14:31:47 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:32:02 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:32:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:32:17 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:32:33 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:32:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:32:47 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:33:03 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:33:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:33:17 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:33:33 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:33:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:33:47 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:34:03 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:34:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:34:17 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:34:33 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:34:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:34:47 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:35:03 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:35:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:35:17 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:35:33 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:35:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:35:48 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:36:03 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:36:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:36:18 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:36:33 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:36:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:36:48 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:37:03 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:37:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:37:18 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:37:33 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:37:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:37:48 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:38:03 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:38:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:38:18 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:38:33 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:38:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:38:48 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:39:03 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:39:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:39:18 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:39:33 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:39:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:39:48 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:40:03 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:40:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:40:18 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:40:33 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:40:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:40:48 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:41:03 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:41:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:41:18 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:41:33 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:41:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:41:48 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:42:03 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:42:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:42:18 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:42:33 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:42:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:42:48 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:43:03 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:43:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:43:18 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:43:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:43:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:43:48 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:44:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:44:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:44:18 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:44:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:44:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:44:48 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:45:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:45:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:45:18 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:45:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:45:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:45:48 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:46:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:46:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:46:18 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:46:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:46:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:46:48 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:47:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:47:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:47:18 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:47:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:47:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:47:48 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:48:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:48:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:48:19 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:48:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:48:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:48:49 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:49:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:49:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:49:19 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:49:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:49:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:49:49 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:50:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:50:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:50:19 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:50:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:50:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:50:49 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:51:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:51:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:51:19 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:51:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:51:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:51:49 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:52:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:52:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:52:19 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:52:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:52:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:52:49 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:53:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:53:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:53:19 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:53:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:53:36 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:53:49 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:54:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:54:06 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:54:19 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:54:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:54:36 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:54:49 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:55:04 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:55:06 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:55:19 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:55:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:55:36 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:55:49 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:56:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:56:06 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:56:19 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:56:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:56:36 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:56:49 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:57:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:57:06 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:57:19 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:57:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:57:36 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:57:49 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:58:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:58:06 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:58:19 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:58:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:58:36 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:58:49 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:59:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:59:06 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:59:19 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:59:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:59:36 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 14:59:49 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 15:00:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 15:00:06 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 15:00:20 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 15:00:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 15:00:36 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 15:00:50 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 15:01:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 15:01:06 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 15:01:20 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
[06/Jan/2017 15:01:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
... View more
01-09-2017
04:45 AM
Hi, The cluster is off due to unexpected power failure which happened this morning. I started the cluster after the power is back but Hive metastore is not able to connect with Postgresql. Can someone let me know why? JDBC url = jdbc:postgresql://master1.rbi.com:7432/hive, username = hive. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
org.postgresql.util.PSQLException: FATAL: the database system is shutting down Caused by: org.postgresql.util.PSQLException: FATAL: the database system is shutting down Thanks.
... View more
01-06-2017
01:29 AM
Below is the runcpserver.log This weblink is for Complete log [06/Jan/2017 13:53:08 +0530] access INFO 172.23.150.34 hive - "POST /notebook/api/notebook/close HTTP/1.1" [06/Jan/2017 13:53:08 +0530] api ERROR Error closing statement 'secret' Traceback (most recent call last): File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/api.py", line 494, in close_notebook response['result'].append(get_api(request, snippet).close_statement(snippet)) File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 68, in decorator return func(*args, **kwargs) File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 312, in close_statement handle = self._get_handle(snippet) File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 594, in _get_handle snippet['result']['handle']['secret'], snippet['result']['handle']['guid'] = HiveServerQueryHandle.get_decoded(snippet['result']['handle']['secret'], snippet['result']['handle']['guid']) KeyError: 'secret' [06/Jan/2017 13:53:08 +0530] middleware INFO Redirecting to login page: / [06/Jan/2017 13:53:08 +0530] access INFO 172.23.150.34 -anon- - "GET / HTTP/1.1" -- login redirection [06/Jan/2017 13:53:08 +0530] decorators INFO AXES: Calling decorated function: dt_login [06/Jan/2017 13:53:21 +0530] decorators INFO AXES: Calling decorated function: dt_login [06/Jan/2017 13:53:21 +0530] access WARNING 172.23.150.34 commonuser - "POST /accounts/login/ HTTP/1.1" -- Successful login for user: commonuser [06/Jan/2017 13:53:21 +0530] access INFO 172.23.150.34 commonuser - "GET / HTTP/1.1" [06/Jan/2017 13:53:21 +0530] models INFO Moved 0 documents to home directory for user: commonuser [06/Jan/2017 13:53:22 +0530] decorators INFO AXES: Calling decorated function: dt_login [06/Jan/2017 13:53:22 +0530] decorators INFO args: (True,) [06/Jan/2017 13:54:24 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1" [ 06/Jan/2017 13:54:24 +0530] access INFO 172.23.150.34 commonuser - "POST /notebook/api/autocomplete/default HTTP/1.1" [06/Jan/2017 13:54:26 +0530] access INFO 172.23.150.34 commonuser - "POST /notebook/api/execute HTTP/1.1" [06/Jan/2017 13:54:26 +0530] decorators ERROR Error running <function execute at 0x7f9d08b56d70> Traceback (most recent call last): File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/decorators.py", line 81, in decorator return func(*args, **kwargs) File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/api.py", line 160, in execute response = _execute_notebook(request, notebook, snippet) File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/api.py", line 142, in _execute_notebook raise ex QueryError [06/Jan/2017 13:54:31 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1" [06/Jan/2017 13:54:32 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1" [06/Jan/2017 13:54:33 +0530] access INFO 172.23 .150.34 commonuser - "POST /notebook/api/notebook/close HTTP/1.1" [06/Jan/2017 13:54:33 +0530] access INFO 172.23.150.34 commonuser - "GET /notebook/editor HTTP/1.1" [06/Jan/2017 13:54:33 +0530] api ERROR Error closing statement 'secret' Traceback (most recent call last): File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/api.py", line 494, in close_notebook response['result'].append(get_api(request, snippet).close_statement(snippet)) File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 68, in decorator return func(*args, **kwargs) File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 312, in close_statement handle = self._get_handle(snippet) File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 594, in _get_handle snippet['result']['handle']['secret'], snippet['result']['handle']['guid'] = HiveServerQueryHandle.get_decoded(snippet['result']['handle']['secret'], snippet['result']['handle']['guid']) KeyError: 'secret' [06/Jan/2017 13:54:34 +0530] decorators INFO AXES: Calling decorated function: dt_login [06/Jan/2017 13:54:34 +0530] decorators INFO args: (True,) [06/Jan/2017 13:54:34 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1" [06/Jan/2017 13:54:35 +0530] access INFO 172.23.150.34 commonuser - "POST /notebook/api/create_notebook HTTP/1.1" [06/Jan/2017 13:54:35 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1" [06/Jan/2017 13:54:36 +0530] access INFO 172.23.150.34 commonuser - "POST /notebook/api/create_session HTTP/1.1" [06/Jan/2017 13:54:36 +0530] access INFO 172.23.150.34 commonuser - "GET /notebook/api/get_history HTTP/1.1" [06/Jan/2017 13:54:38 +0530] access INFO 172.23.150.34 commonuser - "GET /desktop/api2/doc/ HTTP/1.1" [06/Jan/2017 13:54:38 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1" [06/Jan/2017 13:54:40 +0530] access INFO 172.23.150.34 commonuser - "POST /notebook/api/execute HTTP/1.1" [06/Jan/2017 13:54:40 +0530] hive_server2_lib INFO Retrying with a new session because for commonuser of TExecuteStatementResp(status=TStatus(errorCode=0, errorMessage='Invalid SessionHandle: SessionHandle [17c6652b-fb09-4dbd-951b-9e415918b6bc]', sqlState=None, infoMessages=['*org.apache.hive.service.cli.HiveSQLException:Invalid SessionHandle: SessionHandle [17c6652b-fb09-4dbd-951b-9e415918b6bc]:12:11', 'org.apache.hive.service.cli.session.SessionManager:getSession:SessionManager.java:348', 'org.apache.hive.service.cli.CLIService:executeStatement:CLIService.java:245', 'org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteStatement:ThriftCLIService.java:500', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1313', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1298', 'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39', 'org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39', 'org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor:process:HadoopThriftAuthBridge.java:746', 'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:286', 'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1145', 'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:615', 'java.lang.Thread:run:Thread.java:745'], statusCode=3), operationHandle=None) [06/Jan/2017 13:54:40 +0530] hive_server2_lib INFO Opening beeswax thrift session for user commonuser [06/Jan/2017 13:54:40 +0530] hive_server2_lib INFO Session 'z\xd2&\xa2\xc2\xfeKV\x8b Y\xb5c\xd6v\x85' opened [06/Jan/2017 13:54:41 +0530] access INFO 172.23.150.34 commonuser - "POST /notebook/api/check_status HTTP/1.1" [06/Jan/2017 13:54:42 +0530] access INFO 172.23.150.34 commonuser - "POST /notebook/api/get_logs HTTP/1.1" [06/Jan/2017 13:54:42 +0530] access INFO 172.23.150.34 commonuser - "POST /notebook/api/fetch_result_data HTTP/1.1" [06/Jan/2017 13:54:42 +0530] access INFO 172.23.150.34 commonuser - "POST /notebook/api/fetch_result_data HTTP/1.1" [06/Jan/2017 13:54:53 +0530] access INFO 172.23.150.34 commonuser - "POST /notebook/api/autocomplete/default/sample_08 HTTP/1.1" [06/Jan/2017 13:54:56 +0530] access INFO 172.23.150.34 commonuser - "POST /notebook/api/check_status HTTP/1.1" [06/Jan/2017 13:55:05 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1" [06/Jan/2017 13:55:06 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1" [06/Jan/2017 13:55:09 +0530] access INFO 172.23.150.34 commonuser - "POST /jobbrowser/jobs/ HTTP/1.1"
... View more
01-04-2017
09:37 PM
Yep, database and tables are not reflecting even after refreshing the cache in hue-impala editor. What would be the issue according to you. Please advice.
... View more
01-04-2017
09:34 PM
Hi, Hue-Impala Editor error message for commonuser : AuthorizationException: User 'commonuser' does not have privileges to access: default.* I gave select privilege in sentry app for default database and other database called test.db (test.db is not even visable in hue-impala editor). Screenshot of hue-impala editor error message Screenshot of hue-hive editor (There is no error message for hive editor its working fine) runcpserver.log file for reference Please advice.
... View more
01-03-2017
10:42 PM
Hi, I created a user called "commonuser" and group called "commonuser" in hue and linux machine. Created role called "commonuser" in sentry app to access databases and gave "select" privilege. Now, I logged in as commonuser in hue. In hue-hive editor the databases are visable but not in hue-Impala editor. In impala only the default database without any tables is visable as show in the below screenshot. Please advice me on the issue. Screenshot 0 screenshot 1 Screenshot 2 Screenshot 3
... View more
Labels:
01-03-2017
10:35 PM
Hi, I created a user called "commonuser" and group called "commonuser" in hue and linux machine. Created role called "commonuser" in sentry app to access databases and gave "select" privilege. Now, I logged in as commonuser in hue. In hue-hive editor the databases are visable but not in hue-Impala editor. In impala only the default database without any tables is visable as show in the below screenshot. Please advice me on the issue.
... View more
01-01-2017
08:01 PM
Thank you for the response.
... View more
12-30-2016
02:19 AM
I am breaking my head to find the solution. Someone please atleast give me a hint or advice. 1. I am not able to create a new database using HUE GUI. Its througing message - 'error 500'. I checked the hue server logs but did not find any hint. However I am able to create a new database with Hive cli mode. New database is reflecting in hue filebrowser but not in hue query editors. 2. All the new tables created under default database are in syn between hue and hive. 3. HUE login user and group is hive. I tried with all the other users like hdfs, admin but the problem remains same for all users in hue. Also, I attached the hue file browser pics below. Can someone please let me know whether it is a permissions issue or any misconfiguration issue.
... View more
12-29-2016
03:02 AM
Please help me to solve the issue. I am working the same issue from 2 days but unable to find the correct solution. Any help is higly appreciated. I have attached the images of hive cli and hue web ui.
... View more
Labels:
12-29-2016
12:08 AM
Please help me to solve the issue. I am working the same issue from 2 days but unable to find the correct solution. Any help is higly appreciated. I have attached the images of hive cli and hue web ui.
... View more
Labels:
12-28-2016
03:35 AM
Hi, I did some workaround and found the solution: By running the following commands on the KDC will enable renewable tickets. kadmin> modprinc -maxrenewlife 90day krbtgt/REALM.COM kadmin> modprinc -maxrenewlife 90day +allow_renewable hue/<hostname>@REALM.COM Thanks.
... View more
12-27-2016
12:18 AM
Can't open /var/run/cloudera-scm-agent/process/275-hue-KT_RENEWER/supervisor.conf: Permission denied.
+ make_scripts_executable
+ find /var/run/cloudera-scm-agent/process/275-hue-KT_RENEWER -regex '.*\.\(py\|sh\)$' -exec chmod u+x '{}' ';'
+ '[' kt_renewer == beeswax_server ']'
+ set_classpath_in_var HADOOP_EXTRA_CLASSPATH_STRING
+ '[' -z HADOOP_EXTRA_CLASSPATH_STRING ']'
+ [[ -n /usr/share/cmf ]]
++ find /usr/share/cmf/lib/plugins -maxdepth 1 -name '*.jar'
++ tr '\n' :
+ ADD_TO_CP=/usr/share/cmf/lib/plugins/tt-instrumentation-5.9.0.jar:/usr/share/cmf/lib/plugins/event-publish-5.9.0-shaded.jar:
+ [[ -n '' ]]
+ eval 'OLD_VALUE=$HADOOP_EXTRA_CLASSPATH_STRING'
++ OLD_VALUE=
+ NEW_VALUE=/usr/share/cmf/lib/plugins/tt-instrumentation-5.9.0.jar:/usr/share/cmf/lib/plugins/event-publish-5.9.0-shaded.jar:
+ export HADOOP_EXTRA_CLASSPATH_STRING=/usr/share/cmf/lib/plugins/tt-instrumentation-5.9.0.jar:/usr/share/cmf/lib/plugins/event-publish-5.9.0-shaded.jar
+ HADOOP_EXTRA_CLASSPATH_STRING=/usr/share/cmf/lib/plugins/tt-instrumentation-5.9.0.jar:/usr/share/cmf/lib/plugins/event-publish-5.9.0-shaded.jar
+ HUE=/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/build/env/bin/hue
+ [[ kt_renewer == runcpserver ]]
+ [[ kt_renewer == kt_renewer ]]
+ '[' -d /usr/kerberos/bin ']'
++ which kinit
+ KINIT_PATH=/usr/bin/kinit
+ KINIT_PATH=/usr/bin/kinit
+ perl -pi -e 's#{{KINIT_PATH}}#/usr/bin/kinit#g' /var/run/cloudera-scm-agent/process/275-hue-KT_RENEWER/hue.ini /var/run/cloudera-scm-agent/process/275-hue-KT_RENEWER/hue_safety_valve.ini
+ '[' dumpdata = kt_renewer ']'
+ '[' syncdb = kt_renewer ']'
+ exec /opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/build/env/bin/hue kt_renewer
kinit: Ticket expired while renewing credentials
... View more
Labels:
12-08-2016
04:25 AM
Please help me to solve the issue. I configured mysql database for cloudera manager server and created a database "scm". Run the scm_prepare_database.sh script in terminal. Installed mysql jdbc drivers. Installed Java 1.7u67. All the path are correct. JDBC path : export CMF_JDBC_DRIVER_JAR="/usr/share/java/mysql-connector-java.jar:/usr/share/java/oracle-connector-java.jar". I am using my.conf file which is recommended by cloudera. http://www.cloudera.com/documentation/enterprise/latest/topics/cm_ig_mysql.html I am installing cloudera manager as system root user. Below is the log file copy : 2016-12-08 19:07:45,016 INFO main:org.hibernate.annotations.common.Version: HCANN000001: Hibernate Commons Annotations {4.0.2.Final} 2016-12-08 19:07:45,024 INFO main:org.hibernate.Version: HHH000412: Hibernate Core {4.2.2.Final} 2016-12-08 19:07:45,027 INFO main:org.hibernate.cfg.Environment: HHH000206: hibernate.properties not found 2016-12-08 19:07:45,029 INFO main:org.hibernate.cfg.Environment: HHH000021: Bytecode provider name : javassist 2016-12-08 19:07:45,640 INFO main:org.hibernate.cfg.Configuration: HHH000221: Reading mappings from resource: cmf.hbm.xml 2016-12-08 19:07:45,970 INFO main:org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator: HHH000130: Instantiating explicit connection provider: org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider 2016-12-08 19:07:45,971 INFO main:org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider: HHH010002: C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/scm?useUnicode=true&characterEncoding=UTF-8 2016-12-08 19:07:45,971 INFO main:org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider: HHH000046: Connection properties: {user=root, password=****, autocommit=true, release_mode=auto} 2016-12-08 19:07:45,971 INFO main:org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider: HHH000006: Autocommit mode: true 2016-12-08 19:07:46,001 INFO main:com.mchange.v2.log.MLog: MLog clients using log4j logging. 2016-12-08 19:08:26,080 INFO main:com.mchange.v2.c3p0.impl.C3P0ImplUtils: Failed to get local InetAddress for VMID. This is unlikely to matter. At all. We'll add some extra randomness java.net.UnknownHostException: ODC-HADOOP-MN: ODC-HADOOP-MN at java.net.InetAddress.getLocalHost(InetAddress.java:1473) at com.mchange.v2.c3p0.impl.C3P0ImplUtils.generateVmId(C3P0ImplUtils.java:120) at com.mchange.v2.c3p0.impl.C3P0ImplUtils.<clinit>(C3P0ImplUtils.java:98) at com.mchange.v2.c3p0.impl.DriverManagerDataSourceBase.<init>(DriverManagerDataSourceBase.java:205) at com.mchange.v2.c3p0.DriverManagerDataSource.<init>(DriverManagerDataSource.java:60) at com.mchange.v2.c3p0.DriverManagerDataSource.<init>(DriverManagerDataSource.java:56) at com.mchange.v2.c3p0.DataSources.unpooledDataSource(DataSources.java:152) at org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider.configure(C3P0ConnectionProvider.java:197) at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:75) at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:159) at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:131) at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.buildJdbcConnectionAccess(JdbcServicesImpl.java:223) at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:89) at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:75) at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:159) at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:131) at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1797) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1755) at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:96) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:914) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:899) at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:59) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63) at com.cloudera.enterprise.CommonMain.setupHibernate(CommonMain.java:173) at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:114) at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:65) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1440) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106) at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:616) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425) at com.cloudera.server.cmf.Main.bootstrapSpringContext(Main.java:387) at com.cloudera.server.cmf.Main.<init>(Main.java:242) at com.cloudera.server.cmf.Main.main(Main.java:216) Caused by: java.net.UnknownHostException: ODC-HADOOP-MN at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:901) at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1293) at java.net.InetAddress.getLocalHost(InetAddress.java:1469) ... 48 more 2016-12-08 19:08:26,221 INFO main:com.mchange.v2.c3p0.C3P0Registry: Initializing c3p0-0.9.1.1 [built 15-March-2007 01:32:31; debug? true; trace: 10] 2016-12-08 19:08:26,312 INFO main:org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider: HHH000149: JDBC isolation level: READ_COMMITTED 2016-12-08 19:08:26,390 INFO main:com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource: Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@213285c4 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@62b28672 [ acquireIncrement -> 3, acquireRetryAttempts -> 5, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> vcq48xonp0y81a9b9y4|56adba61, idleConnectionTestPeriod -> 300, initialPoolSize -> 3, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 50, maxStatements -> 2500, maxStatementsPerConnection -> 0, minPoolSize -> 5, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@d2183e49 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> vcq48xonp0y81a9b9y4|1d32c800, jdbcUrl -> jdbc:mysql://localhost/scm?useUnicode=true&characterEncoding=UTF-8, properties -> {user=******, password=******, autocommit=true, release_mode=auto} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> vcq48xonp0y81a9b9y4|206d0c9f, numHelperThreads -> 3 ] 2016-12-08 19:08:26,979 INFO main:org.hibernate.dialect.Dialect: HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2016-12-08 19:08:26,998 INFO main:org.hibernate.engine.jdbc.internal.LobCreatorBuilder: HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException 2016-12-08 19:08:27,258 INFO main:org.hibernate.engine.transaction.internal.TransactionFactoryInitiator: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory 2016-12-08 19:08:27,265 INFO main:org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory: HHH000397: Using ASTQueryTranslatorFactory 2016-12-08 19:09:07,427 ERROR main:net.sf.ehcache.Cache: Unable to set localhost. This prevents creation of a GUID. Cause was: ODC-HADOOP-MN: ODC-HADOOP-MN java.net.UnknownHostException: ODC-HADOOP-MN: ODC-HADOOP-MN at java.net.InetAddress.getLocalHost(InetAddress.java:1473) at net.sf.ehcache.Cache.<clinit>(Cache.java:200) at net.sf.ehcache.config.ConfigurationHelper.createCache(ConfigurationHelper.java:302) at net.sf.ehcache.config.ConfigurationHelper.createDefaultCache(ConfigurationHelper.java:218) at net.sf.ehcache.CacheManager.configure(CacheManager.java:599) at net.sf.ehcache.CacheManager.init(CacheManager.java:358) at net.sf.ehcache.CacheManager.<init>(CacheManager.java:227) at net.sf.ehcache.CacheManager.create(CacheManager.java:818) at org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory.start(SingletonEhCacheRegionFactory.java:92) at org.hibernate.internal.CacheImpl.<init>(CacheImpl.java:70) at org.hibernate.engine.spi.CacheInitiator.initiateService(CacheInitiator.java:40) at org.hibernate.engine.spi.CacheInitiator.initiateService(CacheInitiator.java:35) at org.hibernate.service.internal.SessionFactoryServiceRegistryImpl.initiateService(SessionFactoryServiceRegistryImpl.java:91) at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:176) at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:150) at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:131) at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:264) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1769) at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:96) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:914) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:899) at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:59) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63) at com.cloudera.enterprise.CommonMain.setupHibernate(CommonMain.java:173) at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:114) at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:65) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1440) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106) at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:616) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425) at com.cloudera.server.cmf.Main.bootstrapSpringContext(Main.java:387) at com.cloudera.server.cmf.Main.<init>(Main.java:242) at com.cloudera.server.cmf.Main.main(Main.java:216) Caused by: java.net.UnknownHostException: ODC-HADOOP-MN at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:901) at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1293) at java.net.InetAddress.getLocalHost(InetAddress.java:1469) ... 48 more 2016-12-08 19:09:07,471 INFO main:org.hibernate.cache.spi.UpdateTimestampsCache: HHH000250: Starting update timestamps cache at region: org.hibernate.cache.spi.UpdateTimestampsCache 2016-12-08 19:09:07,477 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.spi.UpdateTimestampsCache]; using defaults. 2016-12-08 19:09:07,481 INFO main:org.hibernate.cache.internal.StandardQueryCache: HHH000248: Starting query cache at region: org.hibernate.cache.internal.StandardQueryCache 2016-12-08 19:09:07,482 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.internal.StandardQueryCache]; using defaults. 2016-12-08 19:09:07,574 INFO main:org.hibernate.validator.internal.util.Version: HV000001: Hibernate Validator 5.0.1.Final 2016-12-08 19:09:09,770 INFO main:com.cloudera.enterprise.CommonMain: Statistics not enabled, JMX will not be registered 2016-12-08 19:09:09,992 INFO main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: MYSQL database engine and table mapping: {InnoDB=[SCHEMA_VERSION]} 2016-12-08 19:09:10,016 WARN main:org.hibernate.engine.jdbc.spi.SqlExceptionHelper: SQL Error: 1146, SQLState: 42S02 2016-12-08 19:09:10,016 ERROR main:org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Table 'scm.CM_VERSION' doesn't exist 2016-12-08 19:09:10,018 WARN main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: Failed to determine prior version. This is expected if you are starting Cloudera Manager for the first time. Please also ignore any error messages about missing tables. Moving ahead assuming no upgrade: org.hibernate.exception.SQLGrammarException: could not extract ResultSet 2016-12-08 19:09:10,028 INFO main:com.cloudera.enterprise.dbutil.DbUtil: Schema version table already exists. 2016-12-08 19:09:10,029 ERROR main:com.cloudera.enterprise.dbutil.DbUtil: Schema version table SCHEMA_VERSION exists but contains no rows. 2016-12-08 19:09:10,030 INFO main:org.springframework.beans.factory.support.DefaultListableBeanFactory: Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@466e06d7: defining beans [commandLineConfigurationBean,entityManagerFactoryBean,com.cloudera.server.cmf.TrialState,com.cloudera.server.cmf.TrialManager,com.cloudera.cmf.crypto.LicenseLoader]; root of factory hierarchy 2016-12-08 19:09:10,030 ERROR main:com.cloudera.server.cmf.Main: Server failed. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.cloudera.server.cmf.TrialState': Cannot resolve reference to bean 'entityManagerFactoryBean' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactoryBean': FactoryBean threw exception on object creation; nested exception is java.sql.SQLException: Schema version table SCHEMA_VERSION exists but contains no rows. at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106) at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:616) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425) at com.cloudera.server.cmf.Main.bootstrapSpringContext(Main.java:387) at com.cloudera.server.cmf.Main.<init>(Main.java:242) at com.cloudera.server.cmf.Main.main(Main.java:216) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactoryBean': FactoryBean threw exception on object creation; nested exception is java.sql.SQLException: Schema version table SCHEMA_VERSION exists but contains no rows. at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:149) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1440) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322) ... 17 more Caused by: java.sql.SQLException: Schema version table SCHEMA_VERSION exists but contains no rows. at com.cloudera.enterprise.dbutil.DbUtil.getSchemaVersion(DbUtil.java:238) at com.cloudera.enterprise.dbutil.DbUtil$1SchemaVersionWork.execute(DbUtil.java:177) at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:54) at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:1982) at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:1979) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:284) at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2000) at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:1986) at com.cloudera.enterprise.dbutil.DbUtil.getSchemaVersion(DbUtil.java:189) at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.checkVersionDoFail(EntityManagerFactoryBean.java:269) at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:127) at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:65) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142) ... 22 more
... View more
Labels:
