<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question Re: Error add node into cluster in Archives of Support Questions (Read Only)</title>
    <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/Error-add-node-into-cluster/m-p/207297#M79013</link>
    <description>&lt;P&gt;&lt;EM&gt; &lt;A href="https://community.hortonworks.com/questions/194245/@FELIPE%20CABRAL"&gt;@FELIPE CABRAL&lt;/A&gt;&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;Your /etc/hosts should look like this in the below example I used &lt;STRONG&gt;192.168.0.124&lt;/STRONG&gt; as the IP of &lt;STRONG&gt;edcserver.domain&lt;/STRONG&gt; please use the appropriate IP&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;The first 2 lines shouldn't be tampered with &lt;/EM&gt;&lt;/P&gt;&lt;PRE&gt; # cat /etc/hosts
127.0.0.1 localhost localhost.localdomain
::1 localhost localhost.localdomain
192.168.0.124  edcserver.domain  edcserver&lt;/PRE&gt;&lt;P&gt;&lt;EM&gt;Now to overcome the error &lt;STRONG&gt;1 other registered host&lt;/STRONG&gt;  (screenshot &lt;A href="https://community.cloudera.com/legacyfs/online/attachments/77484-2018-05-31-18-09-36-window.png"&gt;2018-05-31-18-09-36-window.png&lt;/A&gt;)  you have to delete this entry from 2 tables &lt;STRONG&gt;hoststate&lt;/STRONG&gt; and &lt;STRONG&gt;hosts&lt;/STRONG&gt; in the Ambari database.&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;I have attached the procedure below, the assumption is as follows&lt;/EM&gt;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;&lt;EM&gt; Ambari database name = &lt;STRONG&gt;ambari&lt;/STRONG&gt;&lt;BR /&gt;&lt;/EM&gt;&lt;/LI&gt;&lt;LI&gt;&lt;EM&gt; Ambari database type= &lt;STRONG&gt;MySQL&lt;/STRONG&gt;&lt;BR /&gt;&lt;/EM&gt;&lt;/LI&gt;&lt;LI&gt;&lt;EM&gt; Ambari database password =&lt;STRONG&gt;Secret1234&lt;/STRONG&gt;&lt;BR /&gt;&lt;/EM&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&lt;EM&gt;If you are using postgres please adapt accordingly the SQL&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;&lt;EM&gt;Log on the DB&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;PRE&gt;# mysql -u root -pSecret1234 &lt;/PRE&gt;&lt;P&gt;&lt;EM&gt;some output here&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;&lt;EM&gt;Check the databases&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;PRE&gt;mysql&amp;gt; show databases; 
+--------------------+ 
| Database           | 
+--------------------+ 
| information_schema | 
| ambari             | 
| hive               | 
| mysql              | 
| oozie              | 
| ranger             | 
| rangerkms          | 
| test               | 
+--------------------+ 
8 rows in set (0.00 sec)&lt;/PRE&gt;&lt;P&gt;&lt;STRONG&gt;&lt;EM&gt;Connect to the Ambari database&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;PRE&gt;mysql&amp;gt; use ambari; 
Reading table information for completion of table and column names 
You can turn off this feature to get a quicker startup with -A 
Database changed &lt;/PRE&gt;&lt;P&gt;&lt;EM&gt;Check the structure if hoststate table  we need to delete the &lt;STRONG&gt;host_id&lt;/STRONG&gt;&lt;/EM&gt;&lt;/P&gt;&lt;PRE&gt;mysql&amp;gt; describe hoststate; 
+-------------------+--------------+------+-----+---------+-------+ 
| Field | Type | Null | Key | Default | Extra | 
+-------------------+--------------+------+-----+---------+-------+ 
| agent_version | varchar(255) | NO | | NULL | | 
| available_mem | bigint(20) | NO | | NULL | | 
| current_state     | varchar(255) | NO   |     | NULL    |       | 
| health_status     | varchar(255) | YES  |     | NULL    |       | 
| host_id           | bigint(20)   | NO   | PRI | NULL    |       | 
| time_in_state     | bigint(20)   | NO   |     | NULL    |       | 
| maintenance_state | varchar(512) | YES  |     | NULL    |       | 
+-------------------+--------------+------+-----+---------+-------+ 
7 rows in set (0.03 sec) 
mysql&amp;gt; select host_id from hoststate; 
+---------+ 
| host_id | 
+---------+ 
| 1       | 
+---------+ 
1 row in set (0.04 sec) 
mysql&amp;gt; Delete from hoststate where host_id=1; 
Query OK, 1 rows affected (0.00 sec) &lt;/PRE&gt;&lt;P&gt;&lt;EM&gt;Check the hosts table&lt;/EM&gt;&lt;/P&gt;&lt;PRE&gt;mysql&amp;gt; describe hosts; 
+------------------------+---------------+------+-----+---------+-------+ 
| Field 		 | Type 	 | Null | Key | Default | Extra | 
+------------------------+---------------+------+-----+---------+-------+ 
| host_id 		 | bigint(20) 	 | NO 	| PRI | NULL 	| 	| 
| host_name 		 | varchar(255)  | NO 	| UNI | NULL 	| 	| 
| cpu_count 		 | int(11) 	 | NO 	|     | NULL    |       | 
| cpu_info  		 | varchar(255)  | NO   |     | NULL    |       | 
| discovery_status 	 | varchar(2000) | NO   |     | NULL    |       | 
| host_attributes 	 | longtext 	 | NO   |     | NULL    |       | 
| ipv4 			 | varchar(255)  | YES  |     | NULL    |       | 
| ipv6 			 | varchar(255)  | YES  |     | NULL    |       | 
| last_registration_time | bigint(20)    | NO   |     | NULL    |       | 
| os_arch 		 | varchar(255)  | NO   |     | NULL    |       | 
| os_info 		 | varchar(1000) | NO   |     | NULL    |       | 
| os_type 		 | varchar(255)  | NO   |     | NULL    |       | 
| ph_cpu_count 		 | int(11)       | YES  |     | NULL    |       | 
| public_host_name 	 | varchar(255)  | YES  |     | NULL    |       | 
| rack_info 		 | varchar(255)  | NO   |     | NULL    |       | 
| total_mem 		 | bigint(20)    | NO   |     | NULL    |       | 
+------------------------+---------------+------+-----+---------+-------+ 
16 rows in set (0.02 sec) &lt;/PRE&gt;&lt;P&gt;&lt;EM&gt;Retrieve and delete the host with the matching id 1&lt;/EM&gt;&lt;/P&gt;&lt;PRE&gt;mysql&amp;gt; select host_id from hosts; 
+---------+ 
| host_id | 
+---------+ 
| 1 	  | 
+---------+ 
1 row in set (0.00 sec) 
mysql&amp;gt; Delete from hoststate where host_id=1; 
Query OK, 1 rows affected (0.00 sec)&lt;/PRE&gt;&lt;P&gt;&lt;EM&gt;And restart ambari-server and proceed with the registration all should be fine.&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;Please revert  &lt;I&gt;If you found this answer addressed your question, please take a moment to log 
in and click the "accept" link on the answer.&lt;/I&gt;&lt;/EM&gt;&lt;I&gt;&lt;/I&gt;&lt;/P&gt;</description>
    <pubDate>Fri, 01 Jun 2018 05:39:44 GMT</pubDate>
    <dc:creator>Shelton</dc:creator>
    <dc:date>2018-06-01T05:39:44Z</dc:date>
    <item>
      <title>Error add node into cluster</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/Error-add-node-into-cluster/m-p/207294#M79010</link>
      <description>&lt;P&gt;Folks,
