. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v1.5.2.RELEASE)

2019-08-13 14:54:06.535 INFO localhost-startStop-1 org.ohdsi.webapi.WebApi - - Starting WebApi on 09f62ba461ed with PID 11 (/usr/local/tomcat/webapps/WebAPI/WEB-INF/classes started by root in /usr/local/tomcat/webapps)
2019-08-13 14:54:06.546 DEBUG localhost-startStop-1 org.ohdsi.webapi.WebApi - - Running with Spring Boot v1.5.2.RELEASE, Spring v4.3.7.RELEASE
2019-08-13 14:54:06.546 INFO localhost-startStop-1 org.ohdsi.webapi.WebApi - - The following profiles are active: default
2019-08-13 14:54:06.635 INFO localhost-startStop-1 org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext - - Refreshing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@78195a05: startup date [Tue Aug 13 14:54:06 UTC 2019]; root of context hierarchy
2019-08-13 14:54:06.882 INFO background-preinit org.hibernate.validator.internal.util.Version - - HV000001: Hibernate Validator 5.3.4.Final
2019-08-13 14:54:11.797 INFO localhost-startStop-1 org.springframework.beans.factory.support.DefaultListableBeanFactory - - Overriding bean definition for bean 'requestContextFilter' with a different definition: replacing [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=org.springframework.boot.autoconfigure.jersey.JerseyAutoConfiguration; factoryMethodName=requestContextFilter; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/springframework/boot/autoconfigure/jersey/JerseyAutoConfiguration.class]] with [Root bean: class [org.springframework.boot.autoconfigure.web.WebMvcAutoConfiguration$WebMvcAutoConfigurationAdapter]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=requestContextFilter; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/springframework/boot/autoconfigure/web/WebMvcAutoConfiguration$WebMvcAutoConfigurationAdapter.class]]
2019-08-13 14:54:12.289 INFO localhost-startStop-1 org.springframework.integration.config.IntegrationRegistrar - - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
2019-08-13 14:54:13.010 WARN localhost-startStop-1 org.springframework.context.annotation.ConfigurationClassEnhancer - - @Bean method ScopeConfiguration.stepScope is non-static and returns an object assignable to Spring's BeanFactoryPostProcessor interface. This will result in a failure to process annotations such as @Autowired, @Resource and @PostConstruct within the method's declaring @Configuration class. Add the 'static' modifier to this method to avoid these container lifecycle issues; see @Bean javadoc for complete details.
2019-08-13 14:54:13.043 WARN localhost-startStop-1 org.springframework.context.annotation.ConfigurationClassEnhancer - - @Bean method ScopeConfiguration.jobScope is non-static and returns an object assignable to Spring's BeanFactoryPostProcessor interface. This will result in a failure to process annotations such as @Autowired, @Resource and @PostConstruct within the method's declaring @Configuration class. Add the 'static' modifier to this method to avoid these container lifecycle issues; see @Bean javadoc for complete details.
2019-08-13 14:54:13.091 INFO localhost-startStop-1 org.springframework.integration.config.DefaultConfiguringBeanFactoryPostProcessor - - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
2019-08-13 14:54:13.105 INFO localhost-startStop-1 org.springframework.integration.config.DefaultConfiguringBeanFactoryPostProcessor - - No bean named 'taskScheduler' has been explicitly defined. Therefore, a default ThreadPoolTaskScheduler will be created.
2019-08-13 14:54:13.157 INFO localhost-startStop-1 org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor - - JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
2019-08-13 14:54:13.240 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'converterConfiguration' of type [org.ohdsi.webapi.ConverterConfiguration$$EnhancerBySpringCGLIB$$26802cfb] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:13.258 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'conversionService' of type [org.springframework.core.convert.support.DefaultConversionService] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:13.805 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$bfe505af] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:13.920 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'shiroConfiguration' of type [org.ohdsi.webapi.ShiroConfiguration$$EnhancerBySpringCGLIB$$4536baa] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:13.938 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'flywayConfig' of type [org.ohdsi.webapi.FlywayConfig$$EnhancerBySpringCGLIB$$c288b803] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:15.145 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'secondaryDataSource' of type [org.apache.tomcat.jdbc.pool.DataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:15.160 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration' of type [org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration$$EnhancerBySpringCGLIB$$a1d8a90f] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:15.436 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'spring.datasource-org.springframework.boot.autoconfigure.jdbc.DataSourceProperties' of type [org.springframework.boot.autoconfigure.jdbc.DataSourceProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:15.464 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'dataSourceInitializer' of type [org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:15.697 INFO localhost-startStop-1 org.flywaydb.core.internal.util.VersionPrinter - - Flyway 4.2.0 by Boxfuse
2019-08-13 14:54:15.944 INFO localhost-startStop-1 org.flywaydb.core.internal.dbsupport.DbSupportFactory - - Database: jdbc:postgresql://10.65.4.5:5432/ohdsi (PostgreSQL 10.10)
2019-08-13 14:54:16.272 INFO localhost-startStop-1 org.flywaydb.core.internal.command.DbMigrate - - Current version of schema "ohdsi": 2.6.0.20181009115500
2019-08-13 14:54:16.280 WARN localhost-startStop-1 org.flywaydb.core.internal.command.DbMigrate - - outOfOrder mode is active. Migration of schema "ohdsi" may not be reproducible.
2019-08-13 14:54:16.282 INFO localhost-startStop-1 org.flywaydb.core.internal.command.DbMigrate - - Schema "ohdsi" is up to date. No migration necessary.
2019-08-13 14:54:16.284 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'flyway' of type [org.flywaydb.core.Flyway] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:16.293 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'disabledSecurity' of type [org.ohdsi.webapi.shiro.management.DisabledSecurity] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:16.315 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'noLockoutPolicy' of type [org.ohdsi.webapi.shiro.lockout.NoLockoutPolicy] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:16.408 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'securityManager' of type [org.ohdsi.webapi.shiro.lockout.LockoutWebSecurityManager] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:16.474 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'integrationGlobalProperties' of type [org.springframework.beans.factory.config.PropertiesFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:16.477 INFO localhost-startStop-1 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'integrationGlobalProperties' of type [java.util.Properties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-13 14:54:16.546 INFO localhost-startStop-1 org.springframework.web.context.ContextLoader - - Root WebApplicationContext: initialization completed in 9911 ms
2019-08-13 14:54:18.065 INFO localhost-startStop-1 org.springframework.boot.web.servlet.ServletRegistrationBean - - Mapping servlet: 'org.ohdsi.webapi.JerseyConfig' to [/*]
2019-08-13 14:54:18.074 INFO localhost-startStop-1 org.springframework.boot.web.servlet.ServletRegistrationBean - - Mapping servlet: 'dispatcherServlet' to [/]
2019-08-13 14:54:18.075 INFO localhost-startStop-1 org.springframework.boot.web.servlet.FilterRegistrationBean - - Mapping filter: 'errorPageFilter' to: [/*]
2019-08-13 14:54:18.075 INFO localhost-startStop-1 org.springframework.boot.web.servlet.FilterRegistrationBean - - Mapping filter: 'characterEncodingFilter' to: [/*]
2019-08-13 14:54:18.076 INFO localhost-startStop-1 org.springframework.boot.web.servlet.FilterRegistrationBean - - Mapping filter: 'hiddenHttpMethodFilter' to: [/*]
2019-08-13 14:54:18.076 INFO localhost-startStop-1 org.springframework.boot.web.servlet.FilterRegistrationBean - - Mapping filter: 'httpPutFormContentFilter' to: [/*]
2019-08-13 14:54:18.076 INFO localhost-startStop-1 org.springframework.boot.web.servlet.FilterRegistrationBean - - Mapping filter: 'requestContextFilter' to: [/*]
2019-08-13 14:54:18.076 INFO localhost-startStop-1 org.springframework.boot.web.servlet.FilterRegistrationBean - - Mapping filter: 'corsFilter' to: [/*]
2019-08-13 14:54:18.076 INFO localhost-startStop-1 org.springframework.boot.web.servlet.FilterRegistrationBean - - Mapping filter: 'shiroFilter' to: [/*]
2019-08-13 14:54:18.172 INFO localhost-startStop-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Loaded JDBC driver: org.postgresql.Driver
driver loaded: org.postgresql.Driver
driver loaded: com.microsoft.sqlserver.jdbc.SQLServerDriver
error loading oracle.jdbc.driver.OracleDriver driver.
driver loaded: com.amazon.redshift.jdbc.Driver
error loading com.cloudera.impala.jdbc41.Driver driver.
error loading net.starschema.clouddb.jdbc.BQDriver driver.
error loading org.netezza.Driver driver.
2019-08-13 14:54:18.829 INFO localhost-startStop-1 org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean - - Building JPA container EntityManagerFactory for persistence unit 'default'
2019-08-13 14:54:18.885 INFO localhost-startStop-1 org.hibernate.jpa.internal.util.LogHelper - - HHH000204: Processing PersistenceUnitInfo [
name: default
...]
2019-08-13 14:54:19.088 INFO localhost-startStop-1 org.hibernate.Version - - HHH000412: Hibernate Core {5.0.12.Final}
2019-08-13 14:54:19.094 INFO localhost-startStop-1 org.hibernate.cfg.Environment - - HHH000206: hibernate.properties not found
2019-08-13 14:54:19.096 INFO localhost-startStop-1 org.hibernate.cfg.Environment - - HHH000021: Bytecode provider name : javassist
2019-08-13 14:54:19.236 INFO localhost-startStop-1 org.hibernate.annotations.common.Version - - HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
2019-08-13 14:54:19.890 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:19.927 INFO localhost-startStop-1 org.hibernate.dialect.Dialect - - HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect
2019-08-13 14:54:20.338 INFO localhost-startStop-1 org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl - - HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
2019-08-13 14:54:20.348 INFO localhost-startStop-1 org.hibernate.type.BasicTypeRegistry - - HHH000270: Type registration [java.util.UUID] overrides previous : org.hibernate.type.UUIDBinaryType@4edb8485
2019-08-13 14:54:20.940 WARN localhost-startStop-1 org.hibernate.boot.internal.IdGeneratorInterpreterImpl - - HHH000392: Hibernate does not support SequenceGenerator.initialValue() unless 'hibernate.id.new_generator_mappings' set
2019-08-13 14:54:20.960 WARN localhost-startStop-1 org.hibernate.boot.internal.IdGeneratorInterpreterImpl - - HHH000392: Hibernate does not support SequenceGenerator.initialValue() unless 'hibernate.id.new_generator_mappings' set
2019-08-13 14:54:20.966 WARN localhost-startStop-1 org.hibernate.boot.internal.IdGeneratorInterpreterImpl - - HHH000392: Hibernate does not support SequenceGenerator.initialValue() unless 'hibernate.id.new_generator_mappings' set
2019-08-13 14:54:20.977 WARN localhost-startStop-1 org.hibernate.boot.internal.IdGeneratorInterpreterImpl - - HHH000392: Hibernate does not support SequenceGenerator.initialValue() unless 'hibernate.id.new_generator_mappings' set
2019-08-13 14:54:21.021 WARN localhost-startStop-1 org.hibernate.boot.internal.IdGeneratorInterpreterImpl - - HHH000392: Hibernate does not support SequenceGenerator.initialValue() unless 'hibernate.id.new_generator_mappings' set
2019-08-13 14:54:21.218 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.220 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.225 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.225 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.225 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.226 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.227 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.227 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.228 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.229 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.229 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.229 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.230 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.230 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.236 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.237 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.237 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.237 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.238 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.238 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.238 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.238 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.238 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.238 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.238 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.238 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.239 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.239 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.239 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.239 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.239 WARN localhost-startStop-1 org.hibernate.orm.deprecation - - HHH90000014: Found use of deprecated [org.hibernate.id.SequenceHiLoGenerator] sequence-based id generator; use org.hibernate.id.enhanced.SequenceStyleGenerator instead. See Hibernate Domain Model Mapping Guide for details.
2019-08-13 14:54:21.313 WARN localhost-startStop-1 org.hibernate.mapping.RootClass - - HHH000038: Composite-id class does not override equals(): org.ohdsi.webapi.conceptset.ConceptSetGenerationInfoKey
2019-08-13 14:54:21.313 WARN localhost-startStop-1 org.hibernate.mapping.RootClass - - HHH000039: Composite-id class does not override hashCode(): org.ohdsi.webapi.conceptset.ConceptSetGenerationInfoKey
2019-08-13 14:54:23.133 INFO localhost-startStop-1 org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean - - Initialized JPA EntityManagerFactory for persistence unit 'default'
2019-08-13 14:54:24.088 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.197 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.199 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.204 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.205 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.205 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.225 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.228 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.239 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.240 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.285 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.285 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.471 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.471 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.478 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.478 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.479 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.479 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.480 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.480 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.537 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.538 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.544 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.549 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.549 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.550 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.551 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.557 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.613 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.616 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.617 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.618 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.618 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.620 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.620 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.624 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.662 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.662 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.665 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.665 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.666 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.666 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.668 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.672 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.739 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.740 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.745 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.745 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.746 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.746 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.747 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:24.747 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:24.790 INFO localhost-startStop-1 org.hibernate.hql.internal.QueryTranslatorFactoryInitiator - - HHH000397: Using ASTQueryTranslatorFactory
2019-08-13 14:54:25.176 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.181 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.184 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.185 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.185 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.185 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.186 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.187 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.345 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.345 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.346 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.347 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.348 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.352 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.352 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.353 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.387 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.390 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.390 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.391 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.391 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.391 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.397 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.397 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.449 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.452 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.453 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.453 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.454 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.454 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.455 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.455 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.511 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.511 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.513 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.513 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.513 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.514 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.514 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.514 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.563 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.563 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.565 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.565 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.565 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.568 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.577 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.578 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.608 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.609 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.611 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.611 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.612 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.612 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.613 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.613 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.718 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.718 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.719 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.719 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.720 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.720 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.721 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.721 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.765 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.768 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.769 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.769 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.770 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.770 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.770 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:25.771 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:25.836 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [null]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT
2019-08-13 14:54:25.837 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7a96cdc] for JPA transaction
2019-08-13 14:54:25.840 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:25.854 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@4b15a052]
Hibernate: select cohortgene0_.id as id1_16_, cohortgene0_.source_id as source_i2_16_, cohortgene0_.execution_duration as executio3_16_, cohortgene0_.fail_message as fail_mes4_16_, cohortgene0_.include_features as include_5_16_, cohortgene0_.is_valid as is_valid6_16_, cohortgene0_.person_count as person_c7_16_, cohortgene0_.record_count as record_c8_16_, cohortgene0_.start_time as start_ti9_16_, cohortgene0_.status as status10_16_ from ohdsi.cohort_generation_info cohortgene0_ where cohortgene0_.status in (? , ?)
2019-08-13 14:54:25.959 INFO localhost-startStop-1 org.springframework.batch.core.repository.support.JobRepositoryFactoryBean - - No database type set, using meta data indicating: POSTGRES
2019-08-13 14:54:26.209 INFO localhost-startStop-1 org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor - - Initializing ExecutorService
2019-08-13 14:54:26.229 INFO localhost-startStop-1 org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor - - Initializing ExecutorService 'taskExecutor'
2019-08-13 14:54:26.240 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Found thread-bound EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7a96cdc] for JPA transaction
2019-08-13 14:54:26.240 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Participating in existing transaction
2019-08-13 14:54:26.241 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:26.242 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7a96cdc]
2019-08-13 14:54:26.242 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7a96cdc] after transaction
2019-08-13 14:54:26.243 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.290 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.296 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.300 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.301 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.302 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.304 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.305 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.305 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.393 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.394 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.394 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.395 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.395 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.395 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.396 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.396 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.559 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [null]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT
2019-08-13 14:54:26.560 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@52f37142] for JPA transaction
2019-08-13 14:54:26.564 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:26.573 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@65f74e39]
Hibernate: select ccgenerati0_.id as id1_4_, ccgenerati0_.end_time as end_time2_4_, ccgenerati0_.exit_message as exit_mes3_4_, ccgenerati0_.created_by_id as created_8_4_, ccgenerati0_.design as design4_4_, ccgenerati0_.hash_code as hash_cod5_4_, ccgenerati0_.source_id as source_i9_4_, ccgenerati0_.start_time as start_ti6_4_, ccgenerati0_.status as status7_4_, ccgenerati0_.cc_id as cc_id10_4_ from ohdsi.cc_generation ccgenerati0_ where ccgenerati0_.status in (? , ? , ? , ?)
2019-08-13 14:54:26.590 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:26.590 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@52f37142]
2019-08-13 14:54:26.591 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@52f37142] after transaction
2019-08-13 14:54:26.591 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.782 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.784 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.793 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.793 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.796 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.797 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.797 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.797 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.877 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.878 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.878 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.879 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.879 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.879 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:26.880 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:26.880 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.079 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.079 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.083 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.088 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.089 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.089 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.090 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.092 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.150 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.151 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.152 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.152 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.152 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.152 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.156 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.157 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.336 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.337 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.344 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.345 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.345 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.345 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.346 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.348 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.407 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.408 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.411 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.411 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.412 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.412 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.428 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:27.429 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.639 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [org.ohdsi.webapi.service.SourceService.getSources]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; ''
2019-08-13 14:54:27.639 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7a37b3d7] for JPA transaction
2019-08-13 14:54:27.640 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:27.649 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@30ea5f70]
2019-08-13 14:54:27.669 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Found thread-bound EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7a37b3d7] for JPA transaction
2019-08-13 14:54:27.669 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Participating in existing transaction
Hibernate: select source0_.SOURCE_ID as SOURCE_I1_49_, source0_.keytab_name as keytab_n2_49_, source0_.krb_admin_server as krb_admi3_49_, source0_.krb_auth_method as krb_auth4_49_, source0_.krb_keytab as krb_keyt5_49_, source0_.password as password6_49_, source0_.SOURCE_CONNECTION as SOURCE_C7_49_, source0_.SOURCE_DIALECT as SOURCE_D8_49_, source0_.SOURCE_KEY as SOURCE_K9_49_, source0_.SOURCE_NAME as SOURCE_10_49_, source0_.username as usernam11_49_ from ohdsi.source source0_
Hibernate: select daimons0_.SOURCE_ID as SOURCE_I5_50_0_, daimons0_.SOURCE_DAIMON_ID as SOURCE_D1_50_0_, daimons0_.SOURCE_DAIMON_ID as SOURCE_D1_50_1_, daimons0_.DAIMON_TYPE as DAIMON_T2_50_1_, daimons0_.PRIORITY as PRIORITY3_50_1_, daimons0_.SOURCE_ID as SOURCE_I5_50_1_, daimons0_.TABLE_QUALIFIER as TABLE_QU4_50_1_ from ohdsi.source_daimon daimons0_ where daimons0_.SOURCE_ID=?
2019-08-13 14:54:27.733 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:27.736 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7a37b3d7]
2019-08-13 14:54:27.756 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7a37b3d7] after transaction
2019-08-13 14:54:27.757 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.761 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select source0_.SOURCE_ID as SOURCE_I1_49_, source0_.keytab_name as keytab_n2_49_, source0_.krb_admin_server as krb_admi3_49_, source0_.krb_auth_method as krb_auth4_49_, source0_.krb_keytab as krb_keyt5_49_, source0_.password as password6_49_, source0_.SOURCE_CONNECTION as SOURCE_C7_49_, source0_.SOURCE_DIALECT as SOURCE_D8_49_, source0_.SOURCE_KEY as SOURCE_K9_49_, source0_.SOURCE_NAME as SOURCE_10_49_, source0_.username as usernam11_49_ from ohdsi.source source0_ where source0_.SOURCE_KEY=?
2019-08-13 14:54:27.780 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
Hibernate: select daimons0_.SOURCE_ID as SOURCE_I5_50_0_, daimons0_.SOURCE_DAIMON_ID as SOURCE_D1_50_0_, daimons0_.SOURCE_DAIMON_ID as SOURCE_D1_50_1_, daimons0_.DAIMON_TYPE as DAIMON_T2_50_1_, daimons0_.PRIORITY as PRIORITY3_50_1_, daimons0_.SOURCE_ID as SOURCE_I5_50_1_, daimons0_.TABLE_QUALIFIER as TABLE_QU4_50_1_ from ohdsi.source_daimon daimons0_ where daimons0_.SOURCE_ID=?
2019-08-13 14:54:27.791 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.855 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [org.springframework.batch.core.repository.support.SimpleJobRepository.getLastJobExecution]: PROPAGATION_REQUIRES_NEW,ISOLATION_READ_COMMITTED
2019-08-13 14:54:27.856 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@e60fbe6] for JPA transaction
2019-08-13 14:54:27.857 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:27.862 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DataSourceUtils - - Changing isolation level of JDBC Connection [org.postgresql.jdbc4.Jdbc4Connection@34224828] to 2
2019-08-13 14:54:27.864 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@a9591e8]
2019-08-13 14:54:27.867 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:27.873 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT JOB_INSTANCE_ID, JOB_NAME from ohdsi.BATCH_JOB_INSTANCE where JOB_NAME = ? and JOB_KEY = ?]
2019-08-13 14:54:27.881 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:27.881 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@e60fbe6]
2019-08-13 14:54:27.881 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@e60fbe6] after transaction
2019-08-13 14:54:27.881 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:27.884 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [org.springframework.batch.core.repository.support.SimpleJobRepository.createJobExecution]: PROPAGATION_REQUIRES_NEW,ISOLATION_READ_COMMITTED
2019-08-13 14:54:27.885 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@6df891bf] for JPA transaction
2019-08-13 14:54:27.885 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:27.891 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DataSourceUtils - - Changing isolation level of JDBC Connection [org.postgresql.jdbc4.Jdbc4Connection@3b4fcac] to 2
2019-08-13 14:54:27.892 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@60ce36e2]
2019-08-13 14:54:27.893 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:27.893 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT JOB_INSTANCE_ID, JOB_NAME from ohdsi.BATCH_JOB_INSTANCE where JOB_NAME = ? and JOB_KEY = ?]
2019-08-13 14:54:27.898 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:27.898 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT JOB_INSTANCE_ID, JOB_NAME from ohdsi.BATCH_JOB_INSTANCE where JOB_NAME = ? and JOB_KEY = ?]
2019-08-13 14:54:27.900 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:27.901 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [INSERT into ohdsi.BATCH_JOB_INSTANCE(JOB_INSTANCE_ID, JOB_NAME, JOB_KEY, VERSION) values (?, ?, ?, ?)]
2019-08-13 14:54:27.904 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:27.906 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:27.906 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [INSERT into ohdsi.BATCH_JOB_EXECUTION(JOB_EXECUTION_ID, JOB_INSTANCE_ID, START_TIME, END_TIME, STATUS, EXIT_CODE, EXIT_MESSAGE, VERSION, CREATE_TIME, LAST_UPDATED, JOB_CONFIGURATION_LOCATION) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
2019-08-13 14:54:27.909 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:27.909 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:27.909 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [INSERT into ohdsi.BATCH_JOB_EXECUTION_PARAMS(JOB_EXECUTION_ID, KEY_NAME, TYPE_CD, STRING_VAL, DATE_VAL, LONG_VAL, DOUBLE_VAL, IDENTIFYING) values (?, ?, ?, ?, ?, ?, ?, ?)]
2019-08-13 14:54:27.914 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:27.915 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:27.915 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [INSERT into ohdsi.BATCH_JOB_EXECUTION_PARAMS(JOB_EXECUTION_ID, KEY_NAME, TYPE_CD, STRING_VAL, DATE_VAL, LONG_VAL, DOUBLE_VAL, IDENTIFYING) values (?, ?, ?, ?, ?, ?, ?, ?)]
2019-08-13 14:54:27.915 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:27.915 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:27.916 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [INSERT into ohdsi.BATCH_JOB_EXECUTION_PARAMS(JOB_EXECUTION_ID, KEY_NAME, TYPE_CD, STRING_VAL, DATE_VAL, LONG_VAL, DOUBLE_VAL, IDENTIFYING) values (?, ?, ?, ?, ?, ?, ?, ?)]
2019-08-13 14:54:27.920 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:27.975 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:27.975 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [INSERT INTO ohdsi.BATCH_JOB_EXECUTION_CONTEXT (SHORT_CONTEXT, SERIALIZED_CONTEXT, JOB_EXECUTION_ID) VALUES(?, ?, ?)]
2019-08-13 14:54:27.980 DEBUG localhost-startStop-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:27.980 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:27.981 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@6df891bf]
2019-08-13 14:54:27.986 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@6df891bf] after transaction
2019-08-13 14:54:27.986 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.000 INFO taskExecutor-1 org.springframework.batch.core.launch.support.SimpleJobLauncher - - Job: [SimpleJob: [name=warmCache]] launched with the following parameters: [{jobName=warming OHDSI-CDMV5 cache , time=1565708067816, jobAuthor=system}]
2019-08-13 14:54:28.011 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [org.springframework.batch.core.repository.support.SimpleJobRepository.update]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2019-08-13 14:54:28.013 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@16dd0919] for JPA transaction
2019-08-13 14:54:28.016 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:28.025 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@6c76d7a6]
2019-08-13 14:54:28.027 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:28.028 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT VERSION FROM ohdsi.BATCH_JOB_EXECUTION WHERE JOB_EXECUTION_ID=?]
2019-08-13 14:54:28.036 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:28.048 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT COUNT(*) FROM ohdsi.BATCH_JOB_EXECUTION WHERE JOB_EXECUTION_ID = ?]
2019-08-13 14:54:28.050 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:28.050 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [UPDATE ohdsi.BATCH_JOB_EXECUTION set START_TIME = ?, END_TIME = ?, STATUS = ?, EXIT_CODE = ?, EXIT_MESSAGE = ?, VERSION = ?, CREATE_TIME = ?, LAST_UPDATED = ? where JOB_EXECUTION_ID = ? and VERSION = ?]
2019-08-13 14:54:28.052 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:28.052 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:28.053 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@16dd0919]
2019-08-13 14:54:28.056 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@16dd0919] after transaction
2019-08-13 14:54:28.056 DEBUG taskExecutor-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.059 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [org.springframework.batch.core.repository.support.SimpleJobRepository.getLastStepExecution]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2019-08-13 14:54:28.059 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@4389f304] for JPA transaction
2019-08-13 14:54:28.059 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:28.065 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@f3c77d8]
2019-08-13 14:54:28.065 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:28.066 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT JOB_EXECUTION_ID, START_TIME, END_TIME, STATUS, EXIT_CODE, EXIT_MESSAGE, CREATE_TIME, LAST_UPDATED, VERSION, JOB_CONFIGURATION_LOCATION from ohdsi.BATCH_JOB_EXECUTION where JOB_INSTANCE_ID = ? order by JOB_EXECUTION_ID desc]
2019-08-13 14:54:28.068 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:28.076 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT JOB_EXECUTION_ID, KEY_NAME, TYPE_CD, STRING_VAL, DATE_VAL, LONG_VAL, DOUBLE_VAL, IDENTIFYING from ohdsi.BATCH_JOB_EXECUTION_PARAMS where JOB_EXECUTION_ID = ?]
2019-08-13 14:54:28.078 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:28.080 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT STEP_EXECUTION_ID, STEP_NAME, START_TIME, END_TIME, STATUS, COMMIT_COUNT, READ_COUNT, FILTER_COUNT, WRITE_COUNT, EXIT_CODE, EXIT_MESSAGE, READ_SKIP_COUNT, WRITE_SKIP_COUNT, PROCESS_SKIP_COUNT, ROLLBACK_COUNT, LAST_UPDATED, VERSION from ohdsi.BATCH_STEP_EXECUTION where JOB_EXECUTION_ID = ? order by STEP_EXECUTION_ID]
2019-08-13 14:54:28.081 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:28.081 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@4389f304]
2019-08-13 14:54:28.082 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@4389f304] after transaction
2019-08-13 14:54:28.082 DEBUG taskExecutor-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.084 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [org.springframework.batch.core.repository.support.SimpleJobRepository.getStepExecutionCount]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2019-08-13 14:54:28.088 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@e1c9ab2] for JPA transaction
2019-08-13 14:54:28.089 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:28.098 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@73df4fc]
2019-08-13 14:54:28.099 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:28.099 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT JOB_EXECUTION_ID, START_TIME, END_TIME, STATUS, EXIT_CODE, EXIT_MESSAGE, CREATE_TIME, LAST_UPDATED, VERSION, JOB_CONFIGURATION_LOCATION from ohdsi.BATCH_JOB_EXECUTION where JOB_INSTANCE_ID = ? order by JOB_EXECUTION_ID desc]
2019-08-13 14:54:28.100 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:28.100 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT JOB_EXECUTION_ID, KEY_NAME, TYPE_CD, STRING_VAL, DATE_VAL, LONG_VAL, DOUBLE_VAL, IDENTIFYING from ohdsi.BATCH_JOB_EXECUTION_PARAMS where JOB_EXECUTION_ID = ?]
2019-08-13 14:54:28.101 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:28.101 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT STEP_EXECUTION_ID, STEP_NAME, START_TIME, END_TIME, STATUS, COMMIT_COUNT, READ_COUNT, FILTER_COUNT, WRITE_COUNT, EXIT_CODE, EXIT_MESSAGE, READ_SKIP_COUNT, WRITE_SKIP_COUNT, PROCESS_SKIP_COUNT, ROLLBACK_COUNT, LAST_UPDATED, VERSION from ohdsi.BATCH_STEP_EXECUTION where JOB_EXECUTION_ID = ? order by STEP_EXECUTION_ID]
2019-08-13 14:54:28.102 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:28.102 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@e1c9ab2]
2019-08-13 14:54:28.102 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@e1c9ab2] after transaction
2019-08-13 14:54:28.102 DEBUG taskExecutor-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.108 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [org.springframework.batch.core.repository.support.SimpleJobRepository.add]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2019-08-13 14:54:28.109 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@1dd9d09d] for JPA transaction
2019-08-13 14:54:28.109 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:28.113 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@77fa009e]
2019-08-13 14:54:28.114 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:28.114 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [INSERT into ohdsi.BATCH_STEP_EXECUTION(STEP_EXECUTION_ID, VERSION, STEP_NAME, JOB_EXECUTION_ID, START_TIME, END_TIME, STATUS, COMMIT_COUNT, READ_COUNT, FILTER_COUNT, WRITE_COUNT, EXIT_CODE, EXIT_MESSAGE, READ_SKIP_COUNT, WRITE_SKIP_COUNT, PROCESS_SKIP_COUNT, ROLLBACK_COUNT, LAST_UPDATED) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
2019-08-13 14:54:28.115 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:28.116 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:28.116 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [INSERT INTO ohdsi.BATCH_STEP_EXECUTION_CONTEXT (SHORT_CONTEXT, SERIALIZED_CONTEXT, STEP_EXECUTION_ID) VALUES(?, ?, ?)]
2019-08-13 14:54:28.117 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:28.117 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:28.123 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@1dd9d09d]
2019-08-13 14:54:28.126 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@1dd9d09d] after transaction
2019-08-13 14:54:28.127 DEBUG taskExecutor-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.129 INFO taskExecutor-1 org.springframework.batch.core.job.SimpleStepHandler - - Executing step: [warmCacheStep]
2019-08-13 14:54:28.129 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [org.springframework.batch.core.repository.support.SimpleJobRepository.update]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2019-08-13 14:54:28.129 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7408f4ac] for JPA transaction
2019-08-13 14:54:28.129 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:28.133 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@5351e443]
2019-08-13 14:54:28.133 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:28.133 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [UPDATE ohdsi.BATCH_STEP_EXECUTION set START_TIME = ?, END_TIME = ?, STATUS = ?, COMMIT_COUNT = ?, READ_COUNT = ?, FILTER_COUNT = ?, WRITE_COUNT = ?, EXIT_CODE = ?, EXIT_MESSAGE = ?, VERSION = ?, READ_SKIP_COUNT = ?, PROCESS_SKIP_COUNT = ?, WRITE_SKIP_COUNT = ?, ROLLBACK_COUNT = ?, LAST_UPDATED = ? where STEP_EXECUTION_ID = ? and VERSION = ?]
2019-08-13 14:54:28.134 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:28.135 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:28.135 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT VERSION FROM ohdsi.BATCH_JOB_EXECUTION WHERE JOB_EXECUTION_ID=?]
2019-08-13 14:54:28.135 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:28.135 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7408f4ac]
2019-08-13 14:54:28.139 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7408f4ac] after transaction
2019-08-13 14:54:28.139 DEBUG taskExecutor-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.150 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [org.springframework.batch.core.repository.support.SimpleJobRepository.updateExecutionContext]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2019-08-13 14:54:28.150 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@108081eb] for JPA transaction
2019-08-13 14:54:28.150 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:28.159 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@73f31546]
2019-08-13 14:54:28.161 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:28.161 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [UPDATE ohdsi.BATCH_STEP_EXECUTION_CONTEXT SET SHORT_CONTEXT = ?, SERIALIZED_CONTEXT = ? WHERE STEP_EXECUTION_ID = ?]
2019-08-13 14:54:28.162 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:28.162 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:28.163 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@108081eb]
2019-08-13 14:54:28.166 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@108081eb] after transaction
2019-08-13 14:54:28.166 DEBUG taskExecutor-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.180 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [null]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2019-08-13 14:54:28.188 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7ebe7f67] for JPA transaction
2019-08-13 14:54:28.189 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:28.193 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@8977218]
2019-08-13 14:54:28.307 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:28.307 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [WITH concepts AS (
SELECT
CAST(ancestor_concept_id AS VARCHAR) ancestor_id,
CAST(descendant_concept_id AS VARCHAR) descendant_id
FROM public.concept_ancestor ca
), counts AS (
SELECT stratum_1 concept_id, MAX (count_value) agg_count_value
FROM ohdsi.achilles_results
WHERE analysis_id IN (2, 4, 5, 201, 301, 401, 501, 505, 601, 701, 801, 901, 1001, 1201, 1801)

GROUP BY stratum_1
UNION
SELECT stratum_2 AS concept_id, SUM (count_value) AS agg_count_value
FROM ohdsi.achilles_results
WHERE analysis_id IN (405, 605, 705, 805, 807, 1805, 1807)

GROUP BY stratum_2
)
SELECT
concepts.ancestor_id concept_id,
COALESCE(max(c1.agg_count_value),0) record_count,
COALESCE(sum(c2.agg_count_value),0) descendant_record_count

FROM concepts
LEFT JOIN counts c1 ON concepts.ancestor_id = c1.concept_id
LEFT JOIN counts c2 ON concepts.descendant_id = c2.concept_id
GROUP BY concepts.ancestor_id
HAVING COALESCE(max(c1.agg_count_value),0) > 0 OR COALESCE(sum(c2.agg_count_value),0) > 0]
2019-08-13 14:54:28.307 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DataSourceUtils - - Fetching JDBC Connection from DataSource
2019-08-13 14:54:28.312 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi?user=ohdsi_app_user&password=app1]
2019-08-13 14:54:28.321 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DataSourceUtils - - Registering transaction synchronization for JDBC Connection
2019-08-13 14:54:28.357 INFO taskExecutor-1 org.springframework.beans.factory.xml.XmlBeanDefinitionReader - - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2019-08-13 14:54:28.530 INFO taskExecutor-1 org.springframework.jdbc.support.SQLErrorCodesFactory - - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana]
2019-08-13 14:54:28.530 DEBUG taskExecutor-1 org.springframework.jdbc.support.SQLErrorCodesFactory - - Looking up default SQLErrorCodes for DataSource [org.springframework.jdbc.datasource.DriverManagerDataSource@3ea577a4]
2019-08-13 14:54:28.531 DEBUG taskExecutor-1 org.springframework.jdbc.support.SQLErrorCodesFactory - - SQL error codes for 'PostgreSQL' found
2019-08-13 14:54:28.531 DEBUG taskExecutor-1 org.springframework.jdbc.support.SQLErrorCodesFactory - - Caching SQL error codes for DataSource [org.springframework.jdbc.datasource.DriverManagerDataSource@3ea577a4]: database product name is 'PostgreSQL'
2019-08-13 14:54:28.532 DEBUG taskExecutor-1 org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator - - Translating SQLException with SQL state '42P01', error code '0', message [ERROR: relation "public.concept_ancestor" does not exist
Position: 157]; SQL was [WITH concepts AS (
SELECT
CAST(ancestor_concept_id AS VARCHAR) ancestor_id,
CAST(descendant_concept_id AS VARCHAR) descendant_id
FROM public.concept_ancestor ca
), counts AS (
SELECT stratum_1 concept_id, MAX (count_value) agg_count_value
FROM ohdsi.achilles_results
WHERE analysis_id IN (2, 4, 5, 201, 301, 401, 501, 505, 601, 701, 801, 901, 1001, 1201, 1801)

GROUP BY stratum_1
UNION
SELECT stratum_2 AS concept_id, SUM (count_value) AS agg_count_value
FROM ohdsi.achilles_results
WHERE analysis_id IN (405, 605, 705, 805, 807, 1805, 1807)

GROUP BY stratum_2
)
SELECT
concepts.ancestor_id concept_id,
COALESCE(max(c1.agg_count_value),0) record_count,
COALESCE(sum(c2.agg_count_value),0) descendant_record_count

FROM concepts
LEFT JOIN counts c1 ON concepts.ancestor_id = c1.concept_id
LEFT JOIN counts c2 ON concepts.descendant_id = c2.concept_id
GROUP BY concepts.ancestor_id
HAVING COALESCE(max(c1.agg_count_value),0) > 0 OR COALESCE(sum(c2.agg_count_value),0) > 0] for task [PreparedStatementCallback]
2019-08-13 14:54:28.532 ERROR taskExecutor-1 org.ohdsi.webapi.cdmresults.CDMResultsCacheTasklet - - Failed to warm cache for OHDSI-CDMV5. Exception: PreparedStatementCallback; bad SQL grammar [WITH concepts AS (
SELECT
CAST(ancestor_concept_id AS VARCHAR) ancestor_id,
CAST(descendant_concept_id AS VARCHAR) descendant_id
FROM public.concept_ancestor ca
), counts AS (
SELECT stratum_1 concept_id, MAX (count_value) agg_count_value
FROM ohdsi.achilles_results
WHERE analysis_id IN (2, 4, 5, 201, 301, 401, 501, 505, 601, 701, 801, 901, 1001, 1201, 1801)

GROUP BY stratum_1
UNION
SELECT stratum_2 AS concept_id, SUM (count_value) AS agg_count_value
FROM ohdsi.achilles_results
WHERE analysis_id IN (405, 605, 705, 805, 807, 1805, 1807)

GROUP BY stratum_2
)
SELECT
concepts.ancestor_id concept_id,
COALESCE(max(c1.agg_count_value),0) record_count,
COALESCE(sum(c2.agg_count_value),0) descendant_record_count

FROM concepts
LEFT JOIN counts c1 ON concepts.ancestor_id = c1.concept_id
LEFT JOIN counts c2 ON concepts.descendant_id = c2.concept_id
GROUP BY concepts.ancestor_id
HAVING COALESCE(max(c1.agg_count_value),0) > 0 OR COALESCE(sum(c2.agg_count_value),0) > 0]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "public.concept_ancestor" does not exist
Position: 157
2019-08-13 14:54:28.532 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Found thread-bound EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7ebe7f67] for JPA transaction
2019-08-13 14:54:28.536 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Participating in existing transaction
2019-08-13 14:54:28.537 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:28.537 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [UPDATE ohdsi.BATCH_STEP_EXECUTION_CONTEXT SET SHORT_CONTEXT = ?, SERIALIZED_CONTEXT = ? WHERE STEP_EXECUTION_ID = ?]
2019-08-13 14:54:28.542 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:28.542 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Found thread-bound EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7ebe7f67] for JPA transaction
2019-08-13 14:54:28.542 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Participating in existing transaction
2019-08-13 14:54:28.542 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:28.543 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [UPDATE ohdsi.BATCH_STEP_EXECUTION set START_TIME = ?, END_TIME = ?, STATUS = ?, COMMIT_COUNT = ?, READ_COUNT = ?, FILTER_COUNT = ?, WRITE_COUNT = ?, EXIT_CODE = ?, EXIT_MESSAGE = ?, VERSION = ?, READ_SKIP_COUNT = ?, PROCESS_SKIP_COUNT = ?, WRITE_SKIP_COUNT = ?, ROLLBACK_COUNT = ?, LAST_UPDATED = ? where STEP_EXECUTION_ID = ? and VERSION = ?]
2019-08-13 14:54:28.544 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:28.544 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:28.544 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT VERSION FROM ohdsi.BATCH_JOB_EXECUTION WHERE JOB_EXECUTION_ID=?]
2019-08-13 14:54:28.545 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DataSourceUtils - - Returning JDBC Connection to DataSource
2019-08-13 14:54:28.548 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:28.548 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7ebe7f67]
2019-08-13 14:54:28.552 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@7ebe7f67] after transaction
2019-08-13 14:54:28.553 DEBUG taskExecutor-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.555 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [org.springframework.batch.core.repository.support.SimpleJobRepository.updateExecutionContext]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2019-08-13 14:54:28.555 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@4dd8cc59] for JPA transaction
2019-08-13 14:54:28.555 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:28.577 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@3d873164]
2019-08-13 14:54:28.577 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:28.577 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [UPDATE ohdsi.BATCH_STEP_EXECUTION_CONTEXT SET SHORT_CONTEXT = ?, SERIALIZED_CONTEXT = ? WHERE STEP_EXECUTION_ID = ?]
2019-08-13 14:54:28.579 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:28.579 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:28.579 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@4dd8cc59]
2019-08-13 14:54:28.582 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@4dd8cc59] after transaction
2019-08-13 14:54:28.582 DEBUG taskExecutor-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.585 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [org.springframework.batch.core.repository.support.SimpleJobRepository.update]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2019-08-13 14:54:28.586 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@675b2098] for JPA transaction
2019-08-13 14:54:28.586 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:28.590 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@63533106]
2019-08-13 14:54:28.590 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:28.591 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [UPDATE ohdsi.BATCH_STEP_EXECUTION set START_TIME = ?, END_TIME = ?, STATUS = ?, COMMIT_COUNT = ?, READ_COUNT = ?, FILTER_COUNT = ?, WRITE_COUNT = ?, EXIT_CODE = ?, EXIT_MESSAGE = ?, VERSION = ?, READ_SKIP_COUNT = ?, PROCESS_SKIP_COUNT = ?, WRITE_SKIP_COUNT = ?, ROLLBACK_COUNT = ?, LAST_UPDATED = ? where STEP_EXECUTION_ID = ? and VERSION = ?]
2019-08-13 14:54:28.597 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:28.598 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:28.598 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT VERSION FROM ohdsi.BATCH_JOB_EXECUTION WHERE JOB_EXECUTION_ID=?]
2019-08-13 14:54:28.598 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:28.604 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@675b2098]
2019-08-13 14:54:28.608 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@675b2098] after transaction
2019-08-13 14:54:28.608 DEBUG taskExecutor-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.611 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [org.springframework.batch.core.repository.support.SimpleJobRepository.updateExecutionContext]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2019-08-13 14:54:28.611 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@835bd04] for JPA transaction
2019-08-13 14:54:28.611 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:28.618 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@36d4037a]
2019-08-13 14:54:28.618 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:28.619 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [UPDATE ohdsi.BATCH_JOB_EXECUTION_CONTEXT SET SHORT_CONTEXT = ?, SERIALIZED_CONTEXT = ? WHERE JOB_EXECUTION_ID = ?]
2019-08-13 14:54:28.620 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:28.621 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:28.621 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@835bd04]
2019-08-13 14:54:28.624 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@835bd04] after transaction
2019-08-13 14:54:28.624 DEBUG taskExecutor-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.626 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [org.springframework.batch.core.repository.support.SimpleJobRepository.update]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2019-08-13 14:54:28.628 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@27352fae] for JPA transaction
2019-08-13 14:54:28.628 DEBUG taskExecutor-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:28.634 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@72450e6d]
2019-08-13 14:54:28.636 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:28.644 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT VERSION FROM ohdsi.BATCH_JOB_EXECUTION WHERE JOB_EXECUTION_ID=?]
2019-08-13 14:54:28.645 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL query
2019-08-13 14:54:28.645 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [SELECT COUNT(*) FROM ohdsi.BATCH_JOB_EXECUTION WHERE JOB_EXECUTION_ID = ?]
2019-08-13 14:54:28.646 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL update
2019-08-13 14:54:28.646 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - Executing prepared SQL statement [UPDATE ohdsi.BATCH_JOB_EXECUTION set START_TIME = ?, END_TIME = ?, STATUS = ?, EXIT_CODE = ?, EXIT_MESSAGE = ?, VERSION = ?, CREATE_TIME = ?, LAST_UPDATED = ? where JOB_EXECUTION_ID = ? and VERSION = ?]
2019-08-13 14:54:28.647 DEBUG taskExecutor-1 org.springframework.jdbc.core.JdbcTemplate - - SQL update affected 1 rows
2019-08-13 14:54:28.647 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:28.647 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@27352fae]
2019-08-13 14:54:28.650 DEBUG taskExecutor-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@27352fae] after transaction
2019-08-13 14:54:28.650 DEBUG taskExecutor-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.652 INFO taskExecutor-1 org.springframework.batch.core.launch.support.SimpleJobLauncher - - Job: [SimpleJob: [name=warmCache]] completed with the following parameters: [{jobName=warming OHDSI-CDMV5 cache , time=1565708067816, jobAuthor=system}] and the following status: [COMPLETED]
2019-08-13 14:54:28.706 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:28.713 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.713 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:28.714 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.714 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:28.714 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.715 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:28.715 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.883 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:28.884 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.884 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:28.885 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.888 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:28.889 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.889 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:28.889 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.985 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:28.985 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.986 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:28.986 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.986 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:28.987 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:28.987 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:28.987 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.136 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.137 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.141 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.141 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.141 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.142 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.142 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.143 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.223 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.228 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.229 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.229 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.229 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.230 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.230 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.230 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.269 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.270 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.270 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.270 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.271 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.271 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.272 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.276 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.297 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.297 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.297 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.301 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.301 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.301 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.301 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.302 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.329 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.336 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.337 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.337 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.337 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.338 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.338 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.338 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.383 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.389 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.389 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.389 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.390 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.392 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.393 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.393 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.466 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.472 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.473 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.473 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.474 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.474 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.474 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.475 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.512 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.512 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.517 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.517 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.517 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.517 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.518 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.518 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.545 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Creating new transaction with name [null]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT
2019-08-13 14:54:29.545 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Opened new EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@4a98f71e] for JPA transaction
2019-08-13 14:54:29.545 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:29.553 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@4ab9ac2f]
Hibernate: select executioni0_.analysis_id as analysis1_35_, executioni0_.source_id as source_i2_35_, executioni0_.execution_duration as executio3_35_, executioni0_.is_valid as is_valid4_35_, executioni0_.message as message5_35_, executioni0_.start_time as start_ti6_35_, executioni0_.status as status7_35_ from ohdsi.ir_execution executioni0_ where executioni0_.status in (? , ?)
2019-08-13 14:54:29.563 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Found thread-bound EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@4a98f71e] for JPA transaction
2019-08-13 14:54:29.563 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Participating in existing transaction
2019-08-13 14:54:29.564 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Initiating transaction commit
2019-08-13 14:54:29.564 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Committing JPA transaction on EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@4a98f71e]
2019-08-13 14:54:29.564 DEBUG localhost-startStop-1 org.springframework.orm.jpa.JpaTransactionManager - - Closing JPA EntityManager [org.hibernate.jpa.internal.EntityManagerImpl@4a98f71e] after transaction
2019-08-13 14:54:29.564 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.653 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DataSourceUtils - - Fetching JDBC Connection from DataSource
2019-08-13 14:54:29.653 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:29.661 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DataSourceUtils - - Returning JDBC Connection to DataSource
2019-08-13 14:54:29.663 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DataSourceUtils - - Fetching JDBC Connection from DataSource
2019-08-13 14:54:29.663 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:29.667 DEBUG localhost-startStop-1 org.springframework.jdbc.datasource.DataSourceUtils - - Returning JDBC Connection to DataSource
2019-08-13 14:54:29.752 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.753 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.754 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.754 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.755 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.755 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.756 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.756 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.855 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.855 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.856 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.856 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.857 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.858 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.858 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.858 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.914 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.915 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.917 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.917 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.917 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.917 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.918 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.918 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.953 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.953 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.954 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.954 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.954 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.954 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.955 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.955 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.990 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.992 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.993 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.993 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.993 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.994 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:29.994 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:29.996 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.203 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.204 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.205 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.205 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.205 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.205 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.206 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.206 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.297 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.298 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.299 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.302 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.304 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.304 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.305 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.309 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.330 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.330 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.331 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.331 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.331 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.332 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.332 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.332 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.346 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.348 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.351 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.351 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.351 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.351 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.352 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.352 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.372 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.374 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.376 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.376 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.376 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.377 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.377 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.377 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.393 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.393 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.394 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.395 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.396 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.396 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.396 DEBUG localhost-startStop-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
2019-08-13 14:54:30.396 DEBUG localhost-startStop-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:30.598 INFO localhost-startStop-1 org.flywaydb.core.internal.command.DbMigrate - - Current version of schema "ohdsi": 2.6.0.20181009115500
2019-08-13 14:54:30.605 WARN localhost-startStop-1 org.flywaydb.core.internal.command.DbMigrate - - outOfOrder mode is active. Migration of schema "ohdsi" may not be reproducible.
2019-08-13 14:54:30.606 INFO localhost-startStop-1 org.flywaydb.core.internal.command.DbMigrate - - Schema "ohdsi" is up to date. No migration necessary.
2019-08-13 14:54:31.485 INFO localhost-startStop-1 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter - - Looking for @ControllerAdvice: org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@78195a05: startup date [Tue Aug 13 14:54:06 UTC 2019]; root of context hierarchy
2019-08-13 14:54:31.660 INFO localhost-startStop-1 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/error],produces=[text/html]}" onto public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
2019-08-13 14:54:31.662 INFO localhost-startStop-1 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/error]}" onto public org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, java.lang.Object>> org.springframework.boot.autoconfigure.web.BasicErrorController.error(javax.servlet.http.HttpServletRequest)
2019-08-13 14:54:31.729 INFO localhost-startStop-1 org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/webjars/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
2019-08-13 14:54:31.729 INFO localhost-startStop-1 org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
2019-08-13 14:54:31.820 INFO localhost-startStop-1 org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/**/favicon.ico] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
2019-08-13 14:54:32.200 INFO localhost-startStop-1 org.springframework.ldap.core.support.AbstractContextSource - - Property 'userDn' not set - anonymous context will be used for read-write operations
2019-08-13 14:54:32.802 INFO localhost-startStop-1 org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler - - Initializing ExecutorService 'taskScheduler'
2019-08-13 14:54:33.524 INFO localhost-startStop-1 org.springframework.jmx.export.annotation.AnnotationMBeanExporter - - Registering beans for JMX exposure on startup
2019-08-13 14:54:33.554 INFO localhost-startStop-1 org.springframework.jmx.export.annotation.AnnotationMBeanExporter - - Bean with name 'integrationMbeanExporter' has been autodetected for JMX exposure
2019-08-13 14:54:33.557 INFO localhost-startStop-1 org.springframework.jmx.export.annotation.AnnotationMBeanExporter - - Located managed bean 'integrationMbeanExporter': registering with JMX server as MBean [org.springframework.integration.monitor:name=integrationMbeanExporter,type=IntegrationMBeanExporter]
2019-08-13 14:54:33.628 INFO localhost-startStop-1 org.springframework.integration.monitor.IntegrationMBeanExporter - - Registering beans for JMX exposure on startup
2019-08-13 14:54:33.629 INFO localhost-startStop-1 org.springframework.integration.monitor.IntegrationMBeanExporter - - Registering MessageChannel errorChannel
2019-08-13 14:54:33.632 INFO localhost-startStop-1 org.springframework.integration.monitor.IntegrationMBeanExporter - - Located managed bean 'org.springframework.integration:type=MessageChannel,name=errorChannel': registering with JMX server as MBean [org.springframework.integration:type=MessageChannel,name=errorChannel]
2019-08-13 14:54:33.982 INFO localhost-startStop-1 org.springframework.integration.monitor.IntegrationMBeanExporter - - Registering MessageChannel nullChannel
2019-08-13 14:54:33.985 INFO localhost-startStop-1 org.springframework.integration.monitor.IntegrationMBeanExporter - - Located managed bean 'org.springframework.integration:type=MessageChannel,name=nullChannel': registering with JMX server as MBean [org.springframework.integration:type=MessageChannel,name=nullChannel]
2019-08-13 14:54:34.008 INFO localhost-startStop-1 org.springframework.integration.monitor.IntegrationMBeanExporter - - Registering MessageHandler errorLogger
2019-08-13 14:54:34.013 INFO localhost-startStop-1 org.springframework.integration.monitor.IntegrationMBeanExporter - - Located managed bean 'org.springframework.integration:type=MessageHandler,name=errorLogger,bean=internal': registering with JMX server as MBean [org.springframework.integration:type=MessageHandler,name=errorLogger,bean=internal]
2019-08-13 14:54:34.051 INFO localhost-startStop-1 org.springframework.context.support.DefaultLifecycleProcessor - - Starting beans in phase 0
2019-08-13 14:54:34.052 INFO localhost-startStop-1 org.springframework.integration.endpoint.EventDrivenConsumer - - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
2019-08-13 14:54:34.053 INFO localhost-startStop-1 org.springframework.integration.channel.PublishSubscribeChannel - - Channel 'application:default:8090.errorChannel' has 1 subscriber(s).
2019-08-13 14:54:34.056 INFO localhost-startStop-1 org.springframework.integration.endpoint.EventDrivenConsumer - - started _org.springframework.integration.errorLogger
2019-08-13 14:54:34.056 INFO localhost-startStop-1 org.springframework.context.support.DefaultLifecycleProcessor - - Starting beans in phase 2147483647
2019-08-13 14:54:34.082 DEBUG task-scheduler-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:54:34.113 DEBUG task-scheduler-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:34.119 INFO localhost-startStop-1 org.ohdsi.webapi.WebApi - - Started WebApi in 28.492 seconds (JVM running for 41.697)
2019-08-13 14:54:34.122 DEBUG task-scheduler-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:44.127 DEBUG task-scheduler-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:54:44.131 DEBUG task-scheduler-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:44.146 DEBUG task-scheduler-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:54:54.150 DEBUG task-scheduler-2 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:54:54.157 DEBUG task-scheduler-2 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:54:54.171 DEBUG task-scheduler-2 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:55:04.176 DEBUG task-scheduler-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:55:04.178 DEBUG task-scheduler-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:55:04.190 DEBUG task-scheduler-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:55:14.191 DEBUG task-scheduler-3 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:55:14.193 DEBUG task-scheduler-3 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:55:14.207 DEBUG task-scheduler-3 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:55:24.209 DEBUG task-scheduler-6 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:55:24.210 DEBUG task-scheduler-6 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:55:24.227 DEBUG task-scheduler-6 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:55:34.232 DEBUG task-scheduler-4 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:55:34.234 DEBUG task-scheduler-4 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:55:34.248 DEBUG task-scheduler-4 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:55:44.256 DEBUG task-scheduler-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:55:44.265 DEBUG task-scheduler-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:55:44.280 DEBUG task-scheduler-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:55:54.285 DEBUG task-scheduler-9 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:55:54.286 DEBUG task-scheduler-9 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:55:54.296 DEBUG task-scheduler-9 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:56:04.298 DEBUG task-scheduler-3 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:56:04.302 DEBUG task-scheduler-3 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:56:04.319 DEBUG task-scheduler-3 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:56:14.324 DEBUG task-scheduler-2 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:56:14.331 DEBUG task-scheduler-2 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:56:14.346 DEBUG task-scheduler-2 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:56:24.351 DEBUG task-scheduler-7 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:56:24.353 DEBUG task-scheduler-7 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:56:24.365 DEBUG task-scheduler-7 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:56:34.367 DEBUG task-scheduler-8 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:56:34.368 DEBUG task-scheduler-8 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:56:34.383 DEBUG task-scheduler-8 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:56:44.387 DEBUG task-scheduler-5 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:56:44.392 DEBUG task-scheduler-5 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:56:44.403 DEBUG task-scheduler-5 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:56:54.404 DEBUG task-scheduler-10 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:56:54.407 DEBUG task-scheduler-10 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:56:54.416 DEBUG task-scheduler-10 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:57:04.418 DEBUG task-scheduler-6 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:57:04.424 DEBUG task-scheduler-6 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:57:04.435 DEBUG task-scheduler-6 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:57:14.436 DEBUG task-scheduler-7 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:57:14.439 DEBUG task-scheduler-7 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:57:14.449 DEBUG task-scheduler-7 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:57:24.451 DEBUG task-scheduler-1 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:57:24.453 DEBUG task-scheduler-1 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:57:24.465 DEBUG task-scheduler-1 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
2019-08-13 14:57:34.466 DEBUG task-scheduler-9 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
Hibernate: select analysisex0_.id as id1_0_, analysisex0_.analysis_id as analysis2_0_, analysisex0_.analysis_type as analysis3_0_, analysisex0_.duration as duration4_0_, analysisex0_.executed as executed5_0_, analysisex0_.executionStatus as executio6_0_, analysisex0_.source_id as source_i7_0_, analysisex0_.update_password as update_p8_0_, analysisex0_.sec_user_id as sec_user9_0_ from ohdsi.analysis_execution analysisex0_ where analysisex0_.executed<? and (analysisex0_.executionStatus in (? , ? , ?))
2019-08-13 14:57:34.467 DEBUG task-scheduler-9 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://10.65.4.5:5432/ohdsi]
2019-08-13 14:57:34.477 DEBUG task-scheduler-9 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager