@Neeraj Sabharwal I am still facing the same issue, can you please help. Ambari version been used here is 2.2.2.0 with postgresql 9.2.18 on rhel 7. This happens to us most of the time. I have made sure that agents on all hosts are running and are pointing toward the ambari server, iptables, selinux are disabled. /etc/hosts are updated correctly. I am registering Ambari blueprint via API through Ansible and then cluster creation template also via API through Ansible in automated way. What could be the reason behind this? ... View more

I am also having same issue, the o/p of /usr/hdp/current/hive-server2-hive2/bin/schematool -dbType mysql -initSchema -verbose is as follows, SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/hdp/2.5.5.0-157/hive2/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/hdp/2.5.5.0-157/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Metastore connection URL: jdbc:derby:;databaseName=/var/lib/hive/metastore/metastore_db;create=true Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver Metastore connection User: APP Starting metastore schema initialization to 2.1.0 Initialization script hive-schema-2.1.0.mysql.sql Connecting to jdbc:derby:;databaseName=/var/lib/hive/metastore/metastore_db;create=true Connected to: Apache Derby (version 10.10.2.0 - (1582446)) Driver: Apache Derby Embedded JDBC Driver (version 10.10.2.0 - (1582446)) Transaction isolation: TRANSACTION_READ_COMMITTED 0: jdbc:derby:> !autocommit on Autocommit status: true 0: jdbc:derby:> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */ Error: Syntax error: Encountered "<EOF>" at line 1, column 64. (state=42X01,code Closing: 0: jdbc:derby:;databaseName=/var/lib/hive/metastore/metastore_db;create org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED Underlying cause: java.io.IOException : Schema script failed, errorcode 2 org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:304 at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:277 at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:526) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:233) at org.apache.hadoop.util.RunJar.main(RunJar.java:148) Caused by: java.io.IOException: Schema script failed, errorcode 2 at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:300 ... 8 more *** schemaTool failed *** What does this means?? ... View more

Hi Edgar, Do you think MySQL Router is needed when I setup MariaDb galera cluster? As MariaDb galera itself takes care of active server failover. ... View more

@Rahul Reddy. Thank you for the reply. So, these 3 journal nodes don't have to be installed on specific nodes with specific services installed or they can be installed on separate nodes altogether. Am I right? Also why do we need 3 zookeeper servers? ... View more

Hi Kuldeep, I have a question. What is the minimum number of journal nodes that are required for a cluster which is in namenode HA mode? From what I understand what the role of journal node is, only one or two should also be enough (even though in your example you have 3 journal nodes and even when I created a manual namenode HA cluster of 3 nodes, each node had a journal node totally again to 3 journal nodes) or is it that each node must have a journal node for example if I have 10 node cluster where I want to have NN HA enabled, will I require 10 journal nodes to be installed (one on each node)? ... View more

Hi, Kuldeep Kulkarni. I am trying to create cluster using ambari blueprint. But after registering blueprint and triggering cluster creation request successfully when I see progress in Ambari UI it stays stuck in PENDING HOST ASSIGNMENT which means that it is not able to connect or find hosts. But I have checked all the fqdn and ambari agents are also up and running. My approach is to store/ copy ambari.repo and hdp.repo in all hosts before hand so I have skipped step 4. What could be the problem???...please help!!! ... View more