After spend a little days trying install my fisrt ambari-server, I decided ask a little help &lt;span class="lia-unicode-emoji" title=":slightly_smiling_face:"&gt;🙂&lt;/span&gt; &lt;/P&gt;&lt;P&gt;I have done all requeried procedures into installation guide but, when add a node, de process stay in preparing.&lt;/P&gt;&lt;P&gt;
It is normal spend a lot of time to do ? I stayed 24 hours waiting the the process finish but not happened. &lt;/P&gt;&lt;P&gt;The follow the the imagens of configuration procedure. &lt;/P&gt;&lt;P&gt;&lt;A href="https://i.imgur.com/aAVCSzV.png" target="_blank"&gt;https://i.imgur.com/aAVCSzV.png&lt;/A&gt;&lt;/P&gt;&lt;P&gt;
&lt;A href="https://i.imgur.com/gPbVR4U.png" target="_blank"&gt;https://i.imgur.com/gPbVR4U.png&lt;/A&gt;&lt;/P&gt;&lt;P&gt;
&lt;A href="https://i.imgur.com/M99Jugd.png" target="_blank"&gt;https://i.imgur.com/M99Jugd.png&lt;/A&gt; &lt;/P&gt;&lt;P&gt;&lt;A href="https://i.imgur.com/UMcB3BG.png" target="_blank"&gt;https://i.imgur.com/UMcB3BG.png&lt;/A&gt; &lt;/P&gt;&lt;P&gt;The previus configuration (done): &lt;/P&gt;&lt;P&gt;SSH PublicKey - OK&lt;/P&gt;&lt;P&gt;
Disable Firewall - OK &lt;/P&gt;&lt;P&gt;Disable Iptables - OK &lt;/P&gt;&lt;P&gt;Include ip into hosts file - OK &lt;/P&gt;&lt;P&gt;Install amabi-server - OK &lt;/P&gt;&lt;P&gt;Install amabi-agent - OK &lt;/P&gt;&lt;P&gt;Someone can give me some tip or trick about what i do wrong? Or how i can solve my problem.&lt;/P&gt;&lt;P&gt;Thanks so much folks!&lt;/P&gt;&lt;P&gt;The unique message that are showed into log: &lt;/P&gt;&lt;P&gt;tail server log: &lt;/P&gt;&lt;PRE&gt;31 May 2018 14:23:54,071  INFO [ambari-client-thread-34] AmbariMetaInfo:1449 - Stack HDP-2.3 is not active, skipping VDF
31 May 2018 14:23:54,071  INFO [ambari-client-thread-34] AmbariMetaInfo:1449 - Stack HDP-2.2 is not active, skipping VDF
31 May 2018 14:23:54,071  INFO [ambari-client-thread-34] AmbariMetaInfo:1449 - Stack HDP-2.1 is not active, skipping VDF
31 May 2018 14:23:54,071  INFO [ambari-client-thread-34] AmbariMetaInfo:1449 - Stack HDP-2.0 is not active, skipping VDF
31 May 2018 14:23:54,071  INFO [ambari-client-thread-34] AmbariMetaInfo:1449 - Stack BigInsights-4.2 is not active, skipping VDF
31 May 2018 14:24:01,847  INFO [Thread-23] AbstractPoolBackedDataSource:212 - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -&amp;gt; 3, acquireRetryAttempts -&amp;gt; 30, acquireRetryDelay -&amp;gt; 1000, autoCommitOnClose -&amp;gt; false, automaticTestTable -&amp;gt; null, breakAfterAcquireFailure -&amp;gt; false, checkoutTimeout -&amp;gt; 0, connectionCustomizerClassName -&amp;gt; null, connectionTesterClassName -&amp;gt; com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -&amp;gt; caller, dataSourceName -&amp;gt; z8kflt9v1ewa6kzjcpa2f|2a9f7572, debugUnreturnedConnectionStackTraces -&amp;gt; false, description -&amp;gt; null, driverClass -&amp;gt; org.postgresql.Driver, extensions -&amp;gt; {}, factoryClassLocation -&amp;gt; null, forceIgnoreUnresolvedTransactions -&amp;gt; false, forceSynchronousCheckins -&amp;gt; false, forceUseNamedDriverClass -&amp;gt; false, identityToken -&amp;gt; z8kflt9v1ewa6kzjcpa2f|2a9f7572, idleConnectionTestPeriod -&amp;gt; 50, initialPoolSize -&amp;gt; 3, jdbcUrl -&amp;gt; jdbc:postgresql://localhost/ambari, maxAdministrativeTaskTime -&amp;gt; 0, maxConnectionAge -&amp;gt; 0, maxIdleTime -&amp;gt; 0, maxIdleTimeExcessConnections -&amp;gt; 0, maxPoolSize -&amp;gt; 5, maxStatements -&amp;gt; 0, maxStatementsPerConnection -&amp;gt; 120, minPoolSize -&amp;gt; 1, numHelperThreads -&amp;gt; 3, preferredTestQuery -&amp;gt; select 0, privilegeSpawnedThreads -&amp;gt; false, properties -&amp;gt; {user=******, password=******}, propertyCycle -&amp;gt; 0, statementCacheNumDeferredCloseThreads -&amp;gt; 0, testConnectionOnCheckin -&amp;gt; true, testConnectionOnCheckout -&amp;gt; false, unreturnedConnectionTimeout -&amp;gt; 0, userOverrides -&amp;gt; {}, usesTraditionalReflectiveProxies -&amp;gt; false ]
31 May 2018 14:24:01,902  INFO [Thread-23] JobStoreTX:861 - Freed 0 triggers from 'acquired' / 'blocked' state.
31 May 2018 14:24:01,910  INFO [Thread-23] JobStoreTX:871 - Recovering 0 jobs that were in-progress at the time of the last shut-down.
31 May 2018 14:24:01,910  INFO [Thread-23] JobStoreTX:884 - Recovery complete.
31 May 2018 14:24:01,910  INFO [Thread-23] JobStoreTX:891 - Removed 0 'complete' triggers.
31 May 2018 14:24:01,911  INFO [Thread-23] JobStoreTX:896 - Removed 0 stale fired job entries.
31 May 2018 14:24:01,912  INFO [Thread-23] QuartzScheduler:575 - Scheduler ExecutionScheduler_$_NON_CLUSTERED started.
31 May 2018 14:26:35,107  INFO [ambari-client-thread-33] BootStrapImpl:108 - BootStrapping hosts localhost:
31 May 2018 14:26:35,122  INFO [Thread-31] BSRunner:189 - Kicking off the scheduler for polling on logs in /var/run/ambari-server/bootstrap/1
31 May 2018 14:26:35,122  INFO [Thread-31] BSRunner:372 - Error executing bootstrap Cannot create /var/run/ambari-server/bootstrap
31 May 2018 14:26:35,122 ERROR [Thread-31] BSRunner:441 - java.io.FileNotFoundException: /var/run/ambari-server/bootstrap/1/localhost.done (No such file or directory)
31 May 2018 14:26:35,123  WARN [Thread-31] BSRunner:401 - File does not exist: /var/run/ambari-server/bootstrap/1/sshKey
31 May 2018 14:27:01,846  INFO [pool-18-thread-1] MetricsServiceImpl:65 - Attempting to initialize metrics sink
31 May 2018 14:27:01,847  INFO [pool-18-thread-1] MetricsServiceImpl:81 - ********* Configuring Metric Sink **********
31 May 2018 14:27:01,847  INFO [pool-18-thread-1] AmbariMetricSinkImpl:95 - No clusters configured.
31 May 2018 14:32:01,848  INFO [pool-18-thread-1] MetricsServiceImpl:65 - Attempting to initialize metrics sink
31 May 2018 14:32:01,849  INFO [pool-18-thread-1] MetricsServiceImpl:81 - ********* Configuring Metric Sink **********
31 May 2018 14:32:01,849  INFO [pool-18-thread-1] AmbariMetricSinkImpl:95 - No clusters configured.
31 May 2018 14:37:01,853  INFO [pool-18-thread-1] MetricsServiceImpl:65 - Attempting to initialize metrics sink
31 May 2018 14:37:01,853  INFO [pool-18-thread-1] MetricsServiceImpl:81 - ********* Configuring Metric Sink **********
31 May 2018 14:37:01,853  INFO [pool-18-thread-1] AmbariMetricSinkImpl:95 - No clusters configured.
31 May 2018 14:42:01,855  INFO [pool-18-thread-1] MetricsServiceImpl:65 - Attempting to initialize metrics sink
31 May 2018 14:42:01,855  INFO [pool-18-thread-1] MetricsServiceImpl:81 - ********* Configuring Metric Sink **********
31 May 2018 14:42:01,856  INFO [pool-18-thread-1] AmbariMetricSinkImpl:95 - No clusters configured.
31 May 2018 14:47:01,859  INFO [pool-18-thread-1] MetricsServiceImpl:65 - Attempting to initialize metrics sink
31 May 2018 14:47:01,859  INFO [pool-18-thread-1] MetricsServiceImpl:81 - ********* Configuring Metric Sink **********
31 May 2018 14:47:01,859  INFO [pool-18-thread-1] AmbariMetricSinkImpl:95 - No clusters configured. &lt;/PRE&gt;&lt;P&gt;tail agent log: &lt;/P&gt;&lt;PRE&gt;INFO 2018-05-31 14:22:58,839 NetUtil.py:70 - Connecting to &lt;A href="https://edcserver.domain:8440/connection_info" target="_blank"&gt;https://edcserver.domain:8440/connection_info&lt;/A&gt;
INFO 2018-05-31 14:22:58,896 security.py:93 - SSL Connect being called.. connecting to the server
INFO 2018-05-31 14:22:58,938 security.py:60 - SSL connection established. Two-way SSL authentication is turned off on the server.
INFO 2018-05-31 14:22:59,011 Controller.py:196 - Registration Successful (response id = 0)
INFO 2018-05-31 14:22:59,012 AmbariConfig.py:316 - Updating config property (agent.check.remote.mounts) with value (false)
INFO 2018-05-31 14:22:59,012 AmbariConfig.py:316 - Updating config property (agent.auto.cache.update) with value (true)
INFO 2018-05-31 14:22:59,012 AmbariConfig.py:316 - Updating config property (java.home) with value (/usr/jdk64/jdk1.8.0_112)
INFO 2018-05-31 14:22:59,012 AmbariConfig.py:316 - Updating config property (agent.check.mounts.timeout) with value (0)
WARNING 2018-05-31 14:22:59,012 AlertSchedulerHandler.py:123 - There are no alert definition commands in the heartbeat; unable to update definitions
INFO 2018-05-31 14:22:59,012 Controller.py:516 - Registration response from edcserver.domain was OK
INFO 2018-05-31 14:22:59,012 Controller.py:521 - Resetting ActionQueue...
INFO 2018-05-31 14:23:09,016 Controller.py:304 - Heartbeat (response id = 0) with server is running...
INFO 2018-05-31 14:23:09,016 Controller.py:311 - Building heartbeat message
INFO 2018-05-31 14:23:09,017 Heartbeat.py:87 - Adding host info/state to heartbeat message.
INFO 2018-05-31 14:23:09,079 logger.py:75 - Testing the JVM's JCE policy to see it if supports an unlimited key length.
INFO 2018-05-31 14:23:09,259 Hardware.py:188 - Some mount points were ignored: /dev/shm, /run, /sys/fs/cgroup, /run/user/42, /run/user/0
INFO 2018-05-31 14:23:09,260 Controller.py:320 - Sending Heartbeat (id = 0)
INFO 2018-05-31 14:23:09,267 Controller.py:333 - Heartbeat response received (id = 1)
INFO 2018-05-31 14:23:09,268 Controller.py:342 - Heartbeat interval is 10 seconds
INFO 2018-05-31 14:23:09,268 Controller.py:380 - Updating configurations from heartbeat
INFO 2018-05-31 14:23:09,268 Controller.py:389 - Adding cancel/execution commands
INFO 2018-05-31 14:23:09,268 Controller.py:406 - Adding recovery commands
INFO 2018-05-31 14:23:09,268 Controller.py:475 - Waiting 9.9 for next heartbeat
INFO 2018-05-31 14:23:19,169 Controller.py:482 - Wait for next heartbeat over
INFO 2018-05-31 14:24:18,661 Controller.py:304 - Heartbeat (response id = 7) with server is running...
INFO 2018-05-31 14:24:18,661 Controller.py:311 - Building heartbeat message
INFO 2018-05-31 14:24:18,665 Heartbeat.py:87 - Adding host info/state to heartbeat message.
INFO 2018-05-31 14:24:18,753 logger.py:75 - Testing the JVM's JCE policy to see it if supports an unlimited key length.
INFO 2018-05-31 14:24:18,893 Hardware.py:188 - Some mount points were ignored: /dev/shm, /run, /sys/fs/cgroup, /run/user/42, /run/user/0
INFO 2018-05-31 14:24:18,893 Controller.py:320 - Sending Heartbeat (id = 7)
INFO 2018-05-31 14:24:18,896 Controller.py:333 - Heartbeat response received (id = 8)
INFO 2018-05-31 14:24:18,896 Controller.py:342 - Heartbeat interval is 10 seconds
INFO 2018-05-31 14:24:18,896 Controller.py:380 - Updating configurations from heartbeat
INFO 2018-05-31 14:24:18,896 Controller.py:389 - Adding cancel/execution commands
INFO 2018-05-31 14:24:18,896 Controller.py:406 - Adding recovery commands
INFO 2018-05-31 14:24:18,896 Controller.py:475 - Waiting 9.9 for next heartbeat
INFO 2018-05-31 14:24:28,797 Controller.py:482 - Wait for next heartbeat over
INFO 2018-05-31 14:25:28,275 Controller.py:304 - Heartbeat (response id = 14) with server is running...
INFO 2018-05-31 14:25:28,276 Controller.py:311 - Building heartbeat message
INFO 2018-05-31 14:25:28,279 Heartbeat.py:87 - Adding host info/state to heartbeat message.
INFO 2018-05-31 14:25:28,381 logger.py:75 - Testing the JVM's JCE policy to see it if supports an unlimited key length.
INFO 2018-05-31 14:25:28,507 Hardware.py:188 - Some mount points were ignored: /dev/shm, /run, /sys/fs/cgroup, /run/user/42, /run/user/0
INFO 2018-05-31 14:25:28,507 Controller.py:320 - Sending Heartbeat (id = 14)
INFO 2018-05-31 14:25:28,511 Controller.py:333 - Heartbeat response received (id = 15)
INFO 2018-05-31 14:25:28,511 Controller.py:342 - Heartbeat interval is 10 seconds
INFO 2018-05-31 14:25:28,511 Controller.py:380 - Updating configurations from heartbeat
INFO 2018-05-31 14:25:28,511 Controller.py:389 - Adding cancel/execution commands
INFO 2018-05-31 14:25:28,511 Controller.py:406 - Adding recovery commands
INFO 2018-05-31 14:25:28,511 Controller.py:475 - Waiting 9.9 for next heartbeat
INFO 2018-05-31 14:25:38,412 Controller.py:482 - Wait for next heartbeat over
INFO 2018-05-31 14:26:37,884 Controller.py:304 - Heartbeat (response id = 21) with server is running...
INFO 2018-05-31 14:26:37,884 Controller.py:311 - Building heartbeat message
INFO 2018-05-31 14:26:37,889 Heartbeat.py:87 - Adding host info/state to heartbeat message.
INFO 2018-05-31 14:26:37,984 logger.py:75 - Testing the JVM's JCE policy to see it if supports an unlimited key length.
INFO 2018-05-31 14:26:38,138 Hardware.py:188 - Some mount points were ignored: /dev/shm, /run, /sys/fs/cgroup, /run/user/42, /run/user/0
INFO 2018-05-31 14:26:38,139 Controller.py:320 - Sending Heartbeat (id = 21)
INFO 2018-05-31 14:26:38,141 Controller.py:333 - Heartbeat response received (id = 22)
INFO 2018-05-31 14:26:38,141 Controller.py:342 - Heartbeat interval is 10 seconds
INFO 2018-05-31 14:26:38,142 Controller.py:380 - Updating configurations from heartbeat
INFO 2018-05-31 14:26:38,142 Controller.py:389 - Adding cancel/execution commands
INFO 2018-05-31 14:26:38,142 Controller.py:406 - Adding recovery commands
INFO 2018-05-31 14:26:38,142 Controller.py:475 - Waiting 9.9 for next heartbeat
INFO 2018-05-31 14:26:48,043 Controller.py:482 - Wait for next heartbeat over
INFO 2018-05-31 14:27:47,512 Controller.py:304 - Heartbeat (response id = 28) with server is running...
INFO 2018-05-31 14:27:47,512 Controller.py:311 - Building heartbeat message
INFO 2018-05-31 14:27:47,516 Heartbeat.py:87 - Adding host info/state to heartbeat message.
INFO 2018-05-31 14:27:47,650 logger.py:75 - Testing the JVM's JCE policy to see it if supports an unlimited key length.
INFO 2018-05-31 14:27:47,808 Hardware.py:188 - Some mount points were ignored: /dev/shm, /run, /sys/fs/cgroup, /run/user/42, /run/user/0
INFO 2018-05-31 14:27:47,809 Controller.py:320 - Sending Heartbeat (id = 28)
INFO 2018-05-31 14:27:47,811 Controller.py:333 - Heartbeat response received (id = 29)
INFO 2018-05-31 14:27:47,811 Controller.py:342 - Heartbeat interval is 10 seconds
INFO 2018-05-31 14:27:47,811 Controller.py:380 - Updating configurations from heartbeat
INFO 2018-05-31 14:27:47,811 Controller.py:389 - Adding cancel/execution commands
INFO 2018-05-31 14:27:47,811 Controller.py:406 - Adding recovery commands
INFO 2018-05-31 14:27:47,811 Controller.py:475 - Waiting 9.9 for next heartbeat
INFO 2018-05-31 14:27:57,714 Controller.py:482 - Wait for next heartbeat over
INFO 2018-05-31 14:28:57,189 Controller.py:304 - Heartbeat (response id = 35) with server is running...
INFO 2018-05-31 14:28:57,189 Controller.py:311 - Building heartbeat message
INFO 2018-05-31 14:28:57,193 Heartbeat.py:87 - Adding host info/state to heartbeat message.
INFO 2018-05-31 14:28:57,379 logger.py:75 - Testing the JVM's JCE policy to see it if supports an unlimited key length.
INFO 2018-05-31 14:28:57,558 Hardware.py:188 - Some mount points were ignored: /dev/shm, /run, /sys/fs/cgroup, /run/user/42, /run/user/0
INFO 2018-05-31 14:28:57,558 Controller.py:320 - Sending Heartbeat (id = 35)
INFO 2018-05-31 14:28:57,561 Controller.py:333 - Heartbeat response received (id = 36)
INFO 2018-05-31 14:28:57,561 Controller.py:342 - Heartbeat interval is 10 seconds
INFO 2018-05-31 14:28:57,561 Controller.py:380 - Updating configurations from heartbeat
INFO 2018-05-31 14:28:57,561 Controller.py:389 - Adding cancel/execution commands
INFO 2018-05-31 14:28:57,561 Controller.py:406 - Adding recovery commands
INFO 2018-05-31 14:28:57,561 Controller.py:475 - Waiting 9.9 for next heartbeat
INFO 2018-05-31 14:29:07,462 Controller.py:482 - Wait for next heartbeat over&lt;/PRE&gt;</description>
      <pubDate>Fri, 01 Jun 2018 02:04:33 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/Error-add-node-into-cluster/m-p/207294#M79010</guid>
      <dc:creator>felipescabral</dc:creator>
      <dc:date>2018-06-01T02:04:33Z</dc:date>
    </item>
    <item>
      <title>Re: Error add node into cluster</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/Error-add-node-into-cluster/m-p/207295#M79011</link>
      <description>&lt;P&gt;&lt;EM&gt;&lt;A href="@FELIPE CABRAL"&gt; @FELIPE CABRAL&lt;/A&gt;&lt;BR /&gt;&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;Can you share the entry of your /&lt;STRONG&gt;etc/hosts&lt;/STRONG&gt; on the Ambari server?&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;&lt;STRONG&gt;Select Version &lt;/STRONG&gt;&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;Can you remove the repositories that doesn't match  your node either the Redppc7 or Redhat &lt;BR /&gt;&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;&lt;EM&gt;Install Option&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;Please use the &lt;STRONG&gt;FQDN&lt;/STRONG&gt; rather than localhost, see the output of below command&lt;/EM&gt;&lt;/P&gt;&lt;PRE&gt;# hostname -f&lt;/PRE&gt;&lt;P&gt;&lt;EM&gt;Please revert&lt;/EM&gt;&lt;/P&gt;</description>
      <pubDate>Fri, 01 Jun 2018 02:39:01 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/Error-add-node-into-cluster/m-p/207295#M79011</guid>
      <dc:creator>Shelton</dc:creator>
      <dc:date>2018-06-01T02:39:01Z</dc:date>
    </item>
    <item>
      <title>Re: Error add node into cluster</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/Error-add-node-into-cluster/m-p/207296#M79012</link>
      <description>&lt;P&gt;&lt;A rel="user" href="https://community.cloudera.com/users/1271/sheltong.html" nodeid="1271"&gt;@Geoffrey Shelton Okot&lt;/A&gt; thanks a lot by you attention&lt;BR /&gt; &lt;/P&gt;&lt;P&gt;So... a stranger thing happen when I confere the result of the command that you ask to do. Differents names was showed to me.&lt;/P&gt;&lt;P&gt;I modified some things and now looks right.&lt;/P&gt;&lt;P&gt;Print screens&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.cloudera.com/legacyfs/online/attachments/77483-2018-05-31-18-03-10-window.png"&gt;2018-05-31-18-03-10-window.png&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.cloudera.com/legacyfs/online/attachments/77478-2018-05-31-18-06-52-window.png"&gt;2018-05-31-18-06-52-window.png&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.cloudera.com/legacyfs/online/attachments/77479-2018-05-31-18-09-07-window.png"&gt;2018-05-31-18-09-07-window.png&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.cloudera.com/legacyfs/online/attachments/77480-2018-05-31-18-09-22-window.png"&gt;2018-05-31-18-09-22-window.png&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.cloudera.com/legacyfs/online/attachments/77484-2018-05-31-18-09-36-window.png"&gt;2018-05-31-18-09-36-window.png&lt;/A&gt;&lt;/P&gt;&lt;P&gt;How you can see, the modifications and new test failed. The same behavior continue happen.&lt;/P&gt;&lt;P&gt;You can see in the last print (&lt;A href="https://community.cloudera.com/legacyfs/online/attachments/77484-2018-05-31-18-09-36-window.png"&gt;2018-05-31-18-09-36-window.png&lt;/A&gt;) the locahost.localdomain was identified. I don't know where it can influence my process.&lt;/P&gt;&lt;P&gt;Existe some attention point that was done wrong? Just ambari-server and agent need be installed?&lt;/P&gt;&lt;P&gt;-----------------------------------------------------&lt;/P&gt;&lt;P&gt;Computer configuration&lt;/P&gt;&lt;P&gt;Centos 7&lt;/P&gt;&lt;P&gt;16gb ram&lt;/P&gt;&lt;P&gt;4 core&lt;/P&gt;&lt;P&gt;--------------------------------------------------------&lt;/P&gt;&lt;P&gt;Follow the command result and files that you ask:&lt;/P&gt;&lt;PRE&gt;─
