Advertisement
fedorm

Untitled

Jun 19th, 2019
193
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 59.25 KB | None | 0 0
  1. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47)
  2. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:145)
  3. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:171)
  4. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:147)
  5. consumer-service_1  |   at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1985)
  6. consumer-service_1  |   at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1915)
  7. consumer-service_1  |   at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)
  8. consumer-service_1  |   at org.hibernate.loader.Loader.doQuery(Loader.java:938)
  9. consumer-service_1  |   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
  10. consumer-service_1  |   at org.hibernate.loader.Loader.doList(Loader.java:2692)
  11. consumer-service_1  |   at org.hibernate.loader.Loader.doList(Loader.java:2675)
  12. consumer-service_1  |   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
  13. consumer-service_1  |   at org.hibernate.loader.Loader.list(Loader.java:2502)
  14. consumer-service_1  |   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
  15. consumer-service_1  |   at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392)
  16. consumer-service_1  |   at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
  17. consumer-service_1  |   at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490)
  18. consumer-service_1  |   at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
  19. consumer-service_1  |   at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
  20. consumer-service_1  |   at org.hibernate.query.Query.getResultList(Query.java:146)
  21. consumer-service_1  |   at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:72)
  22. consumer-service_1  |   at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source)
  23. consumer-service_1  |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  24. consumer-service_1  |   at java.lang.reflect.Method.invoke(Method.java:498)
  25. consumer-service_1  |   at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:379)
  26. consumer-service_1  |   at com.sun.proxy.$Proxy153.getResultList(Unknown Source)
  27. consumer-service_1  |   at org.springframework.data.jpa.repository.query.JpaQueryExecution$CollectionExecution.doExecute(JpaQueryExecution.java:129)
  28. consumer-service_1  |   at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:91)
  29. consumer-service_1  |   at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:136)
  30. consumer-service_1  |   at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:125)
  31. consumer-service_1  |   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:590)
  32. consumer-service_1  |   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:578)
  33. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  34. consumer-service_1  |   at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:59)
  35. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  36. consumer-service_1  |   at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
  37. consumer-service_1  |   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  38. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  39. consumer-service_1  |   at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
  40. consumer-service_1  |   ... 22 common frames omitted
  41. consumer-service_1  | Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
  42. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:669)
  43. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:183)
  44. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
  45. consumer-service_1  |   at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  46. consumer-service_1  |   at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
  47. consumer-service_1  |   at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35)
  48. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106)
  49. consumer-service_1  |   ... 62 common frames omitted
  50. consumer-service_1  |
  51. consumer-service_1  | 2019-06-19 10:34:16.673  WARN 1 --- [    scheduled-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: null
  52. consumer-service_1  | 2019-06-19 10:34:16.673 ERROR 1 --- [    scheduled-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : HikariPool-1 - Connection is not available, request timed out after 30000ms.
  53. consumer-service_1  | 2019-06-19 10:34:16.675 ERROR 1 --- [    scheduled-3] o.s.s.s.TaskUtils$LoggingErrorHandler    : Unexpected error occurred in scheduled task.
  54. consumer-service_1  |
  55. consumer-service_1  | org.springframework.dao.DataAccessResourceFailureException: Unable to acquire JDBC Connection; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
  56. consumer-service_1  |   at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:238)
  57. consumer-service_1  |   at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:225)
  58. consumer-service_1  |   at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:527)
  59. consumer-service_1  |   at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
  60. consumer-service_1  |   at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)
  61. consumer-service_1  |   at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:153)
  62. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  63. consumer-service_1  |   at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:135)
  64. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  65. consumer-service_1  |   at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  66. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  67. consumer-service_1  |   at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)
  68. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  69. consumer-service_1  |   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  70. consumer-service_1  |   at com.sun.proxy.$Proxy140.findByType(Unknown Source)
  71. consumer-service_1  |   at ru.crystals.processing.coupons.consumer.series.GenerateCouponSeriesDatabaseConsumerService.tick(GenerateCouponSeriesDatabaseConsumerService.java:37)
  72. consumer-service_1  |   at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
  73. consumer-service_1  |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  74. consumer-service_1  |   at java.lang.reflect.Method.invoke(Method.java:498)
  75. consumer-service_1  |   at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65)
  76. consumer-service_1  |   at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  77. consumer-service_1  |   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  78. consumer-service_1  |   at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  79. consumer-service_1  |   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  80. consumer-service_1  |   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  81. consumer-service_1  |   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  82. consumer-service_1  |   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  83. consumer-service_1  |   at java.lang.Thread.run(Thread.java:748)
  84. consumer-service_1  | Caused by: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
  85. consumer-service_1  |   at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)
  86. consumer-service_1  |   at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  87. consumer-service_1  |   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
  88. consumer-service_1  |   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
  89. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:109)
  90. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136)
  91. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47)
  92. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:145)
  93. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:171)
  94. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:147)
  95. consumer-service_1  |   at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1985)
  96. consumer-service_1  |   at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1915)
  97. consumer-service_1  |   at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)
  98. consumer-service_1  |   at org.hibernate.loader.Loader.doQuery(Loader.java:938)
  99. consumer-service_1  |   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
  100. consumer-service_1  |   at org.hibernate.loader.Loader.doList(Loader.java:2692)
  101. consumer-service_1  |   at org.hibernate.loader.Loader.doList(Loader.java:2675)
  102. consumer-service_1  |   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
  103. consumer-service_1  |   at org.hibernate.loader.Loader.list(Loader.java:2502)
  104. consumer-service_1  |   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
  105. consumer-service_1  |   at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392)
  106. consumer-service_1  |   at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
  107. consumer-service_1  |   at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490)
  108. consumer-service_1  |   at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
  109. consumer-service_1  |   at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
  110. consumer-service_1  |   at org.hibernate.query.Query.getResultList(Query.java:146)
  111. consumer-service_1  |   at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:72)
  112. consumer-service_1  |   at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source)
  113. consumer-service_1  |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  114. consumer-service_1  |   at java.lang.reflect.Method.invoke(Method.java:498)
  115. consumer-service_1  |   at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:379)
  116. consumer-service_1  |   at com.sun.proxy.$Proxy153.getResultList(Unknown Source)
  117. consumer-service_1  |   at org.springframework.data.jpa.repository.query.JpaQueryExecution$CollectionExecution.doExecute(JpaQueryExecution.java:129)
  118. consumer-service_1  |   at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:91)
  119. consumer-service_1  |   at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:136)
  120. consumer-service_1  |   at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:125)
  121. consumer-service_1  |   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:590)
  122. consumer-service_1  |   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:578)
  123. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  124. consumer-service_1  |   at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:59)
  125. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  126. consumer-service_1  |   at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
  127. consumer-service_1  |   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  128. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  129. consumer-service_1  |   at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
  130. consumer-service_1  |   ... 22 common frames omitted
  131. consumer-service_1  | Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
  132. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:669)
  133. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:183)
  134. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
  135. consumer-service_1  |   at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  136. consumer-service_1  |   at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
  137. consumer-service_1  |   at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35)
  138. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106)
  139. consumer-service_1  |   ... 62 common frames omitted
  140. consumer-service_1  |
  141. consumer-service_1  | 2019-06-19 10:34:35.371  WARN 1 --- [    scheduled-9] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: null
  142. consumer-service_1  | 2019-06-19 10:34:35.372 ERROR 1 --- [    scheduled-9] o.h.engine.jdbc.spi.SqlExceptionHelper   : HikariPool-1 - Connection is not available, request timed out after 30000ms.
  143. consumer-service_1  | 2019-06-19 10:34:35.374 ERROR 1 --- [    scheduled-9] o.s.s.s.TaskUtils$LoggingErrorHandler    : Unexpected error occurred in scheduled task.
  144. consumer-service_1  |
  145. consumer-service_1  | org.springframework.dao.DataAccessResourceFailureException: Unable to acquire JDBC Connection; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
  146. consumer-service_1  |   at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:238)
  147. consumer-service_1  |   at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:225)
  148. consumer-service_1  |   at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:527)
  149. consumer-service_1  |   at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
  150. consumer-service_1  |   at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)
  151. consumer-service_1  |   at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:153)
  152. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  153. consumer-service_1  |   at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:135)
  154. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  155. consumer-service_1  |   at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  156. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  157. consumer-service_1  |   at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)
  158. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  159. consumer-service_1  |   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  160. consumer-service_1  |   at com.sun.proxy.$Proxy140.findByType(Unknown Source)
  161. consumer-service_1  |   at ru.crystals.processing.coupons.consumer.imports.SingleImportDatabaseConsumerService.tick(SingleImportDatabaseConsumerService.java:37)
  162. consumer-service_1  |   at sun.reflect.GeneratedMethodAccessor64.invoke(Unknown Source)
  163. consumer-service_1  |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  164. consumer-service_1  |   at java.lang.reflect.Method.invoke(Method.java:498)
  165. consumer-service_1  |   at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65)
  166. consumer-service_1  |   at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  167. consumer-service_1  |   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  168. consumer-service_1  |   at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  169. consumer-service_1  |   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  170. consumer-service_1  |   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  171. consumer-service_1  |   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  172. consumer-service_1  |   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  173. consumer-service_1  |   at java.lang.Thread.run(Thread.java:748)
  174. consumer-service_1  | Caused by: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
  175. consumer-service_1  |   at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)
  176. consumer-service_1  |   at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  177. consumer-service_1  |   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
  178. consumer-service_1  |   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
  179. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:109)
  180. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136)
  181. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47)
  182. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:145)
  183. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:171)
  184. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:147)
  185. consumer-service_1  |   at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1985)
  186. consumer-service_1  |   at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1915)
  187. consumer-service_1  |   at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)
  188. consumer-service_1  |   at org.hibernate.loader.Loader.doQuery(Loader.java:938)
  189. consumer-service_1  |   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
  190. consumer-service_1  |   at org.hibernate.loader.Loader.doList(Loader.java:2692)
  191. consumer-service_1  |   at org.hibernate.loader.Loader.doList(Loader.java:2675)
  192. consumer-service_1  |   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
  193. consumer-service_1  |   at org.hibernate.loader.Loader.list(Loader.java:2502)
  194. consumer-service_1  |   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
  195. consumer-service_1  |   at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392)
  196. consumer-service_1  |   at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
  197. consumer-service_1  |   at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490)
  198. consumer-service_1  |   at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
  199. consumer-service_1  |   at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
  200. consumer-service_1  |   at org.hibernate.query.Query.getResultList(Query.java:146)
  201. consumer-service_1  |   at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:72)
  202. consumer-service_1  |   at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source)
  203. consumer-service_1  |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  204. consumer-service_1  |   at java.lang.reflect.Method.invoke(Method.java:498)
  205. consumer-service_1  |   at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:379)
  206. consumer-service_1  |   at com.sun.proxy.$Proxy153.getResultList(Unknown Source)
  207. consumer-service_1  |   at org.springframework.data.jpa.repository.query.JpaQueryExecution$CollectionExecution.doExecute(JpaQueryExecution.java:129)
  208. consumer-service_1  |   at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:91)
  209. consumer-service_1  |   at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:136)
  210. consumer-service_1  |   at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:125)
  211. consumer-service_1  |   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:590)
  212. consumer-service_1  |   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:578)
  213. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  214. consumer-service_1  |   at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:59)
  215. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  216. consumer-service_1  |   at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
  217. consumer-service_1  |   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  218. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  219. consumer-service_1  |   at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
  220. consumer-service_1  |   ... 22 common frames omitted
  221. consumer-service_1  | Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
  222. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:669)
  223. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:183)
  224. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
  225. consumer-service_1  |   at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  226. consumer-service_1  |   at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
  227. consumer-service_1  |   at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35)
  228. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106)
  229. consumer-service_1  |   ... 62 common frames omitted
  230. consumer-service_1  |
  231. consumer-service_1  | 2019-06-19 10:34:47.677  WARN 1 --- [    scheduled-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: null
  232. consumer-service_1  | 2019-06-19 10:34:47.677 ERROR 1 --- [    scheduled-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : HikariPool-1 - Connection is not available, request timed out after 30000ms.
  233. consumer-service_1  | 2019-06-19 10:34:47.680 ERROR 1 --- [    scheduled-3] o.s.s.s.TaskUtils$LoggingErrorHandler    : Unexpected error occurred in scheduled task.
  234. consumer-service_1  |
  235. consumer-service_1  | org.springframework.dao.DataAccessResourceFailureException: Unable to acquire JDBC Connection; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
  236. consumer-service_1  |   at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:238)
  237. consumer-service_1  |   at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:225)
  238. consumer-service_1  |   at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:527)
  239. consumer-service_1  |   at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
  240. consumer-service_1  |   at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)
  241. consumer-service_1  |   at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:153)
  242. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  243. consumer-service_1  |   at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:135)
  244. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  245. consumer-service_1  |   at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  246. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  247. consumer-service_1  |   at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)
  248. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  249. consumer-service_1  |   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  250. consumer-service_1  |   at com.sun.proxy.$Proxy140.findByType(Unknown Source)
  251. consumer-service_1  |   at ru.crystals.processing.coupons.consumer.series.GenerateCouponSeriesDatabaseConsumerService.tick(GenerateCouponSeriesDatabaseConsumerService.java:37)
  252. consumer-service_1  |   at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
  253. consumer-service_1  |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  254. consumer-service_1  |   at java.lang.reflect.Method.invoke(Method.java:498)
  255. consumer-service_1  |   at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65)
  256. consumer-service_1  |   at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  257. consumer-service_1  |   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  258. consumer-service_1  |   at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  259. consumer-service_1  |   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  260. consumer-service_1  |   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  261. consumer-service_1  |   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  262. consumer-service_1  |   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  263. consumer-service_1  |   at java.lang.Thread.run(Thread.java:748)
  264. consumer-service_1  | Caused by: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
  265. consumer-service_1  |   at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)
  266. consumer-service_1  |   at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  267. consumer-service_1  |   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
  268. consumer-service_1  |   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
  269. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:109)
  270. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136)
  271. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47)
  272. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:145)
  273. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:171)
  274. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:147)
  275. consumer-service_1  |   at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1985)
  276. consumer-service_1  |   at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1915)
  277. consumer-service_1  |   at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)
  278. consumer-service_1  |   at org.hibernate.loader.Loader.doQuery(Loader.java:938)
  279. consumer-service_1  |   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
  280. consumer-service_1  |   at org.hibernate.loader.Loader.doList(Loader.java:2692)
  281. consumer-service_1  |   at org.hibernate.loader.Loader.doList(Loader.java:2675)
  282. consumer-service_1  |   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
  283. consumer-service_1  |   at org.hibernate.loader.Loader.list(Loader.java:2502)
  284. consumer-service_1  |   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
  285. consumer-service_1  |   at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392)
  286. consumer-service_1  |   at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
  287. consumer-service_1  |   at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490)
  288. consumer-service_1  |   at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
  289. consumer-service_1  |   at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
  290. consumer-service_1  |   at org.hibernate.query.Query.getResultList(Query.java:146)
  291. consumer-service_1  |   at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:72)
  292. consumer-service_1  |   at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source)
  293. consumer-service_1  |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  294. consumer-service_1  |   at java.lang.reflect.Method.invoke(Method.java:498)
  295. consumer-service_1  |   at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:379)
  296. consumer-service_1  |   at com.sun.proxy.$Proxy153.getResultList(Unknown Source)
  297. consumer-service_1  |   at org.springframework.data.jpa.repository.query.JpaQueryExecution$CollectionExecution.doExecute(JpaQueryExecution.java:129)
  298. consumer-service_1  |   at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:91)
  299. consumer-service_1  |   at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:136)
  300. consumer-service_1  |   at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:125)
  301. consumer-service_1  |   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:590)
  302. consumer-service_1  |   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:578)
  303. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  304. consumer-service_1  |   at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:59)
  305. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  306. consumer-service_1  |   at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
  307. consumer-service_1  |   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  308. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  309. consumer-service_1  |   at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
  310. consumer-service_1  |   ... 22 common frames omitted
  311. consumer-service_1  | Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
  312. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:669)
  313. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:183)
  314. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
  315. consumer-service_1  |   at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  316. consumer-service_1  |   at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
  317. consumer-service_1  |   at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35)
  318. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106)
  319. consumer-service_1  |   ... 62 common frames omitted
  320. consumer-service_1  |
  321. consumer-service_1  | 2019-06-19 10:35:06.376  WARN 1 --- [    scheduled-9] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: null
  322. consumer-service_1  | 2019-06-19 10:35:06.376 ERROR 1 --- [    scheduled-9] o.h.engine.jdbc.spi.SqlExceptionHelper   : HikariPool-1 - Connection is not available, request timed out after 30000ms.
  323. consumer-service_1  | 2019-06-19 10:35:06.377 ERROR 1 --- [    scheduled-9] o.s.s.s.TaskUtils$LoggingErrorHandler    : Unexpected error occurred in scheduled task.
  324. consumer-service_1  |
  325. consumer-service_1  | org.springframework.dao.DataAccessResourceFailureException: Unable to acquire JDBC Connection; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
  326. consumer-service_1  |   at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:238)
  327. consumer-service_1  |   at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:225)
  328. consumer-service_1  |   at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:527)
  329. consumer-service_1  |   at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
  330. consumer-service_1  |   at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)
  331. consumer-service_1  |   at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:153)
  332. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  333. consumer-service_1  |   at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:135)
  334. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  335. consumer-service_1  |   at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  336. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  337. consumer-service_1  |   at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)
  338. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  339. consumer-service_1  |   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  340. consumer-service_1  |   at com.sun.proxy.$Proxy140.findByType(Unknown Source)
  341. consumer-service_1  |   at ru.crystals.processing.coupons.consumer.imports.SingleImportDatabaseConsumerService.tick(SingleImportDatabaseConsumerService.java:37)
  342. consumer-service_1  |   at sun.reflect.GeneratedMethodAccessor64.invoke(Unknown Source)
  343. consumer-service_1  |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  344. consumer-service_1  |   at java.lang.reflect.Method.invoke(Method.java:498)
  345. consumer-service_1  |   at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65)
  346. consumer-service_1  |   at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  347. consumer-service_1  |   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  348. consumer-service_1  |   at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  349. consumer-service_1  |   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  350. consumer-service_1  |   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  351. consumer-service_1  |   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  352. consumer-service_1  |   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  353. consumer-service_1  |   at java.lang.Thread.run(Thread.java:748)
  354. consumer-service_1  | Caused by: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
  355. consumer-service_1  |   at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)
  356. consumer-service_1  |   at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  357. consumer-service_1  |   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
  358. consumer-service_1  |   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
  359. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:109)
  360. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136)
  361. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47)
  362. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:145)
  363. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:171)
  364. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:147)
  365. consumer-service_1  |   at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1985)
  366. consumer-service_1  |   at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1915)
  367. consumer-service_1  |   at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)
  368. consumer-service_1  |   at org.hibernate.loader.Loader.doQuery(Loader.java:938)
  369. consumer-service_1  |   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
  370. consumer-service_1  |   at org.hibernate.loader.Loader.doList(Loader.java:2692)
  371. consumer-service_1  |   at org.hibernate.loader.Loader.doList(Loader.java:2675)
  372. consumer-service_1  |   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
  373. consumer-service_1  |   at org.hibernate.loader.Loader.list(Loader.java:2502)
  374. consumer-service_1  |   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
  375. consumer-service_1  |   at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392)
  376. consumer-service_1  |   at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
  377. consumer-service_1  |   at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490)
  378. consumer-service_1  |   at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
  379. consumer-service_1  |   at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
  380. consumer-service_1  |   at org.hibernate.query.Query.getResultList(Query.java:146)
  381. consumer-service_1  |   at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:72)
  382. consumer-service_1  |   at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source)
  383. consumer-service_1  |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  384. consumer-service_1  |   at java.lang.reflect.Method.invoke(Method.java:498)
  385. consumer-service_1  |   at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:379)
  386. consumer-service_1  |   at com.sun.proxy.$Proxy153.getResultList(Unknown Source)
  387. consumer-service_1  |   at org.springframework.data.jpa.repository.query.JpaQueryExecution$CollectionExecution.doExecute(JpaQueryExecution.java:129)
  388. consumer-service_1  |   at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:91)
  389. consumer-service_1  |   at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:136)
  390. consumer-service_1  |   at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:125)
  391. consumer-service_1  |   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:590)
  392. consumer-service_1  |   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:578)
  393. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  394. consumer-service_1  |   at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:59)
  395. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  396. consumer-service_1  |   at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
  397. consumer-service_1  |   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  398. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  399. consumer-service_1  |   at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
  400. consumer-service_1  |   ... 22 common frames omitted
  401. consumer-service_1  | Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
  402. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:669)
  403. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:183)
  404. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
  405. consumer-service_1  |   at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  406. consumer-service_1  |   at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
  407. consumer-service_1  |   at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35)
  408. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106)
  409. consumer-service_1  |   ... 62 common frames omitted
  410. consumer-service_1  |
  411. consumer-service_1  | 2019-06-19 10:35:18.681  WARN 1 --- [    scheduled-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: null
  412. consumer-service_1  | 2019-06-19 10:35:18.681 ERROR 1 --- [    scheduled-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : HikariPool-1 - Connection is not available, request timed out after 30000ms.
  413. consumer-service_1  | 2019-06-19 10:35:18.682 ERROR 1 --- [    scheduled-3] o.s.s.s.TaskUtils$LoggingErrorHandler    : Unexpected error occurred in scheduled task.
  414. consumer-service_1  |
  415. consumer-service_1  | org.springframework.dao.DataAccessResourceFailureException: Unable to acquire JDBC Connection; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
  416. consumer-service_1  |   at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:238)
  417. consumer-service_1  |   at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:225)
  418. consumer-service_1  |   at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:527)
  419. consumer-service_1  |   at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
  420. consumer-service_1  |   at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)
  421. consumer-service_1  |   at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:153)
  422. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  423. consumer-service_1  |   at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:135)
  424. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  425. consumer-service_1  |   at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
  426. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  427. consumer-service_1  |   at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)
  428. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  429. consumer-service_1  |   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  430. consumer-service_1  |   at com.sun.proxy.$Proxy140.findByType(Unknown Source)
  431. consumer-service_1  |   at ru.crystals.processing.coupons.consumer.series.GenerateCouponSeriesDatabaseConsumerService.tick(GenerateCouponSeriesDatabaseConsumerService.java:37)
  432. consumer-service_1  |   at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
  433. consumer-service_1  |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  434. consumer-service_1  |   at java.lang.reflect.Method.invoke(Method.java:498)
  435. consumer-service_1  |   at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65)
  436. consumer-service_1  |   at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  437. consumer-service_1  |   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  438. consumer-service_1  |   at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  439. consumer-service_1  |   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  440. consumer-service_1  |   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  441. consumer-service_1  |   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  442. consumer-service_1  |   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  443. consumer-service_1  |   at java.lang.Thread.run(Thread.java:748)
  444. consumer-service_1  | Caused by: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
  445. consumer-service_1  |   at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)
  446. consumer-service_1  |   at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  447. consumer-service_1  |   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
  448. consumer-service_1  |   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
  449. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:109)
  450. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136)
  451. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47)
  452. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:145)
  453. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:171)
  454. consumer-service_1  |   at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:147)
  455. consumer-service_1  |   at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1985)
  456. consumer-service_1  |   at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1915)
  457. consumer-service_1  |   at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)
  458. consumer-service_1  |   at org.hibernate.loader.Loader.doQuery(Loader.java:938)
  459. consumer-service_1  |   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
  460. consumer-service_1  |   at org.hibernate.loader.Loader.doList(Loader.java:2692)
  461. consumer-service_1  |   at org.hibernate.loader.Loader.doList(Loader.java:2675)
  462. consumer-service_1  |   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
  463. consumer-service_1  |   at org.hibernate.loader.Loader.list(Loader.java:2502)
  464. consumer-service_1  |   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
  465. consumer-service_1  |   at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392)
  466. consumer-service_1  |   at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
  467. consumer-service_1  |   at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490)
  468. consumer-service_1  |   at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
  469. consumer-service_1  |   at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
  470. consumer-service_1  |   at org.hibernate.query.Query.getResultList(Query.java:146)
  471. consumer-service_1  |   at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:72)
  472. consumer-service_1  |   at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source)
  473. consumer-service_1  |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  474. consumer-service_1  |   at java.lang.reflect.Method.invoke(Method.java:498)
  475. consumer-service_1  |   at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:379)
  476. consumer-service_1  |   at com.sun.proxy.$Proxy153.getResultList(Unknown Source)
  477. consumer-service_1  |   at org.springframework.data.jpa.repository.query.JpaQueryExecution$CollectionExecution.doExecute(JpaQueryExecution.java:129)
  478. consumer-service_1  |   at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:91)
  479. consumer-service_1  |   at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:136)
  480. consumer-service_1  |   at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:125)
  481. consumer-service_1  |   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:590)
  482. consumer-service_1  |   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:578)
  483. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  484. consumer-service_1  |   at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:59)
  485. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  486. consumer-service_1  |   at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
  487. consumer-service_1  |   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  488. consumer-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  489. consumer-service_1  |   at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
  490. consumer-service_1  |   ... 22 common frames omitted
  491. consumer-service_1  | Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
  492. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:669)
  493. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:183)
  494. consumer-service_1  |   at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
  495. consumer-service_1  |   at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  496. consumer-service_1  |   at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
  497. consumer-service_1  |   at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35)
  498. consumer-service_1  |   at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106)
  499. consumer-service_1  |   ... 62 common frames omitted
  500. consumer-service_1  |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement