Liquid.database changeloglock issue with flowable-ui:latest docker image at AKS with Postgres DB

1

Hi Folks

I have deployed flowable-ui:latest docker image into AKS (v1.23.12) with our personal Postgres DB (v12.22) connection. Post deployment there is a error occuring with liquid.database changeloglock.

Kindly provide your support on the below error msg.

2023-01-11 10:06:40.574 INFO 1 — [ main] com.zaxxer.hikari.HikariDataSource : flowable-ui - Starting…
2023-01-11 10:06:41.764 INFO 1 — [ main] com.zaxxer.hikari.HikariDataSource : flowable-ui - Start completed.
2023-01-11 10:06:48.385 INFO 1 — [ main] o.f.a.s.SpringAppEngineConfiguration : Executing configure() of class org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator (priority:50000)
2023-01-11 10:06:49.389 INFO 1 — [ main] o.f.engine.impl.ProcessEngineImpl : ProcessEngine default created
2023-01-11 10:06:49.485 INFO 1 — [ main] o.f.e.impl.cmd.ValidateV5EntitiesCmd : Total of v5 deployments found: 0
2023-01-11 10:06:49.496 INFO 1 — [ main] o.f.a.s.SpringAppEngineConfiguration : Executing configure() of class org.flowable.eventregistry.spring.configurator.SpringEventRegistryConfigurator (priority:100000)
2023-01-11 10:06:50.371 INFO 1 — [ main] liquibase.servicelocator : Cannot load service: liquibase.license.LicenseService: Provider liquibase.license.pro.DaticalTrueLicenseService could not be instantiated
2023-01-11 10:06:50.761 INFO 1 — [ main] liquibase.database : Set default schema name to public
2023-01-11 10:06:50.978 INFO 1 — [ main] liquibase.lockservice : Waiting for changelog lock…
2023-01-11 10:07:00.998 INFO 1 — [ main] liquibase.lockservice : Waiting for changelog lock…
2023-01-11 10:07:11.009 INFO 1 — [ main] liquibase.lockservice : Waiting for changelog lock…

2

Hi.

Could this be the result of an incomplete / failed initial deployment or start up?
You can try and remove the lock by updating the corresponding *_databasechangelock tables.

Regards,

Yvo

3

Hi Yvo

I have already tried with the option. But post changing the lock in corresponding table once the k8s pod restarted it again taking the value as “true”.

Is there any AKS compatibility with flowable-ui docker image ?

Regards
Kunal

4

Hi.

There are no issues with the Flowable UI image for running on a AKS cluster.
This is most probably caused by the way that it is deployed.
Are you using your own Kubernetes configurations? Or are you using the Flowable Helm chart?

Yvo

5

Hi yvo

I am using this following yml. Here I have mentioned the DB connection with our own Azure PaaS Postgres Flexible server v 12.22.

I am just applying this yml at AKS via CLI. The same yml is running on another AKS cluster. Only it is throwing the error for a particular AKS Cluster.

Kindly verify the yml and let me know if anything needs to be changed.

apiVersion: v1
kind: Service
metadata:
name: flowable-ui
annotations:
service.beta.kubernetes.io/azure-load-balancer-internal: “true”
spec:
type: LoadBalancer
ports:

  • port: 8080
    selector:
    app: flowable-ui

apiVersion: apps/v1
kind: Deployment
metadata:
name: flowable-ui
labels:
app: flowable-ui
spec:
replicas: 1
selector:
matchLabels:
service: flowable-ui
template:
metadata:
labels:
app: flowable-ui
service: flowable-ui
spec:
containers:
- name: flowable-ui
image: flowable/flowable-ui:latest
resources:
requests:
memory: “64Mi”
cpu: “50m”
limits:
memory: “256Mi”
cpu: “500m”
env:
- name: spring.datasource.driver-class-name
value: “org.postgresql.Driver”
- name: spring.datasource.url
value: “jdbc:postgresql://{azure_paas_host}:5432/flowable?user={your_username}&password={your_password}&sslmode=require”
ports:
- containerPort: 8080
protocol: TCP

6

I’m sorry. This is not readable.
Is there a reason you’re not using our Helm chart?

Yvo

7

Hi Yvo

No, there is no particular for using helm chart. I can use that as well for installing flowable-ui. Could you please help me with the helm chart link for installing flowable-ui only.

Thanks for your support.

Regards
Kunal Baksi

8

Hi,

can you tell me where this info does not suffice?

Regards,

Yvo

9

Thanks Yvo. Much appreciated for this link. Let me try to install flowable-ui using helm.

10

Hi Yvo

Could you please let me know if we can use our own Azure Postgres PAAS Database connection (v12.22) while installing flowable-ui using Helm 6.8.0 ? We do not want to install another postgres on AKS.

Also kindly let me know if we can set the LoadBalancer spec-type for flowable service at the time of helm installation. We do not want to host it via ingress host DNS.

Regards
Kunal