Member since 
    
	
		
		
		06-20-2016
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                308
            
            
                Posts
            
        
                103
            
            
                Kudos Received
            
        
                29
            
            
                Solutions
            
        My Accepted Solutions
| Title | Views | Posted | 
|---|---|---|
| 2494 | 09-19-2018 06:31 PM | |
| 1877 | 09-13-2018 09:33 PM | |
| 1931 | 09-04-2018 05:29 PM | |
| 6444 | 08-27-2018 04:33 PM | |
| 4069 | 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
				
			
			
			
			
			
			
			
			
			
		 
        













