2023-09-13T13:50:52.704Z INFO 1 --- [ main] o.e.t.semantics.RegistryApplication : Starting RegistryApplication vDEV-SNAPSHOT using Java 17.0.8.1 with PID 1 (/service/app.jar started by spring in /service)
2023-09-13T13:50:52.707Z INFO 1 --- [ main] o.e.t.semantics.RegistryApplication : The following 1 profile is active: "local"
2023-09-13T13:50:57.993Z INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2023-09-13T13:50:58.302Z INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 287 ms. Found 3 JPA repository interfaces.
2023-09-13T13:51:01.493Z INFO 1 --- [ main] o.s.b.w.e.j.JettyServletWebServerFactory : Server initialized with port: 4243
2023-09-13T13:51:01.498Z INFO 1 --- [ main] org.eclipse.jetty.server.Server : jetty-11.0.15; built: 2023-04-11T18:37:53.775Z; git: 5bc5e562c8d05c5862505aebe5cf83a61bdbcb96; jvm 17.0.8.1+1
2023-09-13T13:51:01.709Z INFO 1 --- [ main] o.e.j.s.h.ContextHandler.application : Initializing Spring embedded WebApplicationContext
2023-09-13T13:51:01.710Z INFO 1 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 8720 ms
2023-09-13T13:51:03.707Z INFO 1 --- [ main] o.e.j.s.session.DefaultSessionIdManager : Session workerName=node0
2023-09-13T13:51:03.789Z INFO 1 --- [ main] o.e.jetty.server.handler.ContextHandler : Started o.s.b.w.e.j.JettyEmbeddedWebAppContext@aa21042{application,/,[file:///tmp/jetty-docbase.4243.12607937777430990090/, jar:file:/service/app.jar!/BOOT-INF/lib/swagger-ui-4.15.5.jar!/META-INF/resources],AVAILABLE}
2023-09-13T13:51:03.799Z INFO 1 --- [ main] org.eclipse.jetty.server.Server : Started Server@77b7ffa4{STARTING}[11.0.15,sto=0] @15523ms
2023-09-13T13:51:04.202Z INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2023-09-13T13:51:05.592Z INFO 1 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@328902d5
2023-09-13T13:51:05.595Z INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2023-09-13T13:51:06.406Z INFO 1 --- [ main] liquibase.database : Set default schema name to public
2023-09-13T13:51:07.792Z INFO 1 --- [ main] liquibase.changelog : Reading from public.databasechangelog
2023-09-13T13:51:07.802Z INFO 1 --- [ main] liquibase.executor : Changelog query completed.
2023-09-13T13:51:08.599Z INFO 1 --- [ main] liquibase.executor : Changelog query completed.
2023-09-13T13:51:08.603Z INFO 1 --- [ main] liquibase.executor : Changelog query completed.
2023-09-13T13:51:08.610Z INFO 1 --- [ main] liquibase.lockservice : Waiting for changelog lock....
2023-09-13T13:51:18.621Z INFO 1 --- [ main] liquibase.executor : Changelog query completed.
2023-09-13T13:51:18.624Z INFO 1 --- [ main] liquibase.executor : Changelog query completed.
2023-09-13T13:51:18.636Z INFO 1 --- [ main] liquibase.executor : Changelog query completed.
2023-09-13T13:51:18.640Z INFO 1 --- [ main] liquibase.lockservice : Successfully acquired change log lock
2023-09-13T13:51:18.712Z INFO 1 --- [ main] liquibase.executor : Changelog query completed.
2023-09-13T13:51:18.778Z INFO 1 --- [ main] liquibase.changelog : Reading from public.databasechangelog
2023-09-13T13:51:18.781Z INFO 1 --- [ main] liquibase.executor : Changelog query completed.
2023-09-13T13:51:18.788Z INFO 1 --- [ main] liquibase.executor : Changelog query completed.
Cause of the Problem
The application requires additional extension https://www.postgresql.org/docs/12/uuid-ossp.html which is by some means part of the bitnami chart/image. This extension is not part out-of-the box for "Azure Database for PostgreSQL flexible server"
Observed Behaviour
The deployment fails/hangs for the external DB specified over https://github.com/eclipse-tractusx/sldt-digital-twin-registry/blob/366970100962a3532f1d8dd2bb4be1ecdaea5674/charts/registry/values.yaml#L54C1-L61C17 with log patern like below:
Cause of the Problem
The application requires additional extension https://www.postgresql.org/docs/12/uuid-ossp.html which is by some means part of the bitnami chart/image. This extension is not part out-of-the box for "Azure Database for PostgreSQL flexible server"
Solution
Activation of the extension for "Azure Database for PostgreSQL flexible server" as described in https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-extensions
Documentation
A list of required PostgreSQL extensions has to be part of the documentation