[2018-05-31 17:57.23]  ~/Desktop/chaves
[felip.DESKTOP-183A5DG] ➤ ssh -i id_rsa_root root@192.168.15.205
Last login: Thu May 31 16:57:14 2018 from desktop-183a5dg
[root@edcserver ~]# hostname -f
edcserver
[root@edcserver ~]# hostnamectl status
   Static hostname: edcserver.domain
         Icon name: computer-vm
           Chassis: vm
        Machine ID: e53f426a62744fd7b2c4b7dada89308f
           Boot ID: db8f48d7be7a46249b7c65b224328300
    Virtualization: vmware
  Operating System: CentOS Linux 7 (Core)
       CPE OS Name: cpe:/o:centos:centos:7
            Kernel: Linux 3.10.0-862.3.2.el7.x86_64
      Architecture: x86-64
[root@edcserver ~]#&lt;/PRE&gt;&lt;P&gt;ambari-agent config:&lt;/P&gt;&lt;PRE&gt;#     &lt;A href="http://www.apache.org/licenses/LICENSE-2.0" target="_blank"&gt;http://www.apache.org/licenses/LICENSE-2.0&lt;/A&gt;
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific
[server]
hostname=edcserver.domain
url_port=8440
secured_url_port=8441
connect_retry_delay=10
max_reconnect_retry_delay=30
[agent]
logdir=/var/log/ambari-agent
piddir=/var/run/ambari-agent
prefix=/var/lib/ambari-agent/data
;loglevel=(DEBUG/INFO)
loglevel=INFO
data_cleanup_interval=86400&lt;/PRE&gt;&lt;P&gt;/etc/hosts:&lt;/P&gt;&lt;PRE&gt;[root@edcserver ~]# cat /etc/hosts
127.0.0.1 edcserver edcserver.domain localhost localhost.localdomain
::1 edcserver edcserver.domain localhost localhost.localdomain

