Deployment fails on Azure Database for PostgreSQL flexible server

[jerzy-wachowiak]

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:

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"

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

[agg3fe]

Thanks for pointing out this. We will check this.

[tunacicek]

PR is created.
#453

[tunacicek]

Done. Issue will be closed.