Support Questions
Find answers, ask questions, and share your expertise

unable to log in to cloudbreak UI

unable to log in to cloudbreak UI

Explorer

Unable to log in to cloudbreak UI(did not restart containers). logs shown below. ```cloudbreak_1 | org.springframework.dao.DataAccessResourceFailureException: Unable to acquire JDBC Connection; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection cloudbreak_1 | at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:257) cloudbreak_1 | at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:244) cloudbreak_1 | at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:488) cloudbreak_1 | at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59) cloudbreak_1 | at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213) cloudbreak_1 | at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147) cloudbreak_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) cloudbreak_1 | at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133) cloudbreak_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) cloudbreak_1 | at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) cloudbreak_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) cloudbreak_1 | at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57) cloudbreak_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) cloudbreak_1 | at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) cloudbreak_1 | at com.sun.proxy.$Proxy203.findByStatuses(Unknown Source) cloudbreak_1 | at com.sequenceiq.cloudbreak.websocket.UptimeNotifier.sendUptime(UptimeNotifier.java:36) cloudbreak_1 | at sun.reflect.GeneratedMethodAccessor303.invoke(Unknown Source) cloudbreak_1 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) cloudbreak_1 | at java.lang.reflect.Method.invoke(Method.java:498) cloudbreak_1 | at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) cloudbreak_1 | at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) cloudbreak_1 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) cloudbreak_1 | at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) cloudbreak_1 | at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) cloudbreak_1 | at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) cloudbreak_1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) cloudbreak_1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) cloudbreak_1 | at java.lang.Thread.run(Thread.java:745) cloudbreak_1 | Caused by: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection cloudbreak_1 | at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115) cloudbreak_1 | at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) cloudbreak_1 | at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) cloudbreak_1 | at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95) cloudbreak_1 | at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:90) cloudbreak_1 | at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:112) cloudbreak_1 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47) cloudbreak_1 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146) cloudbreak_1 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172) cloudbreak_1 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148) cloudbreak_1 | at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1929) cloudbreak_1 | at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1898) cloudbreak_1 | at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876) cloudbreak_1 | at org.hibernate.loader.Loader.doQuery(Loader.java:919) cloudbreak_1 | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336) cloudbreak_1 | at org.hibernate.loader.Loader.doList(Loader.java:2617) cloudbreak_1 | at org.hibernate.loader.Loader.doList(Loader.java:2600) cloudbreak_1 | at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2429) cloudbreak_1 | at org.hibernate.loader.Loader.list(Loader.java:2424) cloudbreak_1 | at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501) cloudbreak_1 | at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371) cloudbreak_1 | at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216) cloudbreak_1 | at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326) cloudbreak_1 | at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87) cloudbreak_1 | at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606) cloudbreak_1 | at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:483) cloudbreak_1 | at sun.reflect.GeneratedMethodAccessor196.invoke(Unknown Source) cloudbreak_1 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) cloudbreak_1 | at java.lang.reflect.Method.invoke(Method.java:498) cloudbreak_1 | at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:372) cloudbreak_1 | at com.sun.proxy.$Proxy269.getResultList(Unknown Source) cloudbreak_1 | at org.springframework.data.jpa.repository.query.JpaQueryExecution$CollectionExecution.doExecute(JpaQueryExecution.java:121) cloudbreak_1 | at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:85) cloudbreak_1 | at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:116) cloudbreak_1 | at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:106) cloudbreak_1 | at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:483) cloudbreak_1 | at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:461) cloudbreak_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) cloudbreak_1 | at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:61) cloudbreak_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) cloudbreak_1 | at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) cloudbreak_1 | at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) cloudbreak_1 | at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) cloudbreak_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) cloudbreak_1 | at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136) cloudbreak_1 | ... 22 common frames omitted cloudbreak_1 | Caused by: org.postgresql.util.PSQLException: The connection attempt failed. cloudbreak_1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:272) cloudbreak_1 | at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52) cloudbreak_1 | at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216) cloudbreak_1 | at org.postgresql.Driver.makeConnection(Driver.java:404) cloudbreak_1 | at org.postgresql.Driver.connect(Driver.java:272) cloudbreak_1 | at org.springframework.jdbc.datasource.SimpleDriverDataSource.getConnectionFromDriver(SimpleDriverDataSource.java:140) cloudbreak_1 | at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:196) cloudbreak_1 | at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:159) cloudbreak_1 | at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) cloudbreak_1 | at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:386) cloudbreak_1 | at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:87) cloudbreak_1 | ... 62 common frames omitted cloudbreak_1 | Caused by: java.net.UnknownHostException: node1.node.dc1.consul cloudbreak_1 | at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184) cloudbreak_1 | at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) cloudbreak_1 | at java.net.Socket.connect(Socket.java:589) cloudbreak_1 | at org.postgresql.core.PGStream.<init>(PGStream.java:61) cloudbreak_1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)```

2 REPLIES 2

Re: unable to log in to cloudbreak UI

@prarthana basgod

A couple of questions:

  • what is your Cloudbreak version? (cbd version)
  • is the db running? (you can check with cbd ps)
  • what is your docker version?
  • was it running before this error?
  • if not, have you completed the prerequisites in the docs?
  • can you attach the cbreak.log to the case?

Re: unable to log in to cloudbreak UI

Explorer

xaa.tar.gzxab.tar.gzxac.tar.gzxad.tar.gz

@pdarvasi below is info

  • Cloudbreak Deployer: 1.16.4
  • All the containers are running
  • Docker version 1.10.3, build 20f81dd

we were using deployer for 5 months without any error. I'm sure prerequisites is updated now. we did some of it (ports etc).I have also attached the logs