Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Hapi server does not work with PostgreSQL 15 and 16 #694

Closed
neumartin opened this issue Jun 12, 2024 · 1 comment
Closed

Hapi server does not work with PostgreSQL 15 and 16 #694

neumartin opened this issue Jun 12, 2024 · 1 comment

Comments

@neumartin
Copy link

Hi!

I have this docker compose file:

services:
  web:
    image: "hapiproject/hapi:latest"
    container_name: hapi-fhir
    ports:
      - "8090:8080"
    volumes:
      #- ./configs/application.yaml:/data/hapi/application.yaml
      #- ./configs:/data/hapi      
      - ./configs/application.yaml:/data/hapi/application.yaml
    environment:
      SPRING_CONFIG_LOCATION: 'file:https:///data/hapi/application.yaml'
    networks:
      - postgresql_15_postgresql_15
      - hapi-network

networks:
  postgresql_15_postgresql_15:
    external: true

  hapi-network:
    driver: bridge

And this application.yaml

#Uncomment the "servlet" and "context-path" lines below to make the fhir endpoint available at /example/path/fhir instead of the default value of /fhir
server:
#  servlet:
#    context-path: /example/path
  port: 8080
#Adds the option to go to eg. http:https://localhost:8080/actuator/health for seeing the running configuration
#see https://docs.spring.io/spring-boot/docs/current/reference/html/actuator.html#actuator.endpoints
management:
  endpoints:
    web:
      exposure:
        include: "health,prometheus"
spring:
  main:
    allow-circular-references: true
    #allow-bean-definition-overriding: true
  flyway:
    enabled: false
    baselineOnMigrate: true
    fail-on-missing-locations: false
  datasource:
    url: jdbc:postgresql:https://172.26.0.2:5432/hapi
    username: postgres
    password: password
    driver-class-name: org.postgresql.Driver
    # database connection pool size
    hikari:
      maximum-pool-size: 10
  jpa:
    properties:
      hibernate.format_sql: false
      hibernate.show_sql: false

      #Hibernate dialect is automatically detected except Postgres and H2.
      #If using H2, then supply the value of ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect
      #If using postgres, then supply the value of ca.uhn.fhir.jpa.model.dialect.HapiFhirPostgres94Dialect
      hibernate.dialect: ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect
  #      hibernate.hbm2ddl.auto: update
  #      hibernate.jdbc.batch_size: 20
  #      hibernate.cache.use_query_cache: false
  #      hibernate.cache.use_second_level_cache: false
  #      hibernate.cache.use_structured_entries: false
  #      hibernate.cache.use_minimal_puts: false

  ###    These settings will enable fulltext search with lucene or elastic
      hibernate.search.enabled: true
  ### lucene parameters
#      hibernate.search.backend.type: lucene
#      hibernate.search.backend.analysis.configurer: ca.uhn.fhir.jpa.search.HapiHSearchAnalysisConfigurers$HapiLuceneAnalysisConfigurer
#      hibernate.search.backend.directory.type: local-filesystem
#      hibernate.search.backend.directory.root: target/lucenefiles
#      hibernate.search.backend.lucene_version: lucene_current
  ### elastic parameters ===> see also elasticsearch section below <===
