search

arkhn / fhir-river

Live ETL pipeline to standardize Health Data into FHIR.
Apache License 2.0
42 stars 4 forks source link

Error on croix rouge #726

Open nriss opened 2 years ago

nriss commented 2 years ago

Description

There is not the same data between FHIR and datalake

Loader logs:

fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    | 19:21:25.023 [hapi-fhir-jpa-scheduler-clustered-4] WARN  o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: 08003
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    | 19:21:25.024 [hapi-fhir-jpa-scheduler-clustered-4] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - HikariPool-1 - Connection is not available, request timed out after 30986ms.
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    | 19:21:25.024 [hapi-fhir-jpa-scheduler-clustered-4] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - This connection has been closed.
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    | 19:21:25.029 [hapi-fhir-jpa-scheduler-clustered-4] ERROR org.quartz.core.JobRunShell - Job HAPI.ca.uhn.fhir.jpa.search.StaleSearchDeletingSvcImpl threw an unhandled Exception: 
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    | org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:467)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:137)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.cache.DatabaseSearchCacheSvcImpl.pollForStaleSearchesAndDeleteThem(DatabaseSearchCacheSvcImpl.java:184)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.cache.DatabaseSearchCacheSvcImpl$$FastClassBySpringCGLIB$$f9ac20c0.invoke(<generated>)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.cache.DatabaseSearchCacheSvcImpl$$EnhancerBySpringCGLIB$$acd5805f.pollForStaleSearchesAndDeleteThem(<generated>)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.StaleSearchDeletingSvcImpl.pollForStaleSearchesAndDeleteThem(StaleSearchDeletingSvcImpl.java:57)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.StaleSearchDeletingSvcImpl.schedulePollForStaleSearches(StaleSearchDeletingSvcImpl.java:82)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.StaleSearchDeletingSvcImpl$$FastClassBySpringCGLIB$$979cdeaa.invoke(<generated>)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.StaleSearchDeletingSvcImpl$$EnhancerBySpringCGLIB$$7cb0bc5d.schedulePollForStaleSearches(<generated>)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.StaleSearchDeletingSvcImpl$Job.execute(StaleSearchDeletingSvcImpl.java:74)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    | Caused by: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:111)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:138)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getConnectionForTransactionManagement(LogicalConnectionManagedImpl.java:274)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.begin(LogicalConnectionManagedImpl.java:282)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.begin(JdbcResourceLocalTransactionCoordinatorImpl.java:246)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.engine.transaction.internal.TransactionImpl.begin(TransactionImpl.java:83)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.beginTransaction(HibernateJpaDialect.java:164)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:421)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    ... 33 common frames omitted
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    | Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30986ms.
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:695)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:38)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:108)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    ... 40 common frames omitted
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    | Caused by: org.postgresql.util.PSQLException: This connection has been closed.
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:857)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.postgresql.jdbc.PgConnection.setNetworkTimeout(PgConnection.java:1639)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at com.zaxxer.hikari.pool.PoolBase.setNetworkTimeout(PoolBase.java:560)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:173)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    ... 45 common frames omitted
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    | 19:21:25.030 [hapi-fhir-jpa-scheduler-clustered-4] ERROR org.quartz.core.ErrorLogger - Job (HAPI.ca.uhn.fhir.jpa.search.StaleSearchDeletingSvcImpl threw an exception.
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    | org.quartz.SchedulerException: Job threw an unhandled exception.
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    | Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:467)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:137)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.cache.DatabaseSearchCacheSvcImpl.pollForStaleSearchesAndDeleteThem(DatabaseSearchCacheSvcImpl.java:184)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.cache.DatabaseSearchCacheSvcImpl$$FastClassBySpringCGLIB$$f9ac20c0.invoke(<generated>)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.cache.DatabaseSearchCacheSvcImpl$$EnhancerBySpringCGLIB$$acd5805f.pollForStaleSearchesAndDeleteThem(<generated>)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.StaleSearchDeletingSvcImpl.pollForStaleSearchesAndDeleteThem(StaleSearchDeletingSvcImpl.java:57)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.StaleSearchDeletingSvcImpl.schedulePollForStaleSearches(StaleSearchDeletingSvcImpl.java:82)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.StaleSearchDeletingSvcImpl$$FastClassBySpringCGLIB$$979cdeaa.invoke(<generated>)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.StaleSearchDeletingSvcImpl$$EnhancerBySpringCGLIB$$7cb0bc5d.schedulePollForStaleSearches(<generated>)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at ca.uhn.fhir.jpa.search.StaleSearchDeletingSvcImpl$Job.execute(StaleSearchDeletingSvcImpl.java:74)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    ... 1 common frames omitted
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    | Caused by: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:111)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:138)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getConnectionForTransactionManagement(LogicalConnectionManagedImpl.java:274)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.begin(LogicalConnectionManagedImpl.java:282)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.begin(JdbcResourceLocalTransactionCoordinatorImpl.java:246)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.engine.transaction.internal.TransactionImpl.begin(TransactionImpl.java:83)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.beginTransaction(HibernateJpaDialect.java:164)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:421)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    ... 33 common frames omitted
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    | Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30986ms.
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:695)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:38)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:108)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    ... 40 common frames omitted
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    | Caused by: org.postgresql.util.PSQLException: This connection has been closed.
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:857)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at org.postgresql.jdbc.PgConnection.setNetworkTimeout(PgConnection.java:1639)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at com.zaxxer.hikari.pool.PoolBase.setNetworkTimeout(PoolBase.java:560)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:173)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186)
fhir-river_hapi-loader.1.tf6azxrbtosr@PRI0000DC0031    |    ... 45 common frames omitted
nriss commented 2 years ago 
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    | Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    | 15:19:56.376 [main] ERROR o.s.boot.SpringApplication - Application run failed
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    | org.springframework.context.ApplicationContextException: Failed to start bean 'org.springframework.kafka.config.internalKafkaListenerEndpointRegistry'; nested exception is org.apache.kafka.common.KafkaException: Failed to construct kafka consumer
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:181)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:54)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:356)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at java.base/java.lang.Iterable.forEach(Iterable.java:75)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:155)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:935)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:586)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:144)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:769)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:761)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:426)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.boot.SpringApplication.run(SpringApplication.java:326)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1313)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1302)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at com.arkhn.hapi.loader.ResourceConsumer.main(ResourceConsumer.java:33)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.boot.loader.Launcher.launch(Launcher.java:107)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    | Caused by: org.apache.kafka.common.KafkaException: Failed to construct kafka consumer
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.apache.kafka.clients.consumer.KafkaConsumer.<init>(KafkaConsumer.java:825)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.apache.kafka.clients.consumer.KafkaConsumer.<init>(KafkaConsumer.java:631)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.kafka.core.DefaultKafkaConsumerFactory.createRawConsumer(DefaultKafkaConsumerFactory.java:340)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.kafka.core.DefaultKafkaConsumerFactory.createKafkaConsumer(DefaultKafkaConsumerFactory.java:308)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.kafka.core.DefaultKafkaConsumerFactory.createConsumerWithAdjustedProperties(DefaultKafkaConsumerFactory.java:293)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.kafka.core.DefaultKafkaConsumerFactory.createKafkaConsumer(DefaultKafkaConsumerFactory.java:267)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.kafka.core.DefaultKafkaConsumerFactory.createConsumer(DefaultKafkaConsumerFactory.java:241)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.<init>(KafkaMessageListenerContainer.java:615)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.kafka.listener.KafkaMessageListenerContainer.doStart(KafkaMessageListenerContainer.java:304)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.kafka.listener.AbstractMessageListenerContainer.start(AbstractMessageListenerContainer.java:338)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.kafka.listener.ConcurrentMessageListenerContainer.doStart(ConcurrentMessageListenerContainer.java:204)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.kafka.listener.AbstractMessageListenerContainer.start(AbstractMessageListenerContainer.java:338)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.kafka.config.KafkaListenerEndpointRegistry.startIfNecessary(KafkaListenerEndpointRegistry.java:312)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.kafka.config.KafkaListenerEndpointRegistry.start(KafkaListenerEndpointRegistry.java:257)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    ... 23 common frames omitted
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    | Caused by: org.apache.kafka.common.config.ConfigException: No resolvable bootstrap urls given in bootstrap.servers
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.apache.kafka.clients.ClientUtils.parseAndValidateAddresses(ClientUtils.java:89)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.apache.kafka.clients.ClientUtils.parseAndValidateAddresses(ClientUtils.java:48)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    at org.apache.kafka.clients.consumer.KafkaConsumer.<init>(KafkaConsumer.java:737)
fhir-river_hapi-loader.1.i4fvbzfk6xy6@PRI0000DC0031    |    ... 37 common frames omitted