cloudera - hive service is not starting getting error Failed initialising database? -
i have installed cloudera 4.6 on 4 node
while starting services getting error in hive logs
due issues skipped first run command , hive db not created
failed initialising database. fatal: password authentication failed user "hive" org.datanucleus.exceptions.nucleusdatastoreexception: fatal: password authentication failed user "hive" @ org.datanucleus.store.rdbms.connectionfactoryimpl$managedconnectionimpl.getconnection(connectionfactoryimpl.java:494) @ org.datanucleus.store.rdbms.rdbmsstoremanager.<init>(rdbmsstoremanager.java:304) @ sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method) @ sun.reflect.nativeconstructoraccessorimpl.newinstance(nativeconstructoraccessorimpl.java:39) @ sun.reflect.delegatingconstructoraccessorimpl.newinstance(delegatingconstructoraccessorimpl.java:27) @ java.lang.reflect.constructor.newinstance(constructor.java:513) @ org.datanucleus.plugin.nonmanagedpluginregistry.createexecutableextension(nonmanagedpluginregistry.java:631) @ org.datanucleus.plugin.pluginmanager.createexecutableextension(pluginmanager.java:301) @ org.datanucleus.nucleuscontext.createstoremanagerforproperties(nucleuscontext.java:1069) @ org.datanucleus.nucleuscontext.initialise(nucleuscontext.java:359) @ org.datanucleus.api.jdo.jdopersistencemanagerfactory.freezeconfiguration(jdopersistencemanagerfactory.java:768) @ org.datanucleus.api.jdo.jdopersistencemanagerfactory.createpersistencemanagerfactory(jdopersistencemanagerfactory.java:326) @ org.datanucleus.api.jdo.jdopersistencemanagerfactory.getpersistencemanagerfactory(jdopersistencemanagerfactory.java:195) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:39) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) @ java.lang.reflect.method.invoke(method.java:597) @ javax.jdo.jdohelper$16.run(jdohelper.java:1958) @ java.security.accesscontroller.doprivileged(native method) @ javax.jdo.jdohelper.invoke(jdohelper.java:1953) @ javax.jdo.jdohelper.invokegetpersistencemanagerfactoryonimplementation(jdohelper.java:1159) @ javax.jdo.jdohelper.getpersistencemanagerfactory(jdohelper.java:803) @ javax.jdo.jdohelper.getpersistencemanagerfactory(jdohelper.java:698) @ org.apache.hadoop.hive.metastore.objectstore.getpmf(objectstore.java:262) @ org.apache.hadoop.hive.metastore.objectstore.getpersistencemanager(objectstore.java:291) @ org.apache.hadoop.hive.metastore.objectstore.initialize(objectstore.java:224) @ org.apache.hadoop.hive.metastore.objectstore.setconf(objectstore.java:199) @ org.apache.hadoop.util.reflectionutils.setconf(reflectionutils.java:73) @ org.apache.hadoop.util.reflectionutils.newinstance(reflectionutils.java:133) @ org.apache.hadoop.hive.metastore.retryingrawstore.<init>(retryingrawstore.java:62) @ org.apache.hadoop.hive.metastore.retryingrawstore.getproxy(retryingrawstore.java:71) @ org.apache.hadoop.hive.metastore.hivemetastore$hmshandler.newrawstore(hivemetastore.java:408) @ org.apache.hadoop.hive.metastore.hivemetastore$hmshandler.getms(hivemetastore.java:396) @ org.apache.hadoop.hive.metastore.hivemetastore$hmshandler.createdefaultdb(hivemetastore.java:434) @ org.apache.hadoop.hive.metastore.hivemetastore$hmshandler.init(hivemetastore.java:328) @ org.apache.hadoop.hive.metastore.hivemetastore$hmshandler.<init>(hivemetastore.java:289) @ org.apache.hadoop.hive.metastore.retryinghmshandler.<init>(retryinghmshandler.java:56) @ org.apache.hadoop.hive.metastore.retryinghmshandler.getproxy(retryinghmshandler.java:61) @ org.apache.hadoop.hive.metastore.hivemetastore.newhmshandler(hivemetastore.java:4014) @ org.apache.hadoop.hive.metastore.hivemetastore.startmetastore(hivemetastore.java:4215) @ org.apache.hadoop.hive.metastore.hivemetastore.main(hivemetastore.java:4150) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:39) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) @ java.lang.reflect.method.invoke(method.java:597) @ org.apache.hadoop.util.runjar.main(runjar.java:208) caused by: org.postgresql.util.psqlexception: fatal: password authentication failed user "hive" @ org.postgresql.core.v3.connectionfactoryimpl.doauthentication(connectionfactoryimpl.java:291) @ org.postgresql.core.v3.connectionfactoryimpl.openconnectionimpl(connectionfactoryimpl.java:108) @ org.postgresql.core.connectionfactory.openconnection(connectionfactory.java:66) @ org.postgresql.jdbc2.abstractjdbc2connection.<init>(abstractjdbc2connection.java:125) @ org.postgresql.jdbc3.abstractjdbc3connection.<init>(abstractjdbc3connection.java:30) @ org.postgresql.jdbc3g.abstractjdbc3gconnection.<init>(abstractjdbc3gconnection.java:22) @ org.postgresql.jdbc4.abstractjdbc4connection.<init>(abstractjdbc4connection.java:30) @ org.postgresql.jdbc4.jdbc4connection.<init>(jdbc4connection.java:24) @ org.postgresql.driver.makeconnection(driver.java:393) @ org.postgresql.driver.connect(driver.java:267) @ java.sql.drivermanager.getconnection(drivermanager.java:582) @ java.sql.drivermanager.getconnection(drivermanager.java:154) @ org.apache.commons.dbcp.drivermanagerconnectionfactory.createconnection(drivermanagerconnectionfactory.java:78) @ org.apache.commons.dbcp.poolableconnectionfactory.makeobject(poolableconnectionfactory.java:582) @ org.apache.commons.pool.impl.genericobjectpool.borrowobject(genericobjectpool.java:1148) @ org.apache.commons.dbcp.poolingdatasource.getconnection(poolingdatasource.java:106) @ org.datanucleus.store.rdbms.connectionfactoryimpl$managedconnectionimpl.getconnection(connectionfactoryimpl.java:479) ... 45 more nested throwables stacktrace: org.postgresql.util.psqlexception: fatal: password authentication failed user "hive" @ org.postgresql.core.v3.connectionfactoryimpl.doauthentication(connectionfactoryimpl.java:291) @ org.postgresql.core.v3.connectionfactoryimpl.openconnectionimpl(connectionfactoryimpl.java:108) @ org.postgresql.core.connectionfactory.openconnection(connectionfactory.java:66) @ org.postgresql.jdbc2.abstractjdbc2connection.<init>(abstractjdbc2connection.java:125) @ org.postgresql.jdbc3.abstractjdbc3connection.<init>(abstractjdbc3connection.java:30) @ org.postgresql.jdbc3g.abstractjdbc3gconnection.<init>(abstractjdbc3gconnection.java:22) @ org.postgresql.jdbc4.abstractjdbc4connection.<init>(abstractjdbc4connection.java:30) @ org.postgresql.jdbc4.jdbc4connection.<init>(jdbc4connection.java:24) @ org.postgresql.driver.makeconnection(driver.java:393) @ org.postgresql.driver.connect(driver.java:267) @ java.sql.drivermanager.getconnection(drivermanager.java:582) @ java.sql.drivermanager.getconnection(drivermanager.java:154) @ org.apache.commons.dbcp.drivermanagerconnectionfactory.createconnection(drivermanagerconnectionfactory.java:78) @ org.apache.commons.dbcp.poolableconnectionfactory.makeobject(poolableconnectionfactory.java:582) @ org.apache.commons.pool.impl.genericobjectpool.borrowobject(genericobjectpool.java:1148) @ org.apache.commons.dbcp.poolingdatasource.getconnection(poolingdatasource.java:106) @ org.datanucleus.store.rdbms.connectionfactoryimpl$managedconnectionimpl.getconnection(connectionfactoryimpl.java:479) @ org.datanucleus.store.rdbms.rdbmsstoremanager.<init>(rdbmsstoremanager.java:304) @ sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method) @ sun.reflect.nativeconstructoraccessorimpl.newinstance(nativeconstructoraccessorimpl.java:39) @ sun.reflect.delegatingconstructoraccessorimpl.newinstance(delegatingconstructoraccessorimpl.java:27) @ java.lang.reflect.constructor.newinstance(constructor.java:513) @ org.datanucleus.plugin.nonmanagedpluginregistry.createexecutableextension(nonmanagedpluginregistry.java:631) @ org.datanucleus.plugin.pluginmanager.createexecutableextension(pluginmanager.java:301) @ org.datanucleus.nucleuscontext.createstoremanagerforproperties(nucleuscontext.java:1069) @ org.datanucleus.nucleuscontext.initialise(nucleuscontext.java:359) @ org.datanucleus.api.jdo.jdopersistencemanagerfactory.freezeconfiguration(jdopersistencemanagerfactory.java:768) @ org.datanucleus.api.jdo.jdopersistencemanagerfactory.createpersistencemanagerfactory(jdopersistencemanagerfactory.java:326) @ org.datanucleus.api.jdo.jdopersistencemanagerfactory.getpersistencemanagerfactory(jdopersistencemanagerfactory.java:195) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:39) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) @ java.lang.reflect.method.invoke(method.java:597) @ javax.jdo.jdohelper$16.run(jdohelper.java:1958) @ java.security.accesscontroller.doprivileged(native method) @ javax.jdo.jdohelper.invoke(jdohelper.java:1953) @ javax.jdo.jdohelper.invokegetpersistencemanagerfactoryonimplementation(jdohelper.java:1159) @ javax.jdo.jdohelper.getpersistencemanagerfactory(jdohelper.java:803) @ javax.jdo.jdohelper.getpersistencemanagerfactory(jdohelper.java:698) @ org.apache.hadoop.hive.metastore.objectstore.getpmf(objectstore.java:262) @ org.apache.hadoop.hive.metastore.objectstore.getpersistencemanager(objectstore.java:291) @ org.apache.hadoop.hive.metastore.objectstore.initialize(objectstore.java:224) @ org.apache.hadoop.hive.metastore.objectstore.setconf(objectstore.java:199) @ org.apache.hadoop.util.reflectionutils.setconf(reflectionutils.java:73) @ org.apache.hadoop.util.reflectionutils.newinstance(reflectionutils.java:133) @ org.apache.hadoop.hive.metastore.retryingrawstore.<init>(retryingrawstore.java:62) @ org.apache.hadoop.hive.metastore.retryingrawstore.getproxy(retryingrawstore.java:71) @ org.apache.hadoop.hive.metastore.hivemetastore$hmshandler.newrawstore(hivemetastore.java:408) @ org.apache.hadoop.hive.metastore.hivemetastore$hmshandler.getms(hivemetastore.java:396) @ org.apache.hadoop.hive.metastore.hivemetastore$hmshandler.createdefaultdb(hivemetastore.java:434) @ org.apache.hadoop.hive.metastore.hivemetastore$hmshandler.init(hivemetastore.java:328) @ org.apache.hadoop.hive.metastore.hivemetastore$hmshandler.<init>(hivemetastore.java:289) @ org.apache.hadoop.hive.metastore.retryinghmshandler.<init>(retryinghmshandler.java:56) @ org.apache.hadoop.hive.metastore.retryinghmshandler.getproxy(retryinghmshandler.java:61) @ org.apache.hadoop.hive.metastore.hivemetastore.newhmshandler(hivemetastore.java:4014) @ org.apache.hadoop.hive.metastore.hivemetastore.startmetastore(hivemetastore.java:4215) @ org.apache.hadoop.hive.metastore.hivemetastore.main(hivemetastore.java:4150) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:39) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) @ java.lang.reflect.method.invoke(method.java:597) @ org.apache.hadoop.util.runjar.main(runjar.java:208)
it still important check in /var/log/hive right properties remote db set , used hive metastore. /var/log/hive/hadoop-....log.out logs display info log used properties:
Comments
Post a Comment