#      hibernate.search.backend.type: elasticsearch
#      hibernate.search.backend.analysis.configurer: ca.uhn.fhir.jpa.search.HapiHSearchAnalysisConfigurers$HapiElasticAnalysisConfigurer
hapi:
  fhir:
    ### This flag when enabled to true, will avail evaluate measure operations from CR Module.
    ### Flag is false by default, can be passed as command line argument to override.
    cr:
      enabled: false

    cdshooks:
      enabled: true
      clientIdHeaderName: client_id

    ### This enables the swagger-ui at /fhir/swagger-ui/index.html as well as the /fhir/api-docs (see https://hapifhir.io/hapi-fhir/docs/server_plain/openapi.html)
    openapi_enabled: true
    ### This is the FHIR version. Choose between, DSTU2, DSTU3, R4 or R5
    fhir_version: R4
    ### Flag is false by default. This flag enables runtime installation of IG's.
    ig_runtime_upload_enabled: false
    ### This flag when enabled to true, will avail evaluate measure operations from CR Module.

    ### enable to use the ApacheProxyAddressStrategy which uses X-Forwarded-* headers
    ### to determine the FHIR server address
    #   use_apache_address_strategy: false
    ### forces the use of the https:// protocol for the returned server address.
    ### alternatively, it may be set using the X-Forwarded-Proto header.
    #   use_apache_address_strategy_https: false
    ### enables the server to overwrite defaults on HTML, css, etc. under the url pattern of eg. /content/custom **
    ### Folder with custom content MUST be named custom. If omitted then default content applies
    #custom_content_path: ./custom
    ### enables the server host custom content. If e.g. the value ./configs/app is supplied then the content
    ### will be served under /web/app
    #app_content_path: ./configs/app
    ### enable to set the Server URL
    #    server_address: http:https://hapi.fhir.org/baseR4
    #    defer_indexing_for_codesystems_of_size: 101
    #    install_transitive_ig_dependencies: true
    #implementationguides:
    ###    example from registry (packages.fhir.org)
    #  swiss:
    #    name: swiss.mednet.fhir
    #    version: 0.8.0
    #    reloadExisting: false
    #    installMode: STORE_AND_INSTALL
    #      example not from registry
    #      ips_1_0_0:
    #        packageUrl: https://build.fhir.org/ig/HL7/fhir-ips/package.tgz
    #        name: hl7.fhir.uv.ips
    #        version: 1.0.0
    #    supported_resource_types:
    #      - Patient
    #      - Observation
    ##################################################
    # Allowed Bundle Types for persistence (defaults are: COLLECTION,DOCUMENT,MESSAGE)
    ##################################################
    #    allowed_bundle_types: COLLECTION,DOCUMENT,MESSAGE,TRANSACTION,TRANSACTIONRESPONSE,BATCH,BATCHRESPONSE,HISTORY,SEARCHSET
    #    allow_cascading_deletes: true
    #    allow_contains_searches: true
    #    allow_external_references: true
    #    allow_multiple_delete: true
    #    allow_override_default_search_params: true
    #    auto_create_placeholder_reference_targets: false
    ### tells the server to automatically append the current version of the target resource to references at these paths
    #    auto_version_reference_at_paths: Device.patient, Device.location, Device.parent, DeviceMetric.parent, DeviceMetric.source, Observation.device, Observation.subject
    #    ips_enabled: false
    #    default_encoding: JSON
    #    default_pretty_print: true
    #    default_page_size: 20
    #    delete_expunge_enabled: true
    #    enable_repository_validating_interceptor: true
    #    enable_index_missing_fields: false
    #    enable_index_of_type: true
    #    enable_index_contained_resource: false
    #    resource_dbhistory_enabled: false
    ###  !!Extended Lucene/Elasticsearch Indexing is still a experimental feature, expect some features (e.g. _total=accurate) to not work as expected!!
    ###  more information here: https://hapifhir.io/hapi-fhir/docs/server_jpa/elastic.html
    advanced_lucene_indexing: false
    bulk_export_enabled: false
    bulk_import_enabled: false
    #    language_search_parameter_enabled: true
    #    enforce_referential_integrity_on_delete: false
    # This is an experimental feature, and does not fully support _total and other FHIR features.
    #    enforce_referential_integrity_on_delete: false
    #    enforce_referential_integrity_on_write: false
    #    etag_support_enabled: true
    #    expunge_enabled: true
    #    client_id_strategy: ALPHANUMERIC
    #    server_id_strategy: SEQUENTIAL_NUMERIC
    #    fhirpath_interceptor_enabled: false
    #    filter_search_enabled: true
    #    graphql_enabled: true
    narrative_enabled: false
    mdm_enabled: false
    mdm_rules_json_location: "mdm-rules.json"
    #    local_base_urls:
    #      - https://hapi.fhir.org/baseR4
    logical_urls:
      - http:https://terminology.hl7.org/*
      - https://terminology.hl7.org/*
      - http:https://snomed.info/*
      - https://snomed.info/*
      - http:https://unitsofmeasure.org/*
      - https://unitsofmeasure.org/*
      - http:https://loinc.org/*
      - https://loinc.org/*
    #    partitioning:
    #      allow_references_across_partitions: false
    #      partitioning_include_in_search_hashes: false
    cors:
      allow_Credentials: true
      # These are allowed_origin patterns, see: https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/web/cors/CorsConfiguration.html#setAllowedOriginPatterns-java.util.List-
      allowed_origin:
        - '*'

    # Search coordinator thread pool sizes
    search-coord-core-pool-size: 20
    search-coord-max-pool-size: 100
    search-coord-queue-capacity: 200
    
    # comma-separated package names, will be @ComponentScan'ed by Spring to allow for creating custom Spring beans
    #custom-bean-packages:
    
    # comma-separated list of fully qualified interceptor classes. 
    # classes listed here will be fetched from the Spring context when combined with 'custom-bean-packages', 
    # or will be instantiated via reflection using an no-arg contructor; then registered with the server  
    #custom-interceptor-classes:  

    # comma-separated list of fully qualified provider classes. 
    # classes listed here will be fetched from the Spring context when combined with 'custom-bean-packages', 
    # or will be instantiated via reflection using an no-arg contructor; then registered with the server  
    #custom-provider-classes:  
    
    # Threadpool size for BATCH'ed GETs in a bundle.
    #    bundle_batch_pool_size: 10
    #    bundle_batch_pool_max_size: 50

    #    logger:
    #      error_format: 'ERROR - ${requestVerb} ${requestUrl}'
    #      format: >-
    #        Path[${servletPath}] Source[${requestHeader.x-forwarded-for}]
    #        Operation[${operationType} ${operationName} ${idOrResourceName}]
    #        UA[${requestHeader.user-agent}] Params[${requestParameters}]
    #        ResponseEncoding[${responseEncodingNoDefault}]
    #      log_exceptions: true
    #      name: fhirtest.access
    #    max_binary_size: 104857600
    #    max_page_size: 200
    #    retain_cached_searches_mins: 60
    #    reuse_cached_search_results_millis: 60000
    tester:
      home:
        name: Local Tester
        server_address: 'http:https://localhost:8080/fhir'
        refuse_to_fetch_third_party_urls: false
        fhir_version: R4
      global:
        name: Global Tester
        server_address: "http:https://hapi.fhir.org/baseR4"
        refuse_to_fetch_third_party_urls: false
        fhir_version: R4
    #    validation:
    #      requests_enabled: true
    #      responses_enabled: true
    #    binary_storage_enabled: true
    inline_resource_storage_below_size: 4000
