You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by mayank rathi <ma...@gmail.com> on 2017/09/16 01:09:42 UTC
Error while creating database accessor
Hello All,
I just finished setting up Ambari 2.5.1. I am using Standalone PostgreSQL
9.6
Setup finished successfully but I am getting error while starting Ambari
server.
This is what I see in Linux command line
Ambari Server 'setup' completed successfully.
[kfkadm@******didkfkw ~]$ ambari-server start
Using python /usr/bin/python
Starting ambari-server
Organizing resource files at /var/lib/ambari-server/resources...
Unable to check firewall status when starting without root privileges.
Please do not forget to disable or adjust firewall if needed
Ambari database consistency check started...
Server PID at: /var/run/ambari-server/ambari-server.pid
Server out at: /var/log/ambari-server/ambari-server.out
Server log at: /var/log/ambari-server/ambari-server.log
/usr/bin/sh: line 0: ulimit: open files: cannot modify limit: Operation not
permitted
Waiting for server start.........Unable to determine server PID. Retrying...
......Unable to determine server PID. Retrying...
......Unable to determine server PID. Retrying...
ERROR: Exiting with exit code -1.
REASON: Ambari Server java process died with exitcode 1. Check
/var/log/ambari-server/ambari-server.out for more information.
This is what I see in ambari-server.out file
Error injecting constructor, java.lang.RuntimeException: Error while
creating database accessor
at org.apache.ambari.server.orm.DBAccessorImpl.<init>(
DBAccessorImpl.java:85)
at org.apache.ambari.server.orm.DBAccessorImpl.class(DBAccessorImpl.java:73)
while locating org.apache.ambari.server.orm.DBAccessorImpl
while locating org.apache.ambari.server.orm.DBAccessor
for field at org.apache.ambari.server.orm.dao.DaoUtils.dbAccessor(
DaoUtils.java:36)
at org.apache.ambari.server.orm.dao.DaoUtils.class(DaoUtils.java:36)
while locating org.apache.ambari.server.orm.dao.DaoUtils
for field at org.apache.ambari.server.orm.dao.UserDAO.daoUtils(UserDAO.
java:45)
at org.apache.ambari.server.orm.dao.UserDAO.class(UserDAO.java:45)
while locating org.apache.ambari.server.orm.dao.UserDAO
for field at org.apache.ambari.server.controller.internal.
ActiveWidgetLayoutResourceProvider.userDAO(ActiveWidgetLayoutResourceProv
ider.java:61)
Caused by: java.lang.RuntimeException: Error while creating database
accessor
at org.apache.ambari.server.orm.DBAccessorImpl.<init>(
DBAccessorImpl.java:118)
at org.apache.ambari.server.orm.DBAccessorImpl$$FastClassByGuice$$86dbc63e.
newInstance(<generated>)
at com.google.inject.internal.cglib.reflect.$FastConstructor.newInstance(
FastConstructor.java:40)
at com.google.inject.internal.DefaultConstructionProxyFactory$1.newInstance(
DefaultConstructionProxyFactory.java:60)
at com.google.inject.internal.ConstructorInjector.construct(
ConstructorInjector.java:85)
at com.google.inject.internal.ConstructorBindingImpl$Factory.get(
ConstructorBindingImpl.java:254)
at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(
ProviderToInternalFactoryAdapter.java:46)
at com.google.inject.internal.InjectorImpl.callInContext(
InjectorImpl.java:1031)
at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(
ProviderToInternalFactoryAdapter.java:40)
at com.google.inject.Scopes$1$1.get(Scopes.java:65)
at com.google.inject.internal.InternalFactoryToProviderAdapter.get(
InternalFactoryToProviderAdapter.java:40)
at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:54)
at com.google.inject.internal.SingleFieldInjector.inject(
SingleFieldInjector.java:53)
at com.google.inject.internal.MembersInjectorImpl.injectMembers(
MembersInjectorImpl.java:110)
at com.google.inject.internal.ConstructorInjector.construct(
ConstructorInjector.java:94)
at com.google.inject.internal.ConstructorBindingImpl$Factory.get(
ConstructorBindingImpl.java:254)
at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(
ProviderToInternalFactoryAdapter.java:46)
at com.google.inject.internal.InjectorImpl.callInContext(
InjectorImpl.java:1031)
at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(
ProviderToInternalFactoryAdapter.java:40)
at com.google.inject.Scopes$1$1.get(Scopes.java:65)
at com.google.inject.internal.InternalFactoryToProviderAdapter.get(
InternalFactoryToProviderAdapter.java:40)
at com.google.inject.internal.SingleFieldInjector.inject(
SingleFieldInjector.java:53)
at com.google.inject.internal.MembersInjectorImpl.injectMembers(
MembersInjectorImpl.java:110)
at com.google.inject.internal.ConstructorInjector.construct(
ConstructorInjector.java:94)
at com.google.inject.internal.ConstructorBindingImpl$Factory.get(
ConstructorBindingImpl.java:254)
at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(
ProviderToInternalFactoryAdapter.java:46)
at com.google.inject.internal.InjectorImpl.callInContext(
InjectorImpl.java:1031)
at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(
ProviderToInternalFactoryAdapter.java:40)
at com.google.inject.Scopes$1$1.get(Scopes.java:65)
at com.google.inject.internal.InternalFactoryToProviderAdapter.get(
InternalFactoryToProviderAdapter.java:40)
at com.google.inject.internal.SingleFieldInjector.inject(
SingleFieldInjector.java:53)
at com.google.inject.internal.InjectionRequestProcessor$
StaticInjection$1.call(InjectionRequestProcessor.java:116)
at com.google.inject.internal.InjectionRequestProcessor$
StaticInjection$1.call(InjectionRequestProcessor.java:110)
at com.google.inject.internal.InjectorImpl.callInContext(
InjectorImpl.java:1024)
at com.google.inject.internal.InjectionRequestProcessor$
StaticInjection.injectMembers(InjectionRequestProcessor.java:110)
at com.google.inject.internal.InjectionRequestProcessor.injectMembers(
InjectionRequestProcessor.java:78)
at com.google.inject.internal.InternalInjectorCreator.injectDynamically(
InternalInjectorCreator.java:170)
at com.google.inject.internal.InternalInjectorCreator.build(
InternalInjectorCreator.java:109)
at com.google.inject.Guice.createInjector(Guice.java:95)
at com.google.inject.Guice.createInjector(Guice.java:72)
at com.google.inject.Guice.createInjector(Guice.java:62)
at org.apache.ambari.server.controller.AmbariServer.main(
AmbariServer.java:992)
Caused by: org.postgresql.util.PSQLException: Connection refused. Check
that the hostname and port are correct and that the postmaster is accepting
TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(
ConnectionFactoryImpl.java:207)
at org.postgresql.core.ConnectionFactory.openConnection(
ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>
(AbstractJdbc2Connection.java:138)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>
(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(
AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>
(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:410)
at org.postgresql.Driver.connect(Driver.java:280)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.apache.ambari.server.orm.DBAccessorImpl.<init>(
DBAccessorImpl.java:91)
... 41 more
Caused by: java.net.ConnectException: Connection refused (Connection
refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:
350)
at java.net.AbstractPlainSocketImpl.connectToAddress(
AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:
188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at java.net.Socket.connect(Socket.java:538)
at org.postgresql.core.PGStream.<init>(PGStream.java:60)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(
ConnectionFactoryImpl.java:101)
... 52 more
How do I resolve this error?
--
NOTICE: This email message is for the sole use of the intended recipient(s)
and may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not the
intended recipient, please contact the sender by reply email and destroy
all copies of the original message.
Re: Error while creating database accessor
Posted by Gonzalo Herreros <gh...@gmail.com>.
Connection refused (Connection refused)
Either the standalone db is not running correctly or the Ambari db
configuration is wrong
I would try first to connect manually to the DB
On Sep 16, 2017 2:10 AM, "mayank rathi" <ma...@gmail.com> wrote:
> Hello All,
>
> I just finished setting up Ambari 2.5.1. I am using Standalone PostgreSQL
> 9.6
>
> Setup finished successfully but I am getting error while starting Ambari
> server.
>
> This is what I see in Linux command line
>
> Ambari Server 'setup' completed successfully.
> [kfkadm@******didkfkw ~]$ ambari-server start
> Using python /usr/bin/python
> Starting ambari-server
> Organizing resource files at /var/lib/ambari-server/resources...
> Unable to check firewall status when starting without root privileges.
> Please do not forget to disable or adjust firewall if needed
> Ambari database consistency check started...
> Server PID at: /var/run/ambari-server/ambari-server.pid
> Server out at: /var/log/ambari-server/ambari-server.out
> Server log at: /var/log/ambari-server/ambari-server.log
> /usr/bin/sh: line 0: ulimit: open files: cannot modify limit: Operation not
> permitted
> Waiting for server start.........Unable to determine server PID.
> Retrying...
> ......Unable to determine server PID. Retrying...
> ......Unable to determine server PID. Retrying...
> ERROR: Exiting with exit code -1.
> REASON: Ambari Server java process died with exitcode 1. Check
> /var/log/ambari-server/ambari-server.out for more information.
>
> This is what I see in ambari-server.out file
>
> Error injecting constructor, java.lang.RuntimeException: Error while
> creating database accessor
> at org.apache.ambari.server.orm.DBAccessorImpl.<init>(
> DBAccessorImpl.java:85)
> at org.apache.ambari.server.orm.DBAccessorImpl.class(
> DBAccessorImpl.java:73)
> while locating org.apache.ambari.server.orm.DBAccessorImpl
> while locating org.apache.ambari.server.orm.DBAccessor
> for field at org.apache.ambari.server.orm.dao.DaoUtils.dbAccessor(
> DaoUtils.java:36)
> at org.apache.ambari.server.orm.dao.DaoUtils.class(DaoUtils.java:36)
> while locating org.apache.ambari.server.orm.dao.DaoUtils
> for field at org.apache.ambari.server.orm.dao.UserDAO.daoUtils(UserDAO.
> java:45)
> at org.apache.ambari.server.orm.dao.UserDAO.class(UserDAO.java:45)
> while locating org.apache.ambari.server.orm.dao.UserDAO
> for field at org.apache.ambari.server.controller.internal.
> ActiveWidgetLayoutResourceProvider.userDAO(ActiveWidgetLayoutResourceProv
> ider.java:61)
> Caused by: java.lang.RuntimeException: Error while creating database
> accessor
> at org.apache.ambari.server.orm.DBAccessorImpl.<init>(
> DBAccessorImpl.java:118)
> at org.apache.ambari.server.orm.DBAccessorImpl$$
> FastClassByGuice$$86dbc63e.
> newInstance(<generated>)
> at com.google.inject.internal.cglib.reflect.$FastConstructor.newInstance(
> FastConstructor.java:40)
> at com.google.inject.internal.DefaultConstructionProxyFactor
> y$1.newInstance(
> DefaultConstructionProxyFactory.java:60)
> at com.google.inject.internal.ConstructorInjector.construct(
> ConstructorInjector.java:85)
> at com.google.inject.internal.ConstructorBindingImpl$Factory.get(
> ConstructorBindingImpl.java:254)
> at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(
> ProviderToInternalFactoryAdapter.java:46)
> at com.google.inject.internal.InjectorImpl.callInContext(
> InjectorImpl.java:1031)
> at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(
> ProviderToInternalFactoryAdapter.java:40)
> at com.google.inject.Scopes$1$1.get(Scopes.java:65)
> at com.google.inject.internal.InternalFactoryToProviderAdapter.get(
> InternalFactoryToProviderAdapter.java:40)
> at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:54)
> at com.google.inject.internal.SingleFieldInjector.inject(
> SingleFieldInjector.java:53)
> at com.google.inject.internal.MembersInjectorImpl.injectMembers(
> MembersInjectorImpl.java:110)
> at com.google.inject.internal.ConstructorInjector.construct(
> ConstructorInjector.java:94)
> at com.google.inject.internal.ConstructorBindingImpl$Factory.get(
> ConstructorBindingImpl.java:254)
> at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(
> ProviderToInternalFactoryAdapter.java:46)
> at com.google.inject.internal.InjectorImpl.callInContext(
> InjectorImpl.java:1031)
> at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(
> ProviderToInternalFactoryAdapter.java:40)
> at com.google.inject.Scopes$1$1.get(Scopes.java:65)
> at com.google.inject.internal.InternalFactoryToProviderAdapter.get(
> InternalFactoryToProviderAdapter.java:40)
> at com.google.inject.internal.SingleFieldInjector.inject(
> SingleFieldInjector.java:53)
> at com.google.inject.internal.MembersInjectorImpl.injectMembers(
> MembersInjectorImpl.java:110)
> at com.google.inject.internal.ConstructorInjector.construct(
> ConstructorInjector.java:94)
> at com.google.inject.internal.ConstructorBindingImpl$Factory.get(
> ConstructorBindingImpl.java:254)
> at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(
> ProviderToInternalFactoryAdapter.java:46)
> at com.google.inject.internal.InjectorImpl.callInContext(
> InjectorImpl.java:1031)
> at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(
> ProviderToInternalFactoryAdapter.java:40)
> at com.google.inject.Scopes$1$1.get(Scopes.java:65)
> at com.google.inject.internal.InternalFactoryToProviderAdapter.get(
> InternalFactoryToProviderAdapter.java:40)
> at com.google.inject.internal.SingleFieldInjector.inject(
> SingleFieldInjector.java:53)
> at com.google.inject.internal.InjectionRequestProcessor$
> StaticInjection$1.call(InjectionRequestProcessor.java:116)
> at com.google.inject.internal.InjectionRequestProcessor$
> StaticInjection$1.call(InjectionRequestProcessor.java:110)
> at com.google.inject.internal.InjectorImpl.callInContext(
> InjectorImpl.java:1024)
> at com.google.inject.internal.InjectionRequestProcessor$
> StaticInjection.injectMembers(InjectionRequestProcessor.java:110)
> at com.google.inject.internal.InjectionRequestProcessor.injectMembers(
> InjectionRequestProcessor.java:78)
> at com.google.inject.internal.InternalInjectorCreator.injectDynamically(
> InternalInjectorCreator.java:170)
> at com.google.inject.internal.InternalInjectorCreator.build(
> InternalInjectorCreator.java:109)
> at com.google.inject.Guice.createInjector(Guice.java:95)
> at com.google.inject.Guice.createInjector(Guice.java:72)
> at com.google.inject.Guice.createInjector(Guice.java:62)
> at org.apache.ambari.server.controller.AmbariServer.main(
> AmbariServer.java:992)
> Caused by: org.postgresql.util.PSQLException: Connection refused. Check
> that the hostname and port are correct and that the postmaster is accepting
> TCP/IP connections.
> at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(
> ConnectionFactoryImpl.java:207)
> at org.postgresql.core.ConnectionFactory.openConnection(
> ConnectionFactory.java:64)
> at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>
> (AbstractJdbc2Connection.java:138)
> at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>
> (AbstractJdbc3Connection.java:29)
> at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(
> AbstractJdbc3gConnection.java:21)
> at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>
> (AbstractJdbc4Connection.java:31)
> at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
> at org.postgresql.Driver.makeConnection(Driver.java:410)
> at org.postgresql.Driver.connect(Driver.java:280)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:247)
> at org.apache.ambari.server.orm.DBAccessorImpl.<init>(
> DBAccessorImpl.java:91)
> ... 41 more
> Caused by: java.net.ConnectException: Connection refused (Connection
> refused)
> at java.net.PlainSocketImpl.socketConnect(Native Method)
> at java.net.AbstractPlainSocketImpl.doConnect(
> AbstractPlainSocketImpl.java:
> 350)
> at java.net.AbstractPlainSocketImpl.connectToAddress(
> AbstractPlainSocketImpl.java:206)
> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:
> 188)
> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
> at java.net.Socket.connect(Socket.java:589)
> at java.net.Socket.connect(Socket.java:538)
> at org.postgresql.core.PGStream.<init>(PGStream.java:60)
> at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(
> ConnectionFactoryImpl.java:101)
> ... 52 more
> How do I resolve this error?
>
> --
> NOTICE: This email message is for the sole use of the intended recipient(s)
> and may contain confidential and privileged information. Any unauthorized
> review, use, disclosure or distribution is prohibited. If you are not the
> intended recipient, please contact the sender by reply email and destroy
> all copies of the original message.
>