Created 02-21-2018 06:21 AM
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)```
Created 02-23-2018 09:08 AM
A couple of questions:
Created 02-23-2018 08:16 PM
xaa.tar.gzxab.tar.gzxac.tar.gzxad.tar.gz
@pdarvasi below is info
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