API tools faq
paste
Guest User

Ohdsi new error

a guest
Sep 1st, 2015
334
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 178.86 KB | None | 0 0
raw download clone embed print report
  1. rgmac:Downloads maurya$ java -XX:MaxPermSize=128m -jar Olympus-1.2.0-exec.war
  2. Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128m; support was removed in 8.0
  3.  
  4. . ____ _ __ _ _
  5. /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
  6. ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
  7. \\/ ___)| |_)| | | | | || (_| | ) ) ) )
  8. ' |____| .__|_| |_|_| |_\__, | / / / /
  9. =========|_|==============|___/=/_/_/_/
  10. :: Spring Boot :: (v1.2.1.RELEASE)
  11.  
  12. 2015-09-02 00:21:12.698 INFO main org.ohdsi.olympus.Olympus - - Starting Olympus on rgmac.local with PID 1227 (started by maurya in /Users/maurya/Downloads)
  13. 2015-09-02 00:21:12.700 DEBUG main org.ohdsi.olympus.Olympus - - Running with Spring Boot v1.2.1.RELEASE, Spring v4.1.4.RELEASE
  14. 2015-09-02 00:21:12.758 INFO main org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext - - Refreshing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@4ab81e89: startup date [Wed Sep 02 00:21:12 EDT 2015]; root of context hierarchy
  15. 2015-09-02 00:21:13.193 WARN main org.springframework.core.io.support.PathMatchingResourcePatternResolver - - Skipping [/Users/maurya/Downloads/Olympus-1.2.0-exec.war] because it does not denote a directory
  16. 2015-09-02 00:21:14.090 INFO main org.springframework.beans.factory.support.DefaultListableBeanFactory - - Overriding bean definition for bean 'passwordEncoder': replacing [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=securityConfig.SecurityUtilsConfiguration; factoryMethodName=passwordEncoder; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/ohdsi/olympus/SecurityConfig$SecurityUtilsConfiguration.class]] with [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=securityConfig; factoryMethodName=passwordEncoder; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/ohdsi/olympus/SecurityConfig.class]]
  17. 2015-09-02 00:21:14.974 INFO main org.hibernate.validator.internal.util.Version - - HV000001: Hibernate Validator 5.1.3.Final
  18. 2015-09-02 00:21:15.297 INFO main org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [class org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$dd61a7d4] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  19. 2015-09-02 00:21:15.344 INFO main org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'transactionAttributeSource' of type [class org.springframework.transaction.annotation.AnnotationTransactionAttributeSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  20. 2015-09-02 00:21:15.368 INFO main org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'transactionInterceptor' of type [class org.springframework.transaction.interceptor.TransactionInterceptor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  21. 2015-09-02 00:21:15.385 INFO main org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'org.springframework.transaction.config.internalTransactionAdvisor' of type [class org.springframework.transaction.interceptor.BeanFactoryTransactionAttributeSourceAdvisor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  22. 2015-09-02 00:21:16.027 INFO main org.springframework.boot.context.embedded.jetty.JettyEmbeddedServletContainerFactory - - Server initialized with port: 20000
  23. 2015-09-02 00:21:16.104 INFO main org.eclipse.jetty.server.Server - - jetty-9.2.4.v20141103
  24. 2015-09-02 00:21:16.186 INFO main / - - Initializing Spring embedded WebApplicationContext
  25. 2015-09-02 00:21:16.187 INFO main org.springframework.web.context.ContextLoader - - Root WebApplicationContext: initialization completed in 3432 ms
  26. 2015-09-02 00:21:17.611 INFO main org.ohdsi.olympus.DataSourceConfig - - Using jdbcurl: jdbc:h2:file:/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/olympus/dbfile
  27. 2015-09-02 00:21:17.780 INFO main org.springframework.jdbc.datasource.DriverManagerDataSource - - Loaded JDBC driver: org.h2.Driver
  28. 2015-09-02 00:21:18.145 INFO main org.springframework.jdbc.datasource.init.ScriptUtils - - Executing SQL script from URL [jar:file:/Users/maurya/Downloads/Olympus-1.2.0-exec.war!/WEB-INF/classes!/schema.sql]
  29. 2015-09-02 00:21:18.158 INFO main org.springframework.jdbc.datasource.init.ScriptUtils - - Executed SQL script from URL [jar:file:/Users/maurya/Downloads/Olympus-1.2.0-exec.war!/WEB-INF/classes!/schema.sql] in 13 ms.
  30. 2015-09-02 00:21:18.173 INFO main org.springframework.jdbc.datasource.init.ScriptUtils - - Executing SQL script from URL [jar:file:/Users/maurya/Downloads/Olympus-1.2.0-exec.war!/WEB-INF/classes!/data.sql]
  31. 2015-09-02 00:21:18.182 INFO main org.springframework.jdbc.datasource.init.ScriptUtils - - Executed SQL script from URL [jar:file:/Users/maurya/Downloads/Olympus-1.2.0-exec.war!/WEB-INF/classes!/data.sql] in 9 ms.
  32. 2015-09-02 00:21:18.524 INFO main org.springframework.security.web.DefaultSecurityFilterChain - - Creating filter chain: Ant [pattern='/static/**'], []
  33. 2015-09-02 00:21:18.524 INFO main org.springframework.security.web.DefaultSecurityFilterChain - - Creating filter chain: Ant [pattern='/webjars/**'], []
  34. 2015-09-02 00:21:18.524 INFO main org.springframework.security.web.DefaultSecurityFilterChain - - Creating filter chain: Ant [pattern='/js/**'], []
  35. 2015-09-02 00:21:18.524 INFO main org.springframework.security.web.DefaultSecurityFilterChain - - Creating filter chain: Ant [pattern='/css/**'], []
  36. 2015-09-02 00:21:18.524 INFO main org.springframework.security.web.DefaultSecurityFilterChain - - Creating filter chain: Ant [pattern='/img/**'], []
  37. 2015-09-02 00:21:18.573 INFO main org.springframework.security.web.DefaultSecurityFilterChain - - Creating filter chain: Ant [pattern='/console/**'], [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@24625800, org.springframework.security.web.context.SecurityContextPersistenceFilter@1db350f9, org.springframework.security.web.authentication.logout.LogoutFilter@b994a43, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@2526fc73, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@192a521f, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@5c33c128, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@3635fd9b, org.springframework.security.web.session.SessionManagementFilter@7e64f59f, org.springframework.security.web.access.ExceptionTranslationFilter@7dee1235, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@6a9775f9]
  38. 2015-09-02 00:21:18.585 INFO main org.springframework.security.web.DefaultSecurityFilterChain - - Creating filter chain: org.springframework.security.web.util.matcher.AnyRequestMatcher@1, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@f8e024e, org.springframework.security.web.context.SecurityContextPersistenceFilter@4885c168, org.springframework.security.web.csrf.CsrfFilter@1ca92520, org.springframework.security.web.authentication.logout.LogoutFilter@3a26d518, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@6e9c744b, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@42f711e8, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@1614ce39, org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter@2e4a2dab, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@2bd01d8, org.springframework.security.web.session.SessionManagementFilter@1a5a764, org.springframework.security.web.access.ExceptionTranslationFilter@547018ef, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@983532a]
  39. 2015-09-02 00:21:18.658 INFO main org.springframework.boot.context.embedded.ServletRegistrationBean - - Mapping servlet: 'webServlet' to [/console/*]
  40. 2015-09-02 00:21:18.660 INFO main org.springframework.boot.context.embedded.ServletRegistrationBean - - Mapping servlet: 'dispatcherServlet' to [/]
  41. 2015-09-02 00:21:18.662 INFO main org.springframework.boot.context.embedded.FilterRegistrationBean - - Mapping filter: 'characterEncodingFilter' to: [/*]
  42. 2015-09-02 00:21:18.665 INFO main org.springframework.boot.context.embedded.FilterRegistrationBean - - Mapping filter: 'springSecurityFilterChain' to: [/*]
  43. 2015-09-02 00:21:18.665 INFO main org.springframework.boot.context.embedded.FilterRegistrationBean - - Mapping filter: 'hiddenHttpMethodFilter' to: [/*]
  44. 2015-09-02 00:21:18.665 INFO main org.eclipse.jetty.server.handler.ContextHandler - - Started o.s.b.c.e.j.JettyEmbeddedWebAppContext@10fd8cc2{/,jar:file:/Users/maurya/Downloads/Olympus-1.2.0-exec.war!/,AVAILABLE}
  45. 2015-09-02 00:21:18.666 INFO main org.eclipse.jetty.server.Server - - Started @7654ms
  46. 2015-09-02 00:21:18.820 INFO main org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean - - Building JPA container EntityManagerFactory for persistence unit 'default'
  47. 2015-09-02 00:21:18.841 INFO main org.hibernate.jpa.internal.util.LogHelper - - HHH000204: Processing PersistenceUnitInfo [
  48. name: default
  49. ...]
  50. 2015-09-02 00:21:18.983 INFO main org.hibernate.Version - - HHH000412: Hibernate Core {4.3.7.Final}
  51. 2015-09-02 00:21:18.989 INFO main org.hibernate.cfg.Environment - - HHH000206: hibernate.properties not found
  52. 2015-09-02 00:21:18.992 INFO main org.hibernate.cfg.Environment - - HHH000021: Bytecode provider name : javassist
  53. 2015-09-02 00:21:19.776 INFO main org.hibernate.annotations.common.Version - - HCANN000001: Hibernate Commons Annotations {4.0.5.Final}
  54. 2015-09-02 00:21:19.859 INFO main org.hibernate.dialect.Dialect - - HHH000400: Using dialect: org.hibernate.dialect.H2Dialect
  55. 2015-09-02 00:21:20.084 INFO main org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory - - HHH000397: Using ASTQueryTranslatorFactory
  56. 2015-09-02 00:21:20.437 INFO main org.ohdsi.olympus.WebApiConfig - - Copying WAR to absolute path: /var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/olympus
  57. 2015-09-02 00:21:20.444 DEBUG main org.ohdsi.olympus.WebApiConfig - - InputStream for WebAPI.war: 0
  58. 2015-09-02 00:21:21.090 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter - - Looking for @ControllerAdvice: org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@4ab81e89: startup date [Wed Sep 02 00:21:12 EDT 2015]; root of context hierarchy
  59. 2015-09-02 00:21:21.186 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/achilles//datasources],methods=[GET],params=[],headers=[],consumes=[],produces=[application/json],custom=[]}" onto public org.springframework.http.HttpEntity<org.json.simple.JSONObject> org.ohdsi.olympus.controller.AchillesController.datasource()
  60. 2015-09-02 00:21:21.186 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/achilles//data],methods=[GET],params=[],headers=[],consumes=[],produces=[application/json],custom=[]}" onto public org.springframework.http.HttpEntity<org.json.simple.JSONObject> org.ohdsi.olympus.controller.AchillesController.datasource(java.lang.String,java.lang.String)
  61. 2015-09-02 00:21:21.186 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/login],methods=[GET],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.LoginController.getLoginPage(java.lang.String,javax.servlet.http.HttpServletRequest,org.springframework.security.core.Authentication)
  62. 2015-09-02 00:21:21.187 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/home/index || /home || //index || /],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.MainController.handleIndexRequest() throws java.lang.Exception
  63. 2015-09-02 00:21:21.187 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/home/error || //error],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.MainController.handleErrorRequest(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,javax.servlet.http.HttpSession) throws java.lang.Exception
  64. 2015-09-02 00:21:21.188 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/user],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.UserController.getUsersPage()
  65. 2015-09-02 00:21:21.188 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/user/create],methods=[GET],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.UserController.getUserCreatePage()
  66. 2015-09-02 00:21:21.188 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/user/create],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.UserController.handleUserCreateForm(org.ohdsi.olympus.model.UserCreateForm,org.springframework.validation.BindingResult)
  67. 2015-09-02 00:21:21.189 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi/start],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.http.ResponseEntity org.ohdsi.olympus.controller.WebApiController.start() throws java.lang.Exception
  68. 2015-09-02 00:21:21.189 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi/stop],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.http.ResponseEntity org.ohdsi.olympus.controller.WebApiController.stop() throws java.lang.Exception
  69. 2015-09-02 00:21:21.189 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi],methods=[GET],params=[],headers=[],consumes=[],produces=[application/json],custom=[]}" onto public org.springframework.http.HttpEntity<java.util.List<org.ohdsi.olympus.model.WebApiRemote>> org.ohdsi.olympus.controller.WebApiController.webApis()
  70. 2015-09-02 00:21:21.190 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi/config],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.WebApiController.handleConfigurationRequest(java.lang.String) throws java.lang.Exception
  71. 2015-09-02 00:21:21.190 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi/remote],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.WebApiController.handleConfigurationSubmission(org.ohdsi.olympus.model.WebApiRemote,org.springframework.validation.BindingResult) throws java.lang.Exception
  72. 2015-09-02 00:21:21.190 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi/config],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.WebApiController.handleConfigurationSubmission(org.ohdsi.olympus.model.WebApiProperties,org.springframework.validation.BindingResult) throws java.lang.Exception
  73. 2015-09-02 00:21:21.190 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi/appproperties],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.WebApiController.handleConfigurationSubmission(org.ohdsi.olympus.model.AppProperties,org.springframework.validation.BindingResult) throws java.lang.Exception
  74. 2015-09-02 00:21:21.190 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi/request-start],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.WebApiController.handleStartSubmission() throws java.lang.Exception
  75. 2015-09-02 00:21:21.192 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/error],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" 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)
  76. 2015-09-02 00:21:21.192 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/error],methods=[],params=[],headers=[],consumes=[],produces=[text/html],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest)
  77. 2015-09-02 00:21:21.237 INFO main org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/webjars/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  78. 2015-09-02 00:21:21.237 INFO main org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  79. 2015-09-02 00:21:21.297 INFO main org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/**/favicon.ico] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  80. 2015-09-02 00:21:21.744 INFO main org.springframework.boot.autoconfigure.security.AuthenticationManagerConfiguration - -
  81.  
  82. Using default security password: d855881e-e634-4422-a5c3-d34a0cd9ceb0
  83.  
  84. 2015-09-02 00:21:21.802 INFO main org.springframework.web.servlet.view.velocity.VelocityConfigurer - - ClasspathResourceLoader with name 'springMacro' added to configured VelocityEngine
  85. 2015-09-02 00:21:21.815 INFO main org.springframework.ui.velocity.SpringResourceLoader - - SpringResourceLoader for Velocity: using resource loader [org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@4ab81e89: startup date [Wed Sep 02 00:21:12 EDT 2015]; root of context hierarchy] and resource loader paths [classpath:/templates/]
  86. 2015-09-02 00:21:21.944 INFO main org.springframework.jmx.export.annotation.AnnotationMBeanExporter - - Registering beans for JMX exposure on startup
  87. 2015-09-02 00:21:21.961 INFO main / - - Initializing Spring FrameworkServlet 'dispatcherServlet'
  88. 2015-09-02 00:21:21.961 INFO main org.springframework.web.servlet.DispatcherServlet - - FrameworkServlet 'dispatcherServlet': initialization started
  89. 2015-09-02 00:21:22.000 INFO main org.springframework.web.servlet.DispatcherServlet - - FrameworkServlet 'dispatcherServlet': initialization completed in 39 ms
  90. 2015-09-02 00:21:22.065 INFO main org.eclipse.jetty.server.ServerConnector - - Started ServerConnector@74f8cae3{HTTP/1.1}{0.0.0.0:20000}
  91. 2015-09-02 00:21:22.069 INFO main org.springframework.boot.context.embedded.jetty.JettyEmbeddedServletContainer - - Jetty started on port(s) 20000 (http/1.1)
  92. 2015-09-02 00:21:22.134 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.driverClassName,org.postgresql.Driver]
  93. 2015-09-02 00:21:22.134 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.url,jdbc:postgresql://localhost:5432/postgres]
  94. 2015-09-02 00:21:22.134 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.username,postgres]
  95. 2015-09-02 00:21:22.134 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.password,***]
  96. 2015-09-02 00:21:22.134 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [flyway.datasource.driverClassName,org.postgresql.Driver]
  97. 2015-09-02 00:21:22.135 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [flyway.datasource.url,jdbc:postgresql://localhost:5432/postgres]
  98. 2015-09-02 00:21:22.135 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [flyway.datasource.username,postgres]
  99. 2015-09-02 00:21:22.135 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [flyway.datasource.password,***]
  100. 2015-09-02 00:21:22.135 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [flyway.schemas,public]
  101. 2015-09-02 00:21:22.135 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [flyway.locations,classpath:db/migration/postgresql]
  102. 2015-09-02 00:21:22.135 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.dialect,postgresql]
  103. 2015-09-02 00:21:22.135 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.cdm.schema,postgres]
  104. 2015-09-02 00:21:22.135 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.ohdsi.schema,public]
  105. 2015-09-02 00:21:22.135 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.cohort.schema,public]
  106. 2015-09-02 00:21:22.147 INFO main org.ohdsi.olympus.model.WebApiService - - Not setting key[achilles.data.dir] due to null key or value
  107. 2015-09-02 00:21:22.147 WARN main org.ohdsi.olympus.model.WebApiService - - WebApi launch disabled.
  108. 2015-09-02 00:21:22.149 INFO main org.ohdsi.olympus.Olympus - - Started Olympus in 10.185 seconds (JVM running for 11.137)
  109. 2015-09-02 00:21:57.593 DEBUG qtp1303694167-44 org.ohdsi.olympus.controller.WebApiController - - Get config
  110. 2015-09-02 00:22:00.396 INFO qtp1303694167-47 org.ohdsi.olympus.model.WebApiService - - Starting WebAppContext: o.e.j.w.WebAppContext@2f3bff1b{/WebAPI,null,null}{/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/olympus/WebAPI.war}
  111. SLF4J: Class path contains multiple SLF4J bindings.
  112. SLF4J: Found binding in [jar:file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/slf4j-log4j12-1.7.8.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  113. SLF4J: Found binding in [jar:file:/Users/maurya/Downloads/Olympus-1.2.0-exec.war!/WEB-INF/lib/slf4j-log4j12-1.7.8.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  114. SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
  115. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
  116. 2015-09-02 00:22:02.617 INFO qtp1303694167-47 /WebAPI - - Spring WebApplicationInitializers detected on classpath: [org.springframework.boot.autoconfigure.jersey.JerseyAutoConfiguration@7041e6a7, org.glassfish.jersey.server.spring.SpringWebApplicationInitializer@4fa3ca65, org.ohdsi.webapi.WebApi@7579bef5]
  117.  
  118. . ____ _ __ _ _
  119. /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
  120. ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
  121. \\/ ___)| |_)| | | | | || (_| | ) ) ) )
  122. ' |____| .__|_| |_|_| |_\__, | / / / /
  123. =========|_|==============|___/=/_/_/_/
  124. :: Spring Boot :: (v1.2.1.RELEASE)
  125.  
  126. 2015-09-02 00:22:03.856 INFO qtp1303694167-47 org.springframework.boot.SpringApplication - - Starting application on rgmac.local with PID 1227 (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-1.2.1.RELEASE.jar started by maurya in /Users/maurya/Downloads)
  127. 2015-09-02 00:22:03.879 INFO qtp1303694167-47 org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext - - Refreshing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@50f07903: startup date [Wed Sep 02 00:22:03 EDT 2015]; root of context hierarchy
  128. 2015-09-02 00:22:04.107 WARN qtp1303694167-47 org.springframework.core.io.support.PathMatchingResourcePatternResolver - - Skipping [/Users/maurya/Downloads/Olympus-1.2.0-exec.war] because it does not denote a directory
  129. 2015-09-02 00:22:04.897 INFO qtp1303694167-47 org.springframework.beans.factory.support.DefaultListableBeanFactory - - Overriding bean definition for bean 'entityLinksPluginRegistry': replacing [Root bean: class [org.springframework.plugin.core.support.PluginRegistryFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Root bean: class [org.springframework.plugin.core.support.PluginRegistryFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
  130. 2015-09-02 00:22:04.897 INFO qtp1303694167-47 org.springframework.beans.factory.support.DefaultListableBeanFactory - - Overriding bean definition for bean 'controllerEntityLinks': replacing [Root bean: class [org.springframework.hateoas.core.ControllerEntityLinksFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Root bean: class [org.springframework.hateoas.core.ControllerEntityLinksFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
  131. 2015-09-02 00:22:04.898 INFO qtp1303694167-47 org.springframework.beans.factory.support.DefaultListableBeanFactory - - Overriding bean definition for bean 'jaxRsEntityLinks': replacing [Root bean: class [org.springframework.hateoas.core.ControllerEntityLinksFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Root bean: class [org.springframework.hateoas.core.ControllerEntityLinksFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
  132. 2015-09-02 00:22:04.898 INFO qtp1303694167-47 org.springframework.beans.factory.support.DefaultListableBeanFactory - - Overriding bean definition for bean 'delegatingEntityLinks': replacing [Root bean: class [org.springframework.hateoas.core.DelegatingEntityLinks]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=true; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Root bean: class [org.springframework.hateoas.core.DelegatingEntityLinks]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=true; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
  133. 2015-09-02 00:22:04.920 INFO qtp1303694167-47 org.springframework.beans.factory.config.PropertiesFactoryBean - - Loading properties file from URL [jar:file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-integration-core-4.1.1.RELEASE.jar!/META-INF/spring.integration.default.properties]
  134. 2015-09-02 00:22:04.930 INFO qtp1303694167-47 org.springframework.integration.config.IntegrationRegistrar - - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
  135. 2015-09-02 00:22:05.221 WARN qtp1303694167-47 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
  136. 2015-09-02 00:22:05.232 WARN qtp1303694167-47 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
  137. 2015-09-02 00:22:05.270 INFO qtp1303694167-47 org.springframework.integration.config.DefaultConfiguringBeanFactoryPostProcessor - - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
  138. 2015-09-02 00:22:05.273 INFO qtp1303694167-47 org.springframework.integration.config.DefaultConfiguringBeanFactoryPostProcessor - - No bean named 'taskScheduler' has been explicitly defined. Therefore, a default ThreadPoolTaskScheduler will be created.
  139. 2015-09-02 00:22:05.283 INFO qtp1303694167-47 org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor - - JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
  140. 2015-09-02 00:22:05.338 INFO qtp1303694167-47 org.hibernate.validator.internal.util.Version - - HV000001: Hibernate Validator 5.1.2.Final
  141. 2015-09-02 00:22:05.561 INFO qtp1303694167-47 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean '$autoCreateChannelCandidates' of type [class org.springframework.integration.config.ChannelInitializer$AutoCreateCandidatesCollector] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  142. 2015-09-02 00:22:05.562 INFO qtp1303694167-47 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [class org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$5885b22a] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  143. 2015-09-02 00:22:05.580 INFO qtp1303694167-47 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'transactionAttributeSource' of type [class org.springframework.transaction.annotation.AnnotationTransactionAttributeSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  144. 2015-09-02 00:22:05.591 INFO qtp1303694167-47 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'transactionInterceptor' of type [class org.springframework.transaction.interceptor.TransactionInterceptor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  145. 2015-09-02 00:22:05.605 INFO qtp1303694167-47 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'org.springframework.transaction.config.internalTransactionAdvisor' of type [class org.springframework.transaction.interceptor.BeanFactoryTransactionAttributeSourceAdvisor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  146. 2015-09-02 00:22:05.638 INFO qtp1303694167-47 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'org.springframework.integration.jmx.config.IntegrationMBeanExportConfiguration' of type [class org.springframework.integration.jmx.config.IntegrationMBeanExportConfiguration$$EnhancerBySpringCGLIB$$9b30d5d6] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  147. 2015-09-02 00:22:05.667 INFO qtp1303694167-47 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'org.springframework.boot.autoconfigure.jmx.JmxAutoConfiguration' of type [class org.springframework.boot.autoconfigure.jmx.JmxAutoConfiguration$$EnhancerBySpringCGLIB$$d1616dc6] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  148. 2015-09-02 00:22:05.676 INFO qtp1303694167-47 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'mbeanServer' of type [class com.sun.jmx.mbeanserver.JmxMBeanServer] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  149. 2015-09-02 00:22:05.738 INFO qtp1303694167-47 org.springframework.beans.factory.config.PropertiesFactoryBean - - Loading properties file from URL [jar:file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-integration-core-4.1.1.RELEASE.jar!/META-INF/spring.integration.default.properties]
  150. 2015-09-02 00:22:05.738 INFO qtp1303694167-47 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'integrationGlobalProperties' of type [class org.springframework.beans.factory.config.PropertiesFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  151. 2015-09-02 00:22:05.739 INFO qtp1303694167-47 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'integrationGlobalProperties' of type [class java.util.Properties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  152. 2015-09-02 00:22:05.746 INFO qtp1303694167-47 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'messageBuilderFactory' of type [class org.springframework.integration.support.DefaultMessageBuilderFactory] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  153. 2015-09-02 00:22:05.819 INFO qtp1303694167-47 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean '(inner bean)#241722d0' of type [class org.springframework.integration.channel.MessagePublishingErrorHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  154. 2015-09-02 00:22:05.820 INFO qtp1303694167-47 org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler - - Initializing ExecutorService 'taskScheduler'
  155. 2015-09-02 00:22:05.820 INFO qtp1303694167-47 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'taskScheduler' of type [class org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  156. 2015-09-02 00:22:05.821 INFO qtp1303694167-47 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'integrationHeaderChannelRegistry' of type [class org.springframework.integration.channel.DefaultHeaderChannelRegistry] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  157. 2015-09-02 00:22:05.839 INFO qtp1303694167-47 /WebAPI - - Initializing Spring embedded WebApplicationContext
  158. 2015-09-02 00:22:05.839 INFO qtp1303694167-47 org.springframework.web.context.ContextLoader - - Root WebApplicationContext: initialization completed in 1960 ms
  159. 2015-09-02 00:22:06.899 INFO qtp1303694167-47 org.springframework.boot.context.embedded.FilterRegistrationBean - - Mapping filter: 'errorPageFilter' to: [/*]
  160. 2015-09-02 00:22:06.899 INFO qtp1303694167-47 org.springframework.boot.context.embedded.FilterRegistrationBean - - Mapping filter: 'characterEncodingFilter' to: [/*]
  161. 2015-09-02 00:22:06.899 INFO qtp1303694167-47 org.springframework.boot.context.embedded.FilterRegistrationBean - - Mapping filter: 'requestContextFilter' to: [/*]
  162. 2015-09-02 00:22:06.899 INFO qtp1303694167-47 org.springframework.boot.context.embedded.FilterRegistrationBean - - Mapping filter: 'hiddenHttpMethodFilter' to: [/*]
  163. 2015-09-02 00:22:06.899 INFO qtp1303694167-47 org.springframework.boot.context.embedded.ServletRegistrationBean - - Mapping servlet: 'jerseyServlet' to [/*]
  164. 2015-09-02 00:22:06.899 INFO qtp1303694167-47 org.springframework.boot.context.embedded.ServletRegistrationBean - - Mapping servlet: 'dispatcherServlet' to [/]
  165. 2015-09-02 00:22:06.985 INFO qtp1303694167-47 org.springframework.jdbc.datasource.DriverManagerDataSource - - Loaded JDBC driver: org.postgresql.Driver
  166. 2015-09-02 00:22:07.583 INFO qtp1303694167-47 org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean - - Building JPA container EntityManagerFactory for persistence unit 'default'
  167. 2015-09-02 00:22:07.597 INFO qtp1303694167-47 org.hibernate.jpa.internal.util.LogHelper - - HHH000204: Processing PersistenceUnitInfo [
  168. name: default
  169. ...]
  170. 2015-09-02 00:22:07.686 INFO qtp1303694167-47 org.hibernate.Version - - HHH000412: Hibernate Core {4.3.7.Final}
  171. 2015-09-02 00:22:07.698 INFO qtp1303694167-47 org.hibernate.cfg.Environment - - HHH000206: hibernate.properties not found
  172. 2015-09-02 00:22:07.700 INFO qtp1303694167-47 org.hibernate.cfg.Environment - - HHH000021: Bytecode provider name : javassist
  173. 2015-09-02 00:22:07.914 INFO qtp1303694167-47 org.hibernate.annotations.common.Version - - HCANN000001: Hibernate Commons Annotations {4.0.5.Final}
  174. 2015-09-02 00:22:07.958 DEBUG qtp1303694167-47 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://localhost:5432/postgres]
  175. 2015-09-02 00:22:08.236 INFO qtp1303694167-47 org.hibernate.dialect.Dialect - - HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL9Dialect
  176. 2015-09-02 00:22:08.256 INFO qtp1303694167-47 org.hibernate.engine.jdbc.internal.LobCreatorBuilder - - HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
  177. 2015-09-02 00:22:08.436 INFO qtp1303694167-47 org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory - - HHH000397: Using ASTQueryTranslatorFactory
  178. 2015-09-02 00:22:09.005 DEBUG qtp1303694167-47 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  179. 2015-09-02 00:22:09.053 DEBUG qtp1303694167-47 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  180. 2015-09-02 00:22:09.062 DEBUG qtp1303694167-47 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  181. 2015-09-02 00:22:09.062 DEBUG qtp1303694167-47 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  182. 2015-09-02 00:22:09.228 DEBUG qtp1303694167-47 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  183. 2015-09-02 00:22:09.229 DEBUG qtp1303694167-47 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  184. 2015-09-02 00:22:09.230 DEBUG qtp1303694167-47 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  185. 2015-09-02 00:22:09.230 DEBUG qtp1303694167-47 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  186. 2015-09-02 00:22:09.279 DEBUG qtp1303694167-47 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  187. 2015-09-02 00:22:09.279 DEBUG qtp1303694167-47 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  188. 2015-09-02 00:22:09.280 DEBUG qtp1303694167-47 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  189. 2015-09-02 00:22:09.280 DEBUG qtp1303694167-47 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  190. 2015-09-02 00:22:09.356 DEBUG qtp1303694167-47 org.springframework.jdbc.datasource.DataSourceUtils - - Fetching JDBC Connection from DataSource
  191. 2015-09-02 00:22:09.356 DEBUG qtp1303694167-47 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://localhost:5432/postgres]
  192. 2015-09-02 00:22:09.364 DEBUG qtp1303694167-47 org.springframework.jdbc.datasource.DataSourceUtils - - Returning JDBC Connection to DataSource
  193. 2015-09-02 00:22:09.366 DEBUG qtp1303694167-47 org.springframework.jdbc.datasource.DataSourceUtils - - Fetching JDBC Connection from DataSource
  194. 2015-09-02 00:22:09.366 DEBUG qtp1303694167-47 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://localhost:5432/postgres]
  195. 2015-09-02 00:22:09.376 DEBUG qtp1303694167-47 org.springframework.jdbc.datasource.DataSourceUtils - - Returning JDBC Connection to DataSource
  196. 2015-09-02 00:22:09.408 DEBUG qtp1303694167-47 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  197. 2015-09-02 00:22:09.409 DEBUG qtp1303694167-47 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  198. 2015-09-02 00:22:09.409 DEBUG qtp1303694167-47 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  199. 2015-09-02 00:22:09.410 DEBUG qtp1303694167-47 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  200. 2015-09-02 00:22:09.440 INFO qtp1303694167-47 org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor - - Initializing ExecutorService
  201. 2015-09-02 00:22:09.447 INFO qtp1303694167-47 org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor - - Initializing ExecutorService 'taskExecutor'
  202. 2015-09-02 00:22:09.456 DEBUG qtp1303694167-47 org.springframework.jdbc.datasource.DataSourceUtils - - Fetching JDBC Connection from DataSource
  203. 2015-09-02 00:22:09.456 DEBUG qtp1303694167-47 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://localhost:5432/postgres]
  204. 2015-09-02 00:22:09.470 DEBUG qtp1303694167-47 org.springframework.jdbc.datasource.DataSourceUtils - - Returning JDBC Connection to DataSource
  205. 2015-09-02 00:22:09.470 INFO qtp1303694167-47 org.springframework.batch.core.repository.support.JobRepositoryFactoryBean - - No database type set, using meta data indicating: POSTGRES
  206. 2015-09-02 00:22:09.830 INFO qtp1303694167-47 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter - - Looking for @ControllerAdvice: org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@50f07903: startup date [Wed Sep 02 00:22:03 EDT 2015]; root of context hierarchy
  207. 2015-09-02 00:22:09.883 INFO qtp1303694167-47 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/error],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" 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)
  208. 2015-09-02 00:22:09.883 INFO qtp1303694167-47 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/error],methods=[],params=[],headers=[],consumes=[],produces=[text/html],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest)
  209. 2015-09-02 00:22:09.926 INFO qtp1303694167-47 org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/webjars/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  210. 2015-09-02 00:22:09.926 INFO qtp1303694167-47 org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  211. 2015-09-02 00:22:09.986 INFO qtp1303694167-47 org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/**/favicon.ico] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  212. 2015-09-02 00:22:10.469 INFO qtp1303694167-47 org.flywaydb.core.internal.dbsupport.DbSupportFactory - - Database: jdbc:postgresql://localhost:5432/postgres (PostgreSQL 9.4)
  213. 2015-09-02 00:22:10.522 INFO qtp1303694167-47 org.flywaydb.core.internal.command.DbMigrate - - Current version of schema "public": 1.0.0.2
  214. 2015-09-02 00:22:10.523 WARN qtp1303694167-47 org.flywaydb.core.internal.command.DbMigrate - - outOfOrder mode is active. Migration of schema "public" may not be reproducible.
  215. 2015-09-02 00:22:10.523 INFO qtp1303694167-47 org.flywaydb.core.internal.command.DbMigrate - - Migrating schema "public" to version 1.0.0.3
  216. 2015-09-02 00:22:10.556 INFO qtp1303694167-47 org.flywaydb.core.internal.command.DbMigrate - - Migrating schema "public" to version 1.0.0.3.1
  217. 2015-09-02 00:22:10.576 INFO qtp1303694167-47 org.flywaydb.core.internal.command.DbMigrate - - Migrating schema "public" to version 1.0.0.3.2
  218. 2015-09-02 00:22:10.590 INFO qtp1303694167-47 org.flywaydb.core.internal.command.DbMigrate - - Migrating schema "public" to version 1.0.0.4
  219. 2015-09-02 00:22:10.620 ERROR qtp1303694167-47 org.flywaydb.core.internal.command.DbMigrate - - Migration of schema "public" to version 1.0.0.4 failed! Changes successfully rolled back.
  220. 2015-09-02 00:22:10.622 WARN qtp1303694167-47 org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext - - Exception encountered during context initialization - cancelling refresh attempt
  221. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  222. Migration V1.0.0.4__cohort_analysis_results.sql failed
  223. ------------------------------------------------------
  224. SQL State : 42P07
  225. Error Code : 0
  226. Message : ERROR: relation "cohort" already exists
  227. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  228. Line : 2
  229. Statement : create table COHORT
  230. (
  231. COHORT_DEFINITION_ID int NOT NULL,
  232. SUBJECT_ID bigint NOT NULL,
  233. cohort_start_date date NOT NULL,
  234. cohort_end_date date NOT NULL
  235. )
  236.  
  237. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
  238. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  239. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
  240. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
  241. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  242. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
  243. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
  244. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
  245. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
  246. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
  247. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
  248. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:691)
  249. at org.springframework.boot.SpringApplication.run(SpringApplication.java:321)
  250. at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:117)
  251. at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:108)
  252. at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:68)
  253. at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:175)
  254. at org.eclipse.jetty.plus.annotation.ContainerInitializer.callStartup(ContainerInitializer.java:140)
  255. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:65)
  256. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  257. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:274)
  258. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
  259. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
  260. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
  261. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
  262. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  263. at org.ohdsi.olympus.model.WebApiService.start(WebApiService.java:200)
  264. at org.ohdsi.olympus.controller.WebApiController.start(WebApiController.java:232)
  265. at org.ohdsi.olympus.controller.WebApiController.handleStartSubmission(WebApiController.java:209)
  266. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  267. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  268. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  269. at java.lang.reflect.Method.invoke(Method.java:497)
  270. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  271. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  272. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  273. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  274. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  275. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  276. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  277. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  278. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  279. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  280. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  281. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  282. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  283. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
  284. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
  285. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  286. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  287. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  288. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  289. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  290. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  291. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  292. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  293. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  294. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  295. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  296. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  297. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  298. at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
  299. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  300. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
  301. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  302. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  303. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  304. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
  305. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  306. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  307. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  308. at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
  309. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  310. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  311. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  312. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  313. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
  314. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  315. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  316. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  317. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  318. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  319. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  320. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  321. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  322. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  323. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  324. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  325. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  326. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  327. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  328. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  329. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  330. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  331. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
  332. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  333. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  334. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
  335. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  336. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  337. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
  338. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
  339. at java.lang.Thread.run(Thread.java:745)
  340. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  341. Migration V1.0.0.4__cohort_analysis_results.sql failed
  342. ------------------------------------------------------
  343. SQL State : 42P07
  344. Error Code : 0
  345. Message : ERROR: relation "cohort" already exists
  346. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  347. Line : 2
  348. Statement : create table COHORT
  349. (
  350. COHORT_DEFINITION_ID int NOT NULL,
  351. SUBJECT_ID bigint NOT NULL,
  352. cohort_start_date date NOT NULL,
  353. cohort_end_date date NOT NULL
  354. )
  355.  
  356. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
  357. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
  358. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
  359. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
  360. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  361. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
  362. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
  363. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
  364. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
  365. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  366. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
  367. at org.flywaydb.core.Flyway$1.execute(Flyway.java:972)
  368. at org.flywaydb.core.Flyway$1.execute(Flyway.java:919)
  369. at org.flywaydb.core.Flyway.execute(Flyway.java:1320)
  370. at org.flywaydb.core.Flyway.migrate(Flyway.java:919)
  371. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  372. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  373. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  374. at java.lang.reflect.Method.invoke(Method.java:497)
  375. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
  376. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
  377. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
  378. ... 102 more
  379. Caused by: org.postgresql.util.PSQLException: ERROR: relation "cohort" already exists
  380. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  381. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  382. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  383. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  384. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  385. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  386. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
  387. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
  388. ... 123 more
  389. 2015-09-02 00:22:10.629 INFO qtp1303694167-47 org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor - - Shutting down ExecutorService 'taskExecutor'
  390. 2015-09-02 00:22:10.634 INFO qtp1303694167-47 org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler - - Shutting down ExecutorService 'taskScheduler'
  391. 2015-09-02 00:22:10.635 INFO qtp1303694167-47 org.springframework.integration.monitor.IntegrationMBeanExporter - - Unregistering JMX-exposed beans on shutdown
  392. 2015-09-02 00:22:10.636 INFO qtp1303694167-47 org.springframework.beans.factory.config.PropertiesFactoryBean - - Loading properties file from URL [jar:file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-integration-core-4.1.1.RELEASE.jar!/META-INF/spring.integration.default.properties]
  393. 2015-09-02 00:22:10.637 INFO qtp1303694167-47 org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler - - Initializing ExecutorService 'taskScheduler'
  394. 2015-09-02 00:22:10.638 INFO qtp1303694167-47 org.springframework.boot.logging.ClasspathLoggingApplicationListener - - Application failed to start with classpath: [file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/antlr-2.7.7.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/aopalliance-1.0.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/aopalliance-repackaged-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/asm-all-repackaged-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/aspectjrt-1.8.4.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/aspectjweaver-1.8.4.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/bean-validator-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/class-model-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/classmate-1.0.0.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/com.ibm.jbatch-tck-spi-1.0.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/commons-collections-3.2.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/commons-dbutils-1.6.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/commons-fileupload-1.3.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/commons-io-2.4.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/commons-lang-2.6.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/commons-lang3-3.3.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/commons-logging-1.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/config-types-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/core-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/disruptor-3.2.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/dom4j-1.6.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/flyway-core-3.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/gs-collections-5.1.0.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/gs-collections-api-5.1.0.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hibernate-commons-annotations-4.0.5.Final.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hibernate-core-4.3.7.Final.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hibernate-entitymanager-4.3.7.Final.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hibernate-jpa-2.1-api-1.0.0.Final.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hibernate-validator-5.1.3.Final.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hk2-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hk2-api-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hk2-config-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hk2-locator-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hk2-runlevel-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hk2-utils-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jackson-annotations-2.4.4.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jackson-core-2.4.4.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jackson-databind-2.4.4.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jackson-jaxrs-base-2.3.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jackson-jaxrs-json-provider-2.3.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jackson-module-jaxb-annotations-2.3.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jandex-1.1.0.Final.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/javassist-3.18.1-GA.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/javax.annotation-api-1.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/javax.batch-api-1.0.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/javax.inject-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/javax.transaction-api-1.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/javax.ws.rs-api-2.0.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jboss-logging-3.1.3.GA.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jboss-logging-annotations-1.2.0.Beta1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jcl-over-slf4j-1.7.8.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-client-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-common-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-container-servlet-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-container-servlet-core-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-guava-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-media-json-jackson-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-server-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-spring3-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jettison-1.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/joda-time-2.5.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/json-path-0.9.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/json-smart-1.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jsr166e-1.0.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jul-to-slf4j-1.7.8.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/log4j-1.2.17.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/objenesis-2.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/osgi-resource-locator-1.0.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/reactor-core-1.1.5.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/slf4j-api-1.7.8.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/slf4j-log4j12-1.7.8.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/snakeyaml-1.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-aop-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-aspects-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-batch-admin-domain-2.0.0.M1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-batch-admin-manager-2.0.0.M1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-batch-admin-resources-2.0.0.M1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-batch-core-3.0.3.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-batch-infrastructure-3.0.2.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-batch-integration-3.0.2.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-beans-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-autoconfigure-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-starter-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-starter-aop-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-starter-data-jpa-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-starter-jdbc-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-starter-jersey-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-starter-log4j-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-starter-web-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-bridge-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-context-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-context-support-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-core-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-data-commons-1.9.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-data-jpa-1.7.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-expression-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-hateoas-0.16.0.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-integration-core-4.1.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-integration-file-4.1.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-integration-http-4.1.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-integration-jmx-4.1.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-jdbc-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-messaging-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-orm-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-oxm-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-plugin-core-1.1.0.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-retry-1.1.0.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-tx-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-web-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-webmvc-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/SqlRender-1.0.0-20150715.141736-41.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/tiger-types-1.4.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/tomcat-jdbc-8.0.15.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/tomcat-juli-8.0.15.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/validation-api-1.1.0.Final.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/xml-apis-1.0.b2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/xmlpull-1.1.3.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/xpp3_min-1.1.4c.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/xstream-1.4.7.jar]
  395. 2015-09-02 00:22:10.639 INFO qtp1303694167-47 org.springframework.boot.autoconfigure.logging.AutoConfigurationReportLoggingInitializer - -
  396.  
  397. Error starting ApplicationContext. To display the auto-configuration report enabled debug logging (start with --debug)
  398.  
  399.  
  400. 2015-09-02 00:22:10.639 ERROR qtp1303694167-47 org.springframework.boot.SpringApplication - - Application startup failed
  401. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  402. Migration V1.0.0.4__cohort_analysis_results.sql failed
  403. ------------------------------------------------------
  404. SQL State : 42P07
  405. Error Code : 0
  406. Message : ERROR: relation "cohort" already exists
  407. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  408. Line : 2
  409. Statement : create table COHORT
  410. (
  411. COHORT_DEFINITION_ID int NOT NULL,
  412. SUBJECT_ID bigint NOT NULL,
  413. cohort_start_date date NOT NULL,
  414. cohort_end_date date NOT NULL
  415. )
  416.  
  417. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
  418. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  419. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
  420. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
  421. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  422. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
  423. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
  424. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
  425. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
  426. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
  427. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
  428. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:691)
  429. at org.springframework.boot.SpringApplication.run(SpringApplication.java:321)
  430. at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:117)
  431. at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:108)
  432. at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:68)
  433. at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:175)
  434. at org.eclipse.jetty.plus.annotation.ContainerInitializer.callStartup(ContainerInitializer.java:140)
  435. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:65)
  436. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  437. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:274)
  438. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
  439. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
  440. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
  441. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
  442. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  443. at org.ohdsi.olympus.model.WebApiService.start(WebApiService.java:200)
  444. at org.ohdsi.olympus.controller.WebApiController.start(WebApiController.java:232)
  445. at org.ohdsi.olympus.controller.WebApiController.handleStartSubmission(WebApiController.java:209)
  446. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  447. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  448. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  449. at java.lang.reflect.Method.invoke(Method.java:497)
  450. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  451. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  452. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  453. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  454. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  455. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  456. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  457. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  458. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  459. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  460. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  461. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  462. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  463. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
  464. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
  465. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  466. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  467. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  468. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  469. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  470. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  471. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  472. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  473. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  474. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  475. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  476. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  477. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  478. at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
  479. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  480. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
  481. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  482. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  483. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  484. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
  485. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  486. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  487. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  488. at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
  489. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  490. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  491. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  492. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  493. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
  494. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  495. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  496. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  497. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  498. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  499. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  500. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  501. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  502. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  503. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  504. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  505. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  506. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  507. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  508. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  509. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  510. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  511. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
  512. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  513. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  514. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
  515. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  516. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  517. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
  518. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
  519. at java.lang.Thread.run(Thread.java:745)
  520. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  521. Migration V1.0.0.4__cohort_analysis_results.sql failed
  522. ------------------------------------------------------
  523. SQL State : 42P07
  524. Error Code : 0
  525. Message : ERROR: relation "cohort" already exists
  526. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  527. Line : 2
  528. Statement : create table COHORT
  529. (
  530. COHORT_DEFINITION_ID int NOT NULL,
  531. SUBJECT_ID bigint NOT NULL,
  532. cohort_start_date date NOT NULL,
  533. cohort_end_date date NOT NULL
  534. )
  535.  
  536. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
  537. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
  538. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
  539. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
  540. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  541. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
  542. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
  543. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
  544. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
  545. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  546. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
  547. at org.flywaydb.core.Flyway$1.execute(Flyway.java:972)
  548. at org.flywaydb.core.Flyway$1.execute(Flyway.java:919)
  549. at org.flywaydb.core.Flyway.execute(Flyway.java:1320)
  550. at org.flywaydb.core.Flyway.migrate(Flyway.java:919)
  551. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  552. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  553. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  554. at java.lang.reflect.Method.invoke(Method.java:497)
  555. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
  556. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
  557. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
  558. ... 102 more
  559. Caused by: org.postgresql.util.PSQLException: ERROR: relation "cohort" already exists
  560. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  561. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  562. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  563. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  564. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  565. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  566. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
  567. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
  568. ... 123 more
  569. 2015-09-02 00:22:10.642 WARN qtp1303694167-47 org.eclipse.jetty.annotations.ServletContainerInitializersStarter - -
  570. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  571. Migration V1.0.0.4__cohort_analysis_results.sql failed
  572. ------------------------------------------------------
  573. SQL State : 42P07
  574. Error Code : 0
  575. Message : ERROR: relation "cohort" already exists
  576. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  577. Line : 2
  578. Statement : create table COHORT
  579. (
  580. COHORT_DEFINITION_ID int NOT NULL,
  581. SUBJECT_ID bigint NOT NULL,
  582. cohort_start_date date NOT NULL,
  583. cohort_end_date date NOT NULL
  584. )
  585.  
  586. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
  587. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  588. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
  589. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
  590. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  591. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
  592. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
  593. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
  594. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
  595. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
  596. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
  597. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:691)
  598. at org.springframework.boot.SpringApplication.run(SpringApplication.java:321)
  599. at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:117)
  600. at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:108)
  601. at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:68)
  602. at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:175)
  603. at org.eclipse.jetty.plus.annotation.ContainerInitializer.callStartup(ContainerInitializer.java:140)
  604. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:65)
  605. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  606. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:274)
  607. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
  608. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
  609. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
  610. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
  611. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  612. at org.ohdsi.olympus.model.WebApiService.start(WebApiService.java:200)
  613. at org.ohdsi.olympus.controller.WebApiController.start(WebApiController.java:232)
  614. at org.ohdsi.olympus.controller.WebApiController.handleStartSubmission(WebApiController.java:209)
  615. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  616. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  617. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  618. at java.lang.reflect.Method.invoke(Method.java:497)
  619. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  620. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  621. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  622. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  623. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  624. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  625. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  626. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  627. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  628. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  629. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  630. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  631. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  632. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
  633. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
  634. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  635. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  636. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  637. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  638. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  639. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  640. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  641. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  642. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  643. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  644. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  645. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  646. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  647. at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
  648. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  649. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
  650. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  651. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  652. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  653. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
  654. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  655. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  656. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  657. at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
  658. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  659. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  660. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  661. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  662. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
  663. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  664. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  665. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  666. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  667. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  668. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  669. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  670. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  671. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  672. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  673. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  674. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  675. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  676. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  677. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  678. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  679. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  680. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
  681. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  682. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  683. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
  684. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  685. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  686. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
  687. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
  688. at java.lang.Thread.run(Thread.java:745)
  689. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  690. Migration V1.0.0.4__cohort_analysis_results.sql failed
  691. ------------------------------------------------------
  692. SQL State : 42P07
  693. Error Code : 0
  694. Message : ERROR: relation "cohort" already exists
  695. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  696. Line : 2
  697. Statement : create table COHORT
  698. (
  699. COHORT_DEFINITION_ID int NOT NULL,
  700. SUBJECT_ID bigint NOT NULL,
  701. cohort_start_date date NOT NULL,
  702. cohort_end_date date NOT NULL
  703. )
  704.  
  705. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
  706. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
  707. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
  708. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
  709. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  710. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
  711. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
  712. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
  713. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
  714. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  715. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
  716. at org.flywaydb.core.Flyway$1.execute(Flyway.java:972)
  717. at org.flywaydb.core.Flyway$1.execute(Flyway.java:919)
  718. at org.flywaydb.core.Flyway.execute(Flyway.java:1320)
  719. at org.flywaydb.core.Flyway.migrate(Flyway.java:919)
  720. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  721. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  722. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  723. at java.lang.reflect.Method.invoke(Method.java:497)
  724. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
  725. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
  726. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
  727. ... 102 more
  728. Caused by: org.postgresql.util.PSQLException: ERROR: relation "cohort" already exists
  729. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  730. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  731. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  732. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  733. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  734. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  735. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
  736. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
  737. ... 123 more
  738. 2015-09-02 00:22:10.645 WARN qtp1303694167-47 org.eclipse.jetty.util.component.AbstractLifeCycle - - FAILED org.eclipse.jetty.annotations.ServletContainerInitializersStarter@1b074258: java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  739. Migration V1.0.0.4__cohort_analysis_results.sql failed
  740. ------------------------------------------------------
  741. SQL State : 42P07
  742. Error Code : 0
  743. Message : ERROR: relation "cohort" already exists
  744. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  745. Line : 2
  746. Statement : create table COHORT
  747. (
  748. COHORT_DEFINITION_ID int NOT NULL,
  749. SUBJECT_ID bigint NOT NULL,
  750. cohort_start_date date NOT NULL,
  751. cohort_end_date date NOT NULL
  752. )
  753.  
  754. java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  755. Migration V1.0.0.4__cohort_analysis_results.sql failed
  756. ------------------------------------------------------
  757. SQL State : 42P07
  758. Error Code : 0
  759. Message : ERROR: relation "cohort" already exists
  760. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  761. Line : 2
  762. Statement : create table COHORT
  763. (
  764. COHORT_DEFINITION_ID int NOT NULL,
  765. SUBJECT_ID bigint NOT NULL,
  766. cohort_start_date date NOT NULL,
  767. cohort_end_date date NOT NULL
  768. )
  769.  
  770. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:70)
  771. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  772. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:274)
  773. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
  774. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
  775. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
  776. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
  777. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  778. at org.ohdsi.olympus.model.WebApiService.start(WebApiService.java:200)
  779. at org.ohdsi.olympus.controller.WebApiController.start(WebApiController.java:232)
  780. at org.ohdsi.olympus.controller.WebApiController.handleStartSubmission(WebApiController.java:209)
  781. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  782. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  783. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  784. at java.lang.reflect.Method.invoke(Method.java:497)
  785. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  786. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  787. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  788. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  789. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  790. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  791. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  792. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  793. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  794. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  795. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  796. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  797. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  798. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
  799. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
  800. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  801. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  802. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  803. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  804. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  805. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  806. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  807. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  808. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  809. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  810. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  811. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  812. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  813. at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
  814. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  815. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
  816. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  817. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  818. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  819. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
  820. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  821. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  822. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  823. at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
  824. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  825. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  826. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  827. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  828. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
  829. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  830. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  831. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  832. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  833. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  834. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  835. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  836. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  837. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  838. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  839. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  840. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  841. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  842. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  843. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  844. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  845. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  846. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
  847. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  848. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  849. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
  850. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  851. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  852. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
  853. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
  854. at java.lang.Thread.run(Thread.java:745)
  855. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  856. Migration V1.0.0.4__cohort_analysis_results.sql failed
  857. ------------------------------------------------------
  858. SQL State : 42P07
  859. Error Code : 0
  860. Message : ERROR: relation "cohort" already exists
  861. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  862. Line : 2
  863. Statement : create table COHORT
  864. (
  865. COHORT_DEFINITION_ID int NOT NULL,
  866. SUBJECT_ID bigint NOT NULL,
  867. cohort_start_date date NOT NULL,
  868. cohort_end_date date NOT NULL
  869. )
  870.  
  871. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
  872. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  873. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
  874. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
  875. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  876. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
  877. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
  878. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
  879. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
  880. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
  881. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
  882. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:691)
  883. at org.springframework.boot.SpringApplication.run(SpringApplication.java:321)
  884. at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:117)
  885. at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:108)
  886. at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:68)
  887. at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:175)
  888. at org.eclipse.jetty.plus.annotation.ContainerInitializer.callStartup(ContainerInitializer.java:140)
  889. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:65)
  890. ... 84 more
  891. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  892. Migration V1.0.0.4__cohort_analysis_results.sql failed
  893. ------------------------------------------------------
  894. SQL State : 42P07
  895. Error Code : 0
  896. Message : ERROR: relation "cohort" already exists
  897. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  898. Line : 2
  899. Statement : create table COHORT
  900. (
  901. COHORT_DEFINITION_ID int NOT NULL,
  902. SUBJECT_ID bigint NOT NULL,
  903. cohort_start_date date NOT NULL,
  904. cohort_end_date date NOT NULL
  905. )
  906.  
  907. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
  908. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
  909. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
  910. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
  911. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  912. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
  913. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
  914. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
  915. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
  916. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  917. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
  918. at org.flywaydb.core.Flyway$1.execute(Flyway.java:972)
  919. at org.flywaydb.core.Flyway$1.execute(Flyway.java:919)
  920. at org.flywaydb.core.Flyway.execute(Flyway.java:1320)
  921. at org.flywaydb.core.Flyway.migrate(Flyway.java:919)
  922. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  923. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  924. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  925. at java.lang.reflect.Method.invoke(Method.java:497)
  926. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
  927. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
  928. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
  929. ... 102 more
  930. Caused by: org.postgresql.util.PSQLException: ERROR: relation "cohort" already exists
  931. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  932. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  933. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  934. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  935. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  936. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  937. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
  938. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
  939. ... 123 more
  940. 2015-09-02 00:22:10.648 WARN qtp1303694167-47 org.eclipse.jetty.webapp.WebAppContext - - Failed startup of context o.e.j.w.WebAppContext@2f3bff1b{/WebAPI,file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/,STARTING}{/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/olympus/WebAPI.war}
  941. java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  942. Migration V1.0.0.4__cohort_analysis_results.sql failed
  943. ------------------------------------------------------
  944. SQL State : 42P07
  945. Error Code : 0
  946. Message : ERROR: relation "cohort" already exists
  947. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  948. Line : 2
  949. Statement : create table COHORT
  950. (
  951. COHORT_DEFINITION_ID int NOT NULL,
  952. SUBJECT_ID bigint NOT NULL,
  953. cohort_start_date date NOT NULL,
  954. cohort_end_date date NOT NULL
  955. )
  956.  
  957. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:70)
  958. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  959. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:274)
  960. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
  961. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
  962. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
  963. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
  964. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  965. at org.ohdsi.olympus.model.WebApiService.start(WebApiService.java:200)
  966. at org.ohdsi.olympus.controller.WebApiController.start(WebApiController.java:232)
  967. at org.ohdsi.olympus.controller.WebApiController.handleStartSubmission(WebApiController.java:209)
  968. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  969. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  970. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  971. at java.lang.reflect.Method.invoke(Method.java:497)
  972. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  973. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  974. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  975. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  976. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  977. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  978. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  979. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  980. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  981. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  982. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  983. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  984. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  985. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
  986. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
  987. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  988. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  989. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  990. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  991. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  992. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  993. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  994. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  995. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  996. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  997. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  998. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  999. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1000. at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
  1001. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1002. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
  1003. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1004. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  1005. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1006. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
  1007. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1008. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  1009. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1010. at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
  1011. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1012. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1013. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  1014. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1015. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
  1016. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1017. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1018. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  1019. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  1020. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1021. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  1022. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1023. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1024. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  1025. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  1026. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  1027. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  1028. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  1029. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  1030. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  1031. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  1032. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  1033. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
  1034. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  1035. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  1036. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
  1037. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  1038. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  1039. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
  1040. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
  1041. at java.lang.Thread.run(Thread.java:745)
  1042. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1043. Migration V1.0.0.4__cohort_analysis_results.sql failed
  1044. ------------------------------------------------------
  1045. SQL State : 42P07
  1046. Error Code : 0
  1047. Message : ERROR: relation "cohort" already exists
  1048. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  1049. Line : 2
  1050. Statement : create table COHORT
  1051. (
  1052. COHORT_DEFINITION_ID int NOT NULL,
  1053. SUBJECT_ID bigint NOT NULL,
  1054. cohort_start_date date NOT NULL,
  1055. cohort_end_date date NOT NULL
  1056. )
  1057.  
  1058. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
  1059. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  1060. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
  1061. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
  1062. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  1063. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
  1064. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
  1065. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
  1066. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
  1067. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
  1068. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
  1069. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:691)
  1070. at org.springframework.boot.SpringApplication.run(SpringApplication.java:321)
  1071. at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:117)
  1072. at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:108)
  1073. at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:68)
  1074. at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:175)
  1075. at org.eclipse.jetty.plus.annotation.ContainerInitializer.callStartup(ContainerInitializer.java:140)
  1076. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:65)
  1077. ... 84 more
  1078. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1079. Migration V1.0.0.4__cohort_analysis_results.sql failed
  1080. ------------------------------------------------------
  1081. SQL State : 42P07
  1082. Error Code : 0
  1083. Message : ERROR: relation "cohort" already exists
  1084. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  1085. Line : 2
  1086. Statement : create table COHORT
  1087. (
  1088. COHORT_DEFINITION_ID int NOT NULL,
  1089. SUBJECT_ID bigint NOT NULL,
  1090. cohort_start_date date NOT NULL,
  1091. cohort_end_date date NOT NULL
  1092. )
  1093.  
  1094. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
  1095. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
  1096. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
  1097. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
  1098. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  1099. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
  1100. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
  1101. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
  1102. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
  1103. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  1104. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
  1105. at org.flywaydb.core.Flyway$1.execute(Flyway.java:972)
  1106. at org.flywaydb.core.Flyway$1.execute(Flyway.java:919)
  1107. at org.flywaydb.core.Flyway.execute(Flyway.java:1320)
  1108. at org.flywaydb.core.Flyway.migrate(Flyway.java:919)
  1109. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1110. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1111. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1112. at java.lang.reflect.Method.invoke(Method.java:497)
  1113. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
  1114. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
  1115. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
  1116. ... 102 more
  1117. Caused by: org.postgresql.util.PSQLException: ERROR: relation "cohort" already exists
  1118. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  1119. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  1120. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  1121. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  1122. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  1123. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  1124. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
  1125. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
  1126. ... 123 more
  1127. 2015-09-02 00:22:10.650 WARN qtp1303694167-47 org.eclipse.jetty.util.component.AbstractLifeCycle - - FAILED o.e.j.w.WebAppContext@2f3bff1b{/WebAPI,file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/,UNAVAILABLE}{/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/olympus/WebAPI.war}: java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1128. Migration V1.0.0.4__cohort_analysis_results.sql failed
  1129. ------------------------------------------------------
  1130. SQL State : 42P07
  1131. Error Code : 0
  1132. Message : ERROR: relation "cohort" already exists
  1133. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  1134. Line : 2
  1135. Statement : create table COHORT
  1136. (
  1137. COHORT_DEFINITION_ID int NOT NULL,
  1138. SUBJECT_ID bigint NOT NULL,
  1139. cohort_start_date date NOT NULL,
  1140. cohort_end_date date NOT NULL
  1141. )
  1142.  
  1143. java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1144. Migration V1.0.0.4__cohort_analysis_results.sql failed
  1145. ------------------------------------------------------
  1146. SQL State : 42P07
  1147. Error Code : 0
  1148. Message : ERROR: relation "cohort" already exists
  1149. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  1150. Line : 2
  1151. Statement : create table COHORT
  1152. (
  1153. COHORT_DEFINITION_ID int NOT NULL,
  1154. SUBJECT_ID bigint NOT NULL,
  1155. cohort_start_date date NOT NULL,
  1156. cohort_end_date date NOT NULL
  1157. )
  1158.  
  1159. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:70)
  1160. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  1161. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:274)
  1162. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
  1163. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
  1164. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
  1165. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
  1166. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  1167. at org.ohdsi.olympus.model.WebApiService.start(WebApiService.java:200)
  1168. at org.ohdsi.olympus.controller.WebApiController.start(WebApiController.java:232)
  1169. at org.ohdsi.olympus.controller.WebApiController.handleStartSubmission(WebApiController.java:209)
  1170. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1171. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1172. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1173. at java.lang.reflect.Method.invoke(Method.java:497)
  1174. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  1175. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  1176. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  1177. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  1178. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  1179. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  1180. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  1181. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  1182. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  1183. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  1184. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  1185. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  1186. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  1187. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
  1188. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
  1189. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  1190. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1191. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1192. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  1193. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  1194. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  1195. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1196. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  1197. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1198. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  1199. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1200. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  1201. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1202. at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
  1203. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1204. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
  1205. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1206. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  1207. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1208. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
  1209. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1210. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  1211. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1212. at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
  1213. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1214. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1215. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  1216. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1217. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
  1218. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1219. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1220. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  1221. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  1222. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1223. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  1224. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1225. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1226. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  1227. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  1228. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  1229. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  1230. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  1231. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  1232. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  1233. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  1234. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  1235. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
  1236. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  1237. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  1238. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
  1239. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  1240. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  1241. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
  1242. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
  1243. at java.lang.Thread.run(Thread.java:745)
  1244. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1245. Migration V1.0.0.4__cohort_analysis_results.sql failed
  1246. ------------------------------------------------------
  1247. SQL State : 42P07
  1248. Error Code : 0
  1249. Message : ERROR: relation "cohort" already exists
  1250. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  1251. Line : 2
  1252. Statement : create table COHORT
  1253. (
  1254. COHORT_DEFINITION_ID int NOT NULL,
  1255. SUBJECT_ID bigint NOT NULL,
  1256. cohort_start_date date NOT NULL,
  1257. cohort_end_date date NOT NULL
  1258. )
  1259.  
  1260. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
  1261. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  1262. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
  1263. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
  1264. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  1265. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
  1266. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
  1267. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
  1268. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
  1269. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
  1270. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
  1271. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:691)
  1272. at org.springframework.boot.SpringApplication.run(SpringApplication.java:321)
  1273. at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:117)
  1274. at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:108)
  1275. at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:68)
  1276. at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:175)
  1277. at org.eclipse.jetty.plus.annotation.ContainerInitializer.callStartup(ContainerInitializer.java:140)
  1278. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:65)
  1279. ... 84 more
  1280. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1281. Migration V1.0.0.4__cohort_analysis_results.sql failed
  1282. ------------------------------------------------------
  1283. SQL State : 42P07
  1284. Error Code : 0
  1285. Message : ERROR: relation "cohort" already exists
  1286. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  1287. Line : 2
  1288. Statement : create table COHORT
  1289. (
  1290. COHORT_DEFINITION_ID int NOT NULL,
  1291. SUBJECT_ID bigint NOT NULL,
  1292. cohort_start_date date NOT NULL,
  1293. cohort_end_date date NOT NULL
  1294. )
  1295.  
  1296. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
  1297. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
  1298. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
  1299. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
  1300. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  1301. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
  1302. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
  1303. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
  1304. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
  1305. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  1306. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
  1307. at org.flywaydb.core.Flyway$1.execute(Flyway.java:972)
  1308. at org.flywaydb.core.Flyway$1.execute(Flyway.java:919)
  1309. at org.flywaydb.core.Flyway.execute(Flyway.java:1320)
  1310. at org.flywaydb.core.Flyway.migrate(Flyway.java:919)
  1311. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1312. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1313. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1314. at java.lang.reflect.Method.invoke(Method.java:497)
  1315. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
  1316. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
  1317. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
  1318. ... 102 more
  1319. Caused by: org.postgresql.util.PSQLException: ERROR: relation "cohort" already exists
  1320. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  1321. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  1322. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  1323. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  1324. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  1325. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  1326. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
  1327. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
  1328. ... 123 more
  1329. 2015-09-02 00:22:10.652 ERROR qtp1303694167-47 org.ohdsi.olympus.controller.WebApiController - - WebAPI was not able to start up successfully, please check your configuration. (org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1330. Migration V1.0.0.4__cohort_analysis_results.sql failed
  1331. ------------------------------------------------------
  1332. SQL State : 42P07
  1333. Error Code : 0
  1334. Message : ERROR: relation "cohort" already exists
  1335. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  1336. Line : 2
  1337. Statement : create table COHORT
  1338. (
  1339. COHORT_DEFINITION_ID int NOT NULL,
  1340. SUBJECT_ID bigint NOT NULL,
  1341. cohort_start_date date NOT NULL,
  1342. cohort_end_date date NOT NULL
  1343. )
  1344. )
  1345. java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1346. Migration V1.0.0.4__cohort_analysis_results.sql failed
  1347. ------------------------------------------------------
  1348. SQL State : 42P07
  1349. Error Code : 0
  1350. Message : ERROR: relation "cohort" already exists
  1351. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  1352. Line : 2
  1353. Statement : create table COHORT
  1354. (
  1355. COHORT_DEFINITION_ID int NOT NULL,
  1356. SUBJECT_ID bigint NOT NULL,
  1357. cohort_start_date date NOT NULL,
  1358. cohort_end_date date NOT NULL
  1359. )
  1360.  
  1361. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:70)
  1362. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  1363. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:274)
  1364. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
  1365. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
  1366. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
  1367. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
  1368. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  1369. at org.ohdsi.olympus.model.WebApiService.start(WebApiService.java:200)
  1370. at org.ohdsi.olympus.controller.WebApiController.start(WebApiController.java:232)
  1371. at org.ohdsi.olympus.controller.WebApiController.handleStartSubmission(WebApiController.java:209)
  1372. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1373. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1374. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1375. at java.lang.reflect.Method.invoke(Method.java:497)
  1376. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  1377. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  1378. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  1379. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  1380. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  1381. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  1382. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  1383. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  1384. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  1385. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  1386. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  1387. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  1388. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  1389. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
  1390. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
  1391. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  1392. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1393. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1394. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  1395. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  1396. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  1397. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1398. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  1399. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1400. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  1401. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1402. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  1403. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1404. at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
  1405. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1406. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
  1407. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1408. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  1409. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1410. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
  1411. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1412. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  1413. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1414. at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
  1415. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1416. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1417. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  1418. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1419. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
  1420. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1421. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1422. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  1423. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  1424. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1425. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  1426. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1427. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1428. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  1429. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  1430. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  1431. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  1432. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  1433. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  1434. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  1435. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  1436. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  1437. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
  1438. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  1439. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  1440. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
  1441. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  1442. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  1443. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
  1444. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
  1445. at java.lang.Thread.run(Thread.java:745)
  1446. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1447. Migration V1.0.0.4__cohort_analysis_results.sql failed
  1448. ------------------------------------------------------
  1449. SQL State : 42P07
  1450. Error Code : 0
  1451. Message : ERROR: relation "cohort" already exists
  1452. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  1453. Line : 2
  1454. Statement : create table COHORT
  1455. (
  1456. COHORT_DEFINITION_ID int NOT NULL,
  1457. SUBJECT_ID bigint NOT NULL,
  1458. cohort_start_date date NOT NULL,
  1459. cohort_end_date date NOT NULL
  1460. )
  1461.  
  1462. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
  1463. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  1464. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
  1465. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
  1466. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  1467. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
  1468. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
  1469. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
  1470. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
  1471. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
  1472. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
  1473. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:691)
  1474. at org.springframework.boot.SpringApplication.run(SpringApplication.java:321)
  1475. at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:117)
  1476. at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:108)
  1477. at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:68)
  1478. at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:175)
  1479. at org.eclipse.jetty.plus.annotation.ContainerInitializer.callStartup(ContainerInitializer.java:140)
  1480. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:65)
  1481. ... 84 more
  1482. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1483. Migration V1.0.0.4__cohort_analysis_results.sql failed
  1484. ------------------------------------------------------
  1485. SQL State : 42P07
  1486. Error Code : 0
  1487. Message : ERROR: relation "cohort" already exists
  1488. Location : db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.4__cohort_analysis_results.sql)
  1489. Line : 2
  1490. Statement : create table COHORT
  1491. (
  1492. COHORT_DEFINITION_ID int NOT NULL,
  1493. SUBJECT_ID bigint NOT NULL,
  1494. cohort_start_date date NOT NULL,
  1495. cohort_end_date date NOT NULL
  1496. )
  1497.  
  1498. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
  1499. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
  1500. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
  1501. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
  1502. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  1503. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
  1504. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
  1505. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
  1506. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
  1507. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  1508. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
  1509. at org.flywaydb.core.Flyway$1.execute(Flyway.java:972)
  1510. at org.flywaydb.core.Flyway$1.execute(Flyway.java:919)
  1511. at org.flywaydb.core.Flyway.execute(Flyway.java:1320)
  1512. at org.flywaydb.core.Flyway.migrate(Flyway.java:919)
  1513. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1514. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1515. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1516. at java.lang.reflect.Method.invoke(Method.java:497)
  1517. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
  1518. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
  1519. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
  1520. ... 102 more
  1521. Caused by: org.postgresql.util.PSQLException: ERROR: relation "cohort" already exists
  1522. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  1523. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  1524. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  1525. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  1526. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  1527. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  1528. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
  1529. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
  1530. ... 123 more
  1531. 2015-09-02 00:22:10.654 DEBUG qtp1303694167-47 org.ohdsi.olympus.controller.WebApiController - - Get config
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!