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

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

Open
KonradHoeffner opened this issue Nov 3, 2023 · 7 comments
Open

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

KonradHoeffner opened this issue Nov 3, 2023 · 7 comments
Assignees
@KonradHoeffner
Labels
enhancement New feature or request

Comments

@KonradHoeffner
Copy link
Contributor

Part of Onto-Med/top-deployment#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
Copy link
Contributor Author

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)

@KonradHoeffner KonradHoeffner changed the title allow logging to be configurable using env variables allow logging to be configurable using env variables and tone it down by default Nov 3, 2023
KonradHoeffner added a commit that referenced this issue Nov 3, 2023
@KonradHoeffner
Set liquibase log level to warning
be678fe 
Right now it is extremely verbose.
See <https://docs.liquibase.com/concepts/connections/creating-config-properties.html>.
Partly addresses #176.
@KonradHoeffner KonradHoeffner mentioned this issue Nov 3, 2023
Merged
ChristophB pushed a commit that referenced this issue Nov 3, 2023
@KonradHoeffner @ChristophB
Set liquibase log level to warning
37491bf 
Right now it is extremely verbose.
See <https://docs.liquibase.com/concepts/connections/creating-config-properties.html>.
Partly addresses #176.
@ChristophB
Copy link
Member

ChristophB commented Nov 3, 2023 •
edited
Loading

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)

ChristophB pushed a commit that referenced this issue Nov 3, 2023
@KonradHoeffner
Set liquibase log level to warning (#177)
d9bf3f9 
Partly addresses #176
@KonradHoeffner
Copy link
Contributor Author

KonradHoeffner commented Nov 3, 2023 •
edited
Loading

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 Console information leak liquibase/liquibase#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
Copy link
Member

ChristophB commented Dec 15, 2023 •
edited
Loading

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 added a commit that referenced this issue Dec 15, 2023
@KonradHoeffner
update liquibase, helps with #176
168ba62
@KonradHoeffner KonradHoeffner mentioned this issue Dec 15, 2023
Merged
fmatthies pushed a commit that referenced this issue Dec 16, 2023
@KonradHoeffner
update liquibase, helps with #176 (#185)
901a515
fmatthies pushed a commit that referenced this issue Dec 16, 2023
@KonradHoeffner @fmatthies
update liquibase, helps with #176 (#185)
2fc0b4e
@KonradHoeffner
Copy link
Contributor Author

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

@KonradHoeffner
Copy link
Contributor Author

KonradHoeffner commented Dec 18, 2023 •
edited
Loading

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
Copy link
Contributor Author

KonradHoeffner commented Dec 18, 2023 •
edited
Loading

Strangely, the liquibase INFO messages still occur with backend version v0.7.0-beta-10 where d9bf3f9 is included.

@KonradHoeffner KonradHoeffner self-assigned this Dec 18, 2023
@KonradHoeffner KonradHoeffner added the enhancement New feature or request label Dec 18, 2023
ChristophB added a commit that referenced this issue Jan 15, 2024
@fmatthies @ChristophB @KonradHoeffner
Add concept cluster creation functionality (#188)
536ca51 
* for convenience: added google-java-format script

* fixed response; removed unused imports

* started implementing the functionality to replicate the conceptGraphs returned by concept-graphs-api in the neo4j db with backend methods

* continuing; relationships are added. but there are also duplicates and DocumentNodeEntity are not created

* added methods to remove and add related nodes from within each NodeEntity as well as methods to convert them to its respective API counterpart

* seems like I need to use cypher queries in java to create the network like I want and can't use SDN

* update concept caching; fixed some bugs; need to rework the neo4j node creation (probably still with explicit Cypher Queries)

* basic neo4j concept cluster creation implemented for the backend. now we need to adapt top-api accordingly

* Re-enable OLS related tests

Looks like they were accidentally disabled due to merging issues

* Fix plugin detection with `reflections` (#186)

* update liquibase, helps with #176 (#185)

* google-java-format and implemented call to create concept graphs

* wrong override?

* fixed caching

* Threading of concept cluster creation in neo4j per process only; not for each graph. Added logging filter for neo4j except error since massive amounts of warnings of deprecation where thrown that are beyond our control

* bump pom version

* fixed google format

* Remove google java style scripts

They should not be included in this repository

* Reduce version number

We are still in preparation for the v0.7.0 release

* review: requested changes

* review: requested changes - working on tests

* only conceptById test; the other is not feasible

* disabled test for neo4j. it works when just running it as a single test but when run with more tests somehow the database is not accessible anymore. need to look into it before enabling.

* google format...

---------

Co-authored-by: Christoph Beger <[email protected]>
Co-authored-by: Konrad Höffner <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@KonradHoeffner KonradHoeffner

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@KonradHoeffner @ChristophB