Member since
06-20-2016
308
Posts
103
Kudos Received
29
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2081 | 09-19-2018 06:31 PM | |
1541 | 09-13-2018 09:33 PM | |
1529 | 09-04-2018 05:29 PM | |
4706 | 08-27-2018 04:33 PM | |
3629 | 08-22-2018 07:46 PM |
07-19-2017
12:10 PM
1 Kudo
Run the following commands postgres user(super user) : To check the db total size:- (before and after comparision)
SELECT pg_size_pretty( pg_database_size('ambari')); vacuum full;
reindex database ambari;
SELECT pg_size_pretty( pg_database_size('ambari'));
... View more
07-25-2018
07:17 PM
read alsto about a limitation of Python..
... View more
09-26-2018
08:15 PM
There's a typo in the Step 1 command line - you need a space between the closing single quote and the Ambari URL. Also please be advised that I just encountered this issue in both Ambari 2.6.0.0 and 2.6.2.2. YMMV.
... View more
04-20-2017
12:59 PM
How to increase Read time out value from Ambari stand alone view server to Ambari main server Stand alone Ambari view server makes below call to fetch configurations from Remote server. http://REMOTEAMBARI:8080/api/v1/clusters/CLUSTER_NAME?fields=services/ServiceInfo,hosts,Clusters If this takes more than 10 seconds you will be exception in the logs. because of that non of the views would work. Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:170)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
at java.io.BufferedInputStream.read1(BufferedInputStream.java:286)
at java.io.BufferedInputStream.read(BufferedInputStream.java:345)
at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:704)
at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:647)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1536)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
at org.apache.ambari.server.controller.internal.URLStreamProvider.processURL(URLStreamProvider.java:218)
at org.apache.ambari.server.controller.internal.URLStreamProvider.processURL(URLStreamProvider.java:142)
at org.apache.ambari.server.view.RemoteAmbariStreamProvider.readFrom(RemoteAmbariStreamProvider.java:67)
at org.apache.ambari.server.view.RemoteAmbariCluster.readFromUrlJSON(RemoteAmbariCluster.java:297)
at org.apache.ambari.server.view.RemoteAmbariCluster.access$000(RemoteAmbariCluster.java:51)
at org.apache.ambari.server.view.RemoteAmbariCluster$1.load(RemoteAmbariCluster.java:83)
at org.apache.ambari.server.view.RemoteAmbariCluster$1.load(RemoteAmbariCluster.java:80)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3524)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2317)
... 109 more
Add the below configuration in Remote/Main Ambari server /etc/ambari-server/conf/ambari.properties file. please note that this needs Ambari-server restart. views.request.read.timeout.millis=20000 Note: This is tried and tested in Ambari-2.5.0.3 version
... View more
Labels:
05-09-2019
08:42 PM
Works like a charm!!
... View more
04-19-2017
11:34 PM
some times if you run some curl calls expecting to fix some other issues - it may turn out to that Ambari UI does not even load the UI. Running the below call would fix the issue and load the UI. curl -u admin:admin -i -H 'X-Requested-By: ambari' -X POST -d '{"wizard-data":"{\"userName\":\"admin\",\"controllerName\":\"\"}"}'http://AMBARIHOST:8080/api/v1/persist Note: Please note that these call should run with caution. contact Hortonworks support team. This is tried and tested with Ambari-2.4.x
... View more
Labels:
04-10-2017
07:51 PM
Hi @Ciarán Porter. There is a hotfix required for this issue. In the meantime you can use the beeline cli and send the output to a csv format. A good explanation is found here: https://community.hortonworks.com/questions/25789/how-to-dump-the-output-from-beeline.html
... View more
02-24-2017
08:51 PM
Steps to enable Trace logging in Ambari server for Oracle Database. Step1: 1. Download ojdbc6_g.jar from Oracle JDBC driver trace jar and copy to /usr/share/java and make sure to have correct permissions.
Note: take out the actual ojdbc.jar from the location. 2.Create /etc/ambari-server/conf/oracle.properties .level=ALL
oracle.jdbc.level=INFO
oracle.jdbc.handlers=java.util.logging.ConsoleHandler
java.util.logging.ConsoleHandler.level=INFO
java.util.logging.ConsoleHandler.formatter=java.util.logging.SimpleFormatter
3. Add "-Doracle.jdbc.Trace=true -Djava.util.logging.config.file=/etc/ambari-server/conf/oracle.properties" property in /var/lib/ambari-server/ambari-env.sh export AMBARI_JVM_ARGS=$AMBARI_JVM_ARGS' -Xms512m -Xmx2048m -XX:MaxPermSize=128m -Djava.security.auth.login.config=$ROOT/etc/ambari-server/conf/krb5JAASLogin.conf -Djav
to
export AMBARI_JVM_ARGS=$AMBARI_JVM_ARGS' -Xms512m -Xmx2048m -XX:MaxPermSize=128m -Doracle.jdbc.Trace=true -Djava.util.logging.config.file=/etc/ambari-server/conf/oracle.properties -Djava.security.auth.login.config=$ROOT/etc/ambari-server/conf/krb5JAASLogin.conf -Djav
After restart you will see logs being written to jdbc.log file
... View more
Labels:
04-17-2018
03:36 PM
Just a caution note:- When you are trying to set "server.jdbc.properties.loglevel=2", it adds additional database query logging and it should be enabled only when we troubleshoot performance issues. Advise to remove this property once the troubleshooting is over. We have seen 2x to 3x Ambari performance degradation when it is enabled.
... View more