search

Onto-Med / top-backend

Spring Boot based backend of the TOP Framework
MIT License
0 stars 1 forks source link

allow logging to be configurable using env variables and tone it down by default #176

Open KonradHoeffner opened 11 months ago

KonradHoeffner commented 11 months ago

Part of https://github.com/Onto-Med/top-deployment/issues/44. Right now there is a large amount of unnecessary log output:

top-deployment-backend-1   | 
top-deployment-backend-1   |   .   ____          _            __ _ _
top-deployment-backend-1   |  /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
top-deployment-backend-1   | ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
top-deployment-backend-1   |  \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
top-deployment-backend-1   |   '  |____| .__|_| |_|_| |_\__, | / / / /
top-deployment-backend-1   |  =========|_|==============|___/=/_/_/_/
top-deployment-backend-1   |  :: Spring Boot ::               (v2.7.10)
top-deployment-backend-1   | 
top-deployment-backend-1   | 2023-11-03 08:21:34.989  INFO 1 --- [           main] c.s.top.backend.TopBackendApplication    : Starting TopBackendApplication v0.6.9 using Java 11.0.16 on 31a1e13f6666 with PID 1 (/usr/src/top-backend/top-backend.jar started by root in /usr/src/top-backend)
top-deployment-backend-1   | 2023-11-03 08:21:34.991  INFO 1 --- [           main] c.s.top.backend.TopBackendApplication    : No active profile set, falling back to 1 default profile: "default"
top-deployment-backend-1   | 2023-11-03 08:21:35.641  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode
top-deployment-backend-1   | 2023-11-03 08:21:35.641  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
top-deployment-backend-1   | 2023-11-03 08:21:35.817  INFO 1 --- [           main] .RepositoryConfigurationExtensionSupport : Spring Data JPA - Could not safely identify store assignment for repository candidate interface care.smith.top.backend.repository.nlp.DocumentRepository; If you want this repository to be a JPA repository, consider annotating your entities with one of these annotations: javax.persistence.Entity, javax.persistence.MappedSuperclass (preferred), or consider extending one of the following types with your repository: org.springframework.data.jpa.repository.JpaRepository
top-deployment-backend-1   | 2023-11-03 08:21:35.818  INFO 1 --- [           main] .RepositoryConfigurationExtensionSupport : Spring Data JPA - Could not safely identify store assignment for repository candidate interface care.smith.top.backend.repository.nlp.ConceptRepository; If you want this repository to be a JPA repository, consider annotating your entities with one of these annotations: javax.persistence.Entity, javax.persistence.MappedSuperclass (preferred), or consider extending one of the following types with your repository: org.springframework.data.jpa.repository.JpaRepository
top-deployment-backend-1   | 2023-11-03 08:21:35.820  INFO 1 --- [           main] .RepositoryConfigurationExtensionSupport : Spring Data JPA - Could not safely identify store assignment for repository candidate interface care.smith.top.backend.repository.nlp.PhraseRepository; If you want this repository to be a JPA repository, consider annotating your entities with one of these annotations: javax.persistence.Entity, javax.persistence.MappedSuperclass (preferred), or consider extending one of the following types with your repository: org.springframework.data.jpa.repository.JpaRepository
top-deployment-backend-1   | 2023-11-03 08:21:35.836  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 190 ms. Found 9 JPA repository interfaces.
top-deployment-backend-1   | 2023-11-03 08:21:35.840  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode
top-deployment-backend-1   | 2023-11-03 08:21:35.840  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data Neo4j repositories in DEFAULT mode.
top-deployment-backend-1   | 2023-11-03 08:21:35.847  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 6 ms. Found 3 Neo4j repository interfaces.
top-deployment-backend-1   | 2023-11-03 08:21:36.222  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode
top-deployment-backend-1   | 2023-11-03 08:21:36.222  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data Neo4j repositories in DEFAULT mode.
top-deployment-backend-1   | 2023-11-03 08:21:36.228  INFO 1 --- [           main] .RepositoryConfigurationExtensionSupport : Spring Data Neo4j - Could not safely identify store assignment for repository candidate interface care.smith.top.backend.repository.QueryRepository; If you want this repository to be a Neo4j repository, consider annotating your entities with one of these annotations: org.springframework.data.neo4j.core.schema.Node, org.springframework.data.neo4j.core.schema.RelationshipProperties (preferred), or consider extending one of the following types with your repository: org.springframework.data.neo4j.repository.ReactiveNeo4jRepository
top-deployment-backend-1   | 2023-11-03 08:21:36.229  INFO 1 --- [           main] .RepositoryConfigurationExtensionSupport : Spring Data Neo4j - Could not safely identify store assignment for repository candidate interface care.smith.top.backend.repository.EntityVersionRepository; If you want this repository to be a Neo4j repository, consider annotating your entities with one of these annotations: org.springframework.data.neo4j.core.schema.Node, org.springframework.data.neo4j.core.schema.RelationshipProperties (preferred), or consider extending one of the following types with your repository: org.springframework.data.neo4j.repository.ReactiveNeo4jRepository
top-deployment-backend-1   | 2023-11-03 08:21:36.229  INFO 1 --- [           main] .RepositoryConfigurationExtensionSupport : Spring Data Neo4j - Could not safely identify store assignment for repository candidate interface care.smith.top.backend.repository.PhenotypeRepository; If you want this repository to be a Neo4j repository, consider annotating your entities with one of these annotations: org.springframework.data.neo4j.core.schema.Node, org.springframework.data.neo4j.core.schema.RelationshipProperties (preferred), or consider extending one of the following types with your repository: org.springframework.data.neo4j.repository.ReactiveNeo4jRepository
top-deployment-backend-1   | 2023-11-03 08:21:36.230  INFO 1 --- [           main] .RepositoryConfigurationExtensionSupport : Spring Data Neo4j - Could not safely identify store assignment for repository candidate interface care.smith.top.backend.repository.RepositoryRepository; If you want this repository to be a Neo4j repository, consider annotating your entities with one of these annotations: org.springframework.data.neo4j.core.schema.Node, org.springframework.data.neo4j.core.schema.RelationshipProperties (preferred), or consider extending one of the following types with your repository: org.springframework.data.neo4j.repository.ReactiveNeo4jRepository
top-deployment-backend-1   | 2023-11-03 08:21:36.230  INFO 1 --- [           main] .RepositoryConfigurationExtensionSupport : Spring Data Neo4j - Could not safely identify store assignment for repository candidate interface care.smith.top.backend.repository.OrganisationRepository; If you want this repository to be a Neo4j repository, consider annotating your entities with one of these annotations: org.springframework.data.neo4j.core.schema.Node, org.springframework.data.neo4j.core.schema.RelationshipProperties (preferred), or consider extending one of the following types with your repository: org.springframework.data.neo4j.repository.ReactiveNeo4jRepository
top-deployment-backend-1   | 2023-11-03 08:21:36.230  INFO 1 --- [           main] .RepositoryConfigurationExtensionSupport : Spring Data Neo4j - Could not safely identify store assignment for repository candidate interface care.smith.top.backend.repository.CategoryRepository; If you want this repository to be a Neo4j repository, consider annotating your entities with one of these annotations: org.springframework.data.neo4j.core.schema.Node, org.springframework.data.neo4j.core.schema.RelationshipProperties (preferred), or consider extending one of the following types with your repository: org.springframework.data.neo4j.repository.ReactiveNeo4jRepository
top-deployment-backend-1   | 2023-11-03 08:21:36.231  INFO 1 --- [           main] .RepositoryConfigurationExtensionSupport : Spring Data Neo4j - Could not safely identify store assignment for repository candidate interface care.smith.top.backend.repository.OrganisationMembershipRepository; If you want this repository to be a Neo4j repository, consider annotating your entities with one of these annotations: org.springframework.data.neo4j.core.schema.Node, org.springframework.data.neo4j.core.schema.RelationshipProperties (preferred), or consider extending one of the following types with your repository: org.springframework.data.neo4j.repository.ReactiveNeo4jRepository
top-deployment-backend-1   | 2023-11-03 08:21:36.231  INFO 1 --- [           main] .RepositoryConfigurationExtensionSupport : Spring Data Neo4j - Could not safely identify store assignment for repository candidate interface care.smith.top.backend.repository.EntityRepository; If you want this repository to be a Neo4j repository, consider annotating your entities with one of these annotations: org.springframework.data.neo4j.core.schema.Node, org.springframework.data.neo4j.core.schema.RelationshipProperties (preferred), or consider extending one of the following types with your repository: org.springframework.data.neo4j.repository.ReactiveNeo4jRepository
top-deployment-backend-1   | 2023-11-03 08:21:36.233  INFO 1 --- [           main] .RepositoryConfigurationExtensionSupport : Spring Data Neo4j - Could not safely identify store assignment for repository candidate interface care.smith.top.backend.repository.UserRepository; If you want this repository to be a Neo4j repository, consider annotating your entities with one of these annotations: org.springframework.data.neo4j.core.schema.Node, org.springframework.data.neo4j.core.schema.RelationshipProperties (preferred), or consider extending one of the following types with your repository: org.springframework.data.neo4j.repository.ReactiveNeo4jRepository
top-deployment-backend-1   | 2023-11-03 08:21:36.234  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 11 ms. Found 0 Neo4j repository interfaces.
top-deployment-backend-1   | 2023-11-03 08:21:36.632  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'customGlobalMethodSecurityConfiguration' of type [care.smith.top.backend.configuration.CustomGlobalMethodSecurityConfiguration$$EnhancerBySpringCGLIB$$f51a703b] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
top-deployment-backend-1   | 2023-11-03 08:21:36.980  INFO 1 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
top-deployment-backend-1   | 2023-11-03 08:21:36.991  INFO 1 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
top-deployment-backend-1   | 2023-11-03 08:21:36.991  INFO 1 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.73]
top-deployment-backend-1   | 2023-11-03 08:21:37.051  INFO 1 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/api]    : Initializing Spring embedded WebApplicationContext
top-deployment-backend-1   | 2023-11-03 08:21:37.052  INFO 1 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2005 ms
top-deployment-backend-1   | 2023-11-03 08:21:37.321  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
top-deployment-backend-1   | 2023-11-03 08:21:37.455  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
top-deployment-backend-1   | 2023-11-03 08:21:37.543  INFO 1 --- [           main] liquibase.database                       : Set default schema name to public
top-deployment-backend-1   | 2023-11-03 08:21:37.616  INFO 1 --- [           main] liquibase.lockservice                    : Successfully acquired change log lock
top-deployment-backend-1   | 2023-11-03 08:21:37.634  INFO 1 --- [           main] liquibase.changelog                      : Reading resource: db/changelog/changesets/202210170901-init-db.yaml
top-deployment-backend-1   | 2023-11-03 08:21:37.761  INFO 1 --- [           main] liquibase.changelog                      : Reading resource: db/changelog/changesets/202212141550-add-repository-type.yaml
top-deployment-backend-1   | 2023-11-03 08:21:37.763  INFO 1 --- [           main] liquibase.changelog                      : Reading resource: db/changelog/changesets/202301231633-add-value-table.yaml
top-deployment-backend-1   | 2023-11-03 08:21:37.765  INFO 1 --- [           main] liquibase.changelog                      : Reading resource: db/changelog/changesets/202302140945-add-user-table.yaml
top-deployment-backend-1   | 2023-11-03 08:21:37.767  INFO 1 --- [           main] liquibase.changelog                      : Reading resource: db/changelog/changesets/202302141252-add-user-role.yaml
top-deployment-backend-1   | 2023-11-03 08:21:37.768  INFO 1 --- [           main] liquibase.changelog                      : Reading resource: db/changelog/changesets/202302280930-replace-author-column.yaml
top-deployment-backend-1   | 2023-11-03 08:21:37.769  INFO 1 --- [           main] liquibase.changelog                      : Reading resource: db/changelog/changesets/202303221649-add-projection-default_aggregation-function-id.yaml
top-deployment-backend-1   | 2023-11-03 08:21:37.770  INFO 1 --- [           main] liquibase.changelog                      : Reading resource: db/changelog/changesets/202304191653-add-query-created-at.yaml
top-deployment-backend-1   | 2023-11-03 08:21:37.771  INFO 1 --- [           main] liquibase.changelog                      : Reading resource: db/changelog/changesets/202305261404-add-code-uri.yaml
top-deployment-backend-1   | 2023-11-03 08:21:37.785  INFO 1 --- [           main] liquibase.changelog                      : Creating database history table with name: public.databasechangelog
top-deployment-backend-1   | 2023-11-03 08:21:37.796  INFO 1 --- [           main] liquibase.changelog                      : Reading from public.databasechangelog
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-1::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:37.938  INFO 1 --- [           main] liquibase.changelog                      : Sequence hibernate_sequence created
top-deployment-backend-1   | 2023-11-03 08:21:37.940  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-1::ChristophB (generated) ran successfully in 3ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-2::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:37.952  INFO 1 --- [           main] liquibase.changelog                      : Table entity created
top-deployment-backend-1   | 2023-11-03 08:21:37.958  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-2::ChristophB (generated) ran successfully in 15ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-3::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:37.971  INFO 1 --- [           main] liquibase.changelog                      : Table entity_super_entities created
top-deployment-backend-1   | 2023-11-03 08:21:37.973  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-3::ChristophB (generated) ran successfully in 10ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-4::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:37.983  INFO 1 --- [           main] liquibase.changelog                      : Table entity_version created
top-deployment-backend-1   | 2023-11-03 08:21:37.985  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-4::ChristophB (generated) ran successfully in 10ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-5::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:37.996  INFO 1 --- [           main] liquibase.changelog                      : Table entity_version_codes created
top-deployment-backend-1   | 2023-11-03 08:21:37.998  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-5::ChristophB (generated) ran successfully in 11ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-6::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.009  INFO 1 --- [           main] liquibase.changelog                      : Table entity_version_descriptions created
top-deployment-backend-1   | 2023-11-03 08:21:38.010  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-6::ChristophB (generated) ran successfully in 10ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-7::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.016  INFO 1 --- [           main] liquibase.changelog                      : Table entity_version_equivalent_entity_versions created
top-deployment-backend-1   | 2023-11-03 08:21:38.018  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-7::ChristophB (generated) ran successfully in 6ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-8::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.028  INFO 1 --- [           main] liquibase.changelog                      : Table entity_version_synonyms created
top-deployment-backend-1   | 2023-11-03 08:21:38.029  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-8::ChristophB (generated) ran successfully in 9ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-9::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.039  INFO 1 --- [           main] liquibase.changelog                      : Table entity_version_titles created
top-deployment-backend-1   | 2023-11-03 08:21:38.040  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-9::ChristophB (generated) ran successfully in 9ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-10::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.051  INFO 1 --- [           main] liquibase.changelog                      : Table expression created
top-deployment-backend-1   | 2023-11-03 08:21:38.052  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-10::ChristophB (generated) ran successfully in 10ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-11::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.055  INFO 1 --- [           main] liquibase.changelog                      : Table expression_arguments created
top-deployment-backend-1   | 2023-11-03 08:21:38.056  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-11::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-12::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.066  INFO 1 --- [           main] liquibase.changelog                      : Table organisation created
top-deployment-backend-1   | 2023-11-03 08:21:38.068  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-12::ChristophB (generated) ran successfully in 10ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-13::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.078  INFO 1 --- [           main] liquibase.changelog                      : Table query created
top-deployment-backend-1   | 2023-11-03 08:21:38.079  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-13::ChristophB (generated) ran successfully in 10ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-14::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.085  INFO 1 --- [           main] liquibase.changelog                      : Table query_criteria created
top-deployment-backend-1   | 2023-11-03 08:21:38.087  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-14::ChristophB (generated) ran successfully in 6ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-15::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.092  INFO 1 --- [           main] liquibase.changelog                      : Table query_data_sources created
top-deployment-backend-1   | 2023-11-03 08:21:38.094  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-15::ChristophB (generated) ran successfully in 6ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-16::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.101  INFO 1 --- [           main] liquibase.changelog                      : Table query_projection created
top-deployment-backend-1   | 2023-11-03 08:21:38.102  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-16::ChristophB (generated) ran successfully in 6ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-17::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.113  INFO 1 --- [           main] liquibase.changelog                      : Table query_result created
top-deployment-backend-1   | 2023-11-03 08:21:38.114  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-17::ChristophB (generated) ran successfully in 10ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-18::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.124  INFO 1 --- [           main] liquibase.changelog                      : Table repository created
top-deployment-backend-1   | 2023-11-03 08:21:38.125  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-18::ChristophB (generated) ran successfully in 9ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-19::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.132  INFO 1 --- [           main] liquibase.changelog                      : Table restriction created
top-deployment-backend-1   | 2023-11-03 08:21:38.133  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-19::ChristophB (generated) ran successfully in 6ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-20::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.136  INFO 1 --- [           main] liquibase.changelog                      : Table restriction_boolean_values created
top-deployment-backend-1   | 2023-11-03 08:21:38.137  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-20::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-21::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.140  INFO 1 --- [           main] liquibase.changelog                      : Table restriction_date_time_values created
top-deployment-backend-1   | 2023-11-03 08:21:38.141  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-21::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-22::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.143  INFO 1 --- [           main] liquibase.changelog                      : Table restriction_number_values created
top-deployment-backend-1   | 2023-11-03 08:21:38.145  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-22::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-23::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.147  INFO 1 --- [           main] liquibase.changelog                      : Table restriction_string_values created
top-deployment-backend-1   | 2023-11-03 08:21:38.148  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-23::ChristophB (generated) ran successfully in 1ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-24::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.155  INFO 1 --- [           main] liquibase.changelog                      : Unique constraint added to expression_arguments(arguments_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.156  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-24::ChristophB (generated) ran successfully in 6ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-25::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.162  INFO 1 --- [           main] liquibase.changelog                      : Unique constraint added to query_result(query_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.163  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-25::ChristophB (generated) ran successfully in 5ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-26::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.167  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to organisation (super_organisation_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.168  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-26::ChristophB (generated) ran successfully in 3ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-27::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.171  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity_super_entities (super_entities_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.172  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-27::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-28::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.174  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to query_criteria (date_time_restriction_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.176  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-28::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-29::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.178  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to repository (organisation_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.180  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-29::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-30::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.182  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity_version (restriction_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.183  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-30::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-31::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.186  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity_version (expression_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.187  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-31::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-32::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.190  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to expression_arguments (expression_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.191  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-32::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-33::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.193  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity_version (entity_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.195  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-33::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-34::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.197  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity_super_entities (sub_entities_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.199  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-34::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-35::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.201  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity (origin_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.202  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-35::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-36::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.205  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity (repository_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.206  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-36::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-37::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.209  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to expression_arguments (arguments_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.210  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-37::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-38::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.213  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to query_projection (query_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.214  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-38::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-39::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.217  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity_version_titles (entity_version_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.218  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-39::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-40::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.222  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity (current_version_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.223  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-40::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-41::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.226  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to restriction_string_values (restriction_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.227  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-41::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-42::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.230  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity_version_synonyms (entity_version_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.231  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-42::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-43::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.234  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to query_criteria (query_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.235  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-43::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-44::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.238  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity_version (previous_version_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.239  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-44::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-45::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.242  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to restriction_number_values (restriction_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.243  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-45::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-46::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.245  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to query_data_sources (query_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.247  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-46::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-47::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.249  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to restriction_date_time_values (restriction_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.250  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-47::ChristophB (generated) ran successfully in 1ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-48::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.253  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to query_result (query_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.254  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-48::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-49::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.257  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to query (repository_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.258  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-49::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-50::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.261  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity_version_equivalent_entity_versions (equivalent_entity_version_of_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.263  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-50::ChristophB (generated) ran successfully in 3ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-51::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.265  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to restriction_boolean_values (restriction_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.266  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-51::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-52::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.269  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity_version_codes (entity_version_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.270  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-52::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-53::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.272  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity_version_descriptions (entity_version_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.273  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-53::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202210170901-init-db.yaml::1665990027334-54::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.276  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity_version_equivalent_entity_versions (equivalent_entity_versions_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.277  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202210170901-init-db.yaml::1665990027334-54::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202212141550-add-repository-type.yaml::1671028818545-6::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.279  INFO 1 --- [           main] liquibase.changelog                      : Columns repository_type(integer) added to repository
top-deployment-backend-1   | 2023-11-03 08:21:38.280  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202212141550-add-repository-type.yaml::1671028818545-6::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-6::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.283  INFO 1 --- [           main] liquibase.changelog                      : Table expression_values created
top-deployment-backend-1   | 2023-11-03 08:21:38.284  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-6::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-7::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.291  INFO 1 --- [           main] liquibase.changelog                      : Table value created
top-deployment-backend-1   | 2023-11-03 08:21:38.292  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-7::ChristophB (generated) ran successfully in 6ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-8::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.299  INFO 1 --- [           main] liquibase.changelog                      : Unique constraint added to expression_values(values_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.300  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-8::ChristophB (generated) ran successfully in 5ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-9::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.303  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to expression_values (values_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.304  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-9::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-10::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.307  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to expression_values (expression_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.308  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-10::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-11::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.311  INFO 1 --- [           main] liquibase.changelog                      : Column EXPRESSION.BOOLEAN_VALUE dropped
top-deployment-backend-1   | 2023-11-03 08:21:38.312  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-11::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-12::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.315  INFO 1 --- [           main] liquibase.changelog                      : Column EXPRESSION.DATE_TIME_VALUE dropped
top-deployment-backend-1   | 2023-11-03 08:21:38.316  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-12::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-13::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.319  INFO 1 --- [           main] liquibase.changelog                      : Column EXPRESSION.NUMBER_VALUE dropped
top-deployment-backend-1   | 2023-11-03 08:21:38.320  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-13::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-14::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.322  INFO 1 --- [           main] liquibase.changelog                      : Column EXPRESSION.STRING_VALUE dropped
top-deployment-backend-1   | 2023-11-03 08:21:38.324  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202301231633-add-value-table.yaml::1674488016958-14::ChristophB (generated) ran successfully in 1ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202302140945-add-user-table.yaml::1676364352747-8::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.330  INFO 1 --- [           main] liquibase.changelog                      : Table organisation_membership created
top-deployment-backend-1   | 2023-11-03 08:21:38.331  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202302140945-add-user-table.yaml::1676364352747-8::ChristophB (generated) ran successfully in 6ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202302140945-add-user-table.yaml::1676364352747-9::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.340  INFO 1 --- [           main] liquibase.changelog                      : Table user_table created
top-deployment-backend-1   | 2023-11-03 08:21:38.342  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202302140945-add-user-table.yaml::1676364352747-9::ChristophB (generated) ran successfully in 9ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202302140945-add-user-table.yaml::1676364352747-10::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.349  INFO 1 --- [           main] liquibase.changelog                      : Primary key added to organisation_membership (organisation_id, user_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.350  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202302140945-add-user-table.yaml::1676364352747-10::ChristophB (generated) ran successfully in 6ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202302140945-add-user-table.yaml::1676364352747-11::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.353  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to organisation_membership (user_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.354  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202302140945-add-user-table.yaml::1676364352747-11::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202302140945-add-user-table.yaml::1676364352747-12::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.357  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to organisation_membership (organisation_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.358  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202302140945-add-user-table.yaml::1676364352747-12::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202302141252-add-user-role.yaml::1676375700740-8::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.360  INFO 1 --- [           main] liquibase.changelog                      : Columns role(varchar(255)) added to user_table
top-deployment-backend-1   | 2023-11-03 08:21:38.362  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202302141252-add-user-role.yaml::1676375700740-8::ChristophB (generated) ran successfully in 1ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202302280930-replace-author-column.yaml::1677573038780-8::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.365  INFO 1 --- [           main] liquibase.changelog                      : Columns user_id(varchar(255)) added to entity_version
top-deployment-backend-1   | 2023-11-03 08:21:38.366  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202302280930-replace-author-column.yaml::1677573038780-8::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202302280930-replace-author-column.yaml::1677573038780-9::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.369  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to entity_version (user_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.370  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202302280930-replace-author-column.yaml::1677573038780-9::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202302280930-replace-author-column.yaml::1677573038780-10::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.373  INFO 1 --- [           main] liquibase.changelog                      : Column ENTITY_VERSION.AUTHOR dropped
top-deployment-backend-1   | 2023-11-03 08:21:38.374  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202302280930-replace-author-column.yaml::1677573038780-10::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202303221649-add-projection-default_aggregation-function-id.yaml::1679500200016-8::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.376  INFO 1 --- [           main] liquibase.changelog                      : Columns date_time_restriction_id(bigint) added to query_projection
top-deployment-backend-1   | 2023-11-03 08:21:38.377  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202303221649-add-projection-default_aggregation-function-id.yaml::1679500200016-8::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202303221649-add-projection-default_aggregation-function-id.yaml::1679500200016-9::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.380  INFO 1 --- [           main] liquibase.changelog                      : Columns default_aggregation_function_id(varchar(255)) added to query_projection
top-deployment-backend-1   | 2023-11-03 08:21:38.381  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202303221649-add-projection-default_aggregation-function-id.yaml::1679500200016-9::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202303221649-add-projection-default_aggregation-function-id.yaml::1679500200016-10::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.383  INFO 1 --- [           main] liquibase.changelog                      : Foreign key constraint added to query_projection (date_time_restriction_id)
top-deployment-backend-1   | 2023-11-03 08:21:38.384  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202303221649-add-projection-default_aggregation-function-id.yaml::1679500200016-10::ChristophB (generated) ran successfully in 1ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202303221649-add-projection-default_aggregation-function-id.yaml::1679500200016-11::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.387  INFO 1 --- [           main] liquibase.changelog                      : Column QUERY_PROJECTION.DATE_TIME_RESTRICTION dropped
top-deployment-backend-1   | 2023-11-03 08:21:38.388  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202303221649-add-projection-default_aggregation-function-id.yaml::1679500200016-11::ChristophB (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202303221649-add-projection-default_aggregation-function-id.yaml::1679500200016-12::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.390  INFO 1 --- [           main] liquibase.changelog                      : Column QUERY_PROJECTION.SORTING dropped
top-deployment-backend-1   | 2023-11-03 08:21:38.391  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202303221649-add-projection-default_aggregation-function-id.yaml::1679500200016-12::ChristophB (generated) ran successfully in 1ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202304191653-add-query-created-at.yaml::1681916104935-8::ChristophB (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.393  INFO 1 --- [           main] liquibase.changelog                      : Columns created_at(timestamp) added to query
top-deployment-backend-1   | 2023-11-03 08:21:38.394  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202304191653-add-query-created-at.yaml::1681916104935-8::ChristophB (generated) ran successfully in 1ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202305261404-add-code-uri.yaml::1685102649304-8::Christoph (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.396  INFO 1 --- [           main] liquibase.changelog                      : Columns uri(varchar(255)) added to entity_version_codes
top-deployment-backend-1   | 2023-11-03 08:21:38.398  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202305261404-add-code-uri.yaml::1685102649304-8::Christoph (generated) ran successfully in 2ms
top-deployment-backend-1   | Running Changeset: db/changelog/changesets/202305261404-add-code-uri.yaml::1685102649304-9::Christoph (generated)
top-deployment-backend-1   | 2023-11-03 08:21:38.403  INFO 1 --- [           main] liquibase.changelog                      : Column ENTITY_VERSION_CODES.CODE_SYSTEM_NAME dropped
top-deployment-backend-1   | 2023-11-03 08:21:38.404  INFO 1 --- [           main] liquibase.changelog                      : ChangeSet db/changelog/changesets/202305261404-add-code-uri.yaml::1685102649304-9::Christoph (generated) ran successfully in 2ms
top-deployment-backend-1   | 2023-11-03 08:21:38.407  INFO 1 --- [           main] liquibase.lockservice                    : Successfully released change log lock
top-deployment-backend-1   | 2023-11-03 08:21:38.455  INFO 1 --- [           main] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
top-deployment-backend-1   | 2023-11-03 08:21:38.508  INFO 1 --- [           main] org.hibernate.Version                    : HHH000412: Hibernate ORM core version 5.6.15.Final
top-deployment-backend-1   | 2023-11-03 08:21:38.644  INFO 1 --- [           main] o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons Annotations {5.1.2.Final}
top-deployment-backend-1   | 2023-11-03 08:21:38.743  INFO 1 --- [           main] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL10Dialect
top-deployment-backend-1   | 2023-11-03 08:21:39.454  INFO 1 --- [           main] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
top-deployment-backend-1   | 2023-11-03 08:21:39.462  INFO 1 --- [           main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
top-deployment-backend-1   | 2023-11-03 08:21:40.325  INFO 1 --- [           main] org.neo4j.driver.internal.DriverFactory  : Direct driver instance 1798217138 created for server address neo4j:7687
KonradHoeffner commented 11 months ago

Part 2 due to the character limit of 65536:

top-deployment-backend-1   | 2023-11-03 08:21:40.743  INFO 1 --- [           main] o.s.s.web.DefaultSecurityFilterChain     : Will secure any request with [org.springframework.security.web.session.DisableEncodeUrlFilter@51869ad6, org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@27a90ce5, org.springframework.security.web.context.SecurityContextPersistenceFilter@3c87e851, org.springframework.security.web.header.HeaderWriterFilter@1fc5c0b2, org.springframework.web.filter.CorsFilter@77f4038c, org.springframework.security.web.authentication.logout.LogoutFilter@4bff28e7, org.springframework.security.oauth2.server.resource.web.BearerTokenAuthenticationFilter@1eb9d69a, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@6124dda2, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@380e33c2, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@49a06087, org.springframework.security.web.session.SessionManagementFilter@d2cb2d0, org.springframework.security.web.access.ExceptionTranslationFilter@949d347, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@44e08a7a]
top-deployment-backend-1   | 2023-11-03 08:21:40.897  WARN 1 --- [           main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
top-deployment-backend-1   | 2023-11-03 08:21:41.539  INFO 1 --- [           main] j.s.t.ScheduledThreadPoolJobRunrExecutor : ThreadManager of type 'ScheduledThreadPool' started
top-deployment-backend-1   | 2023-11-03 08:21:41.541  INFO 1 --- [pool-2-thread-4] org.jobrunr.server.BackgroundJobServer   : Found 0 recurring jobs that need to be updated.
top-deployment-backend-1   | 2023-11-03 08:21:41.543  INFO 1 --- [pool-1-thread-1] org.jobrunr.server.BackgroundJobServer   : JobRunr BackgroundJobServer (e2174be3-a28b-4f51-b56e-ffacdd3bb456) using InMemoryStorageProvider and 160 BackgroundJobPerformers started successfully
top-deployment-backend-1   | 2023-11-03 08:21:41.543  INFO 1 --- [pool-1-thread-1] org.jobrunr.server.ServerZooKeeper       : Server e2174be3-a28b-4f51-b56e-ffacdd3bb456 is master (this BackgroundJobServer)
top-deployment-backend-1   | 2023-11-03 08:21:41.720  INFO 1 --- [           main] o.s.b.a.e.web.EndpointLinksResolver      : Exposing 1 endpoint(s) beneath base path '/actuator'
top-deployment-backend-1   | 2023-11-03 08:21:41.751  INFO 1 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path '/api'
top-deployment-backend-1   | 2023-11-03 08:21:41.762  INFO 1 --- [           main] c.s.top.backend.TopBackendApplication    : Started TopBackendApplication in 7.15 seconds (JVM running for 7.795)
ChristophB commented 11 months ago

The corresponding environment variable is LIQUIBASE_LOG_LEVEL. It has a higher precedents than the liquibase.properties file. (see https://docs.liquibase.com/concepts/connections/liquibase-environment-variables.html)

KonradHoeffner commented 11 months ago

After more research I I found the liquibase issue has two parts:

  1. the "Running Changeset: ..." messages are a bug in Liquibase that leaks out to console log, see https://github.com/liquibase/liquibase/issues/4274. There is a merged PR but the current release still has the problem so this should be resolvable with the next release.
  2. JAVA_OPTS=-Dlogging.level.liquibase=WARN works as well in docker-compose.env to get rid of the other INFO messages. But to make sure I will set LIQUIBASE_LOG_LEVEL there as well.
ChristophB commented 10 months ago

Liquibase v4.25.0 was released on November 13 and mentions the pull request in the "New Features" section: https://github.com/liquibase/liquibase/releases/tag/v4.25.0

KonradHoeffner commented 10 months ago

The "Running Changeset" messages are now gone after upgrading to Liquibase v4.25.0.

KonradHoeffner commented 10 months ago

LIQUIBASE_LOG_LEVEL=WARNING has no effect.

  backend:
    image: ghcr.io/onto-med/top-backend:v0.6.9
    [...]
    environment:
      - LIQUIBASE_LOG_LEVEL=WARNING
$ docker compose logs backend | grep liquibase
backend-1  | 2023-12-18 09:21:08.932  INFO 1 --- [           main] liquibase.database                       : Set default schema name to public
backend-1  | 2023-12-18 09:21:08.987  INFO 1 --- [           main] liquibase.lockservice                    : Successfully acquired change log lock
backend-1  | 2023-12-18 09:21:09.004  INFO 1 --- [           main] liquibase.changelog                      : Reading resource: db/changelog/changesets/202210170901-init-db.yaml
[...]

Even though the env var is set inside the container:

$ docker compose exec backend /bin/bash
root@77f229d94447:/usr/src/top-backend# echo $LIQUIBASE_LOG_LEVEL
WARNING
KonradHoeffner commented 10 months ago

Strangely, the liquibase INFO messages still occur with backend version v0.7.0-beta-10 where https://github.com/Onto-Med/top-backend/commit/d9bf3f939f2095b455ae02bdcfc0bc505de367a6 is included.