&lt;/PRE&gt;</description>
      <pubDate>Fri, 01 Jun 2018 04:27:13 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/Error-add-node-into-cluster/m-p/207296#M79012</guid>
      <dc:creator>felipescabral</dc:creator>
      <dc:date>2018-06-01T04:27:13Z</dc:date>
    </item>
    <item>
      <title>Re: Error add node into cluster</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/Error-add-node-into-cluster/m-p/207297#M79013</link>
      <description>&lt;P&gt;&lt;EM&gt; &lt;A href="https://community.hortonworks.com/questions/194245/@FELIPE%20CABRAL"&gt;@FELIPE CABRAL&lt;/A&gt;&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;Your /etc/hosts should look like this in the below example I used &lt;STRONG&gt;192.168.0.124&lt;/STRONG&gt; as the IP of &lt;STRONG&gt;edcserver.domain&lt;/STRONG&gt; please use the appropriate IP&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;The first 2 lines shouldn't be tampered with &lt;/EM&gt;&lt;/P&gt;&lt;PRE&gt; # cat /etc/hosts
127.0.0.1 localhost localhost.localdomain
::1 localhost localhost.localdomain
192.168.0.124  edcserver.domain  edcserver&lt;/PRE&gt;&lt;P&gt;&lt;EM&gt;Now to overcome the error &lt;STRONG&gt;1 other registered host&lt;/STRONG&gt;  (screenshot &lt;A href="https://community.cloudera.com/legacyfs/online/attachments/77484-2018-05-31-18-09-36-window.png"&gt;2018-05-31-18-09-36-window.png&lt;/A&gt;)  you have to delete this entry from 2 tables &lt;STRONG&gt;hoststate&lt;/STRONG&gt; and &lt;STRONG&gt;hosts&lt;/STRONG&gt; in the Ambari database.&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;I have attached the procedure below, the assumption is as follows&lt;/EM&gt;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;&lt;EM&gt; Ambari database name = &lt;STRONG&gt;ambari&lt;/STRONG&gt;&lt;BR /&gt;&lt;/EM&gt;&lt;/LI&gt;&lt;LI&gt;&lt;EM&gt; Ambari database type= &lt;STRONG&gt;MySQL&lt;/STRONG&gt;&lt;BR /&gt;&lt;/EM&gt;&lt;/LI&gt;&lt;LI&gt;&lt;EM&gt; Ambari database password =&lt;STRONG&gt;Secret1234&lt;/STRONG&gt;&lt;BR /&gt;&lt;/EM&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&lt;EM&gt;If you are using postgres please adapt accordingly the SQL&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;&lt;EM&gt;Log on the DB&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;PRE&gt;# mysql -u root -pSecret1234 &lt;/PRE&gt;&lt;P&gt;&lt;EM&gt;some output here&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;&lt;EM&gt;Check the databases&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;PRE&gt;mysql&amp;gt; show databases; 
+--------------------+ 
| Database           | 
+--------------------+ 
| information_schema | 
| ambari             | 
| hive               | 
| mysql              | 
| oozie              | 
| ranger             | 
| rangerkms          | 
| test               | 
+--------------------+ 
8 rows in set (0.00 sec)&lt;/PRE&gt;&lt;P&gt;&lt;STRONG&gt;&lt;EM&gt;Connect to the Ambari database&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;PRE&gt;mysql&amp;gt; use ambari; 
Reading table information for completion of table and column names 
You can turn off this feature to get a quicker startup with -A 
Database changed &lt;/PRE&gt;&lt;P&gt;&lt;EM&gt;Check the structure if hoststate table  we need to delete the &lt;STRONG&gt;host_id&lt;/STRONG&gt;&lt;/EM&gt;&lt;/P&gt;&lt;PRE&gt;mysql&amp;gt; describe hoststate; 
+-------------------+--------------+------+-----+---------+-------+ 
| Field | Type | Null | Key | Default | Extra | 
+-------------------+--------------+------+-----+---------+-------+ 
| agent_version | varchar(255) | NO | | NULL | | 
| available_mem | bigint(20) | NO | | NULL | | 
| current_state     | varchar(255) | NO   |     | NULL    |       | 
| health_status     | varchar(255) | YES  |     | NULL    |       | 
| host_id           | bigint(20)   | NO   | PRI | NULL    |       | 
| time_in_state     | bigint(20)   | NO   |     | NULL    |       | 
| maintenance_state | varchar(512) | YES  |     | NULL    |       | 
+-------------------+--------------+------+-----+---------+-------+ 
7 rows in set (0.03 sec) 
mysql&amp;gt; select host_id from hoststate; 
+---------+ 
| host_id | 
+---------+ 
| 1       | 
+---------+ 
1 row in set (0.04 sec) 
mysql&amp;gt; Delete from hoststate where host_id=1; 
Query OK, 1 rows affected (0.00 sec) &lt;/PRE&gt;&lt;P&gt;&lt;EM&gt;Check the hosts table&lt;/EM&gt;&lt;/P&gt;&lt;PRE&gt;mysql&amp;gt; describe hosts; 
+------------------------+---------------+------+-----+---------+-------+ 
| Field 		 | Type 	 | Null | Key | Default | Extra | 
+------------------------+---------------+------+-----+---------+-------+ 
| host_id 		 | bigint(20) 	 | NO 	| PRI | NULL 	| 	| 
| host_name 		 | varchar(255)  | NO 	| UNI | NULL 	| 	| 
| cpu_count 		 | int(11) 	 | NO 	|     | NULL    |       | 
| cpu_info  		 | varchar(255)  | NO   |     | NULL    |       | 
| discovery_status 	 | varchar(2000) | NO   |     | NULL    |       | 
| host_attributes 	 | longtext 	 | NO   |     | NULL    |       | 
| ipv4 			 | varchar(255)  | YES  |     | NULL    |       | 
| ipv6 			 | varchar(255)  | YES  |     | NULL    |       | 
| last_registration_time | bigint(20)    | NO   |     | NULL    |       | 
| os_arch 		 | varchar(255)  | NO   |     | NULL    |       | 
| os_info 		 | varchar(1000) | NO   |     | NULL    |       | 
| os_type 		 | varchar(255)  | NO   |     | NULL    |       | 
| ph_cpu_count 		 | int(11)       | YES  |     | NULL    |       | 
| public_host_name 	 | varchar(255)  | YES  |     | NULL    |       | 
| rack_info 		 | varchar(255)  | NO   |     | NULL    |       | 
| total_mem 		 | bigint(20)    | NO   |     | NULL    |       | 
+------------------------+---------------+------+-----+---------+-------+ 
16 rows in set (0.02 sec) &lt;/PRE&gt;&lt;P&gt;&lt;EM&gt;Retrieve and delete the host with the matching id 1&lt;/EM&gt;&lt;/P&gt;&lt;PRE&gt;mysql&amp;gt; select host_id from hosts; 
+---------+ 
| host_id | 
+---------+ 
| 1 	  | 
+---------+ 
1 row in set (0.00 sec) 
mysql&amp;gt; Delete from hoststate where host_id=1; 
Query OK, 1 rows affected (0.00 sec)&lt;/PRE&gt;&lt;P&gt;&lt;EM&gt;And restart ambari-server and proceed with the registration all should be fine.&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;Please revert  &lt;I&gt;If you found this answer addressed your question, please take a moment to log 
in and click the "accept" link on the answer.&lt;/I&gt;&lt;/EM&gt;&lt;I&gt;&lt;/I&gt;&lt;/P&gt;</description>
      <pubDate>Fri, 01 Jun 2018 05:39:44 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/Error-add-node-into-cluster/m-p/207297#M79013</guid>
      <dc:creator>Shelton</dc:creator>
      <dc:date>2018-06-01T05:39:44Z</dc:date>
    </item>
    <item>
      <title>Re: Error add node into cluster</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/Error-add-node-into-cluster/m-p/207298#M79014</link>
      <description>&lt;P&gt;Nice!  now it works fine. &lt;/P&gt;&lt;P&gt;I got passed of installation part. But now, error message are showed when i try configure the service into te machine, follow.&lt;/P&gt;&lt;P&gt;
I have create the directory and give all permission to them, but not works. &lt;/P&gt;&lt;P&gt;&lt;A href="https://community.cloudera.com/legacyfs/online/attachments/77488-greenshot-2018-06-01-120718.png"&gt;greenshot-2018-06-01-120718.png&lt;/A&gt;&lt;/P&gt;&lt;P&gt;Other erros that are showed it just insert password to admin ou root database. I did it. But the HDFS and YARN can't do it.&lt;/P&gt;&lt;P&gt;Guy! It's works. The problem above question was the directory that can't initiate with '/home'!&lt;/P&gt;&lt;P&gt;I change this part and the installation continue.&lt;/P&gt;&lt;P&gt;Thanks so much!!! &lt;span class="lia-unicode-emoji" title=":slightly_smiling_face:"&gt;🙂&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Fri, 01 Jun 2018 22:29:59 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/Error-add-node-into-cluster/m-p/207298#M79014</guid>
      <dc:creator>felipescabral</dc:creator>
      <dc:date>2018-06-01T22:29:59Z</dc:date>
    </item>
  </channel>
</rss>

