2023-04-18 05:27:51 
2023-04-18 05:27:51   .   ____          _            __ _ _
2023-04-18 05:27:51  /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
2023-04-18 05:27:51 ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
2023-04-18 05:27:51  \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
2023-04-18 05:27:51   '  |____| .__|_| |_|_| |_\__, | / / / /
2023-04-18 05:27:51  =========|_|==============|___/=/_/_/_/
2023-04-18 05:27:51  :: Spring Boot ::       (v1.5.22.RELEASE)
2023-04-18 05:27:51 
2023-04-18 05:27:51 2023-04-18 09:27:51.763 INFO main org.springframework.boot.StartupInfoLogger - [] - Starting WebApi on 36d4379775f9 with PID 1 (/var/lib/ohdsi/webapi/WEB-INF/classes started by ? in /var/lib/ohdsi/webapi)
2023-04-18 05:27:51 2023-04-18 09:27:51.768 INFO main org.springframework.boot.SpringApplication - [] - The following profiles are active: default
2023-04-18 05:27:51 2023-04-18 09:27:51.814 INFO main org.springframework.context.support.AbstractApplicationContext - [] - Refreshing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@33a10788: startup date [Tue Apr 18 09:27:51 UTC 2023]; root of context hierarchy
2023-04-18 05:27:51 2023-04-18 09:27:51.964 INFO background-preinit org.hibernate.validator.internal.util.Version - [] - HV000001: Hibernate Validator 5.4.2.Final
2023-04-18 05:27:53 2023-04-18 09:27:53.142 INFO main org.springframework.beans.factory.support.DefaultListableBeanFactory - [] - Overriding bean definition for bean 'jobBuilders' 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.batch.core.configuration.annotation.SimpleBatchConfiguration; factoryMethodName=jobBuilders; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/springframework/batch/core/configuration/annotation/SimpleBatchConfiguration.class]] with [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=true; factoryBeanName=jobConfig; factoryMethodName=jobBuilders; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/ohdsi/webapi/JobConfig.class]]
2023-04-18 05:27:53 2023-04-18 09:27:53.300 INFO main 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]]
2023-04-18 05:27:53 2023-04-18 09:27:53.482 INFO main org.springframework.integration.config.IntegrationRegistrar - [] - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
2023-04-18 05:27:53 2023-04-18 09:27:53.859 INFO main org.springframework.integration.config.DefaultConfiguringBeanFactoryPostProcessor - [] - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
2023-04-18 05:27:53 2023-04-18 09:27:53.878 INFO main org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor - [] - JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
2023-04-18 05:27:53 2023-04-18 09:27:53.922 INFO main org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'converterConfiguration' of type [org.ohdsi.webapi.ConverterConfiguration$$EnhancerBySpringCGLIB$$afc10f5] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-04-18 05:27:53 2023-04-18 09:27:53.939 INFO main 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)
2023-04-18 05:27:54 2023-04-18 09:27:54.195 INFO main org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$a460e9a9] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-04-18 05:27:54 2023-04-18 09:27:54.348 INFO main org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'shiroConfiguration' of type [org.ohdsi.webapi.ShiroConfiguration$$EnhancerBySpringCGLIB$$e8cf4fa4] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-04-18 05:27:54 2023-04-18 09:27:54.360 INFO main org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'flywayConfig' of type [org.ohdsi.webapi.FlywayConfig$$EnhancerBySpringCGLIB$$a7049bfd] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-04-18 05:27:54 2023-04-18 09:27:54.590 INFO main 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)
2023-04-18 05:27:54 2023-04-18 09:27:54.611 INFO main org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - [] - Bean 'org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration' of type [org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration$$EnhancerBySpringCGLIB$$86548d09] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2023-04-18 05:27:54 2023-04-18 09:27:54.632 INFO main 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)
2023-04-18 05:27:54 2023-04-18 09:27:54.649 INFO main 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)
2023-04-18 05:27:54 2023-04-18 09:27:54.719 INFO main org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - Flyway 4.2.0 by Boxfuse
2023-04-18 05:27:55 2023-04-18 09:27:55.548 INFO main org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - Database: jdbc:postgresql://192.168.0.119:5432/OHDSI (PostgreSQL 15.1)
2023-04-18 05:27:55 2023-04-18 09:27:55.636 INFO main org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - Creating Metadata table: "webapi"."schema_history"
2023-04-18 05:27:55 2023-04-18 09:27:55.678 INFO main org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - Successfully baselined schema with version: 2.2.5.20180212152023
2023-04-18 05:27:55 2023-04-18 09:27:55.775 INFO main org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - Current version of schema "webapi": 2.2.5.20180212152023
2023-04-18 05:27:55 2023-04-18 09:27:55.776 WARN main org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - outOfOrder mode is active. Migration of schema "webapi" may not be reproducible.
2023-04-18 05:27:55 2023-04-18 09:27:55.777 INFO main org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - Migrating schema "webapi" to version 2.2.5.20180212181325 - cca-author
2023-04-18 05:27:55 2023-04-18 09:27:55.808 INFO main org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - Migrating schema "webapi" to version 2.2.5.20180215105415 - separate-sequences
2023-04-18 05:27:55 2023-04-18 09:27:55.824 ERROR main org.flywaydb.core.internal.util.logging.slf4j.Slf4jLog - [] - Migration of schema "webapi" to version 2.2.5.20180215105415 - separate-sequences failed! Changes successfully rolled back.
2023-04-18 05:27:55 2023-04-18 09:27:55.827 WARN main org.springframework.context.support.AbstractApplicationContext - [] - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'shiroFilter' defined in class path resource [org/ohdsi/webapi/ShiroConfiguration.class]: Unsatisfied dependency expressed through method 'shiroFilter' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/ohdsi/webapi/FlywayConfig.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateSqlException: 
2023-04-18 05:27:55 Migration V2.2.5.20180215105415__separate-sequences.sql failed
2023-04-18 05:27:55 --------------------------------------------------------------
2023-04-18 05:27:55 SQL State  : 42P07
2023-04-18 05:27:55 Error Code : 0
2023-04-18 05:27:55 Message    : ERROR: relation "cca_sequence" already exists
2023-04-18 05:27:55 Location   : db/migration/postgresql/V2.2.5.20180215105415__separate-sequences.sql (/var/lib/ohdsi/webapi/WEB-INF/classes/db/migration/postgresql/V2.2.5.20180215105415__separate-sequences.sql)
2023-04-18 05:27:55 Line       : 1
2023-04-18 05:27:55 Statement  : CREATE SEQUENCE webapi.cca_sequence
2023-04-18 05:27:55 
2023-04-18 05:27:55 2023-04-18 09:27:55.840 INFO main org.springframework.boot.autoconfigure.logging.AutoConfigurationReportLoggingInitializer - [] - 
2023-04-18 05:27:55 
2023-04-18 05:27:55 Error starting ApplicationContext. To display the auto-configuration report re-run your application with 'debug' enabled.
2023-04-18 05:27:55 2023-04-18 09:27:55.844 ERROR main org.springframework.boot.SpringApplication - [] - Application startup failed
2023-04-18 05:27:55 org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'shiroFilter' defined in class path resource [org/ohdsi/webapi/ShiroConfiguration.class]: Unsatisfied dependency expressed through method 'shiroFilter' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/ohdsi/webapi/FlywayConfig.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateSqlException: 
2023-04-18 05:27:55 Migration V2.2.5.20180215105415__separate-sequences.sql failed
2023-04-18 05:27:55 --------------------------------------------------------------
2023-04-18 05:27:55 SQL State  : 42P07
2023-04-18 05:27:55 Error Code : 0
2023-04-18 05:27:55 Message    : ERROR: relation "cca_sequence" already exists
2023-04-18 05:27:55 Location   : db/migration/postgresql/V2.2.5.20180215105415__separate-sequences.sql (/var/lib/ohdsi/webapi/WEB-INF/classes/db/migration/postgresql/V2.2.5.20180215105415__separate-sequences.sql)
2023-04-18 05:27:55 Line       : 1
2023-04-18 05:27:55 Statement  : CREATE SEQUENCE webapi.cca_sequence
2023-04-18 05:27:55 
2023-04-18 05:27:55 at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:467) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1177) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1072) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:237) ~[spring-context-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:703) ~[spring-context-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:527) ~[spring-context-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:123) ~[spring-boot-1.5.22.RELEASE.jar!/:1.5.22.RELEASE]
2023-04-18 05:27:55 at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:666) [spring-boot-1.5.22.RELEASE.jar!/:1.5.22.RELEASE]
2023-04-18 05:27:55 at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:353) [spring-boot-1.5.22.RELEASE.jar!/:1.5.22.RELEASE]
2023-04-18 05:27:55 at org.springframework.boot.SpringApplication.run(SpringApplication.java:300) [spring-boot-1.5.22.RELEASE.jar!/:1.5.22.RELEASE]
2023-04-18 05:27:55 at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:135) [spring-boot-1.5.22.RELEASE.jar!/:1.5.22.RELEASE]
2023-04-18 05:27:55 at org.ohdsi.webapi.WebApi.main(WebApi.java:37) [classes/:?]
2023-04-18 05:27:55 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_342]
2023-04-18 05:27:55 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_342]
2023-04-18 05:27:55 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_342]
2023-04-18 05:27:55 at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_342]
2023-04-18 05:27:55 at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [webapi/:?]
2023-04-18 05:27:55 at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [webapi/:?]
2023-04-18 05:27:55 at org.springframework.boot.loader.Launcher.launch(Launcher.java:51) [webapi/:?]
2023-04-18 05:27:55 at org.springframework.boot.loader.WarLauncher.main(WarLauncher.java:59) [webapi/:?]
2023-04-18 05:27:55 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/ohdsi/webapi/FlywayConfig.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateSqlException: 
2023-04-18 05:27:55 Migration V2.2.5.20180215105415__separate-sequences.sql failed
2023-04-18 05:27:55 --------------------------------------------------------------
2023-04-18 05:27:55 SQL State  : 42P07
2023-04-18 05:27:55 Error Code : 0
2023-04-18 05:27:55 Message    : ERROR: relation "cca_sequence" already exists
2023-04-18 05:27:55 Location   : db/migration/postgresql/V2.2.5.20180215105415__separate-sequences.sql (/var/lib/ohdsi/webapi/WEB-INF/classes/db/migration/postgresql/V2.2.5.20180215105415__separate-sequences.sql)
2023-04-18 05:27:55 Line       : 1
2023-04-18 05:27:55 Statement  : CREATE SEQUENCE webapi.cca_sequence
2023-04-18 05:27:55 
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1630) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:211) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1131) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1059) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 ... 26 more
2023-04-18 05:27:55 Caused by: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateSqlException: 
2023-04-18 05:27:55 Migration V2.2.5.20180215105415__separate-sequences.sql failed
2023-04-18 05:27:55 --------------------------------------------------------------
2023-04-18 05:27:55 SQL State  : 42P07
2023-04-18 05:27:55 Error Code : 0
2023-04-18 05:27:55 Message    : ERROR: relation "cca_sequence" already exists
2023-04-18 05:27:55 Location   : db/migration/postgresql/V2.2.5.20180215105415__separate-sequences.sql (/var/lib/ohdsi/webapi/WEB-INF/classes/db/migration/postgresql/V2.2.5.20180215105415__separate-sequences.sql)
2023-04-18 05:27:55 Line       : 1
2023-04-18 05:27:55 Statement  : CREATE SEQUENCE webapi.cca_sequence
2023-04-18 05:27:55 
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:345) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate.access$900(DbMigrate.java:53) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate$4.call(DbMigrate.java:276) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:75) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:273) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:53) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:210) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:146) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.dbsupport.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:68) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.dbsupport.postgresql.PostgreSQLDbSupport.lock(PostgreSQLDbSupport.java:162) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.lock(MetaDataTableImpl.java:174) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:146) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.Flyway$1.execute(Flyway.java:1010) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.Flyway$1.execute(Flyway.java:971) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.Flyway.execute(Flyway.java:1464) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.Flyway.migrate(Flyway.java:971) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_342]
2023-04-18 05:27:55 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_342]
2023-04-18 05:27:55 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_342]
2023-04-18 05:27:55 at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_342]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1759) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1696) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1626) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:211) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1131) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1059) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 ... 26 more
2023-04-18 05:27:55 Caused by: org.postgresql.util.PSQLException: ERROR: relation "cca_sequence" already exists
2023-04-18 05:27:55 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675) ~[postgresql-42.3.7.jar!/:42.3.7]
2023-04-18 05:27:55 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365) ~[postgresql-42.3.7.jar!/:42.3.7]
2023-04-18 05:27:55 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355) ~[postgresql-42.3.7.jar!/:42.3.7]
2023-04-18 05:27:55 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490) ~[postgresql-42.3.7.jar!/:42.3.7]
2023-04-18 05:27:55 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408) ~[postgresql-42.3.7.jar!/:42.3.7]
2023-04-18 05:27:55 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:329) ~[postgresql-42.3.7.jar!/:42.3.7]
2023-04-18 05:27:55 at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:315) ~[postgresql-42.3.7.jar!/:42.3.7]
2023-04-18 05:27:55 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:291) ~[postgresql-42.3.7.jar!/:42.3.7]
2023-04-18 05:27:55 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:286) ~[postgresql-42.3.7.jar!/:42.3.7]
2023-04-18 05:27:55 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_342]
2023-04-18 05:27:55 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_342]
2023-04-18 05:27:55 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_342]
2023-04-18 05:27:55 at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_342]
2023-04-18 05:27:55 at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc-8.5.43.jar!/:?]
2023-04-18 05:27:55 at com.sun.proxy.$Proxy107.execute(Unknown Source) ~[?:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:267) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:142) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:76) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:343) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate.access$900(DbMigrate.java:53) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate$4.call(DbMigrate.java:276) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:75) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:273) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:53) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:210) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:146) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.dbsupport.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:68) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.dbsupport.postgresql.PostgreSQLDbSupport.lock(PostgreSQLDbSupport.java:162) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.lock(MetaDataTableImpl.java:174) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:146) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.Flyway$1.execute(Flyway.java:1010) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.Flyway$1.execute(Flyway.java:971) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.Flyway.execute(Flyway.java:1464) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at org.flywaydb.core.Flyway.migrate(Flyway.java:971) ~[flyway-core-4.2.0.jar!/:?]
2023-04-18 05:27:55 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_342]
2023-04-18 05:27:55 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_342]
2023-04-18 05:27:55 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_342]
2023-04-18 05:27:55 at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_342]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1759) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1696) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1626) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:211) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1131) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1059) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741) ~[spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-18 05:27:55 ... 26 more
2023-04-18 05:27:58 
2023-04-18 05:27:58   .   ____          _            __ _ _
2023-04-18 05:27:58  /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
2023-04-18 05:27:58 ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
2023-04-18 05:27:58  \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
2023-04-18 05:27:58   '  |____| .__|_| |_|_| |_\__, | / / / /
2023-04-18 05:27:58  =========|_|==============|___/=/_/_/_/
2023-04-18 05:27:58  :: Spring Boot ::       (v1.5.22.RELEASE)
2023-04-18 05:27:58 
2023-04-18 05:27:58 2023-04-18 09:27:58.259 INFO main org.springframework.boot.StartupInfoLogger - [] - Starting WebApi on 36d4379775f9 with PID 1 (/var/lib/ohdsi/webapi/WEB-INF/classes started by ? in /var/lib/ohdsi/webapi)
2023-04-18 05:27:58 2023-04-18 09:27:58.296 INFO main org.springframework.boot.SpringApplication - [] - The following profiles are active: default
2023-04-18 05:27:58 2023-04-18 09:27:58.350 INFO main org.springframework.context.support.AbstractApplicationContext - [] - Refreshing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@33a10788: startup date [Tue Apr 18 09:27:58 UTC 2023]; root of context hierarchy
2023-04-18 05:27:58 2023-04-18 09:27:58.550 INFO background-preinit org.hibernate.validator.internal.util.Version - [] - HV000001: Hibernate Validator 5.4.2.Final