#    bulk_export_enabled: true
#    subscription:
#      resthook_enabled: true
#      websocket_enabled: false
#      email:
#        from: [email protected]
#        host: google.com
#        port:
#        username:
#        password:
#        auth:
#        startTlsEnable:
#        startTlsRequired:
#        quitWait:
#    lastn_enabled: true
#    store_resource_in_lucene_index_enabled: true
###  This is configuration for normalized quantity search level default is 0
###   0: NORMALIZED_QUANTITY_SEARCH_NOT_SUPPORTED - default
###   1: NORMALIZED_QUANTITY_STORAGE_SUPPORTED
###   2: NORMALIZED_QUANTITY_SEARCH_SUPPORTED
#    normalized_quantity_search_level: 2
#elasticsearch:
#  debug:
#    pretty_print_json_log: false
#    refresh_after_write: false
#  enabled: false
#  password: SomePassword
#  required_index_status: YELLOW
#  rest_url: 'localhost:9200'
#  protocol: 'http'
#  schema_management_strategy: CREATE
#  username: SomeUsername

But when I start with docker compose up the tables were created in PostgreSQL but I'm getting these errors in the log, then http:https://localhost:8090/ works but REST API not:

2024-06-12 15:50:57 hapi-fhir  | 
2024-06-12 15:50:57 hapi-fhir  |   .   ____          _            __ _ _
2024-06-12 15:50:57 hapi-fhir  |  /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
2024-06-12 15:50:57 hapi-fhir  | ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
2024-06-12 15:50:57 hapi-fhir  |  \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
2024-06-12 15:50:57 hapi-fhir  |   '  |____| .__|_| |_|_| |_\__, | / / / /
2024-06-12 15:50:57 hapi-fhir  |  =========|_|==============|___/=/_/_/_/
2024-06-12 15:50:57 hapi-fhir  | 2024-06-12 18:50:57.312 [background-preinit] INFO  o.h.validator.internal.util.Version [Version.java:21] HV000001: Hibernate Validator 8.0.0.Final
2024-06-12 15:50:57 hapi-fhir  |  :: Spring Boot ::                (v3.2.0)
2024-06-12 15:50:57 hapi-fhir  | 
2024-06-12 15:50:57 hapi-fhir  | 2024-06-12 18:50:57.370 [main] INFO  ca.uhn.fhir.jpa.starter.Application [StartupInfoLogger.java:50] Starting Application using Java 17.0.11 with PID 1 (/app/main.war started by nonroot in /app)
2024-06-12 15:50:57 hapi-fhir  | 2024-06-12 18:50:57.371 [main] INFO  ca.uhn.fhir.jpa.starter.Application [SpringApplication.java:653] No active profile set, falling back to 1 default profile: "default"
2024-06-12 15:50:58 hapi-fhir  | 2024-06-12 18:50:58.036 [main] INFO  o.s.d.r.c.RepositoryConfigurationDelegate [RepositoryConfigurationDelegate.java:139] Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2024-06-12 15:50:58 hapi-fhir  | 2024-06-12 18:50:58.160 [main] INFO  o.s.d.r.c.RepositoryConfigurationDelegate [RepositoryConfigurationDelegate.java:208] Finished Spring Data repository scanning in 119 ms. Found 52 JPA repository interfaces.
2024-06-12 15:50:58 hapi-fhir  | 2024-06-12 18:50:58.966 [main] WARN  o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker [PostProcessorRegistrationDelegate.java:429] Bean 'ca.uhn.fhir.jpa.config.BeanPostProcessorConfig' of type [ca.uhn.fhir.jpa.config.BeanPostProcessorConfig$$SpringCGLIB$$0] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying). The currently created BeanPostProcessor [persistenceExceptionTranslationPostProcessor] is declared through a non-static factory method on that class; consider declaring it as static instead.
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.212 [main] INFO  o.s.b.w.e.tomcat.TomcatWebServer [TomcatWebServer.java:108] Tomcat initialized with port 8080 (http)
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.219 [main] INFO  o.a.coyote.http11.Http11NioProtocol [DirectJDKLog.java:173] Initializing ProtocolHandler ["http-nio-8080"]
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.220 [main] INFO  o.a.catalina.core.StandardService [DirectJDKLog.java:173] Starting service [Tomcat]
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.220 [main] INFO  o.a.catalina.core.StandardEngine [DirectJDKLog.java:173] Starting Servlet engine: [Apache Tomcat/10.1.16]
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.283 [main] INFO  o.a.c.c.C.[Tomcat].[localhost].[/] [DirectJDKLog.java:173] Initializing Spring embedded WebApplicationContext
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.284 [main] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext [ServletWebServerApplicationContext.java:296] Root WebApplicationContext: initialization completed in 1877 ms
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.331 [main] INFO  ca.uhn.fhir.util.VersionUtil [VersionUtil.java:84] HAPI FHIR version 7.2.0 - Rev 018a38bd45
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.333 [main] INFO  ca.uhn.fhir.context.FhirContext [FhirContext.java:226] Creating new FHIR context for FHIR version [R4]
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.346 [main] INFO  c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:39] Server configured to allow contains searches
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.347 [main] INFO  c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:41] Server configured to deny multiple deletes
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.347 [main] INFO  c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:43] Server configured to deny external references
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.347 [main] INFO  c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:45] Server configured to enable DAO scheduling
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.347 [main] INFO  c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:47] Server configured to disable delete expunges
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.347 [main] INFO  c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:49] Server configured to enable expunges
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.347 [main] INFO  c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:51] Server configured to allow overriding default search params
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.347 [main] INFO  c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:54] Server configured to disable auto-creating placeholder references
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.347 [main] INFO  c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:57] Server configured to auto-version references at paths []
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.370 [main] INFO  c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:122] Server configured to have a maximum fetch size of 'unlimited'
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.370 [main] INFO  c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:127] Server configured to cache search results for 60000 milliseconds
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.370 [main] INFO  c.u.f.j.s.c.FhirServerConfigCommon [FhirServerConfigCommon.java:178] Server configured to use 'ALPHANUMERIC' Client ID Strategy
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.432 [main] INFO  o.h.jpa.internal.util.LogHelper [LogHelper.java:31] HHH000204: Processing PersistenceUnitInfo [name: HAPI_PU]
2024-06-12 15:50:59 hapi-fhir  | 2024-06-12 18:50:59.473 [main] INFO  org.hibernate.Version [Version.java:44] HHH000412: Hibernate ORM core version 6.4.1.Final
2024-06-12 15:51:02 hapi-fhir  | 2024-06-12 18:51:02.607 [main] INFO  c.u.f.j.l.FilteringSqlLoggerImplContributor [FilteringSqlLoggerImplContributor.java:33] Adding service: SqlStatementFilteringLogger
2024-06-12 15:51:02 hapi-fhir  | 2024-06-12 18:51:02.620 [main] INFO  o.h.c.i.RegionFactoryInitiator [RegionFactoryInitiator.java:50] HHH000026: Second-level cache disabled
2024-06-12 15:51:02 hapi-fhir  | 2024-06-12 18:51:02.663 [main] INFO  o.h.e.b.internal.EnversServiceImpl [EnversServiceImpl.java:76] Envers integration enabled? : true
2024-06-12 15:51:02 hapi-fhir  | 2024-06-12 18:51:02.836 [main] INFO  o.s.o.j.p.SpringPersistenceUnitInfo [SpringPersistenceUnitInfo.java:87] No LoadTimeWeaver setup: ignoring JPA class transformer
2024-06-12 15:51:02 hapi-fhir  | 2024-06-12 18:51:02.852 [main] INFO  com.zaxxer.hikari.HikariDataSource [HikariDataSource.java:110] HikariPool-1 - Starting...
2024-06-12 15:51:02 hapi-fhir  | 2024-06-12 18:51:02.991 [main] INFO  com.zaxxer.hikari.pool.HikariPool [HikariPool.java:565] HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@65bb6275
2024-06-12 15:51:02 hapi-fhir  | 2024-06-12 18:51:02.994 [main] INFO  com.zaxxer.hikari.HikariDataSource [HikariDataSource.java:123] HikariPool-1 - Start completed.
2024-06-12 15:51:03 hapi-fhir  | 2024-06-12 18:51:03.010 [main] WARN  o.h.e.j.e.i.JdbcEnvironmentInitiator [JdbcEnvironmentInitiator.java:345] HHH000342: Could not obtain connection to query metadata
2024-06-12 15:51:03 hapi-fhir  | org.hibernate.boot.registry.selector.spi.StrategySelectionException: Could not instantiate named strategy class [ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect]
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:244)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:189)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.constructDialect(DialectFactoryImpl.java:123)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:88)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$1.execute(JdbcEnvironmentInitiator.java:328)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$1.execute(JdbcEnvironmentInitiator.java:277)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.jdbc.WorkExecutor.executeReturningWork(WorkExecutor.java:58)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.jdbc.AbstractReturningWork.accept(AbstractReturningWork.java:34)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:70)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentUsingJdbcMetadata(JdbcEnvironmentInitiator.java:276)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:107)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:129)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:238)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:215)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.boot.model.relational.Database.<init>(Database.java:45)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase(InFlightMetadataCollectorImpl.java:223)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:191)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:170)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1432)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1503)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.jpa.HibernatePersistenceProvider.createContainerEntityManagerFactory(HibernatePersistenceProvider.java:142)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:390)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:366)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1833)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:600)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:225)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1323)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1284)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1252)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findDefaultEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:593)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:557)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.resolveEntityManager(PersistenceAnnotationBeanPostProcessor.java:724)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.getResourceToInject(PersistenceAnnotationBeanPostProcessor.java:697)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:270)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:145)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.postProcessProperties(PersistenceAnnotationBeanPostProcessor.java:385)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1419)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:599)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:542)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1335)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1165)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:542)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1335)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1165)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:205)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:210)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:201)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addServletContextInitializerBeans(ServletContextInitializerBeans.java:96)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.web.servlet.ServletContextInitializerBeans.<init>(ServletContextInitializerBeans.java:85)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.getServletContextInitializerBeans(ServletWebServerApplicationContext.java:266)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.selfInitialize(ServletWebServerApplicationContext.java:240)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.web.embedded.tomcat.TomcatStarter.onStartup(TomcatStarter.java:52)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4850)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322)
2024-06-12 15:51:03 hapi-fhir  |        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2024-06-12 15:51:03 hapi-fhir  |        at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:845)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322)
2024-06-12 15:51:03 hapi-fhir  |        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2024-06-12 15:51:03 hapi-fhir  |        at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:866)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:240)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.core.StandardService.startInternal(StandardService.java:433)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:917)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
2024-06-12 15:51:03 hapi-fhir  |        at org.apache.catalina.startup.Tomcat.start(Tomcat.java:488)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:123)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.<init>(TomcatWebServer.java:104)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:501)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:218)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:188)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:162)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:618)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:753)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:455)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.SpringApplication.run(SpringApplication.java:323)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.SpringApplication.run(SpringApplication.java:1342)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.SpringApplication.run(SpringApplication.java:1331)
2024-06-12 15:51:03 hapi-fhir  |        at ca.uhn.fhir.jpa.starter.Application.main(Application.java:46)
2024-06-12 15:51:03 hapi-fhir  |        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2024-06-12 15:51:03 hapi-fhir  |        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
2024-06-12 15:51:03 hapi-fhir  |        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2024-06-12 15:51:03 hapi-fhir  |        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.loader.Launcher.launch(Launcher.java:95)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
2024-06-12 15:51:03 hapi-fhir  |        at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:466)
2024-06-12 15:51:03 hapi-fhir  | Caused by: org.hibernate.boot.registry.selector.spi.StrategySelectionException: Could not instantiate named dialect class [ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect]
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.lambda$constructDialect$0(DialectFactoryImpl.java:143)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:240)
2024-06-12 15:51:03 hapi-fhir  |        ... 131 common frames omitted
2024-06-12 15:51:03 hapi-fhir  | Caused by: java.lang.reflect.InvocationTargetException: null
2024-06-12 15:51:03 hapi-fhir  |        at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2024-06-12 15:51:03 hapi-fhir  |        at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
2024-06-12 15:51:03 hapi-fhir  |        at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2024-06-12 15:51:03 hapi-fhir  |        at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
2024-06-12 15:51:03 hapi-fhir  |        at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.lambda$constructDialect$0(DialectFactoryImpl.java:131)
2024-06-12 15:51:03 hapi-fhir  |        ... 132 common frames omitted
2024-06-12 15:51:03 hapi-fhir  | Caused by: java.lang.NumberFormatException: For input string: "(Debian"
2024-06-12 15:51:03 hapi-fhir  |        at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:67)
2024-06-12 15:51:03 hapi-fhir  |        at java.base/java.lang.Integer.parseInt(Integer.java:654)
2024-06-12 15:51:03 hapi-fhir  |        at java.base/java.lang.Integer.parseInt(Integer.java:786)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.dialect.H2Dialect.parseBuildId(H2Dialect.java:160)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.dialect.H2Dialect.parseVersion(H2Dialect.java:150)
2024-06-12 15:51:03 hapi-fhir  |        at org.hibernate.dialect.H2Dialect.<init>(H2Dialect.java:124)
2024-06-12 15:51:03 hapi-fhir  |        at ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect.<init>(HapiFhirH2Dialect.java:36)
2024-06-12 15:51:03 hapi-fhir  |        ... 138 common frames omitted
2024-06-12 15:51:03 hapi-fhir  | 2024-06-12 18:51:03.384 [main] INFO  o.h.s.m.o.b.i.HibernateSearchPreIntegrationService [HibernateSearchPreIntegrationService.java:101] HSEARCH000034: Hibernate Search version 7.0.0.Final
2024-06-12 15:51:03 hapi-fhir  | 2024-06-12 18:51:03.470 [main] INFO  o.h.e.c.i.m.AuditMetadataGenerator [AuditMetadataGenerator.java:322] Adding properties for entity: ca.uhn.fhir.jpa.entity.MdmLink
2024-06-12 15:51:04 hapi-fhir  | 2024-06-12 18:51:04.258 [main] INFO  o.h.e.t.j.p.i.JtaPlatformInitiator [JtaPlatformInitiator.java:58] HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
2024-06-12 15:51:04 hapi-fhir  | 2024-06-12 18:51:04.310 [main] WARN  o.h.t.s.i.ExceptionHandlerLoggedImpl [ExceptionHandlerLoggedImpl.java:27] GenerationTarget encountered exception accepting command : Error executing DDL "create table bt2_job_instance (id varchar(100) not null, job_cancelled boolean not null, cmb_recs_processed integer, cmb_recs_per_sec float(53), create_time timestamp(6) not null, cur_gated_step_id varchar(100), definition_id varchar(100) not null, definition_ver integer not null, end_time timestamp(6), error_count integer, error_msg varchar(500), est_remaining varchar(100), fast_tracking boolean, params_json varchar(2000), params_json_lob clob, params_json_vc clob, progress_pct float(53), report clob, report_vc clob, start_time timestamp(6), stat varchar(20) not null, tot_elapsed_millis integer, client_id varchar(200), user_name varchar(200), update_time timestamp(6), warning_msg varchar(4000), work_chunks_purged boolean not null, primary key (id))" via JDBC [ERROR: type "clob" does not exist
2024-06-12 15:51:04 hapi-fhir  |   Position: 445]
2024-06-12 15:51:04 hapi-fhir  | org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table bt2_job_instance (id varchar(100) not null, job_cancelled boolean not null, cmb_recs_processed integer, cmb_recs_per_sec float(53), create_time timestamp(6) not null, cur_gated_step_id varchar(100), definition_id varchar(100) not null, definition_ver integer not null, end_time timestamp(6), error_count integer, error_msg varchar(500), est_remaining varchar(100), fast_tracking boolean, params_json varchar(2000), params_json_lob clob, params_json_vc clob, progress_pct float(53), report clob, report_vc clob, start_time timestamp(6), stat varchar(20) not null, tot_elapsed_millis integer, client_id varchar(200), user_name varchar(200), update_time timestamp(6), warning_msg varchar(4000), work_chunks_purged boolean not null, primary key (id))" via JDBC [ERROR: type "clob" does not exist
2024-06-12 15:51:04 hapi-fhir  |   Position: 445]
.... and more....

Please can anyone help me to understand what I doing wrong?
Thanks!
@neumartin
Copy link
Author

Now it works, the problem was hibernate.dialect:

hibernate.dialect: ca.uhn.fhir.jpa.model.dialect.HapiFhirPostgres94Dialect

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@neumartin